Kento

Thank you very much for posting your findings, would you mind letting us know which exact settings in W3TC you were using when this happened? It would be interesting to research it on our side.

You’re very welcome, I hope this will help, I would recommend to following steps:

First make a backup of the site and database as it currently is.

From your previous backup, look at the database backup and find the CREATE TABLE v4x_groups_group ... statement for the table that is missing. Use that statement to create the table. Locate the INSERT INTO v4x_groups_group ... statement that will insert the group data into the table.

If that table is the only one missing, then this could solve the issue for you.

If your database has been corrupted further than just this missing table, you will need to consider the decision to revert to a previous backup and insert the new data after that.

Hi,

The error you get indicates that one of the database tables that Groups creates – and requires – is missing. This table stores information about groups that the plugin handles and is essential.

This table should not be missing and must have been deleted by accident. Or if you have moved the site to another server, maybe the table was not imported.

I would recommend to recover from a backup to make sure your database is consistent.

Regarding the extension, yes, it requires Groups to be active. The table that is missing is essential for Groups, thus it is also essential for the extension to work properly.

Great, it would be interesting to see the solution when you’ve had a chance to look into it. I guess the block editor’s categories meta box could be affected by the filter, but I wonder if there’s another way to achieve what you need hooking into anything that the block editor provides.

Hi!

Thanks for posting this, it’s a case that isn’t covered yet OOTB by Groups or any of its extensions.

One approach you could take is to limit the categories offered when someone is editing a post based on their group membership. You’d have to use a filter to limit the categories offered, and could use Groups’ API to check for the user’s membership.

For example, use the list_terms_exclusions filter hook and exclude categories that the user should not be able to choose while editing a post. On the Examples documentation page you can see how to check for a user’s membership. Also useful as a source are the repositories related to Groups.

I hope this helps, feel free to ask if you have any questions!

Thanks for sharing your solution!

As a reference for others who might seek a similar solution, there is also this plugin which adds a user on registration based on his role https://github.com/itthinx/groups-role-registration

Thank you very much Fabio, that’s really great to hear! I hope it will be useful to you for many years to come!

Haha :D, awesome, nicely put! Thank you very much for your feedback!

That’s great to hear, I think keeping it easy to use is a very important part of its usefulness. Thanks for the feedback!

Thank you so much! Such nice feedback brings happiness to everyone on the team ??

Hi, I’m not aware of any particular integration for Elementor but you could use this:

• Create a content block using Widgets Control (see the documentation for details). The content blocks are a custom post type which you can protect with Groups as usual.
• Insert the content block in your page editing with Elementor; look under WordPress and find the “Content Block” element – choose the content block you have created in the dropdown.

Awesome, thank you very much!

Did you do your own integration with that plugin or does it already integrate itself with Groups?

Hi,

the Groups plugin does not change a user’s role. Whatever caused this was either another plugin or someone changed it manually, but certainly not Groups.

Regarding the table you mention, that’s expected and is not involved in user roles.

You can simply change the user role back by logging in with another account that has the Administrator role and editing the corresponding user’s profile, setting its role to Administrator.

If you don’t have such an account, you can set the role of the initial administrator user, whose user id is 1, using a database query – but make a full backup of your site and its database and be sure you know how to restore it before you run any such queries:

UPDATE wp_usermeta SET meta_value = 'a:1:{s:13:"administrator";b:1;}' WHERE user_id = 1 AND meta_key = 'wp_capabilities';

This is assuming that your setup uses the default wp_ database table prefix, which it seems to do based on your report.

Useful documentation is the Roles and Capabilities page.

Although this cannot be done with Groups yet, it’s great to see that there is more interest in those types of access control. Noted and will take this into consideration for further enhancements.

Hi there, thanks for the question – I’ve just posted a reply here.

Please note that the Forum Guidelines here prohibit posting about commercial products, as you don’t seem to be aware of the rule, I just wanted to make sure you know. If you have any follow-up questions on the extension, please make sure to reply to the comment I left referenced above.