View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15826 | Bug reports | Installation | public | 2020-02-05 21:11 | 2021-03-10 17:45 |
Reporter | segui | Assigned To | c_schmitz | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 4.1.1 | ||||
Summary | 15826: 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:
This is the relevant part of the summary shown right before the db upgrade step: Database type: mysql And this is the error I get during the database upgrade: "An non-recoverable error happened during the update. Error details: Please fix this error in your database and try again" More info about my setup:
Thank you!!! | ||||
Steps To Reproduce | In-place upgrade of 3.22.1 installation to version 4.1.1 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 4.1.11+200316 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Google Chrome 79.0.3945.130 (64-bit), Firefox 72.0.2 (64-bit) | ||||
Database type & version | mysql 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 Version | 7.2 | ||||
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 |
|
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: File update_helper.php, line 31.Ginet |
|
Can you still reproduce that using the latest 4.x or (even better) RC version? |
|
Hello segui, we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved. Thank you and best regards, ollehar |
|
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 |