SQL error on save user profile
By Evgeniy on Thursday, 14 August 2014
Posted in Technical Issues
Likes 0
Views 1K
Votes 0
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.
Guys, please try to download the attached file and upload it into /components/com_easydiscuss/helpers/ and overwrite the helper.php file.
Mark
·
Sunday, 17 August 2014 22:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Please provide us with the back end and FTP access to the site to check on this please.
Mark
·
Thursday, 14 August 2014 12:34
·
0 Likes
·
0 Votes
·
0 Comments
·
FTP access is not ready, but the error is critical.
Please investigate this issue/error on your side.
And tell me how to fix it and what to change in the code.
Thank a lot.
Evgeniy
·
Thursday, 14 August 2014 13:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Well, I would if I could because I cannot reproduce this error on my end
Mark
·
Thursday, 14 August 2014 13:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok. Timeout...
(I will create a development stand before...)
Evgeniy
·
Thursday, 14 August 2014 13:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Evgeniy,

Sure, let me know when you are ready
Mark
·
Thursday, 14 August 2014 16:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi i have the same error when i upgrade the user avatar. I need to disconnect the user throght the admin interface. Then when, he come back to the website, is allright, and he can login without any error.
I use easy profil and their plugin joomsocial and i configure easydiscuss to use joomsocial avatar.
Best regards
saidi
·
Thursday, 14 August 2014 21:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Saidi,

Can you please start a new thread and provide us with the following details please?

1. Access to back end
2. FTP access
3. Steps to reproduce this issue
Mark
·
Friday, 15 August 2014 02:34
·
0 Likes
·
0 Votes
·
0 Comments
·
The problem is due to easydiscuss on joomla 3.3.3.
The problem not appears on an older version of joomla.
Please help
saidi
·
Sunday, 17 August 2014 19:53
·
0 Likes
·
0 Votes
·
0 Comments
·
Congratulation and many thanks, It works !
Will you include this fix in the futur easydiscuss version?
saidi
·
Sunday, 17 August 2014 22:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, this fix will be included in the next release of EasyDiscuss
Mark
·
Sunday, 17 August 2014 22:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark, BIG THANKS! ALL WORKS!!!
And XMap (http://stackideas.com/forums/xmap-incorrect-generate-sef-links-skipped-menu-path-before) is FIXED !!!
Evgeniy
·
Monday, 18 August 2014 05:35
·
0 Likes
·
0 Votes
·
0 Comments
·
in behalf of mark: you're welcome good to hear that your issue's resolved.
Alex
·
Monday, 18 August 2014 05:40
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post