Back to limesurvey.org

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
  • adm_serveur@uqar.ca's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months ago - 1 year 9 months 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.
=================================================================================
Last edit: 1 year 9 months ago by adm_serveur@uqar.ca. Reason: bad cut/paste

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 9 months ago #242768 by holch
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.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

  • adm_serveur@uqar.ca
  • adm_serveur@uqar.ca's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months 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.

Please Log in to join the conversation.

More
1 year 9 months ago #242775 by jelo
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.
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
  • adm_serveur@uqar.ca's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months 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
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 9 months ago #242797 by holch
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.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.

Please Log in to join the conversation.

  • adm_serveur@uqar.ca
  • adm_serveur@uqar.ca's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 9 months 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.

Please Log in to join the conversation.

Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source