View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17608 | Bug reports | Database design | public | 2021-09-20 15:42 | 2021-11-02 09:06 |
Reporter | bbraeuer | Assigned To | ollehar | ||
Priority | none | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 4.5.x | ||||
Summary | 17608: Database Update ist not working | ||||
Description | Database upgrade 473 to 475 is not working SQLSTATE[42S02]: Base table or view not found: 1146 Table 'limesurvey.lime_labels' doesn't exist | ||||
Steps To Reproduce | use today's Comfort Update | ||||
Additional Information | Ein Fehler trat während des Datenbankupdates auf. Fehlerinformation: Datei updatedb_helper.php, Zeile 4951. | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | current from comfort update | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | uptodate | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | uptodate | ||||
Thank you for reporting this, I will release a fix very soon. |
|
Fix has been released, please update and try again. |
|
Thanks, but how can I update now? Going to the admin page leads only to the database upgrade page :/ |
|
You might have to apply the fixing patch manually. You can see the changes here: https://github.com/LimeSurvey/LimeSurvey/commit/6a4cdee9289d82a8baf8e9905e9af27b21d90d66 This is new new version of updatedb_helper.php: https://raw.githubusercontent.com/LimeSurvey/LimeSurvey/6a4cdee9289d82a8baf8e9905e9af27b21d90d66/application/helpers/update/updatedb_helper.php |
|
Thanks, it's working now :-) |
|
Great! |
|
Hi! Another issue with the same update (473->475) is identified (two different installations) An non-recoverable error happened during the update. Error details: File updatedb_helper.php, line 8072. |
|
Hm, ok, will check. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=32734 |
|
Please try the latest patch release. Let us know if the problem remains. Thank you! |
|
No, there is issue now with the execution of SQL statement for creating a new index - see below: An non-recoverable error happened during the update. Error details: File updatedb_helper.php, line 4955. |
|
@exnovo OK, can you maybe upload your database dump here? Mark the comment as private. |
|
The problem is duplicated label set codes in a single label set. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=32743 |
|
@exnovo Can you apply this commit manually and try again? https://github.com/LimeSurvey/LimeSurvey/commit/022518db2288b5dcc33cefba7eaea3f4ee1d6d2f Your database had orphan labels - labels with lid = 0, without a belonging label set. I've added code to remove such orphans. |
|
Thank you - this works. |
|
LimeSurvey: master f8a0a94c 2021-09-21 10:03:18 Details Diff |
Fixed issue 17608: Label sets have no language column in latest dbversion |
Affected Issues 17608 |
|
mod - application/helpers/update/updatedb_helper.php | Diff File | ||
LimeSurvey: master 022518db 2021-09-22 16:03:40 Details Diff |
Fixed issue 17608: Remove orphan labels before adding table unique constraint |
Affected Issues 17608 |
|
mod - application/helpers/update/updatedb_helper.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2021-09-20 15:42 | bbraeuer | New Issue | |
2021-09-20 15:45 | ollehar | Note Added: 66535 | |
2021-09-20 15:45 | ollehar | Bug heat | 0 => 2 |
2021-09-20 16:13 | ollehar | Assigned To | => ollehar |
2021-09-20 16:13 | ollehar | Status | new => resolved |
2021-09-20 16:13 | ollehar | Resolution | open => fixed |
2021-09-20 16:13 | ollehar | Note Added: 66540 | |
2021-09-20 16:14 | ollehar | Note Edited: 66540 | |
2021-09-20 16:15 | bbraeuer | Note Added: 66541 | |
2021-09-20 16:15 | bbraeuer | Bug heat | 2 => 4 |
2021-09-20 16:26 | ollehar | Note Added: 66542 | |
2021-09-20 16:32 | bbraeuer | Note Added: 66543 | |
2021-09-20 16:33 | ollehar | Note Added: 66544 | |
2021-09-21 08:28 | exnovo | Note Added: 66548 | |
2021-09-21 08:28 | exnovo | Bug heat | 4 => 6 |
2021-09-21 09:41 | ollehar | Note Added: 66552 | |
2021-09-21 09:45 | c_schmitz | Bug heat | 6 => 8 |
2021-09-21 09:45 | c_schmitz | Status | resolved => closed |
2021-09-21 09:50 | c_schmitz | Status | closed => feedback |
2021-09-21 09:50 | c_schmitz | Resolution | fixed => reopened |
2021-09-21 09:54 | c_schmitz | Bug heat | 8 => 6 |
2021-09-21 10:03 | ollehar | Changeset attached | => LimeSurvey master f8a0a94c |
2021-09-21 10:03 | ollehar | Note Added: 66568 | |
2021-09-21 10:03 | ollehar | Resolution | reopened => fixed |
2021-09-21 10:05 | ollehar | Status | feedback => ready for testing |
2021-09-21 10:56 | ollehar | Note Added: 66569 | |
2021-09-21 15:23 | exnovo | Note Added: 66573 | |
2021-09-21 16:27 | ollehar | Note Added: 66574 | |
2021-09-21 16:50 | ollehar | Note Added: 66575 | |
2021-09-22 16:03 | ollehar | Changeset attached | => LimeSurvey master 022518db |
2021-09-22 16:03 | ollehar | Note Added: 66590 | |
2021-09-22 16:06 | ollehar | Note Added: 66591 | |
2021-09-22 16:08 | ollehar | Zoho Project Synchronization | => |Yes| |
2021-09-22 17:06 | exnovo | Note Added: 66592 | |
2021-09-24 12:18 | ollehar | Status | ready for testing => resolved |
2021-11-02 09:06 | c_schmitz | Status | resolved => closed |