View Issue Details

IDProjectCategoryView StatusLast Update
15158Bug reports[All Projects] ComfortUpdatepublic2019-08-13 17:16
ReportergrinapoAssigned ToLouisGac 
Status assignedResolutionopen 
Product Version4.0.0-RC3 
Target VersionFixed in Version 
Summary15158: Upgrade fails on postgres due to deliberate NULL in the primary key 'id'

--- 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.

TagsNo tags attached.
Complete LimeSurvey version number (& build)upgrade to 4.0.0-rc3
I will donate to the project if issue is resolvedNo
Database & DB-Version 417 to version 419
Server OS (if known)debian
Webserver software & version (if known)nginx
PHP Version7.0


There are no notes attached to this issue.

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