View Issue Details

This bug affects 1 person(s).
IDProjectCategoryView StatusLast Update
17490Bug reportsInstallationpublic2021-09-17 16:13
Reporterimadevel Assigned Toollehar  
Status feedbackResolutionopen 
Product Version5.x 
Summary17490: Field missing during update resp. field is deleted during update
DescriptionDuring the update from 3.27.9 to 5.0.12 , database 365 to 452 I got two errors

First error
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-de' for key 'lime_idx1_label_l10ns'. The SQL statement executed was: INSERT INTO lime_label_l10ns
(label_id, title, language)
SELECT ,lime_labels_update400.title,lime_labels_update400.language
FROM lime_labels_update400
INNER JOIN lime_labels ON lime_labels_update400.lid = lime_labels.lid AND lime_labels_update400.code = lime_labels.code

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?

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)limesurvey5.0.12+210729
I will donate to the project if issue is resolvedNo
BrowserFirefox 90.0
Database type & version10.3.29-MariaDB-0+deb10u1 Debian 10
Server OS (if known)Debian 10
Webserver software & version (if known)2.4.38-3+deb10u5
PHP VersionPHP Version 7.3.29-1~deb10u1

Users monitoring this issue

User List There are no users monitoring this issue.




2021-08-02 16:06

administrator   ~65775

Can you give us a dump of the database before you executed the update?


2021-08-03 17:32

reporter   ~65797

A little bit difficult but I will try to copy the database and anonymize the data (the answers of the surveys).


2021-08-03 21:36

administrator   ~65799

Depending on the sensitivity, you can also upload the database privately. Then only users with development access can see it.


2021-09-17 16:13

administrator   ~66520

Please update to the latest version and check if the bug can still be reproduced. Thank you.

Issue History

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