View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
04516Bug reportsImport/Exportpublic2010-08-05 20:36
Reporteruser9112Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90RC3 
Fixed in Version1.90 
Summary04516: 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.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)8963
I will donate to the project if issue is resolved
BrowserFirefox
Database type & versionMySQL 5.1.47
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.2.15
PHP Version5.2.13
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2010-08-05 10:52

administrator   ~12576

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!

user9112

2010-08-05 20:11

  ~12578

Just upgraded to 1.90 and all is working fine. Thank you!

Issue History

Date Modified Username Field Change
2010-08-05 05:01 user9112 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 user9112 Issue Monitored: user9112
2010-08-05 20:11 user9112 Note Added: 12578
2010-08-05 20:11 user9112 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