jDownloads Support Forum

Older Versions => jDownloads 3.2 (Support ended) => Bugs => Topic started by: SoundHunter on 29.04.2014 00:34:18

Title: Error: 1064 - [Fixed in 3.2.3]
Post by: SoundHunter on 29.04.2014 00:34:18
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
Title: Re: Error: 1064
Post by: Arno on 29.04.2014 01:58:57
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?
Title: Re: Error: 1064
Post by: SoundHunter on 29.04.2014 07:14:14
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
Title: Re: Error: 1064
Post by: Arno on 29.04.2014 08:48:37
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.
Title: Re: Error: 1064
Post by: SoundHunter on 29.04.2014 20:33:15
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
Title: Re: Error: 1064
Post by: Arno on 29.04.2014 21:44:47
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.
Title: Re: Error: 1064
Post by: SoundHunter on 29.04.2014 23:11:27
Thanks!
You got a PM  ;)
Title: Re: Error: 1064
Post by: Arno on 29.04.2014 23:56:57
I have your send an e-mail.
Please test it and post afterwards here the result.
Title: Re: Error: 1064
Post by: Arno on 30.04.2014 00:18:40
Okay, the problem is solved and will be a part from next update 3.2.3.