Dependency Graph

View IssueRelationship GraphVerticalShow Summary
Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
13952Bug reportsOtherpublic2018-08-10 12:482018-09-26 15:39
Reporterluberm Assigned Tomarkusfluer 
PrioritynoneSeveritypartial_block 
Status closedResolutionduplicate 
Product Version3.13.x 
Fixed in Version3.14.x 
Summary13952: PostgreSQL DB update issue from LS 3.8.2 to 3.14.{1..4}
Description

Updating 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.
Bug heat10
Complete LimeSurvey version number (& build)3.14.4+180810
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 10.4
Server OS (if known)Exherbo Linux
Webserver software & version (if known)NGINX 1.14.0
PHP Version7.2.5

Relationships

Relationship GraphDependency Graph
has duplicate 13954 closedmarkusfluer 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
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