News:

Support for jDownloads 3 has been ended
Since 17 August 2023 Joomla.org has discontinued support for Joomla 3.x. Therefore, we will no longer offer official support for our Joomla 3 jDownloads version 3.9.x from January 2024.
Please update your website to the latest Joomla version (Joomla 4 or Joomla 5) as soon as possible. Afterwards, please update jDownloads to the latest published version. The longer you delay, the more difficult the upgrade process for your website is likely to be.

Main Menu
Support-Forum

After Import/Upgrade ERROR - [Solved !!!]

Started by bsiegle, 15.11.2014 23:37:04

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

bsiegle

Receiving SQL error after going through upgrade/import procedures for 3.2.16

1064 Error: 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 pj5o6_categories cat WHERE cat.id=

This occurs when I am trying to list files in a category in a menu item.
Listing category works, clicking on category to view files fails.
Listing all files directly from menu works.

Joomla 3.3.6
JDownloads 3.2.16
PHP Version 5.4.34
  •  

Arno

Hi,
QuoteReceiving SQL error after going through upgrade/import procedures for 3.2.16

QuoteSELECT cat.description FROM pj5o6_categories cat WHERE cat.id=
This db table is not from jDownloads.

We had a few weeks before another user with a error message like yours.
As result had we find this:
http://www.jdownloads.com/forum/index.php?topic=7433.msg28950#msg28950
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!
  •  

bsiegle

#2
Turns out it is the SimpleSEO module causing the conflict. Disabled it, and problems went away. The
  •