View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06891 | Bug reports | Import/Export | public | 2012-11-16 17:30 | 2012-11-20 15:50 |
Reporter | Nikola | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 06891: 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:
The system should use an escaped fieldname when creating the table. | ||||
Steps To Reproduce | Create a sub question with the code "20d Des classements ". | ||||
Additional Information | I modified the file helpers\admin\activate_helper.php to get the sql error. Got: 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 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 121116 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | MySQL 5.5.11 | ||||
Server OS (if known) | debian | ||||
Webserver software & version (if known) | Apache 2 | ||||
PHP Version | 5.3.6 | ||||
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+ |