Error downloading files regarding Question type file upload.

More
4 years 3 months ago #92809 by MrM
MrM created the topic: Error downloading files regarding Question type file upload.
(Sorry, posted this yesterday in the wrong sub-forum)

Hello,

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.
Anyone?

Thanks, Marten

Please Log in to join the conversation.

More
4 years 3 months ago - 4 years 3 months ago #92847 by MrM
MrM replied the topic: Error downloading files regarding Question type file upload.
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 3 months ago by MrM.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now