View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
15826Bug reportsInstallationpublic2020-02-05 21:112021-03-10 17:45
Reportersegui Assigned Toc_schmitz  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version4.1.1 
Summary15826: DB Error when upgrading from 3.22 to 4.1.1
Description

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.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)4.1.11+200316
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome 79.0.3945.130 (64-bit), Firefox 72.0.2 (64-bit)
Database type & 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

Users monitoring this issue

There are no users monitoring this issue.

Activities

segui

segui

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,

Ginet

CDbException.pdf (118,245 bytes)
segui

segui

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.

Ginet
c_schmitz

c_schmitz

2021-01-13 10:55

administrator   ~61525

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

ollehar

2021-03-10 17:45

administrator   ~63110

Hello segui,

we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exact details on how to reproduce it.

Thank you and best regards,

ollehar

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
2021-03-10 17:45 ollehar Status feedback => closed
2021-03-10 17:45 ollehar Resolution open => fixed
2021-03-10 17:45 ollehar Note Added: 63110