View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04516 | Bug reports | Import/Export | public | 2010-08-05 05:01 | 2010-08-05 20:36 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | high | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.90RC3 | ||||
| Fixed in Version | 1.90 | ||||
| Summary | 04516: Error when trying to export survey results to Excel or CSV | ||||
| Description | When all columns are selected in the Choose Column list box on the Export Results page, the following error displays in Excel or the first line of the CSV file: 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 'AND language='en' ORDER BY gid, title' at line 1:SELECT question, type, other, title FROM lime_questions WHERE qid= AND language='en' ORDER BY gid, title This can be avoided by only selecting the user created columns. If the following columns are selected, the error is produced (id, submitdate, lastpage, startlanguage, token, datestamp, startdate, lpaddr). | ||||
| Steps To Reproduce | Open the Export Results page and select all columns to export. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 8963 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | Firefox | ||||
| Database type & version | MySQL 5.1.47 | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | Apache 2.2.15 | ||||
| PHP Version | 5.2.13 | ||||
| Git branch / Pull Request URL | |||||
|
Hello! We just released 1.90. Please check if the problem persists with the 1.90 release a give some feeback. If you can still reproduce it (because I couldn't) please attach a tiny sample survey to reproduce the problem. Thank you! |
|
|
Just upgraded to 1.90 and all is working fine. Thank you! |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-08-05 05:01 |
|
New Issue | |
| 2010-08-05 10:52 | c_schmitz | Note Added: 12576 | |
| 2010-08-05 10:52 | c_schmitz | Assigned To | => c_schmitz |
| 2010-08-05 10:52 | c_schmitz | Status | new => feedback |
| 2010-08-05 15:48 |
|
Issue Monitored: user9112 | |
| 2010-08-05 20:11 |
|
Note Added: 12578 | |
| 2010-08-05 20:11 |
|
Status | feedback => assigned |
| 2010-08-05 20:36 | c_schmitz | Status | assigned => closed |
| 2010-08-05 20:36 | c_schmitz | Resolution | open => fixed |
| 2010-08-05 20:36 | c_schmitz | Fixed in Version | => 1.90 |