Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

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

  • duimdog
  • duimdog's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 11 months ago #151085 by duimdog
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
The topic has been locked.
More
6 years 11 months ago #151087 by jelo
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 meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: duimdog
The topic has been locked.
  • duimdog
  • duimdog's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 11 months ago #151089 by duimdog
Thanks Jelo, that solved the problem!
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose