View Issue Details

This issue affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
06009Bug reportsOtherpublic2012-05-04 08:45
Reporterpmonstad Assigned Toc_schmitz  
PriorityurgentSeveritycrash 
Status closedResolutionunable to reproduce 
Product Version1.92+ 
Summary06009: can't activate a deactivated survey
Description

After activating a survey with tokens I found an error and had to deactivate the survey. I fixed the "errors" and then try to activate the survey again. This leads to an error telling me Table 'lime_survey_41314' already exists

idI NOTNULL AUTO PRIMARY, submitdateT, lastpageI, startlanguageC(20) NOTNULL, tokenC(36), 41314X319X2763C(5), 41314X319X2764C(5), 41314X319X2765C(5), 41314X319X2766C(1), 41314X319X2767C(5), 41314X320X2768C(5), 41314X320X2768otherX, 41314X320X2769C(1), 41314X321X2770C(5), 41314X321X2771C(5), 41314X321X2771otherX, 41314X321X2772C(5), 41314X321X2772otherX, 41314X321X2773C(5), 41314X321X2773otherX, 41314X321X2774SQ001C(5), 41314X321X2774SQ002C(5), 41314X321X2774SQ003C(5), 41314X321X2774SQ004C(5), 41314X321X2774SQ005C(5), 41314X321X2774SQ006C(5), 41314X321X2774SQ007C(5), 41314X321X2774SQ008C(5), 41314X321X2774SQ009C(5), 41314X322X2775` X

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)120302
I will donate to the project if issue is resolvedNo
Browserall
Database type & versionCentos 5.8, MySQL
Server OS (if known)Centos 5.8
Webserver software & version (if known)Apache 2
PHP Version5.1.6
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

TMSWhite

TMSWhite

2012-04-12 20:08

reporter   ~18340

until someone can look into the root cause, there is an easy work-around. Simply export the survey, re-import it, then activate the newly imported copy.

DenisChenu

DenisChenu

2012-04-13 09:55

developer   ~18345

Or rename manually lime_survey_41314 to lime_old_survey_41314 .

Sure there are something when you deactivate survey. But can't reproduce for my part too :)

Mazi

Mazi

2012-04-16 22:35

updater   ~18394

When deactivating a survey, the lime_survey_12345 table is renamed and a timestamp is added. After re-activation a new lime_survey_12345 table is created.

We can only try to reproduce this if you provide us with a sample survey and step by step instructions on how to reproduce the problem.

c_schmitz

c_schmitz

2012-05-04 08:45

administrator   ~18572

CLosed due to missing feedback.

Issue History

Date Modified Username Field Change
2012-04-12 17:39 pmonstad New Issue
2012-04-12 20:08 TMSWhite Note Added: 18340
2012-04-12 20:08 TMSWhite Status new => feedback
2012-04-13 09:55 DenisChenu Note Added: 18345
2012-04-16 22:35 Mazi Note Added: 18394
2012-05-04 08:45 c_schmitz Note Added: 18572
2012-05-04 08:45 c_schmitz Status feedback => closed
2012-05-04 08:45 c_schmitz Assigned To => c_schmitz
2012-05-04 08:45 c_schmitz Resolution open => unable to reproduce