Hello,

I am trying to use comfort update to update limesurvey. I am on limesurvey  Version 3.27.6+210629
When I run the comfortupdate I end up getting the Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]: Column not found. 1054 Unknown column 'question' in "field list" File update_helper.php line 33. What does this mean and how might I be able to fix it?
(I have also attached a image of the error)

- Tori

This appears to be a bug in the update process. We failed on a similar update. You will need to restore the database and files from the copies you made during the update process.
I have submitted a bug report.

This error is related to a previous update run that was not completed, maybe because of a MySQL 8 incompatibility. We're working on it and will release a number of fixes later.

Version 5.1.1 released, please try again with this new version and let us know if any problems remain. Thank you!

@torilee93 you might have to restore your previous database from the backup and try again, sorry.

5.1.2 released.

Hi @ollehar
Unfortunately when I tried the comfortupdate again, I got a different error.
It now says CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-3n' for key "lime_idx1_label_l1ons'
File update_helper.php, line 33

I have attached a photo of the error.

- Tori

Hi @ollehar

Even with 5.1.2. released, I am getting this error
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-3n' for key "lime_idx1_label_l1ons'

@torilee93 This might be because your database failed in the middle of the update. Can you restore the database from your backup and try to update again?

@ollehar I did restore from a previous backup. After running comfortupdate (5.1.3/210817), it asks to update the database.
When I proceed I get the error
An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-en' for key 'lime_idx1_label_l10ns'


File update_helper.php, line 33.

Did you restore the database and the files from your previous backup and check to see that it worked before you attempted the update?

Hello @GuernseyResearch

Yes, after restoring from a previous backup, I was able to navigate throughtout limesurvey without any issues.

You are using this to go from LS3 to LS5?