20061: After the last update we get the following after the database upgrade: CDbCommand failed to execute the SQL statement: SQLSTATE[

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

20061	Bug reports	_ Unknown	public	2025-04-16 11:16	2025-04-23 18:17

Reporter	mferraz	Assigned To	tibor.pacalat
Priority	none	Severity	crash
Status	resolved	Resolution	fixed
Product Version	6.6.x

Summary	20061: 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".
Tags	No tags attached.

Bug heat	8
Complete LimeSurvey version number (& build)	6.13.0+250415
I will donate to the project if issue is resolved	No
Browser	Firefox
Database type & version	PostgreSQL 13
Server OS (if known)	Ubuntu
Webserver software & version (if known)
PHP Version	PHP 8.1

User List	There are no users monitoring this issue.

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 2025-04-16 16:17 manager ~82430	https://github.com/LimeSurvey/LimeSurvey/pull/4245

DenisChenu 2025-04-22 11:58 developer ~82460	To be tested with PGSQL and plugin activated

tibor.pacalat 2025-04-23 18:16 administrator ~82470	Tested with PGSQL and plugin activated. I am not getting an error after login.

guest 2025-04-23 18:16 viewer ~82471	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=38793

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
2025-04-23 18:16	tibor.pacalat	Note Added: 82470
2025-04-23 18:16		Changeset attached	=> LimeSurvey master 1cac8390
2025-04-23 18:16	guest	Note Added: 82471
2025-04-23 18:16	guest	Bug heat	6 => 8
2025-04-23 18:17	tibor.pacalat	Status	ready for testing => resolved
2025-04-23 18:17	tibor.pacalat	Resolution	open => fixed

LimeSurvey: master 1cac8390 2025-04-23 18:16 Gabriel Jenik Committer: GitHub Details Diff	Fixed issue 20061: Update error in PostgreSQL (04245) Co-authored-by: lapiudevgit <devgit@lapiu.biz>		Affected Issues 20061
	mod - application/helpers/update/updates/Update_629.php		Diff File