View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
05942Bug reportsSurvey editingpublic2012-03-22 00:312012-03-26 09:08
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary05942: Unable to activate/deactivate/ reactivate a survey after anonimity correction
Description

If you activate a survey with token table without anonimity.
After see you made an error ( same admin session, don't verfying with another admin session) : deactivate the survey, set anonimity to YES
Try to activate the survey: SQL error:
<q>Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 3

id I NOTNULL AUTO PRIMARY,
submitdate T,
lastpage I,
startlanguage C(20) NOTNULL,
token,
57228X130X2240 X
</q>

there are 'token' in creation.

Steps To Reproduce

See before

Additional Information

I try with testing with a token before deactivate/ set to anonimity YES/ reactivate.

Maybe there are other issue with 'time' etc ...

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)120322
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionMysql 5.1.49
Server OS (if known)debian/linux
Webserver software & version (if known)apache
PHP VersionPHP Version 5.3.3-7

Relationships

Relationship GraphDependency Graph
parent of 05951 closedDenisChenu After testing some public survey, activation don't create whole table column 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2012-03-22 00:47

developer   ~18034

Error : Non 'not anonymous' survey can be activated !!!!
DenisChenu

DenisChenu

2012-03-22 01:28

developer   ~18035

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=8002
c_schmitz

c_schmitz

2012-03-23 13:03

administrator   ~18059

1.92+ update released.

Related Changesets

LimeSurvey: master 229344a8

2012-03-21 17:27:46

DenisChenu

Details Diff 		Fixed issue 05942 : unable to activate survey after some modification
Dev : allways force createFieldMap to activate a survey, it's the last chance
Dev : remove unnecessary rtrim on createsurvey set to "" 5 line before		 Affected Issues
05942
mod - admin/activate_functions.php Diff File

Issue History

Date Modified Username Field Change
2012-03-22 00:31 DenisChenu New Issue
2012-03-22 00:47 DenisChenu Note Added: 18034
2012-03-22 01:26 DenisChenu Assigned To => DenisChenu
2012-03-22 01:26 DenisChenu Status new => assigned
2012-03-22 01:28 DenisChenu Changeset attached => LimeSurvey master 229344a8
2012-03-22 01:28 DenisChenu Note Added: 18035
2012-03-22 01:28 DenisChenu Resolution open => fixed
2012-03-22 01:29 DenisChenu Status assigned => resolved
2012-03-22 01:29 DenisChenu Fixed in Version => 1.92+
2012-03-23 13:03 c_schmitz Note Added: 18059
2012-03-23 13:03 c_schmitz Status resolved => closed
2012-03-26 09:08 DenisChenu Relationship added parent of 05951
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing