- Posts: 8
- Thank you received: 0
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
Less
More
3 years 6 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.
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.
Attachments:
The topic has been locked.
- Trimbos
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
3 years 6 months ago - 3 years 6 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.
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: 3 years 6 months ago by Trimbos.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13667
- Thank you received: 2496
3 years 6 months ago #206504
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
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).
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 service on demand , plugin development .
I don't answer to private message.
The topic has been locked.