- Posts: 4
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3
- adm_serveur@uqar.ca
- Topic Author
- Offline
- New Member
Less
More
1 year 2 days ago - 1 year 2 days ago #242766
by adm_serveur@uqar.ca
SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3 was created by adm_serveur@uqar.ca
Hello group.
I am using the container acspri/limesurvey from "docker hub" with the version 6.0.2 since couple of weeks and this morning i tried to upgrade at version 6.0.3 with the "confortUpdate" tool, the process is going fine except at the end when it trying to upgrade the database i do have the error message below. Can someone help me please?
Thanks in advance.
===================================
An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'buttontext'
File Update_601.php, line 15.
=================================================================================
I am using the container acspri/limesurvey from "docker hub" with the version 6.0.2 since couple of weeks and this morning i tried to upgrade at version 6.0.3 with the "confortUpdate" tool, the process is going fine except at the end when it trying to upgrade the database i do have the error message below. Can someone help me please?
Thanks in advance.
===================================
An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'buttontext'
File Update_601.php, line 15.
=================================================================================
Last edit: 1 year 2 days ago by adm_serveur@uqar.ca. Reason: bad cut/paste
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
1 year 2 days ago #242768
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3
As this happens during ComfortUpdate and you seem to be a paying customer of ComfortUpdate, I recommend to open a support ticket with Limesurvey GmbH (on the Limesurvey Website under Support).
Comfort Update is created and maintained by them. This might be an issue with docker and / or the container by a third party, but I think it is best to create a support ticket with Limesurvey GmbH to check.
Comfort Update is created and maintained by them. This might be an issue with docker and / or the container by a third party, but I think it is best to create a support ticket with Limesurvey GmbH to check.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- adm_serveur@uqar.ca
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
1 year 2 days ago #242774
by adm_serveur@uqar.ca
Replied by adm_serveur@uqar.ca on topic SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3
Hello.
Well received, thanks for the hint! I will open a ticket with Limesurvey GmbH.
Well received, thanks for the hint! I will open a ticket with Limesurvey GmbH.
Please Log in to join the conversation.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
1 year 2 days ago #242775
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3
This looks like a bug in the updatescript. You are not alone with this issue.
There was a workaround mentioned by tpartner. You might comment out lines 12-18 in the file Update_601.php.
I would just wait 24h to 48h before trying the ComfortUpdate again.
There was a workaround mentioned by tpartner. You might comment out lines 12-18 in the file Update_601.php.
Code:
// Add button text column to boxes table try { $this->db->createCommand() ->addColumn('{{boxes}}', 'buttontext', 'string(255)'); } catch (Exception $e) { // Column already exists - ignore }
I would just wait 24h to 48h before trying the ComfortUpdate again.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Please Log in to join the conversation.
- adm_serveur@uqar.ca
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
1 year 1 day ago #242796
by adm_serveur@uqar.ca
Replied by adm_serveur@uqar.ca on topic SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3
Ho that is cool! Thanks a lot. I will give it a try.
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
1 year 1 day ago #242797
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3
I just went from 6.0.0 to 6.0.4+230427 without any issues. Maybe it is already solved. If it is nothing specific from 6.0.2.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Please Log in to join the conversation.
- adm_serveur@uqar.ca
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
1 year 1 day ago #242800
by adm_serveur@uqar.ca
Replied by adm_serveur@uqar.ca on topic SQLSTATE[42S21] erro when upgrading from 6.0.2 to 6.0.3
I confirm that upgrade from 6.0.2 to 6.0.4 is working correctly. Case close.
Thanks everyone for the help, it is appreciated.
Thanks everyone for the help, it is appreciated.
Please Log in to join the conversation.