Hi I am re-designing my website. The url is dev.soulspring.org. If you go to wellness from the main menu and click on the showcase blog , I am getting a Syntx error:
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 ') or c.`parent_id` IN ()) AND b.`state`='0'' at line 1 SQL=SELECT COUNT(1) AS `cnt` FROM `oqb_easyblog_post_category` AS `a` INNER JOIN `oqb_easyblog_post` AS `b` ON a.`post_id` = b.`id` AND b.`published`='1' INNER JOIN `oqb_easyblog_category` AS `c` ON a.`category_id` = c.`id` AND b.`access`='0' WHERE ( c.`id` IN () or c.`parent_id` IN ()) AND b.`state`='0'
I just updated the Easyblog to the latest but still a problem. How do I fix?
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 ') or c.`parent_id` IN ()) AND b.`state`='0'' at line 1 SQL=SELECT COUNT(1) AS `cnt` FROM `oqb_easyblog_post_category` AS `a` INNER JOIN `oqb_easyblog_post` AS `b` ON a.`post_id` = b.`id` AND b.`published`='1' INNER JOIN `oqb_easyblog_category` AS `c` ON a.`category_id` = c.`id` AND b.`access`='0' WHERE ( c.`id` IN () or c.`parent_id` IN ()) AND b.`state`='0'
I just updated the Easyblog to the latest but still a problem. How do I fix?