- Posts: 103
- Thank you received: 2
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
500 - Internal server error when trying to open any survey in the admin panel
- oleggorfinkel
- Topic Author
- Offline
- Premium Member
All of a sudden, I started getting this error when trying to open any survey from the list in the admin panel:
'500 - Internal server error: The table "{{conditions}}" for active record class "Condition" cannot be found in the database.'
I've been using this very same LimeSurvey installation (v3.17.7+190627) for months, and this had never happened before.
I've looked at my server error log and it's EMPTY. My surveys are working fine for the respondents, by the way; the problem is only in the Admin panel.
I have also tried to use the "Check data integrity" function on the Advanced menu, and got the following:
"CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tentokai_metamindful.lime_conditions' doesn't exist."
Please help!
Thanks,
Oleg.
Oleg G.
- oleggorfinkel
- Topic Author
- Offline
- Premium Member
- Posts: 103
- Thank you received: 2
Oleg G.
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11758
- Thank you received: 2753
The only situation that I could think of where a table could be deleted (if something goes terribly wrong) would be an update.
Who else has access to your installation? Who is responsible for hosting? Who has access to your database?
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- oleggorfinkel
- Topic Author
- Offline
- Premium Member
- Posts: 103
- Thank you received: 2
holch wrote: Limesurvey won't just delete tables out of nothing, especially impossible if you haven't even opened the admin panel. How should this delete be triggered?
The only situation that I could think of where a table could be deleted (if something goes terribly wrong) would be an update.
Who else has access to your installation? Who is responsible for hosting? Who has access to your database?
Only I have access... Now, over this past weekend, my hosting company (iFastNet) had a big outage due to a CEPH storage software upgrade that went badly. It seems very implausible, however, that a single table could have disappeared from the database while all the others remained intact. A very unsettling mystery...
Oleg G.
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11758
- Thank you received: 2753
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- oleggorfinkel
- Topic Author
- Offline
- Premium Member
- Posts: 103
- Thank you received: 2
Yes, that would be my hypothesis, too. I've already reported this to iFastNet support and they asked me for the name of the table and the database, so they can look into it and see what happened. I just hope there is no hidden damage there somewhere that could create an issue for me at some critical moment, when I least expect it...holch wrote: Maybe they had to use a backup and when restoring the backup something went wrong?
Oleg G.
- oleggorfinkel
- Topic Author
- Offline
- Premium Member
- Posts: 103
- Thank you received: 2
Oleg G.
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11758
- Thank you received: 2753
So I think the difference is just that at the time the backup was made, there were a lot of sessions stores in the database (any ongoing surveys at the time?).
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
- oleggorfinkel
- Topic Author
- Offline
- Premium Member
- Posts: 103
- Thank you received: 2
holch wrote: Not an expert, but as I understand it, Limesurvey can store sessions in cookies and in the database. Looks like your installation stores the sessions in the database, which also fits with the size of 1-2MB each.
So I think the difference is just that at the time the backup was made, there were a lot of sessions stores in the database (any ongoing surveys at the time?).
Yes, I did, in fact, change to database-based sessions a while ago. I think that the backup from early July was done just before I cleaned out a bunch of old surveys that had remained opened but weren't being used anymore. So, the differences between that and the later backup are probably due to those sessions being deleted.
Thanks for replying, I really appreciate your help!
Cheers,
Oleg.
Oleg G.
- jelo
- Offline
- Platinum Member
- Posts: 5070
- Thank you received: 1263
LimeSurvey can save the session in the filesystem (PHP session path) OR the database.holch wrote: Not an expert, but as I understand it, Limesurvey can store sessions in cookies and in the database.
The cookie is the browserside identification for the session (an alternative to cookie would have been to attach an ID to the URL all the time). The session data is not saved in the cookie.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
- holch
- Offline
- LimeSurvey Community Team
- Posts: 11758
- Thank you received: 2753
Thank you for the correction (adapted above).LimeSurvey can save the session in the filesystem (PHP session path) OR the database.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.