Hello,
I am using Easyblog version 5.0.8. When adding the categories list module, I get and 1064 SQL error.
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 '-2' at line 1 SQL=SELECT a.*, (select count(1) from `uvte_easyblog_post_category` as `pcat` INNER JOIN `uvte_easyblog_post` as p on pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0' where pcat.`category_id` IN (select c.`id` from `uvte_easyblog_category` as c where (c.`id` = a.`id` OR c.`parent_id` = a.`id`)) ) as cnt from `uvte_easyblog_category` as a WHERE a.`published`='1' and a.`parent_id` = 0 and (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `uvte_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (1,2,3,8)) > 0)) ) ORDER BY a.`created` DESC LIMIT 0,-2
Met vriendelijke groet / Kind regards,
Harald Paterek
I am using Easyblog version 5.0.8. When adding the categories list module, I get and 1064 SQL error.
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 '-2' at line 1 SQL=SELECT a.*, (select count(1) from `uvte_easyblog_post_category` as `pcat` INNER JOIN `uvte_easyblog_post` as p on pcat.`post_id` = p.`id` and p.`published` = '1' and p.`state` = '0' where pcat.`category_id` IN (select c.`id` from `uvte_easyblog_category` as c where (c.`id` = a.`id` OR c.`parent_id` = a.`id`)) ) as cnt from `uvte_easyblog_category` as a WHERE a.`published`='1' and a.`parent_id` = 0 and (( ( a.`private` = 0) OR ( a.`private` = 1 and 1 > 0) OR ( a.`private` = 2 and (select count(1) from `uvte_easyblog_category_acl` where `category_id` = a.`id` and `acl_id` = 1 and `content_id` in (1,2,3,8)) > 0)) ) ORDER BY a.`created` DESC LIMIT 0,-2
Met vriendelijke groet / Kind regards,
Harald Paterek