View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
05311Bug reportsResponse browsingpublic2011-07-08 17:15
Reporterjungstar Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.91+ 
Fixed in Version1.91+ 
Summary05311: SQL Error when trying to download a file of a survey response
Description

The system produces a SQL error when the admin wants to download a file of a survey response.

Steps To Reproduce
  1. Create a survey with question of type file upload.
  2. upload a file and submit your questionnaire
  3. Go to Responses & statistics
  4. Display responses
  5. Click on "Download marked files" or "Download all files in this response as a zip file" or try to download a single file

=> Everything results in an SQL error

Additional Information

ERROR: syntax error at or near "X195X4491" LINE 1: SELECT 54177X195X4491 , 54177X195X4492 FROM "lime_survey_5... ^:SELECT 54177X195X4491 , 54177X195X4492 FROM "lime_survey_54177" WHERE id=2

For me it seems that quotation marks for the column names are missing (quoted identifier).

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)10315
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 8.3
Server OS (if known)Ubuntu 8.04
Webserver software & version (if known)Apache/2.2.8
PHP VersionPHP/5.2.4-2

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-07-03 11:59

administrator   ~15620

Thank you. Fixed in rev 10411

c_schmitz

c_schmitz

2011-07-08 17:15

administrator   ~15690

New 1.91+ version released.

Issue History

Date Modified Username Field Change
2011-06-29 09:02 jungstar New Issue
2011-06-29 13:27 c_schmitz Assigned To => c_schmitz
2011-06-29 13:27 c_schmitz Status new => assigned
2011-07-03 11:59 c_schmitz Note Added: 15620
2011-07-03 11:59 c_schmitz Status assigned => resolved
2011-07-03 11:59 c_schmitz Fixed in Version => 1.91+
2011-07-03 11:59 c_schmitz Resolution open => fixed
2011-07-08 17:15 c_schmitz Note Added: 15690
2011-07-08 17:15 c_schmitz Status resolved => closed