jDownloads Support Forum

Older Versions => jDownloads 3.2 (Support ended) => General => Topic started by: water on 06.10.2014 05:18:56

Title: Error: 1064 - You have an error in your SQL syntax;
Post by: water on 06.10.2014 05:18:56
Hello everybody. I just realize Im getting Error: 1064 today after updating my joomla 3.3.3 to Joomla! 3.3.6. The error read this.

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 1 SQL=SELECT cat.description FROM surqa_categories cat WHERE cat.id=

From a module I can click one of the link and it take me to the download page but if i try clicking to the details page I get the error. Also i can go to the main category page but if I try to go into a category I also get the error.

Any Idea how to fix this problem
Title: Re: Error: 1064 - You have an error in your SQL syntax;
Post by: ColinM on 06.10.2014 09:47:21
Hi
There have been some changes - bugs- introduced in Joomla 3.3.4 to 3.3.6 that are affecting jDownloads.  One in particular is the the pagination in say List All Downloads does not appear in 3.3.6.  Only known solution at this time is to go back to Joomla 3.3.3  But maybe Arno has a short term 'fix'.

Colin
Title: Re: Error: 1064 - You have an error in your SQL syntax;
Post by: water on 06.10.2014 19:12:06
how can i downgrade I was searching on Joomla site but couldn't find anything about downgrading they all recommend to stick with the new version. Arno any fix coming soon for this problem?
Title: Re: Error: 1064 - You have an error in your SQL syntax;
Post by: Arno on 17.10.2014 12:59:22
This thema is already discuss in a other thread. So i will close this here.