View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
15158Bug reportsComfortUpdatepublic2019-08-13 17:162019-09-30 16:41
Reportergrinapo Assigned Todominikvitt 
PriorityurgentSeveritypartial_block 
Status closedResolutionfixed 
Product Version4.0.0-RC3 
Fixed in Version4.0.0-RC3 
Summary15158: 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
+++ updatedb_helper.php 2019-08-13 15:04:07.706841819 +0000
@@ -2868,7 +2868,7 @@
if($iOldDBVersion < 418) {
$oTransaction = $oDB->beginTransaction();
$oDB->createCommand()->insert("{{plugins}}", [

  • 'id' => null,
  • // 'id' => null,
    'name' => 'PasswordRequirement',
    'plugin_type' => 'core',
    'active' => 1,
Steps To Reproduce
  • upgrade
  • db upgrade fail

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.

Tagssprint
Bug heat4
Complete LimeSurvey version number (& build)upgrade to 4.0.0-rc3
I will donate to the project if issue is resolvedNo
Browserfirefox
Database type & version 417 to version 419
Server OS (if known)debian
Webserver software & version (if known)nginx
PHP Version7.0

Users monitoring this issue

There are no users monitoring this issue.

Activities

dominikvitt

dominikvitt

2019-09-11 13:49

developer   ~53556

This issue is fixed.
The patch is available now on GitHub and would be available on next LimeSurvey release.

https://github.com/LimeSurvey/LimeSurvey/commit/e24511a88b2c3bcf3d72b818bdf06b7f7dae995c
lime_release_bot

lime_release_bot

2019-09-30 16:41

administrator   ~53769

Fixed in Release 4.0.0-RC4+190930

Issue History

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 dominikvitt Assigned To => dominikvitt
2019-09-10 16:57 dominikvitt Status new => assigned
2019-09-11 13:49 dominikvitt Status assigned => resolved
2019-09-11 13:49 dominikvitt Resolution open => fixed
2019-09-11 13:49 dominikvitt Fixed in Version => 4.0.0-RC3
2019-09-11 13:49 dominikvitt 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