JDownloads SQL Error

[chopdog]

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

[smart]

Open file mod_jdownloads_cats.php and replace:

Code: (php)

$where[] = 'cat_access <= ' . $access;

with

Code: (php)

if ($access != '') {
$where[] =  'cat_access <= ' . $access;
}

[susancalf]

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

SO thanks.