View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17490 | Bug reports | Installation | public | 2021-08-02 14:56 | 2022-04-11 13:43 |
Reporter | imadevel | Assigned To | ollehar | ||
Priority | high | Severity | crash | ||
Status | closed | Resolution | no change required | ||
Product Version | 5.x | ||||
Summary | 17490: Field missing during update resp. field is deleted during update | ||||
Description | During the update from 3.27.9 to 5.0.12 , database 365 to 452 I got two errors First error without a correction I did a second call and the result was the second error: CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'question' in 'field list'. The SQL statement executed was: INSERT INTO lime_question_l10ns (qid, question, help, language) select qid, question, help, language from lime_questions and indeed the table lime_questions has no column question. Before the update, the column "question" was there, so it look that the column was deleted during the update? | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | limesurvey5.0.12+210729 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 90.0 | ||||
Database type & version | 10.3.29-MariaDB-0+deb10u1 Debian 10 | ||||
Server OS (if known) | Debian 10 | ||||
Webserver software & version (if known) | 2.4.38-3+deb10u5 | ||||
PHP Version | PHP Version 7.3.29-1~deb10u1 | ||||
Can you give us a dump of the database before you executed the update? |
|
A little bit difficult but I will try to copy the database and anonymize the data (the answers of the surveys). |
|
Depending on the sensitivity, you can also upload the database privately. Then only users with development access can see it. |
|
Please update to the latest version and check if the bug can still be reproduced. Thank you. |
|
Hello imadevel, 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, galads |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2021-08-02 14:56 | imadevel | New Issue | |
2021-08-02 15:48 | ollehar | Priority | none => high |
2021-08-02 15:48 | ollehar | Severity | partial_block => crash |
2021-08-02 15:49 | ollehar | Sync to Zoho Project | => |Yes| |
2021-08-02 16:06 | ollehar | Note Added: 65775 | |
2021-08-02 16:06 | ollehar | Bug heat | 0 => 2 |
2021-08-03 14:50 | ollehar | Assigned To | => ollehar |
2021-08-03 14:50 | ollehar | Status | new => feedback |
2021-08-03 17:32 | imadevel | Note Added: 65797 | |
2021-08-03 17:32 | imadevel | Bug heat | 2 => 4 |
2021-08-03 17:32 | imadevel | Status | feedback => assigned |
2021-08-03 21:36 | ollehar | Note Added: 65799 | |
2021-09-17 16:13 | ollehar | Status | assigned => feedback |
2021-09-17 16:13 | ollehar | Note Added: 66520 | |
2022-04-11 13:43 | galads | Note Added: 68986 | |
2022-04-11 13:43 | galads | Bug heat | 4 => 6 |
2022-04-11 13:43 | galads | Status | feedback => closed |
2022-04-11 13:43 | galads | Resolution | open => no change required |