This has already been resolved. The issue was in the sql. Fix will be deployed latest on Monday next week.

Thank you for the quick response. If it's fixed, it would probably be better to pull the latest upgrade from ComfortUpdate to avoid other users breaking their installations.

I had the same problem, with today's (22.1.2023) update, there is still an error message:

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, Zeile 2815.

We're experiencing the same issue when updating from 5.6.50 to 6.4.2 using postgres.

Migration 619 introduces user_status and migration 621 fails changing type and default.

I "fixed" the issue manually via the following sql commands (we're only having three users)

alter table lime_users alter COLUMN user_status drop default;
alter table lime_users alter COLUMN user_status type integer using user_status::integer;
alter table lime_users alter COLUMN user_status set default 1;

Sorry for triple posting, the mantis showed a red internal error and I F5'd two times...

Brilliant, many thanks, Sa8ooch1.
I was notified of another workaround (which I did not try out myself):
"I was able to fix the error by changing line 138 in application/model/User.php changing the 1 to true"

@tibor.pacalat where is the fix ? Ask user to manually update DB are not a fix, right ?

This was supposed to be the fix. It was tested on MSSQL and Postgres.
https://github.com/LimeSurvey/LimeSurvey/commit/356f60ba13578064c480ce8bdae120d761068f0d

It is a part of the newest release 6.4.3+240122.

I will retest and if it is needed, reopen this ticket.

But this bug report is about 5.6.x. If it is not fixed in LS 5 we can't close this bug report.

But this bug report is about 5.6.x. If it is not fixed in LS 5 we can't close this bug report.

The new column was created only in 6 :)

Thank you @tibor.pacalat : it's because there are a forum post linking here :)

Any news on this? Thanks!

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36037

This will be fixed with the next update on Monday.

Fixed in Release 6.4.5+240205