View Issue Details

IDProjectCategoryView StatusLast Update
15826Bug reportsInstallationpublic2021-01-13 10:55
Reportersegui Assigned Toc_schmitz  
Status feedbackResolutionopen 
Product Version4.1.1 
Summary15826: DB Error when upgrading from 3.22 to 4.1.1

I am getting a CDbCommand in the db update portion when attempting to upgrade from 3.22.1 to 4.1.1. This is what I did:

  • 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

And this is the error I get 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"

More info about my setup:

  • PHP 7.2.10
  • DB engine: MySQL 5.5.64-MariaDB
  • OS: RHEL Server 7.7

Thank you!!!

Steps To Reproduce

In-place upgrade of 3.22.1 installation to version 4.1.1

TagsNo tags attached.
Complete LimeSurvey version number (& build)4.1.11+200316
I will donate to the project if issue is resolvedNo
Sync to Zoho Project
BrowserGoogle Chrome 79.0.3945.130 (64-bit), Firefox 72.0.2 (64-bit)
Database & DB-Versionmysql 5.5.64-MariaDB MariaDB Server, dbversionnumber = 359
Server OS (if known)RHEL Server 7.7
Webserver software & version (if known)Apache 2.4
PHP Version7.2




2020-03-17 20:24

reporter   ~56620

This is still happening when trying to upgrade from 3.22.9+200317 to 4.1.11+200316.

I set 'debug'=>2 and 'debugsql'=>1 in config.php right before the db upgrade process. Attached are the 2 first pages of the error I got. Note that "question" is not a field in lime_questions, so that query in the db upgrade process will always fail.

I hope this extra info helps to fix the issue.

Thank you,


CDbException.pdf (118,245 bytes)


2020-03-17 20:34

reporter   ~56621

And after that, if I go back to the db upgrade url (/index.php/admin/databaseupdate/sa/db) I get this error at the top:

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xD9\x85\xD8\xB1\xD8\xA8...' for column 'question' at row 184. The SQL statement executed was: INSERT INTO lime_question_l10ns (qid, question, help, language) select qid, question, help, language from lime_questions

File update_helper.php, line 31.




2021-01-13 10:55

administrator   ~61525

Can you still reproduce that using the latest 4.x or (even better) RC version?

Issue History

Date Modified Username Field Change
2020-02-05 21:11 segui New Issue
2020-03-17 20:24 segui File Added: CDbException.pdf
2020-03-17 20:24 segui Note Added: 56620
2020-03-17 20:34 segui Note Added: 56621
2020-03-20 13:57 cdorin Assigned To => cdorin
2020-03-20 13:57 cdorin Status new => assigned
2020-12-28 18:28 cdorin Assigned To cdorin =>
2020-12-28 18:28 cdorin Status assigned => new
2021-01-13 10:55 c_schmitz Assigned To => c_schmitz
2021-01-13 10:55 c_schmitz Status new => feedback
2021-01-13 10:55 c_schmitz Note Added: 61525
2021-01-13 10:55 c_schmitz Complete LimeSurvey version number (& build) 3.22.1+200129 => 4.1.11+200316