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]:

More
11 years 1 month ago #92268 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
Attachments:
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 1 month ago #92297 by DenisChenu
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 , plugin development .
I don't answer to private message.
The topic has been locked.
More
11 years 1 month ago #92322 by Gabriela
thanks,

how do I try "data integrity? (excuse my extreme ignorance in these matters..)
thanks again
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 1 month ago #92328 by DenisChenu
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 , plugin development .
I don't answer to private message.
The topic has been locked.
More
11 years 1 month ago #92340 by Gabriela
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
8 years 9 months ago #120836 by manolobernales
Did you solve the problem?
How you did it?
The topic has been locked.
More
5 years 11 months ago #167380 by misskana5
Were you able to solve the problem? If so, how?
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 11 months ago #167381 by holch
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.

Lime-years ahead

Online-surveys for every purse and purpose