Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: HELP!!! Error message-CDbCommand failed to execute the SQL statement:

HELP!!! Error message-CDbCommand failed to execute the SQL statement: 2 years 6 months ago #103979

  • mitch54
  • mitch54's Avatar
  • Offline
  • Junior Lime
  • Posts: 38
  • Thank you received: 1
  • Karma: 0
I was trying to go back while setting up a quota and I got this message!!


CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'limesurvey.lime_survey_68191' doesn't exist

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.


Anybody know what this is referring to?
The administrator has disabled public write access.

HELP!!! Error message-CDbCommand failed to execute the SQL statement: 2 years 5 months ago #104060

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9254
  • Thank you received: 1319
  • Karma: 382
Hi,

What is your LimeSurvey version and build ?

Denis
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.

HELP!!! Error message-CDbCommand failed to execute the SQL statement: 2 years 5 months ago #104100

  • mitch54
  • mitch54's Avatar
  • Offline
  • Junior Lime
  • Posts: 38
  • Thank you received: 1
  • Karma: 0
Version 2.05+ Build 140116
This fixed itself, apparently. When I logged back in later the error message was gone and the quota tool worked, I think. I'm not used to using the quota tool and I'm having a hard time figuring it out. Will it work when I test the survey or do I have to activate the survey? I'm trying to have the surveys terminate when a qualifying question is answered incorrectly and also when the number of surveys reaches 500, but when I test it and answer the questions wrong it just keeps going....do I need to activate the survey before it will work?
The administrator has disabled public write access.

HELP!!! Error message-CDbCommand failed to execute the SQL statement: 2 years 5 months ago #104153

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9254
  • Thank you received: 1319
  • Karma: 382
Hi,

Quote work only when survey is activated, count the answer already made.

Even with0, survey decativated : no quota test.
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.198 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form