View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15759 | Bug reports | Installation | public | 2020-01-23 15:46 | 2020-03-14 21:30 |
Reporter | bismark | Assigned To | cdorin | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.21.0 | ||||
Fixed in Version | 3.22.8 | ||||
Summary | 15759: limesurvey update from 2.64 to 3.x fails | ||||
Description | while updating from old limesurvey 2.64-lts (2.64.7?) the db-update throws an exception `can not create table boxes` | ||||
Tags | No tags attached. | ||||
Complete LimeSurvey version number (& build) | 2.64.7 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database & DB-Version | 10.1.26-MariaDB | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | 7.1.8 | ||||
there is a pull request: https://github.com/LimeSurvey/LimeSurvey/pull/1377 | |
@cdorin, we faced that at two different system recently when updating from 2.x to LS 3. It looks as if the "boxes" table already exists and thus the DB update fails. The pull request should fix this. Please assign to a developer for reviewing the pull request. |
|
update also fails, when emails in participants table are NULL mysql error 1265 data truncated for column |
|
`UPDATE participants SET email = '' WHERE email IS NULL` solves this | |
Date Modified | Username | Field | Change |
---|---|---|---|
2020-01-23 15:46 | bismark | New Issue | |
2020-01-27 09:48 | bismark | Note Added: 55471 | |
2020-01-27 09:51 | Mazi | Note Added: 55472 | |
2020-01-27 12:35 | cdorin | Assigned To | => cdorin |
2020-01-27 12:35 | cdorin | Status | new => assigned |
2020-01-27 16:41 | bismark | Note Added: 55488 | |
2020-01-27 16:43 | bismark | Note Added: 55489 | |
2020-03-14 21:30 | c_schmitz | Status | assigned => closed |
2020-03-14 21:30 | c_schmitz | Resolution | open => fixed |
2020-03-14 21:30 | c_schmitz | Fixed in Version | => 3.22.8 |