Please help us help you and fill where relevant:
Your LimeSurvey version: [6.4.1]
Own server or LimeSurvey hosting: Own Server
Survey theme/template: fruity
==================
Since updating today to the latest version (LS 6.4.2-240115), it is no longer possbile to log in.  No changes have been made to the Database. It seems that somewhere the value for the  "active_user"  is no longer recognized as a Boolean.
The error message I get is :

CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer
LINE 1: ...15 16:32:14' OR expires IS NULL) AND (user_status = 1)) AND ...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.. The SQL statement executed was: SELECT * FROM "users" "t" WHERE ((expires > :now OR expires IS NULL) AND (user_status = :active)) AND ("t"."uid") LIMIT 1

From which version to which version did you update/upgrade?

And how did you update/upgrade? Manually or via Comfortupdate?

manual upgrade, from 6.4.1 to 6.4.2. same procedure as last e.g. last week from 6.4.0 to 6.4.1, but this time with unexpected troubles

hello I have the same problem from a blank installation in 6 4 1 everything works I redo a blank installation in 6 4 2 and the message appears


the directories have the same rights in both version 4.1 and 4 2 the same for the database postgresql 15.5
PHP 8.2.14
Centos 7.9

@pirnr81: is your installation also PostGreSQL?

I would suggest to open a bug report. I have read about other issues with PostGreSQL with recent versions. Have a look in the bug tracker if your issue is similar. If so, add to that bug report. If not, create your own bug report.

yes, also postgres-db. i'll look at the bugtracker thursday, thanks for the.suggestion

Same problem here. Could you share the link to the bug report here?

bugs.limesurvey.org/view.php?id=19331

A fix is here
github.com/LimeSurvey/LimeSurvey/pull/3686
but we have an issue in phpunit test

bugs.limesurvey.org/view.php?id=19351

Sa8ooch1's solution worked for me.

I also received a message (but I did not try that one out):
I was able to fix the error by changing line 138 in application/model/User.php changing the 1 to true

Arg, about user : you're right another pg issue …

bugs.limesurvey.org/view.php?id=19351