- Posts: 8
- Thank you received: 1
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
CDb Exception: Undefined function: 7 ERROR: operator does not exist
- pirnr81
- Topic Author
- Offline
- New Member
Less
More
3 months 1 week ago #254536
by pirnr81
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
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.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
3 months 1 week ago #254550
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
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?
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.
Please Log in to join the conversation.
- pirnr81
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
3 months 1 week ago #254554
by pirnr81
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.
- riqcles
- Offline
- Elite Member
Less
More
- Posts: 230
- Thank you received: 21
3 months 1 week ago #254614
by riqcles
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 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
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
Please Log in to join the conversation.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11660
- Thank you received: 2742
3 months 1 week ago #254615
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
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 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.
The following user(s) said Thank You: DenisChenu, pirnr81
Please Log in to join the conversation.
- pirnr81
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
3 months 1 week ago #254653
by pirnr81
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
The following user(s) said Thank You: riqcles
Please Log in to join the conversation.
- alinuxexpert
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 2
3 months 4 days ago #254888
by alinuxexpert
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.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
3 months 3 days ago #254905
by DenisChenu
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 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
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.
Please Log in to join the conversation.
- pirnr81
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 1
3 months 3 days ago #254907
by pirnr81
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
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.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
3 months 3 days ago #254909
by DenisChenu
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 DenisChenu on topic CDb Exception: Undefined function: 7 ERROR: operator does not exist
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.
Please Log in to join the conversation.