View Issue Details

This bug affects 2 person(s).
 12
IDProjectCategoryView StatusLast Update
19373Bug reportsDatabase designpublic2024-11-19 18:14
Reportermferraz Assigned Totibor.pacalat  
PrioritynoneSeveritycrash 
Status closedResolutionno change required 
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 heat12
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.

tibor.pacalat

tibor.pacalat

2024-06-03 12:28

administrator   ~80189

This has already been fixed.

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
2024-06-03 12:28 tibor.pacalat Assigned To => tibor.pacalat
2024-06-03 12:28 tibor.pacalat Status new => resolved
2024-06-03 12:28 tibor.pacalat Resolution open => no change required
2024-06-03 12:28 tibor.pacalat Note Added: 80189
2024-06-03 12:28 tibor.pacalat Bug heat 10 => 12
2024-11-19 18:14 c_schmitz Status resolved => closed