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 | ||||
| Git branch / Pull Request URL | |||||
| 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+ |