Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

An non-recoverable error happened during the update

  • digbySC
  • digbySC's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 2 months ago #250661 by digbySC
Please help us help you and fill where relevant:
Your LimeSurvey version: 2.72.3+171020
Own server or LimeSurvey hosting: Own Server PHP 7.2
Survey theme/template: -vanilla
==================
When I updated an old version of LS CE to the Long Term Maintenance Version, I believe it is, using the comfort updater things went fine until I was asked to upgrade the database. Then I got this error

An non-recoverable error happened during the update. Error details:CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'ls_tutorials' already existsFile updatedb_helper.php, line 1749.

This is not the first time this error has occurred while trying to upgrade..
Any help appreciated

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 2 months ago #250676 by holch
So what Version did you run before and what exact version did you upgrade to?

2.72.3+171020


This is ancient. Over 6 years without any updates? I am not overly surprised that you run into issues when updating/upgrading.

So you are getting an error message, but what exactly happens? Could you upgrade and then get the error message? Can you access the new install? Did the upgrade not really start?

Be a little bit more specific where you are hanging currently.

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.

  • digbySC
  • digbySC's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 2 months ago #250716 by digbySC
Hi Holch
I know it's ancient. I inherited it. Long story but...
Running 2.73.1+171220
Upgrading to: 3.28.74 (230920) - This is the only version that is available via Comfort Updater. I believe this is the Long Term Maintenance version.

So, the updater runs and says everything is good. Files structure etc...
When it finishes we return to the Admin page with a message saying to proceed you must update the database.
When I do that the above error is thrown up.

So I don't know if it is a database issue or an updater issue.

If I check the database integrity (pre update) it reports everything is fine...

Thanks for responding

D

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 2 months ago #250740 by holch

Upgrading to: 3.28.74 (230920) - This is the only version that is available via Comfort Updater. I believe this is the Long Term Maintenance version.


OK, trying to upgrade to LS 3.x. Yes, this is in theory the LTS version, but actually should have been EOL already in June 2023. So I would expect it to become EOL any day.

As you seem to be a paying customer of Comfort Update, you might get direct support from the Limesurvey GmbH by opening a support ticket (Only if they consider this an issue with Comfort Update though).

Another path is trying to open a bug at bugs.limesurvey.org.

I am no expert on the database structure of Limesurvey.

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.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose