View Issue Details

Jump to NotesJump to History
This bug affects 2 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
19373Bug reportsDatabase designpublic2024-01-23 10:012024-01-24 10:34
Reportermferraz Assigned To 
PrioritynoneSeveritycrash 
Status newResolutionopen 
Product Version6.4.x 
Summary19373: An non-recoverable error happened during the update. Error details: CDbCommand failed to execute the SQL statement: SQLSTATE[428
Description

After the upgrade we get this:

An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "user_status" cannot be cast automatically to type integer HINT: You might need to specify "USING user_status::integer".

File updatedb_helper.php, line 2815.

Steps To Reproduce

Just upgrade to the last version

TagsNo tags attached.
Bug heat10
Complete LimeSurvey version number (& build)6.4.3+240122
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 13+225
Server OS (if known)
Webserver software & version (if known)
PHP Version8.1

Users monitoring this issue

H1441H

Activities

H1441H

H1441H

2024-01-24 10:34

reporter   ~79305

Exact same thing, Postgres 16. Installation unusable after update.

Issue History

Date Modified Username Field Change
2024-01-23 10:01 mferraz New Issue
2024-01-24 10:33 H1441H Issue Monitored: H1441H
2024-01-24 10:33 H1441H Bug heat 0 => 2
2024-01-24 10:34 H1441H Note Added: 79305
2024-01-24 10:34 H1441H Bug heat 2 => 4
2024-01-24 10:34 H1441H Bug heat 4 => 10