XF 1.3 Reset node permissions for all usergroups

[sinucello]

Hi,

I have some nodes with incorrect node->usergroups permissions settings. To fix this I need to edit the node rights and then unset everything for every usergroup. Is there a way to do this quickly without having to open each node/usergroup?

thank you - all the best,
Sacha

 

[Paul B]

There is no other way of doing it.
It needs to be done per node/user group combination.

 

[sinucello]

OK, thanks I`m almost done...

 

[sinucello]

Hi,
I grew tired after more then 8 hours of clicking radio buttons and checking rights. I was desperate and just deleted entries in the table xf_permission_entry_content. Maybe it`s bad style but I can barely move my fingers and it seems to work.
Ciao,
Sacha

 

[sinucello]

Here`s the SQL code:

DELETE FROM `xenforo`.`xf_permission_entry_content` WHERE `xf_permission_entry_content`.`content_id` = 357;

replace 357 with the ID of the node / forum whose permissions you`d like to reset.

 

[Kevin]

Here`s the SQL code:

DELETE FROM `xenforo`.`xf_permission_entry_content` WHERE `xf_permission_entry_content`.`content_id` = 357;

replace 357 with the ID of the node / forum whose permissions you`d like to reset.

Thanks, I ran into an issue where it was much easier to do this via SQL.