jDownloads Support Forum

Older Versions => jDownloads 3.2 (Support ended) => Bugs => Topic started by: classicpark on 22.04.2015 15:14:49

Title: You have an error in your SQL syntax
Post by: classicpark on 22.04.2015 15:14:49
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1'' and published = 1' at line 1 SQL=SELECT id from dddi_menu WHERE link = 'index.php?option=com_jdownloads&view=category&catid='1'' and published = 1
If i whant to ad a download on de backend i get this error
Have it also when  install the example data
And if i return to the control pannel for Jdownloads the example data is there also when i ad a download by my self

jDownloads Version 3.2.31 fresh install
Joomla4 3.4.1

Title: Re: You have an error in your SQL syntax
Post by: ColinM on 22.04.2015 15:30:00
Hi
As far as I know the MariaDB server, which is said to be a MySql look alike, is not formally supported on Joomla!   In consequence we have never tested on MariaDB.

Maybe the symptom you report is not MariaDB related.  So could you please send full details of how the fault appears so that we can simulate the sequence.  Please also identify which version of jDownloads, Joomla, PHP and similar that is relevant.

Thanks
Colin
Title: Re: You have an error in your SQL syntax
Post by: classicpark on 22.04.2015 15:38:15
php 5.3.27
Joomla 3.4.1
jDownloads Version 3.2.31
On my test site it works fine and if i put it on my main site i have those errors
Als if i make a backup from de database from my test site and  clear my jdownload tables from the main site and install the backup from my test site  its still the same
My test site is is axact the same as the main site
Title: Re: You have an error in your SQL syntax
Post by: ColinM on 22.04.2015 15:54:18
Hi
What I need is a step by step sequence of how you get to the fault state.   Or maybe it occurs immediately.  How are other things on the Backend, and what about Front End.  Have you migrated from say the jD 1.9.x series? Please details, details....

If the test site and your main site give different results then something must be  different.  It could be different/newer plugins, SEO set up, cache settings, etc, etc.

Colin
Title: Re: You have an error in your SQL syntax
Post by: classicpark on 22.04.2015 16:53:36
I poited my cofig file from my test site to my main site and than als there where no errors.
Pfffffffffffff
So i think yoyr wright about that there must someting wrong on the main site so now ithink i will delete the main site files and upload the files from my test site and hope this wil fix it
Title: Re: You have an error in your SQL syntax
Post by: ColinM on 22.04.2015 17:45:06
Hi
A good way is to do an Akeeba backup of the good site and then restoring from the backup.  There is an article onrestoring a site to WAMP in the documentation which might be useful.
Colin
Title: Re: You have an error in your SQL syntax
Post by: classicpark on 22.04.2015 18:16:35
I deleted al files and uploaded de backup
problem solved but still its strange because the backup and the main site have 100% the same files or its been hacked some where on the main site ???