Response Time
24 — 48 hours
I have a site that uses Jomsocial for its User Profile management as well as Hikashop. Non-logged in visitors can see discussions without any problem. This is for a new version of a site that isn't public yet.
If someone logs in and tries to view Discussions, they get the 1064 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 ') union select b.`category_id` from `jos3_discuss_category_acl_map` as b ' at line 1 SQL=select c.`id` from `jos3_discuss_category` as c where not exists ( select b.`category_id` from `jos3_discuss_category_acl_map` as b where b.`category_id` = c.`id` and b.`acl_id` = '2' and b.`type` = 'group' and b.`content_id` IN () union select b.`category_id` from `jos3_discuss_category_acl_map` as b where b.`category_id` = c.`id` and b.`acl_id` = '2' and b.`type` = 'user' and b.`content_id` = '231' ) and c.`private` = '2'
-------------------------------------------------------
How do I fix this problem?
If someone logs in and tries to view Discussions, they get the 1064 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 ') union select b.`category_id` from `jos3_discuss_category_acl_map` as b ' at line 1 SQL=select c.`id` from `jos3_discuss_category` as c where not exists ( select b.`category_id` from `jos3_discuss_category_acl_map` as b where b.`category_id` = c.`id` and b.`acl_id` = '2' and b.`type` = 'group' and b.`content_id` IN () union select b.`category_id` from `jos3_discuss_category_acl_map` as b where b.`category_id` = c.`id` and b.`acl_id` = '2' and b.`type` = 'user' and b.`content_id` = '231' ) and c.`private` = '2'
-------------------------------------------------------
How do I fix this problem?
7 Replies
The replies under this section are restricted to logged in users or users with an active subscription with us
