Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

ComfortUpdate failed: DB error

Trimbos
Topic Author
Offline
New Member

More

4 years 10 months ago #206462 by Trimbos

ComfortUpdate failed: DB error was created by Trimbos

Performed ComfortUpdate, which I do monthly.
Everything went well.....until the DB update/upgrade in the end: an error occured.
As we use postgres, could not backup from the admin.

How come this happened?
ComfortUpdate is not very comforting with these kind of errors that mess up the database.

...e 20201012.PNG

The topic has been locked.

Trimbos
Topic Author
Offline
New Member

More

4 years 10 months ago - 4 years 10 months ago #206484 by Trimbos

Replied by Trimbos on topic ComfortUpdate failed: DB error

Correction:
according to our webhost, the database update script tried to alter a table from varchar to txt. Which is a valid procedure in itself.
However, our Limesurvey installation is an "Bi-Directional Replication (BDR), an asynchronous multi-master replication system for PostgreSQL" (our production environment for various applications).

The current script is not suited for that.

Last edit: 4 years 10 months ago by Trimbos.

The topic has been locked.

DenisChenu
Offline
LimeSurvey Community Team & Official Partner

More

4 years 10 months ago #206504 by DenisChenu

Replied by DenisChenu on topic ComfortUpdate failed: DB error

MLaybe you can report issue, but clearly … i don't think we have a clean solution …

You can do it yourself ?
Just this step : github.com/LimeSurvey/LimeSurvey/blob/3f...edb_helper.php#L3380

(ahnd update DBversion in settings after).

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

The topic has been locked.