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)
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.
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
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'
I did a fresh install of 3.27.12 on our test server and then used comfortupdate to move it to 5.1.3 with no toruble. It did the files and then asked to do the database. Once updated everything appears fine.