By Anthony Morrison on Monday, 10 August 2015
Posted in Technical Issues
Replies 1
Likes 0
Views 372
Votes 0
Hi, When i select the Subscribe via rss button from http://allnuze.com/index.php/blog/categories, i get the following error:
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 'AND a.`lft` < AND (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.' at line 1 SQL=select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id` from `kcn0p_easyblog_category` as a WHERE a.`lft` > AND a.`lft` < AND (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `kcn0p_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (1)) > 0))) ORDER BY a.`lft` ASC

You can
Hello Anthony,

I've fixed it for you in this file: ../components/com_easyblog/router.php . This issue has already fixed in the latest version (5.0.19).
·
Monday, 10 August 2015 12:23
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post