jDownloads Support Forum

Older Versions => jDownloads 3.2 (Support ended) => Topic started by: ciroslitz on 12.06.2017 14:51:05

Title: 1064 You have an error in your SQL syntax - [Not a jDownloads issue]
Post by: ciroslitz on 12.06.2017 14:51:05
After updating to joomla 3.7.2 if I try to download a file it looks like:

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

site:
https://www.professionistiscuola.it/servizi/area-download/category/4-formazione-docenti-neoimmessi.html
Title: Re: 1064 You have an error in your SQL syntax
Post by: Arno on 12.06.2017 15:09:32
Hm. Strange. What was your old Joomla version?

Had you changed also the PHP version recently?
Use you the newest jD version?
Title: Re: 1064 You have an error in your SQL syntax
Post by: ciroslitz on 12.06.2017 15:14:06
old joomla 3.6.5 upgrade 3.7.2

jdownload  3.2.51


Help me :( :(
Title: Re: 1064 You have an error in your SQL syntax
Post by: ciroslitz on 12.06.2017 15:16:53
PHP 7.0

The problem with the new downloads created
Title: Re: 1064 You have an error in your SQL syntax
Post by: Arno on 12.06.2017 19:17:03
QuoteThe problem with the new downloads created

Sorry but what did you mean with this?  ::)
It is not really useful to give only so tiny informations.

Maybe should you install the version 3.2.51 a second time.
Nobody else seems to have a problem like this.
Title: Re: 1064 You have an error in your SQL syntax
Post by: ciroslitz on 12.06.2017 21:11:36
What other information is needed?

I tried to uninstall and reinstall ... the same problem


Can I provide admin panel access?

Even if I create new dowloads there is an error.


Thanks for your help
Title: Re: 1064 You have an error in your SQL syntax
Post by: ciroslitz on 12.06.2017 21:20:52
Found seo simple creates conflict

https://extensions.joomla.org/extensions/extension/site-management/seo-a-metadata/seosimple/

Can you help me solve it?
Title: Re: 1064 You have an error in your SQL syntax
Post by: ColinM on 12.06.2017 21:56:23
Hi
This has been a bug in SEOsimple for a long time!  See https://github.com/nocean/SEOSimple/issues/3
It refers to http://www.jdownloads.com/forum/index.php?topic=8152.0

Basically SEOSimple does not check that the category type to see if it is a Joomla! article category.  Several extensions use their own categories. See for example the https://docs.joomla.org/Understanding_categories_and_articles#Other_Types_of_Categories

You need to take it up with SEOSimple as it is their problem, but regretably they do not seem to respond quickly.

Colin
Title: Re: 1064 You have an error in your SQL syntax
Post by: ciroslitz on 12.06.2017 22:08:59
thank you
Important to understand

After updating to joomla 3.7.2 I installed seo simple i tried disabling and i solved.

Title: Re: 1064 You have an error in your SQL syntax
Post by: Arno on 12.06.2017 23:36:21
Thanks for this important hint Colin.  ;)