jDownloadsownloads.com


Author Topic: 1064 You have an error in your SQL syntax - [Not a jDownloads issue]  (Read 460 times)

0 Members and 1 Guest are viewing this topic.

Offline ciroslitz

  • Newbie
  • *
  • Posts: 11
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
« Last Edit: 12.06.2017 23:37:29 by Arno »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.271
    • jDownloads.com
Re: 1064 You have an error in your SQL syntax
« Reply #1 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?
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline ciroslitz

  • Newbie
  • *
  • Posts: 11
Re: 1064 You have an error in your SQL syntax
« Reply #2 on: 12.06.2017 15:14:06 »
old joomla 3.6.5 upgrade 3.7.2

jdownload  3.2.51


Help me :( :(

Offline ciroslitz

  • Newbie
  • *
  • Posts: 11
Re: 1064 You have an error in your SQL syntax
« Reply #3 on: 12.06.2017 15:16:53 »
PHP 7.0

The problem with the new downloads created
« Last Edit: 12.06.2017 16:09:58 by ciroslitz »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.271
    • jDownloads.com
Re: 1064 You have an error in your SQL syntax
« Reply #4 on: 12.06.2017 19:17:03 »
Quote
The 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.
« Last Edit: 12.06.2017 19:25:39 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline ciroslitz

  • Newbie
  • *
  • Posts: 11
Re: 1064 You have an error in your SQL syntax
« Reply #5 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

Offline ciroslitz

  • Newbie
  • *
  • Posts: 11
Re: 1064 You have an error in your SQL syntax
« Reply #6 on: 12.06.2017 21:20:52 »

Offline ColinM

  • Moderator
  • *
  • Posts: 3.640
Re: 1064 You have an error in your SQL syntax
« Reply #7 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

Offline ciroslitz

  • Newbie
  • *
  • Posts: 11
Re: 1064 You have an error in your SQL syntax
« Reply #8 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.

« Last Edit: 12.06.2017 22:11:57 by ciroslitz »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.271
    • jDownloads.com
Re: 1064 You have an error in your SQL syntax
« Reply #9 on: 12.06.2017 23:36:21 »
Thanks for this important hint Colin.  ;)
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!