View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
17490Bug reportsInstallationpublic2022-04-11 13:43
Reporterimadevel Assigned Toollehar  
PriorityhighSeveritycrash 
Status closedResolutionno change required 
Product Version5.x 
Summary17490: 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
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.id ,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 heat6
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

There are no users monitoring this issue.

Activities

ollehar

ollehar

2021-08-02 16:06

administrator   ~65775

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

imadevel

imadevel

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).

ollehar

ollehar

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.

ollehar

ollehar

2021-09-17 16:13

administrator   ~66520

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

galads

galads

2022-04-11 13:43

reporter   ~68986

Hello imadevel,

we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exact details on how to reproduce it.

Thank you and best regards,

galads

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
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