Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

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

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: 1 Jahr 8 Monate her #92268

  • Gabriela
  • Gabrielas Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Karma: 0
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
Anhang:
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: 1 Jahr 8 Monate her #92297

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6429
  • Dank erhalten: 839
  • Karma: 249
Hello,

Not sure but try "Check data integrity".

Denis
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: 1 Jahr 8 Monate her #92322

  • Gabriela
  • Gabrielas Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Karma: 0
thanks,

how do I try "data integrity? (excuse my extreme ignorance in these matters..)
thanks again
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: 1 Jahr 8 Monate her #92328

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6429
  • Dank erhalten: 839
  • Karma: 249
Look at this icon in the top menu:
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: 1 Jahr 8 Monate her #92340

  • Gabriela
  • Gabrielas Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Karma: 0
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.131 Sekunden
Donation Image