View Issue Details

This bug affects 1 person(s).
IDProjectCategoryView StatusLast Update
18827Bug reportsDatabase designpublic2023-06-08 17:34
Reporteralinuxexpert Assigned Toc_schmitz  
Status closedResolutionduplicate 
Product Version6.0.x 
Summary18827: DB update from 6.0.2 to 6.0.7 fails (PostgreSQL)

I tried to update my Limesurvey (community) from version 6.0.2 to 6.0.7. When I open Limesurvey, a DB update is attemted but fails with the following error message:

An non-recoverable error happened during the update. Error details:

CDbCommand failed to execute the SQL statement: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block

File Update_601.php, line 38.

I had the same error when trying to update to 6.0.6 previously.

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)6.0.2
I will donate to the project if issue is resolvedNo
Database type & versionPostgreSQL 14.7 (Ubuntu 14.7-0ubuntu0.22.04.1)
Server OS (if known)Ubuntu Linux 22.04
Webserver software & version (if known)
PHP VersionPHP 8.1.2-1ubuntu2.11


duplicate of 18789 closedc_schmitz Updated database PostgreSQL 13 - LimeSurvey version 6.02 to 6.04 

Users monitoring this issue

User List There are no users monitoring this issue.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-05-18 11:31 alinuxexpert New Issue
2023-06-08 17:34 c_schmitz Relationship added duplicate of 18789
2023-06-08 17:34 c_schmitz Assigned To => c_schmitz
2023-06-08 17:34 c_schmitz Status new => closed
2023-06-08 17:34 c_schmitz Resolution open => duplicate