Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]

More
3 months 3 weeks ago #218846 by torilee93
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
Attachments:

Please Log in to join the conversation.

More
3 months 3 weeks ago #218850 by GuernseyResearch
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.

Please Log in to join the conversation.

More
3 months 3 weeks ago #218861 by ollehar
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.

Please Log in to join the conversation.

More
3 months 3 weeks ago #218870 by ollehar
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.

Please Log in to join the conversation.

More
3 months 3 weeks ago #218876 by ollehar

Please Log in to join the conversation.

More
3 months 3 weeks ago #218877 by torilee93
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
Attachments:

Please Log in to join the conversation.

More
3 months 3 weeks ago #218908 by torilee93
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'

Please Log in to join the conversation.

More
3 months 3 weeks ago #218909 by ollehar
@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?

Please Log in to join the conversation.

More
3 months 3 weeks ago #218911 by torilee93
@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.

Please Log in to join the conversation.

More
3 months 3 weeks ago #218912 by GuernseyResearch
Did you restore the database and the files from your previous backup and check to see that it worked before you attempted the update?

Please Log in to join the conversation.

More
3 months 3 weeks ago #218913 by torilee93
Hello @GuernseyResearch

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

Please Log in to join the conversation.

More
3 months 3 weeks ago #218914 by GuernseyResearch
You are using this to go from LS3 to LS5?

Please Log in to join the conversation.

More
3 months 2 weeks ago #218968 by torilee93
Yes. I am on Limesurvey 3.27.10 trying to update to 5.1.3

Please Log in to join the conversation.

More
3 months 2 weeks ago #218969 by ollehar
> Yes, after restoring from a previous backup, I was able to navigate throughtout limesurvey without any issues.

So it's working now? Did you try to restore from LS3 when upgrading to LS5?

Please Log in to join the conversation.

More
3 months 2 weeks ago #218970 by GuernseyResearch
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.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now