View Issue Details

IDProjectCategoryView StatusLast Update
13952Bug reports[All Projects] Otherpublic2018-08-13 10:59
ReporterlubermAssigned Tomarkusfluer 
PrioritynoneSeveritymajor 
Status assignedResolutionopen 
Product Version3.13.x 
Target VersionFixed in Version 
Summary13952: PostgreSQL DB update issue from LS 3.8.2 to 3.14.{1..4}
DescriptionUpdating from 3.8.2 produces the following error:

(german)
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
Browser
Database & DB-VersionPostgreSQL 10.4
Operating System (Server)Exherbo Linux
Webserver software & versionNGINX 1.14.0
PHP Version7.2.5

Relationships

has duplicate 13954 resolvedmarkusfluer Fails to install 

Activities

b58supp

b58supp

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