Error "Base table or view not found" while trying to view list of surveys as adm

More
6 months 4 weeks ago #151085 by duimdog
duimdog created the topic: Error "Base table or view not found" while trying to view list of surv
We have a (until now) properly functioning Limesurvey vs 2.50+ Build 160503.
When we try to view the list of surveys we encounter an (internal server) error message at page 3:

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

It seems to me that something is going wrong with a certain survey, but I haven't got a clue what could be wrong and how to fix it.

Nb: I 'm new to this forum, so this post may not be in the right category. Please excuse me for this.

Kind regards
Michel

Please Log in to join the conversation.

More
6 months 4 weeks ago #151087 by jelo
jelo replied the topic: Error "Base table or view not found" while trying to view list of surv
The database is missing a data-table for the survey with the ID 285876.
You may check the database via "Configuration -> Check data integrity".
The following user(s) said Thank You: duimdog

Please Log in to join the conversation.

More
6 months 4 weeks ago #151089 by duimdog
duimdog replied the topic: Error "Base table or view not found" while trying to view list of surv
Thanks Jelo, that solved the problem!

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now