- Posts: 15
- Thank you received: 2
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Recommended procedure for upgrading from 3.x LTS to 4.x
- segui
- Topic Author
- Offline
- New Member
Less
More
4 years 2 months ago #193570
by segui
Recommended procedure for upgrading from 3.x LTS to 4.x was created by segui
Hello!
What is the recommended way to upgrade an existing Limesurvey installation running version 3.x LTS to the most recent 4.x?
I tried this:
- Downloaded and uncompressed v4.1.1
- Transferred the content of the upload directory from my 3.22.1 installation to the 4.1.1 upload folder
- Made a copy of the 3.22.1 mysql database
- Started the web installation process for the new 4.1.1, and specified the existing database (copy) as the one to use.
This is the relevant part of the summary shown right before the db upgrade step:
Database type: mysql
Table prefix: lime_
Current database version: 359
Target database version: 425
However, I got this error during the database upgrade:
"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 '462-en' for key 'lime_idx1_label_l10ns'
File update_helper.php, line 31.
Please fix this error in your database and try again"
Should I be using a different method to upgrade?
More info about my setup:
- PHP 7.2.10
- DB engine: MySQL 5.5.64-MariaDB
- OS: RHEL Server 7.7
Thank you!!!
Ginet
What is the recommended way to upgrade an existing Limesurvey installation running version 3.x LTS to the most recent 4.x?
I tried this:
- Downloaded and uncompressed v4.1.1
- Transferred the content of the upload directory from my 3.22.1 installation to the 4.1.1 upload folder
- Made a copy of the 3.22.1 mysql database
- Started the web installation process for the new 4.1.1, and specified the existing database (copy) as the one to use.
This is the relevant part of the summary shown right before the db upgrade step:
Database type: mysql
Table prefix: lime_
Current database version: 359
Target database version: 425
However, I got this error during the database upgrade:
"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 '462-en' for key 'lime_idx1_label_l10ns'
File update_helper.php, line 31.
Please fix this error in your database and try again"
Should I be using a different method to upgrade?
More info about my setup:
- PHP 7.2.10
- DB engine: MySQL 5.5.64-MariaDB
- OS: RHEL Server 7.7
Thank you!!!
Ginet
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
4 years 2 months ago #193573
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 Recommended procedure for upgrading from 3.x LTS to 4.x
Looks more like a bug in the upgradescript for the database.
Please report this bug. You might had some faulty data structures inside the database.
Looking for the "Duplicate entry '462-en' for key 'lime_idx1_label_l10ns'" might be helpful.
Please report this bug. You might had some faulty data structures inside the database.
Looking for the "Duplicate entry '462-en' for key 'lime_idx1_label_l10ns'" might be helpful.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- segui
- Topic Author
- Offline
- New Member
Less
More
- Posts: 15
- Thank you received: 2
4 years 2 months ago #193575
by segui
Replied by segui on topic Recommended procedure for upgrading from 3.x LTS to 4.x
Thank you jelo! I'll file the bug report then.
Ginet
Ginet
The topic has been locked.
- segui
- Topic Author
- Offline
- New Member
Less
More
- Posts: 15
- Thank you received: 2
4 years 2 months ago #193577
by segui
Replied by segui on topic Recommended procedure for upgrading from 3.x LTS to 4.x
Bug reported here:
bugs.limesurvey.org/view.php?id=15826
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- Beragatt_218803
- Offline
- Banned
Less
More
- Posts: 3
- Thank you received: 1
4 years 1 month ago #194522
by Beragatt_218803
Replied by Beragatt_218803 on topic Recommended procedure for upgrading from 3.x LTS to 4.x
I get the same error for upgrading from 3.22 to 4.1.6
bug reported bugs.limesurvey.org/view.php?id=15912
bug reported bugs.limesurvey.org/view.php?id=15912
The following user(s) said Thank You: DenisChenu
The topic has been locked.