Check out the LimeSurvey source code on GitHub!

Error downloading files regarding Question type file upload.

4 years 1 day ago #92809 by MrM
(Sorry, posted this yesterday in the wrong sub-forum)


We use Version 1.91 Build 10089 and Microsoft SQL dB.

We are getting this message if we want to download uploaded files using the FileUpload Question:
(Download files as a zip file)

SQLState: 42000 Error Code: 0 Message: [Microsoft][SQL Server Native Client 10.0]Syntax error, permission violation, or other nonspecific error :SELECT 62635X71X24447 FROM [lime_survey_62635] WHERE id={}

We see the uploaded files on the server. So that part is ok.

Remains this issue with the downloading.

Thanks, Marten

Please Log in to join the conversation.

4 years 7 hours ago - 4 years 7 hours ago #92847 by MrM
We thought it might be MS SQL.
So installed everything using MySQL.

Unfortunately also an 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 '}' at line 1:SELECT 62635X2X14 FROM `lime_survey_62635` WHERE id={}"

I looked in Bug sections, so far no luck.
Maybe because of Version 1.91 Build 10089??

Thx, Marten
Last Edit: 4 years 7 hours ago by MrM.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form