Back to limesurvey.org

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
  • Gabriela's Avatar Topic Author
  • New Member
  • New Member
More
12 years 6 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
The topic has been locked.
More
12 years 6 months ago #92297 by DenisChenu
Replied by DenisChenu on 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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
  • Gabriela
  • Gabriela's Avatar Topic Author
  • New Member
  • New Member
More
12 years 6 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
The topic has been locked.
More
12 years 6 months ago #92328 by DenisChenu
Replied by DenisChenu on topic CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Look at this icon in the top menu:
[img
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
  • Gabriela
  • Gabriela's Avatar Topic Author
  • New Member
  • New Member
More
12 years 6 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"..
:unsure:

thanks
The topic has been locked.
More
10 years 3 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?
The topic has been locked.
More
7 years 4 months 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.
More
7 years 4 months ago #167381 by holch
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.
Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source