View Issue Details

IDProjectCategoryView StatusLast Update
15158Bug reports[All Projects] ComfortUpdatepublic2019-09-11 13:49
Reportergrinapo Assigned Todominikvitt  
PriorityurgentSeveritymajor 
Status resolvedResolutionfixed 
Product Version4.0.0-RC3 
Target VersionFixed 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
Complete LimeSurvey version number (& build)upgrade to 4.0.0-rc3
I will donate to the project if issue is resolvedNo
Browserfirefox
Database & DB-Version 417 to version 419
Server OS (if known)debian
Webserver software & version (if known)nginx
PHP Version7.0

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

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