Error: 1064 - [Fixed in 3.2.3]

[SoundHunter]

I switched of the direct download option (bug) and get now the following error:

Error: 1064 - 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 3 SQL=SELECT COUNT(*) FROM ***Databasename***_logs WHERE type = '1' AND log_ip = '***My IP Address***' AND log_file_id = '469' AND log_datetime <= NOW() AND log_datetime >= (NOW() - INTERVAL MINUTE)

Is that also a known error?

Best Regards,

SoundHunter

[Arno]

I think that in the meantime some users has imported the data from a older 1.9.x version.
But nobody else has until today posted a problem like this.

Use you limits in the user groups settings?

[SoundHunter]

Dear Arno,

No, all settings at the usergroup settings are at default.
I got this error also after upgrading to version 3.2.2 of jDownloads.
The direct download linkt does now more than before but gives me the above error message again.

Any help would be greatly appreciated!

Best regards,

SoundHunter

[Arno]

Hi,
i can not reproduce it here, since you have not posted more detailed informations.
So please send me a link to this error via PM.

[SoundHunter]

Hi Arno,

You already had an link to the installation send via PM, it is the same installation as the previous sended link (yesterday).

Hope you will find something.

Some extra info: the problem only happens to public users.
When a registered user or an admin login en try to download a file, everything works perfectly.
User Groups Setting: all default
Options screen: Public - Download - Allowed

Thanks in advance.

Best regards,

SoundHunter

[Arno]

I need login data for the backend as super admin via pm.  
I think that this problem has to with your configuration settings. Nobody else has this problem.

[SoundHunter]

Thanks!
You got a PM 

[Arno]

I have your send an e-mail.
Please test it and post afterwards here the result.

[Arno]

Okay, the problem is solved and will be a part from next update 3.2.3.