CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:

More
4 years 9 months ago #92268 by Gabriela
Gabriela created the topic: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
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
Attachments:

Please Log in to join the conversation.

More
4 years 9 months ago #92297 by DenisChenu
DenisChenu replied the topic: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Hello,

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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 9 months ago #92322 by Gabriela
Gabriela replied the 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

Please Log in to join the conversation.

More
4 years 9 months ago #92328 by DenisChenu
DenisChenu replied the topic: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Look at this icon in the top menu:

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 9 months ago #92340 by Gabriela
Gabriela replied the 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"..
:unsure:

thanks

Please Log in to join the conversation.

More
2 years 5 months ago #120836 by manolobernales
manolobernales replied the topic: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Did you solve the problem?
How you did it?

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!