Welcome to the LimeSurvey Community Forum

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

ComfortUpdate failed: DB error

  • Trimbos
  • Trimbos's Avatar Topic Author
  • Offline
  • New Member
  • New Member
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.
Attachments:
The topic has been locked.
  • Trimbos
  • Trimbos's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
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.
Last edit: 3 years 6 months ago by Trimbos.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 6 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 service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source