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

More
4 years 8 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 8 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 8 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 8 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 8 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 4 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