Products
Demo
Forum
Login
Register
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
May 24, 2012, 05:29:23
Advanced search »»
JoomlaTune Support Forum
Other extensions
Modules
Topic:
JDownloads SQL Error
Pages: [
1
]
Go Down
Print
Author
Topic: JDownloads SQL Error (Read 2802 times)
0 Members and 2 Guests are viewing this topic.
chopdog
Newbie
Karma: 0
Offline
Posts: 1
JDownloads SQL Error
«
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: 160
Offline
Gender:
Posts: 2559
Re: JDownloads SQL Error
«
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
Pages: [
1
]
Go Up
Print
JoomlaTune Support Forum
Other extensions
Modules
Topic:
JDownloads SQL Error
« previous
next »
Jump to:
Please select a destination:
-----------------------------
Announcements
-----------------------------
=> Announcements
-----------------------------
JComments component
-----------------------------
=> General discussion
=> Suggestions, Wishlists & Feature Requests
=> Integration with third-party extensions
===> AlphaUserPoints
===> CommunityBuilder
===> K2 JComments
=> Translations
=> Bug-reports
-----------------------------
ProofReader component
-----------------------------
=> General discussion
=> Suggestions, Wishlists & Feature Requests
=> Translations
=> Bug-reports
-----------------------------
Other extensions
-----------------------------
=> Plugins
=> Modules
Loading...