- Posts: 56
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
- torilee93
- Topic Author
- Offline
- Senior Member
Less
More
2 years 8 months ago #218971
by torilee93
Replied by torilee93 on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Limesurvey works fine when I restored to LS3. It lets me update to 5.1.3 but then when it asks to update the database I run into the error.
The topic has been locked.
- GuernseyResearch
- Offline
- Junior Member
Less
More
- Posts: 31
- Thank you received: 5
2 years 8 months ago #218972
by GuernseyResearch
Replied by GuernseyResearch on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Before you do the upgrade do a "Data integrity" check from the Configuration menu.
My database upgrade was quick.
My database upgrade was quick.
The topic has been locked.
- nooblag
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
2 years 8 months ago #218975
by nooblag
Replied by nooblag on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Hi everyone, I'm not sure if this is related, but I'm getting this error whenever I try to Export Results of a survey:
```
500: Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42803]: Grouping error: 7 ERROR: column "lime_survey_873476.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 5: ORDER BY "lime_survey_873476"."id" ASC
^
```
I've done the Data consistency check and Data redundancy check in Lime Survey admin and still this occurs.System configuration:
```
500: Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42803]: Grouping error: 7 ERROR: column "lime_survey_873476.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 5: ORDER BY "lime_survey_873476"."id" ASC
^
```
I've done the Data consistency check and Data redundancy check in Lime Survey admin and still this occurs.System configuration:
- LimeSurvey version5.1.3
- LimeSurvey buildgithub
- Operating systemLinux s1.mals.cloud 4.15.0-153-generic #160-Ubuntu SMP Thu Jul 29 06:54:29 UTC 2021 x86_64
- PHP version7.4.22
- Web server nameq.mals.cloud
- Web server softwarenginx/1.18.0
- Web server infoHTTP/1.1
- Database driverpgsql
- Database driver version10.17 (Ubuntu 10.17-0ubuntu0.18.04.1)
- Database server infoPID: 36791; Client Encoding: UTF8; Is Superuser: off; Session Authorization: limesurvey; Date Style: ISO, MDY
- Database server version10.18 (Ubuntu 10.18-0ubuntu0.18.04.1)
Attachments:
The topic has been locked.
- ollehar
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
2 years 8 months ago #218984
by ollehar
Replied by ollehar on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Hi @nooblag, thanks for your report. Can you add it to our bug tracker at bugs.limesurvey.org, please?
The topic has been locked.
- nooblag
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
2 years 8 months ago #218986
by nooblag
Replied by nooblag on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Okay, for sure. Thanks for confirming it's a bug rather than a config problem.
The topic has been locked.
- nooblag
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
2 years 8 months ago #218987
by nooblag
Replied by nooblag on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Actually, sorry, I'm having trouble figuring out how to file a report at bugs.limesurvey.org. I don't have a login for it, so I tried the anonymous option, but I still cannot find any ability to open a new ticket...
The topic has been locked.
- ollehar
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
2 years 8 months ago #218988
by ollehar
Replied by ollehar on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Same user as for the forum. Just log out the guest account first.
The topic has been locked.
- nooblag
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
2 years 8 months ago #218989
by nooblag
Replied by nooblag on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Ooop. Ignore all that. It was a problem with my account.limesurvey.org login.
I managed to file a report. #17522
Thank you!
I managed to file a report. #17522
Thank you!
The topic has been locked.
- torilee93
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 56
- Thank you received: 0
2 years 8 months ago #218999
by torilee93
Replied by torilee93 on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Thanks for the advice. I did a data integrity check and everything seemed fine. (Attached screenshot)
I tried the update and saw a screen that said "Checking existing limesurvey files". I clicked continue and when limesurvey asked to update the database, I ran into the error.
I tried the update and saw a screen that said "Checking existing limesurvey files". I clicked continue and when limesurvey asked to update the database, I ran into the error.
Attachments:
The topic has been locked.
- M.Jakob
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
2 years 7 months ago #219553
by M.Jakob
Replied by M.Jakob on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
Hi @ollehar,
I have a similar problem. The database won't migrate and I don' know why. Can you help me?
Best, Mel
I have a similar problem. The database won't migrate and I don' know why. Can you help me?
Best, Mel
Attachments:
The topic has been locked.
- ollehar
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 522
- Thank you received: 108
2 years 7 months ago #219554
by ollehar
Replied by ollehar on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
@M.Jakob That error is because you've tried to update multiple times, and it broke in the middle of the update. I'd suggest you restore your previous db backup and try again to update from the latest LS5 version from our download page.
The topic has been locked.
- M.Jakob
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
2 years 7 months ago #219589
by M.Jakob
Replied by M.Jakob on topic Error CDbCommand failed to excute the SQL statement: SQLSTATE[42S22]
I downloaded whole database from limesurvey before updating and i'm able to import this sql to my database to restore everything. Doesn't fix the errror though!
The topic has been locked.