View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
20061Bug reports_ Unknownpublic2025-04-16 11:162025-04-22 11:58
Reportermferraz Assigned Totibor.pacalat  
PrioritynoneSeveritycrash 
Status ready for testingResolutionopen 
Product Version6.6.x 
Summary20061: After the last update we get the following after the database upgrade: CDbCommand failed to execute the SQL statement: SQLSTATE[
Description

After the last update we get the following after the database upgrade: CDbCommand failed to execute the SQL statement: SQLSTATE[42703]: Undefined column: 7 ERROR: column "authtype" does not exist LINE 1: ...me_user_mfa_settings" SET "authType"='totp' WHERE authType !... ^ HINT: Perhaps you meant to reference the column "lime_user_mfa_settings.authType".

Steps To Reproduce

Steps to reproduce

Upgrade to the last version using postgresql

Expected result

access to the main menu

The following error:
CDbCommand failed to execute the SQL statement: SQLSTATE[42703]: Undefined column: 7 ERROR: column "authtype" does not exist LINE 1: ...me_user_mfa_settings" SET "authType"='totp' WHERE authType !... ^ HINT: Perhaps you meant to reference the column "lime_user_mfa_settings.authType".

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)6.13.0+250415
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionPostgreSQL 13
Server OS (if known)Ubuntu
Webserver software & version (if known)
PHP VersionPHP 8.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

tibor.pacalat

tibor.pacalat

2025-04-16 13:21

administrator   ~82428

@gabrieljenik could this be caused by your recent changes? https://github.com/LimeSurvey/LimeSurvey/pull/4231/files
gabrieljenik

gabrieljenik

2025-04-16 16:17

manager   ~82430

https://github.com/LimeSurvey/LimeSurvey/pull/4245
DenisChenu

DenisChenu

2025-04-22 11:58

developer   ~82460

To be tested with PGSQL and plugin activated

Issue History

Date Modified Username Field Change
2025-04-16 11:16 mferraz New Issue
2025-04-16 13:21 tibor.pacalat Note Added: 82428
2025-04-16 13:21 tibor.pacalat Bug heat 0 => 2
2025-04-16 13:21 tibor.pacalat Assigned To => gabrieljenik
2025-04-16 13:21 tibor.pacalat Status new => assigned
2025-04-16 16:17 gabrieljenik Assigned To gabrieljenik => DenisChenu
2025-04-16 16:17 gabrieljenik Status assigned => ready for code review
2025-04-16 16:17 gabrieljenik Note Added: 82430
2025-04-16 16:17 gabrieljenik Bug heat 2 => 4
2025-04-22 11:58 DenisChenu Assigned To DenisChenu => tibor.pacalat
2025-04-22 11:58 DenisChenu Status ready for code review => ready for testing
2025-04-22 11:58 DenisChenu Note Added: 82460
2025-04-22 11:58 DenisChenu Bug heat 4 => 6