Response Time
24 — 48 hours
Hello, Support.
Please investigate and fix error on save user profile (Joomla! v3.3.3; JA Purity III; Easy Discuss 3.2.9422):
1. open url: http://domain.com/en/component/users/profile.html?layout=edit
2. click "save profile"
-------------------
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 ') union select b.`category_id` from `main_discuss_category_acl_map` as b ' at line 1 SQL=select c.`id` from `main_discuss_category` as c where not exists ( select b.`category_id` from `main_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 `main_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` = '688' ) and c.`private` = '2'
--------------
Thanks.
Please investigate and fix error on save user profile (Joomla! v3.3.3; JA Purity III; Easy Discuss 3.2.9422):
1. open url: http://domain.com/en/component/users/profile.html?layout=edit
2. click "save profile"
-------------------
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 ') union select b.`category_id` from `main_discuss_category_acl_map` as b ' at line 1 SQL=select c.`id` from `main_discuss_category` as c where not exists ( select b.`category_id` from `main_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 `main_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` = '688' ) and c.`private` = '2'
--------------
Thanks.
13 Replies
The replies under this section are restricted to logged in users or users with an active subscription with us
