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 10 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 10 months ago #104060

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1374
  • Karma: 390
Hi,

What is your LimeSurvey version and build ?

Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
The administrator has disabled public write access.

HELP!!! Error message-CDbCommand failed to execute the SQL statement: 2 years 10 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 10 months ago #104153

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9555
  • Thank you received: 1374
  • Karma: 390
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 development are on my free time (Need support ?).
A bug not reported is a bug not corrected. | 2.61lts version improved | Need plugins for LimeSurvey ?
The administrator has disabled public write access.
Time to create page: 0.223 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form