MySQL query to add Public ACL to all Categories
By Patrick Kidney on Friday, 03 October 2014
Posted in Technical Issues
Likes 0
Views 894
Votes 0
Hello Stackideas,

I have many many categories. My client originally wanted me to configure the EasyDiscuss to only be accessablle by Registered users with additional specific users groups.

However, he recently decided he wants all of the categories and discussions visible to the public.

I am hoping to avoid going through 200 categories and manually editting the ACL in the backend.

My solution is to use a MySQL query to update all categories at once.

I believe that the table I will need to access for this is:
x_discuss_category_acl_map

Is this correct?

I need every category to be a memember of the Public ACL which is id = 1
Hello Patrick Kidney,

Sorry for late reply to this,
I have help you fix it, please have a check.
Arlex Wong
·
Tuesday, 07 October 2014 15:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Patrick,

Yep, that's correct You just need to update the ACL table for the category. Perhaps in the future, it would be cool if we could have a "Mass" operation tool
Mark
·
Friday, 03 October 2014 01:43
·
0 Likes
·
0 Votes
·
0 Comments
·
I agree, thanks again Mark!
Patrick Kidney
·
Friday, 03 October 2014 02:51
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Patrick
Mark
·
Friday, 03 October 2014 11:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey,

I'm about reaedy to load my table, but I am not 100% sure what the content_id field is. What is it?
Patrick Kidney
·
Friday, 03 October 2014 21:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Is it the user group id?
Patrick Kidney
·
Friday, 03 October 2014 22:29
·
0 Likes
·
0 Votes
·
0 Comments
·
I also have the error "Model class easydiscussModelCategory not found" when i create new categories. I see other people have asked this before, but I do not have k2 installed and I dont want to try the patches you provided for other people specifically unless you say so.
Patrick Kidney
·
Saturday, 04 October 2014 02:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Patrick,

The 'content_id' column is actually the "joomla user group" id. As for the error that you are getting, I believe there's a plugin "System - K2" that is enabled on the site. Can you check if such plugin is enabled?
Mark
·
Saturday, 04 October 2014 12:54
·
0 Likes
·
0 Votes
·
0 Comments
·
I do not have K2, it must be another component. Are there any others that are known to do this?
Patrick Kidney
·
Tuesday, 07 October 2014 01:02
·
0 Likes
·
0 Votes
·
0 Comments
·
The only thing I found was a K2 plugin for XMap (Sitemap plugin). It was deactivated. I unistalled it and I still see the error.
Patrick Kidney
·
Tuesday, 07 October 2014 01:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Patrick,

Hm, I just tried to create a category in EasyDiscuss on your site but cannot reproduce this error.
Mark
·
Tuesday, 07 October 2014 02:00
·
0 Likes
·
0 Votes
·
0 Comments
·
It is appearing for me, but not when I make a new parent/ top level category.

I am making a new sub-sub-category, so in Automotive category for example, and then when I click "Save & New" the error shows.
Patrick Kidney
·
Tuesday, 07 October 2014 02:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Looks good to me thank you!
Patrick Kidney
·
Wednesday, 08 October 2014 03:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Patrick Kidney,

You're welcome, glad to heard your issues resolved.

I will mark this thread as resolved and lock it to avoid any confusions in the future, but if you need any help please feel free to start a new thread in our forums.
Arlex Wong
·
Wednesday, 08 October 2014 10:41
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post