Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

JoomlaTune Support Forum    Other extensions    Modules    Topic: JDownloads SQL Error
Pages: [1]   Go Down
  Print  
Author Topic: JDownloads SQL Error  (Read 17006 times)
0 Members and 1 Guest are viewing this topic.
chopdog
Newbie
*

Karma: 0
Offline Offline

Posts: 1


« on: October 23, 2010, 14:35:38 »

Freshly installled JDownloads Categories. I have a very straight forward installation. Any ideas gratefully received.

No valid database connection 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 'ORDER BY parent_id, ordering' at line 1 SQL=SELECT cat_id as id, cat_title as title, parent_id as parent FROM clo_jdownloads_cats WHERE published = 1 AND cat_access <= ORDER BY parent_id, ordering

Logged
smart
Administrator
Hero Member
*****

Karma: 188
Offline Offline

Gender: Male
Posts: 1883



WWW
« Reply #1 on: October 23, 2010, 23:17:47 »

Open file mod_jdownloads_cats.php and replace:

Code: (php)
$where[] = 'cat_access <= ' . $access;
with
Code: (php)
if ($access != '') {
$where[] =  'cat_access <= ' . $access;
}
Logged

If you use JComments, please post a rating and a review at the Joomla! Extensions Directory
susancalf
Newbie
*

Karma: 0
Offline Offline

Posts: 1


Email
« Reply #2 on: July 23, 2012, 05:34:02 »

I Was having same problem, i just searched for the solution in google and i found your solution which worked for me.

SO thanks.
Logged
Pages: [1]   Go Up
  Print  
JoomlaTune Support Forum    Other extensions    Modules    Topic: JDownloads SQL Error
 
Jump to: