View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17638Bug reportsInstallationpublic2021-11-02 09:06
ReporterChristianJeske Assigned Toollehar  
PrioritynoneSeverityblock 
Status closedResolutionno change required 
Product Version5.x 
Summary17638: 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 reproduce

Followed the update, delete the old install, put the new install in, copy config and security.php

Expected result

database upgrade

Actual result

error above

TagsNo tags attached.
Attached Files
lables.png (9,962 bytes)   
lables.png (9,962 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)5.1.14
I will donate to the project if issue is resolvedNo
BrowserFirefox 92
Database type & version10.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

Users monitoring this issue

There are no users monitoring this issue.

Activities

ChristianJeske

ChristianJeske

2021-09-30 10:32

reporter   ~66670

One more info: I did a database integrity check: no errors and/or problems.

ollehar

ollehar

2021-09-30 11:06

administrator   ~66672

Strange. Can you run this query and paste the result, please?

            SELECT lime_labels.lid AS lid
            FROM lime_labels
            GROUP BY lime_labels.lid
            HAVING COUNT(DISTINCT(lime_labels.code)) < COUNT(lime_labels.id)

Thank you.

ChristianJeske

ChristianJeske

2021-09-30 11:11

reporter   ~66674

So delete on of the two?

ollehar

ollehar

2021-09-30 11:14

administrator   ~66675

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.

ChristianJeske

ChristianJeske

2021-09-30 11:16

reporter   ~66676

I have a backup of the version from August that works. Where do I do this in the admin interface?

ollehar

ollehar

2021-09-30 11:17

administrator   ~66677

It's the global configuration menu, "Label sets" or "Manage label sets"

https://manual.limesurvey.org/Label_sets

ChristianJeske

ChristianJeske

2021-09-30 11:49

reporter   ~66679

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!

ollehar

ollehar

2021-09-30 13:08

administrator   ~66680

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.

ChristianJeske

ChristianJeske

2021-09-30 13:18

reporter   ~66683

Max File size is 2 MB. The zip is 100 mb

ollehar

ollehar

2021-09-30 13:20

administrator   ~66684

Eh, OK. Can you zip down your label sets only? Pre-update.

ChristianJeske

ChristianJeske

2021-09-30 13:23

reporter   ~66685

Can I go back to an older Version? With the Database updated to a later version? If yes, then no problem

ollehar

ollehar

2021-09-30 15:08

administrator   ~66689

Nope, not possible. Maybe leave it for now and I'll see if anyone else is having the same problem later.

ChristianJeske

ChristianJeske

2021-09-30 15:11

reporter   ~66690

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.

ollehar

ollehar

2021-09-30 15:12

administrator   ~66691

Great, good luck with your research!

Issue History

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