- Posts: 30
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
11 years 2 months ago #92268
by Gabriela
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: was created by Gabriela
Hi all,
Im working in Limesurvey 2.0 (limesurvey200plus-build130129)
When I try to access "quick statistics" this message appears,
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '72567X52X10181_3' in 'where clause'
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Though Im using a custom template, It happens with default and basic template aswell.
Please, its urgent, anyone knows how to fix this problem?
Im attaching the survey
thanks very much in advance
Im working in Limesurvey 2.0 (limesurvey200plus-build130129)
When I try to access "quick statistics" this message appears,
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '72567X52X10181_3' in 'where clause'
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Though Im using a custom template, It happens with default and basic template aswell.
Please, its urgent, anyone knows how to fix this problem?
Im attaching the survey
thanks very much in advance
Attachments:
The topic has been locked.
- DenisChenu
- Away
- LimeSurvey Community Team
Less
More
- Posts: 13645
- Thank you received: 2491
11 years 2 months ago #92297
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 CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Hello,
Not sure but try "Check data integrity".
Denis
Not sure but try "Check data integrity".
Denis
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.
The topic has been locked.
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
- Posts: 30
- Thank you received: 0
11 years 2 months ago #92322
by Gabriela
Replied by Gabriela on topic CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
thanks,
how do I try "data integrity? (excuse my extreme ignorance in these matters..)
thanks again
how do I try "data integrity? (excuse my extreme ignorance in these matters..)
thanks again
The topic has been locked.
- DenisChenu
- Away
- LimeSurvey Community Team
Less
More
- Posts: 13645
- Thank you received: 2491
11 years 2 months ago #92328
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 CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
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.
The topic has been locked.
- Gabriela
- Topic Author
- Offline
- Banned
Less
More
- Posts: 30
- Thank you received: 0
11 years 2 months ago #92340
by Gabriela
Replied by Gabriela on topic CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Ah yes,
Its clean. its says no conflicts. ( deleted unused tables ect..)
but it does not happen with every survey...
have no idea how to fix it. had to deactivate "show public statistics"..
thanks
Its clean. its says no conflicts. ( deleted unused tables ect..)
but it does not happen with every survey...
have no idea how to fix it. had to deactivate "show public statistics"..
thanks
The topic has been locked.
- manolobernales
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 11 months ago #120836
by manolobernales
Replied by manolobernales on topic CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Did you solve the problem?
How you did it?
How you did it?
The topic has been locked.
- misskana5
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
6 years 1 week ago #167380
by misskana5
Replied by misskana5 on topic CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Were you able to solve the problem? If so, how?
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11658
- Thank you received: 2742
6 years 1 week ago #167381
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 CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
This is a 5 year old topic about a version of Limesurvey that is also 5 years old. Even if they would have solved it, the solution might not help you with a current version of Limesurvey.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.