View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
04858Bug reportsImport/Exportpublic2011-01-26 22:10
Reporterpmonstad Assigned Totexens  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version1.91RC1 
Fixed in Version1.91RC3 
Summary04858: mysql crash when file upload
Description

When browsing answers I try to upload file. Generates error:

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 'FROM lime_survey_95793 WHERE id=152' at line 1:SELECT FROM lime_survey_95793 WHERE id=152

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)9696
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql 5 (centos 5.5)
Server OS (if known)centos 5.5
Webserver software & version (if known)apache 2
PHP Version5.1.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

texens

texens

2011-01-14 15:16

reporter   ~13913

pmonstad,

Could you please provide some more information regarding how to reproduce this bug? Did you use the Dataentry screen to upload the file?

Also, could you please give the complete error string that you came across while uploading the file.

Thanks,
Amit

pmonstad

pmonstad

2011-01-14 15:25

updater   ~13914

Last edited: 2011-01-14 15:27

Display responses -> View response details. Then I get an error when choosing download files for this entry:
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 'FROM lime_survey_95793 WHERE id=150' at line 1:SELECT FROM lime_survey_95793 WHERE id=150

If I choose Delete this entry I get an error telling:
You are not allowed to delete a response. (see bug tracker ID 04860)

The survey which generates the errors is enclosed.

texens

texens

2011-01-14 16:14

reporter   ~13915

pmonstad,

your survey does not include any 'file upload question type' questions. Hence, you cannon download any files from the browse page.
Ideally the 'Download files for this entry' button shouldn't be displayed on the browse page for this survey.

texens

texens

2011-01-14 16:17

reporter   ~13916

fixed in r9683

pmonstad

pmonstad

2011-01-15 12:20

updater   ~13930

You are right. I tested every aspect of the options to proof read and improve the Norwegian translation. Good to hear the possibility to upload files are disabled if the question type is not supporting it.

c_schmitz

c_schmitz

2011-01-26 22:10

administrator   ~13971

Released.

Issue History

Date Modified Username Field Change
2011-01-11 19:59 pmonstad New Issue
2011-01-12 18:50 c_schmitz Assigned To => texens
2011-01-12 18:50 c_schmitz Status new => assigned
2011-01-14 15:16 texens Note Added: 13913
2011-01-14 15:16 texens Status assigned => feedback
2011-01-14 15:25 pmonstad Note Added: 13914
2011-01-14 15:25 pmonstad Status feedback => assigned
2011-01-14 15:26 pmonstad File Added: limesurvey_survey_95793.lss
2011-01-14 15:27 pmonstad Note Edited: 13914
2011-01-14 16:14 texens Note Added: 13915
2011-01-14 16:17 texens Note Added: 13916
2011-01-14 16:17 texens Status assigned => resolved
2011-01-14 16:17 texens Fixed in Version => 1.91RC3
2011-01-14 16:17 texens Resolution open => fixed
2011-01-15 12:20 pmonstad Note Added: 13930
2011-01-26 22:10 c_schmitz Note Added: 13971
2011-01-26 22:10 c_schmitz Status resolved => closed