View Issue Details

IDProjectCategoryView StatusLast Update
13952Bug reports[All Projects] Otherpublic2018-09-26 15:39
ReporterlubermAssigned Tomarkusfluer 
Status closedResolutionduplicate 
Product Version3.13.x 
Target VersionFixed in Version3.14.x 
Summary13952: PostgreSQL DB update issue from LS 3.8.2 to 3.14.{1..4}

Updating from 3.8.2 produces the following error:

Ein Fehler trat während des Datenbankupdates auf. Fehlerinformation:
SQLSTATE[42602]: Invalid name: 7 ERROR: invalid name syntax

Datei updatedb_helper.php, Zeile 2291.

I tried updating to 3.14.1, 3.14.3 and 3.14.4, the error remains the same.

DB-Server gives
Aug 10 12:45:36 localhost postgres[31]: 2018-08-10 12:45:36.344 CEST [25990] ERROR: invalid name syntax
Aug 10 12:45:36 localhost postgres[31]: 2018-08-10 12:45:36.344 CEST [25990] STATEMENT: SELECT CURRVAL($1)

Please advise on any additional information you might require.

Thank you in advance.

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.14.4+180810
I will donate to the project if issue is resolvedNo
Database & DB-VersionPostgreSQL 10.4
Server OS (if known)Exherbo Linux
Webserver software & version (if known)NGINX 1.14.0
PHP Version7.2.5


has duplicate 13954 closedmarkusfluer Fails to install 




2018-08-12 20:41

reporter   ~48774

I think this one ist related:

Trying to update Limesurvey from 3.12.2 to 3.14.3 fails with following stacktrace:

SQLSTATE[42602]: Invalid name: 7 ERROR: invalid name syntax
framework/db/CDbConnection.php(564): PDO->lastInsertId("")
application/controllers/AdminController.php(126): db_upgrade_all(353, true)
framework/web/CWebApplication.php(282): AdminController->run("pluginmanager")
framework/web/CWebApplication.php(141): CWebApplication->runController("admin/pluginmanager/sa/index")
framework/base/CApplication.php(185): CWebApplication->processRequest()
index.php(194): CApplication->run()

Maybe a sequence name is missing and postgres requires one?

Issue History

Date Modified Username Field Change
2018-08-10 12:48 luberm New Issue
2018-08-12 20:41 b58supp Note Added: 48774
2018-08-13 10:58 LouisGac Assigned To => markusfluer
2018-08-13 10:58 LouisGac Status new => assigned
2018-08-13 10:59 LouisGac Relationship added has duplicate 13954
2018-09-26 15:39 markusfluer Status assigned => closed
2018-09-26 15:39 markusfluer Resolution open => duplicate
2018-09-26 15:39 markusfluer Fixed in Version => 3.14.x