View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15158 | Bug reports | ComfortUpdate | public | 2019-08-13 17:16 | 2019-09-30 16:41 |
Reporter | grinapo | Assigned To | |||
Priority | urgent | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 4.0.0-RC3 | ||||
Fixed in Version | 4.0.0-RC3 | ||||
Summary | 15158: Upgrade fails on postgres due to deliberate NULL in the primary key 'id' | ||||
Description | --- updatedb_helper.php~ 2019-08-07 16:09:04.000000000 +0000
| ||||
Steps To Reproduce |
An non-recoverable error happened during the update. Error details: CDbCommand failed to execute the SQL statement: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "id" violates not-null constraint DETAIL: Failing row contains (null, PasswordRequirement, 1, 1.0.0, 0, null, core, 0). File updatedb_helper.php, line 2871. Please fix this error in your database and try again | ||||
Additional Information | By the wai the error message do not contain the table name which is failing. Fortunately postgres server log does, by default. | ||||
Tags | sprint | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | upgrade to 4.0.0-rc3 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | firefox | ||||
Database type & version | 417 to version 419 | ||||
Server OS (if known) | debian | ||||
Webserver software & version (if known) | nginx | ||||
PHP Version | 7.0 | ||||
This issue is fixed. https://github.com/LimeSurvey/LimeSurvey/commit/e24511a88b2c3bcf3d72b818bdf06b7f7dae995c |
|
Fixed in Release 4.0.0-RC4+190930 |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2019-08-13 17:16 | grinapo | New Issue | |
2019-08-13 17:16 | grinapo | Status | new => assigned |
2019-08-13 17:16 | grinapo | Assigned To | => LouisGac |
2019-09-09 10:37 | c_schmitz | Assigned To | LouisGac => |
2019-09-09 10:37 | c_schmitz | Priority | none => urgent |
2019-09-09 10:37 | c_schmitz | Status | assigned => new |
2019-09-09 10:42 | c_schmitz | Tag Attached: sprint | |
2019-09-10 16:57 |
|
Assigned To | => dominikvitt |
2019-09-10 16:57 |
|
Status | new => assigned |
2019-09-11 13:49 |
|
Status | assigned => resolved |
2019-09-11 13:49 |
|
Resolution | open => fixed |
2019-09-11 13:49 |
|
Fixed in Version | => 4.0.0-RC3 |
2019-09-11 13:49 |
|
Note Added: 53556 | |
2019-09-30 16:41 | lime_release_bot | Note Added: 53769 | |
2019-09-30 16:41 | lime_release_bot | Status | resolved => closed |