View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
07678Bug reportsSurvey editingpublic2013-03-18 14:532013-03-20 09:01
Reporterdocl Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary07678: When deactivating a survey a critical error is shown
Description

When disabling an active survey an internal server error is shown. The survey is disabled correctly - happens for all surveys. The error shown is: (my domain is replaced with DOMAIN)

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DOMAIN.lime_survey_581731' doesn't exist
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)130317
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySql mysqlnd 5.0.8-dev
Server OS (if known)Linux
Webserver software & version (if known)Apache
PHP Version5.3.21

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-03-19 12:04

administrator   ~24770

I am sorry but I cannot reproduce this here at all.
Does this error happen too if you activate that survey again and deactivate it again?
docl

docl

2013-03-19 12:17

reporter   ~24772

Does this error happen too if you activate that survey again and deactivate it again?

Just tried it with two surveys - apparently whith one of them it only happens the first time I deactivate it, with the other every time.
Will contact you on skype in a moment..
docl

docl

2013-03-19 12:32

reporter   ~24773

Ok, just created a test user and added activate/deactivate rights for two surveys.
Tried activating and then deactivating the two surveys twice, did not get the error - very strange. Don't know what could be the cause - it apparently is a bit random.
c_schmitz

c_schmitz

2013-03-19 13:20

administrator   ~24775

so, what permissions had the user you used at first?
docl

docl

2013-03-20 08:34

reporter   ~24785

the first user was administrator, the test user was actually meant to be for you to see the error, but since the error does not occur now there's no point..
I've seen the error many times, but cannot reproduce it now - will get back to you if I find out exactly when the error occurs..
c_schmitz

c_schmitz

2013-03-20 09:01

administrator   ~24786

Please re-open if you reproduce it.

Issue History

Date Modified Username Field Change
2013-03-18 14:53 docl New Issue
2013-03-19 12:04 c_schmitz Note Added: 24770
2013-03-19 12:04 c_schmitz Assigned To => c_schmitz
2013-03-19 12:04 c_schmitz Status new => feedback
2013-03-19 12:17 docl Note Added: 24772
2013-03-19 12:17 docl Status feedback => assigned
2013-03-19 12:32 docl Note Added: 24773
2013-03-19 13:20 c_schmitz Note Added: 24775
2013-03-19 13:20 c_schmitz Status assigned => feedback
2013-03-20 08:34 docl Note Added: 24785
2013-03-20 08:34 docl Status feedback => assigned
2013-03-20 09:01 c_schmitz Note Added: 24786
2013-03-20 09:01 c_schmitz Status assigned => closed
2013-03-20 09:01 c_schmitz Resolution open => unable to reproduce
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing