Error downloading files regarding Question type file upload.

More
4 years 5 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 5 months ago - 4 years 5 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 5 months ago by MrM.

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now