CDb Exception: Undefined function: 7 ERROR: operator does not exist was created by pirnr81 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

Please Log in to join the conversation.

Replied by holch on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist From which version to which version did you update/upgrade?
And how did you update/upgrade? Manually or via Comfortupdate? I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by pirnr81 on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist 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

Please Log in to join the conversation.

Replied by riqcles on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist 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 LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /
Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x Replied by holch on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist @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. I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by pirnr81 on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist yes, also postgres-db. i'll look at the bugtracker thursday, thanks for the.suggestion Replied by alinuxexpert on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist Same problem here. Could you share the link to the bug report here?

Please Log in to join the conversation.

Replied by DenisChenu on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist 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 Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand plugin development I don't answer to private message.
Replied by pirnr81 on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist 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

Please Log in to join the conversation.

Replied by DenisChenu on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist Arg, about user : you're right another pg issue …
bugs.limesurvey.org/view.php?id=19351 Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand plugin development I don't answer to private message.