View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06891Bug reportsImport/Exportpublic2012-11-20 15:50
ReporterNikola Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06891: Impossible to activate a survey when wrong label code
Description

When activating the survey, got the message: "Impossible to create table".

After invistigating, it looks like that a wrong question code was the origin of the problem.

I thought that there were no control in the UI for codes, those codes used to create fields in the survey responses table... But I tried to create an other example and I couldn't fill the same code: OK, there is a control.

So, where was the origin of the problem:

  • survey created in the previous version (2.00++ 121115)?
  • wrong import/export function?

The system should use an escaped fieldname when creating the table.

Steps To Reproduce

Create a sub question with the code "20d Des classements ".
How? Export/Import?
I joined my survey, created with 2.00++ build 121115

Additional Information

I modified the file helpers\admin\activate_helper.php to get the sql error. Got:
CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1166 Incorrect column name '721797X24X33020d Des classements '. The SQL statement executed was: CREATE TABLE survey_721797 (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
token VARCHAR(36),
submitdate datetime,
lastpage int(11),
startlanguage VARCHAR(20) NOT NULL,
721797X21X3111a text,
721797X21X3111b text,
(...)
721797X24X33020d Des classements VARCHAR(5),

TagsNo tags attached.
Attached Files
Bug heat2
Complete LimeSurvey version number (& build)121116
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5.5.11
Server OS (if known)debian
Webserver software & version (if known)Apache 2
PHP Version5.3.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-11-16 22:04

administrator   ~22292

Well, the question is how did you manage to enter that subquestion code in the first place?

c_schmitz

c_schmitz

2012-11-20 15:50

administrator   ~22339

I am sorry but we cannot fix a issue we cannot reproduce.
If you find out how please re-open the issue.

Issue History

Date Modified Username Field Change
2012-11-16 17:30 Nikola New Issue
2012-11-16 17:30 Nikola File Added: limesurvey_survey_386492.lss
2012-11-16 22:04 c_schmitz Note Added: 22292
2012-11-16 22:04 c_schmitz Assigned To => c_schmitz
2012-11-16 22:04 c_schmitz Status new => feedback
2012-11-20 15:50 c_schmitz Note Added: 22339
2012-11-20 15:50 c_schmitz Status feedback => closed
2012-11-20 15:50 c_schmitz Resolution open => fixed
2012-11-20 15:50 c_schmitz Fixed in Version => 2.00+