View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17638 | Bug reports | Installation | public | 2021-09-30 10:31 | 2021-11-02 09:06 |
Reporter | ChristianJeske | Assigned To | ollehar | ||
Priority | none | Severity | block | ||
Status | closed | Resolution | no change required | ||
Product Version | 5.x | ||||
Summary | 17638: Non-recoverable error during update | ||||
Description | An non-recoverable error happened during the update. Error details: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6-1' for key 'lime_idx5_labels' File updatedb_helper.php, line 4955. Hello, I tried to update from a Version from August (5.1.x to the latest one 5.1.14). I got this error. I have this as a test-version I only have a handful of questionnaires in there. In my sql viewer for the database I have lable_idx1-4 but no idx5 (see screenshot) | ||||
Steps To Reproduce | Steps to reproduceFollowed the update, delete the old install, put the new install in, copy config and security.php Expected resultdatabase upgrade Actual resulterror above | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 5.1.14 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 92 | ||||
Database type & version | 10.4.17-MariaDB | ||||
Server OS (if known) | Linux sh10364 3.10.0-1160.21.1.el7.x86_64 | ||||
Webserver software & version (if known) | Apache | ||||
PHP Version | 7.4.19 | ||||
One more info: I did a database integrity check: no errors and/or problems. |
|
Strange. Can you run this query and paste the result, please?
Thank you. |
|
So delete on of the two? |
|
No, you can instead re-generate the label set codes. If the admin interface still works you can do it manually for label set 6 and 7. |
|
I have a backup of the version from August that works. Where do I do this in the admin interface? |
|
It's the global configuration menu, "Label sets" or "Manage label sets" |
|
I see the labels, I can export or import them. But I don't see an option to regenerate it. But I just deleted the label 7 there. -> Works. Label 6 and 7 where same and borked. I remember I had some problems with that label set, made it again, worked. Should have deleted the non working one. Thank you! |
|
This should have been automatic during the update. Strange that it didn't apply. Do you still have your pre-update backup? Can you upload it here? Mark the comment as private. |
|
Max File size is 2 MB. The zip is 100 mb |
|
Eh, OK. Can you zip down your label sets only? Pre-update. |
|
Can I go back to an older Version? With the Database updated to a later version? If yes, then no problem |
|
Nope, not possible. Maybe leave it for now and I'll see if anyone else is having the same problem later. |
|
I think that I caused that. I do remember that I had some problems with that specific label and then re-did the label with the same info but other name. Somehow that question/label was not working at all. So I guess will be a very rare problem. Anyhow, with the label I solved it, updated to the latest version without a problem now. |
|
Great, good luck with your research! |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2021-09-30 10:31 | ChristianJeske | New Issue | |
2021-09-30 10:31 | ChristianJeske | File Added: lables.png | |
2021-09-30 10:32 | ChristianJeske | Note Added: 66670 | |
2021-09-30 10:32 | ChristianJeske | Bug heat | 0 => 2 |
2021-09-30 10:53 | galads | Assigned To | => galads |
2021-09-30 10:53 | galads | Status | new => assigned |
2021-09-30 10:54 | galads | Assigned To | galads => ollehar |
2021-09-30 11:06 | ollehar | Note Added: 66672 | |
2021-09-30 11:06 | ollehar | Bug heat | 2 => 4 |
2021-09-30 11:11 | ChristianJeske | Note Added: 66674 | |
2021-09-30 11:11 | ChristianJeske | File Added: 2021_09_30_11_07_38_arcim_institute.de_sh10364.ispgateway.de_db306065_7_phpMyAdmin_5.0.4.png | |
2021-09-30 11:14 | ollehar | Note Added: 66675 | |
2021-09-30 11:16 | ChristianJeske | Note Added: 66676 | |
2021-09-30 11:17 | ollehar | Note Added: 66677 | |
2021-09-30 11:39 | ollehar | Status | assigned => feedback |
2021-09-30 11:49 | ChristianJeske | Note Added: 66679 | |
2021-09-30 11:49 | ChristianJeske | File Added: 2021_09_30_11_43_27_LimeSurvey.png | |
2021-09-30 11:49 | ChristianJeske | Status | feedback => assigned |
2021-09-30 13:08 | ollehar | Note Added: 66680 | |
2021-09-30 13:16 | ollehar | Status | assigned => feedback |
2021-09-30 13:18 | ChristianJeske | Note Added: 66683 | |
2021-09-30 13:18 | ChristianJeske | Status | feedback => assigned |
2021-09-30 13:20 | ollehar | Note Added: 66684 | |
2021-09-30 13:23 | ChristianJeske | Note Added: 66685 | |
2021-09-30 15:08 | ollehar | Note Added: 66689 | |
2021-09-30 15:11 | ChristianJeske | Note Added: 66690 | |
2021-09-30 15:12 | ollehar | Note Added: 66691 | |
2021-09-30 15:12 | ollehar | Status | assigned => resolved |
2021-09-30 15:12 | ollehar | Resolution | open => no change required |
2021-11-02 09:06 | c_schmitz | Status | resolved => closed |