View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 17621 | Bug reports | ComfortUpdate | public | 2021-09-23 18:04 | 2021-09-24 11:36 |
| Reporter | Jmantysalo | Assigned To | ollehar | ||
| Priority | none | Severity | partial_block | ||
| Status | closed | Resolution | duplicate | ||
| Product Version | 5.x | ||||
| Summary | 17621: Updating DB fails for label sets | ||||
| Description | ComfortUpdate from 5.1.3+210817 to 5.1.13 failed. It tried to update DB from 473 to 475, and failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '194-AO01' for key 'lime_idx5_labels' Everything went fine on test server, so I guess that the error happened because production server had some label sets defined. Failing update statement was $oDB->createCommand()->createIndex('{{idx5_labels}}', '{{labels}}', ['lid','code'], true); and the DB do have many duplicates in the table lime_labels for value pairs lid-code. This was quite nasty, as the system was left on unusable state. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 14 | ||||
| Complete LimeSurvey version number (& build) | 5.x | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | See above | ||||
| Server OS (if known) | |||||
| Webserver software & version (if known) | |||||
| PHP Version | N/A | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-09-23 18:04 | Jmantysalo | New Issue | |
| 2021-09-24 11:36 | ollehar | Assigned To | => ollehar |
| 2021-09-24 11:36 | ollehar | Status | new => closed |
| 2021-09-24 11:36 | ollehar | Resolution | open => duplicate |
| 2021-09-24 11:36 | ollehar | Note Added: 66609 | |
| 2021-09-24 11:36 | ollehar | Bug heat | 0 => 2 |
| 2021-09-29 15:40 |
|
Bug heat | 2 => 8 |
| 2021-10-01 12:56 | Dietrich Streifert | Bug heat | 8 => 14 |
