View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15912 | Bug reports | Installation | public | 2020-02-24 16:36 | 2020-03-24 11:29 |
Reporter | rustam82 | Assigned To | c_schmitz | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 4.1.6 | ||||
Fixed in Version | 4.1.12 | ||||
Summary | 15912: Error upgrading from 3.22.5+ to 4.1.6 | ||||
Description | I get an error by upgrating from 3.22 to 4.1.6 "Invalid datetime format: 1366 Incorrect string value: '\xE2\x86\x94 5=...' for column Web server | ||||
Steps To Reproduce | In the begining of installation when I click on 'Start database upgrade' I get this error | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 12 | ||||
Complete LimeSurvey version number (& build) | Version 3.22.5+200218 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Database client version: libmysql - 5.6.43 | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | PHP version: 7.3.6 | ||||
Thanks for reporting, we'll have a look. |
|
I can upgrade to new(empty) DB but not to my DB which has about 1400 surveys |
|
Yes, one of the values does not fit. |
|
«Invalid datetime format» ? For i10n->help ???? |
|
Same here. Error is similar: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC4\x85ca l...' for column After an unsuccessful upgrade, I have a lime_question_l10ns table left (expected) with incorrect encoding (latin1). This may be the source of the problem.
|
|
Ok. My bad - database was from very old lime upgraded year by year - the error can be fixed by properly setting database-wide character set and collation (which will be applied for any new table). ALTER DATABASE lsurvey CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Upgraded without further problems. |
|
Then must be done before upgrade, or must be forced in upgrade system. Thanks for the information. |
|
Thanks a lot! It is OK now. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=29707 |
|
Fixed in Release 4.1.12+200324 |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2020-02-24 16:36 | rustam82 | New Issue | |
2020-02-24 16:36 | rustam82 | File Added: image.png | |
2020-02-24 16:36 | rustam82 | File Added: image-2.png | |
2020-02-24 16:36 | rustam82 | File Added: LimeSurvey VIVES.mhtml | |
2020-02-24 16:38 | ollehar | Note Added: 56176 | |
2020-02-25 11:14 | rustam82 | Note Added: 56197 | |
2020-02-25 13:17 | ollehar | Note Added: 56198 | |
2020-02-27 10:01 | DenisChenu | Note Added: 56219 | |
2020-03-09 15:04 | robaato | Note Added: 56371 | |
2020-03-09 15:32 | robaato | Note Added: 56372 | |
2020-03-09 15:36 | DenisChenu | Note Added: 56373 | |
2020-03-10 10:03 | rustam82 | Note Added: 56389 | |
2020-03-17 00:03 | c_schmitz | Changeset attached | => LimeSurvey master 5ce4587b |
2020-03-17 00:03 | c_schmitz | Note Added: 56586 | |
2020-03-17 00:03 | c_schmitz | Assigned To | => c_schmitz |
2020-03-17 00:03 | c_schmitz | Resolution | open => fixed |
2020-03-17 00:06 | c_schmitz | Status | new => resolved |
2020-03-17 00:06 | c_schmitz | Fixed in Version | => 4.1.12 |
2020-03-24 11:29 | lime_release_bot | Note Added: 56751 | |
2020-03-24 11:29 | lime_release_bot | Status | resolved => closed |