Why your plugin delete table wp_capabilities?

  • Pierre236

    (@pierreto)


    1 year ago

    I keep your plugin because I can’t find a way to uninstall it without problem.

    Then have problem again with Rank Math who write me:

    “We can see one plugin installed that changes the default roles and capabilities of the website and that is likely causing the issue when our plugin tries to generate the author sitemap for a particular user role.

    If you have a staging website please try to remove the plugin “User Role Editor”, reset the WordPress capabilities and roles to default, and test the issue once again.”

    I do that but now your plugin delete the table wp_capabilities and I don’t know if it delete other important tables, but have big problem.

    How can I resolve it?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Pierre236

    (@pierreto)

    1 year ago

    Why you don’t give response?

    Your plugin delete table wp-capabilities in database, I don’t know if it’s an important table and if I need to recreate it.

    Plugin Author Vladimir Garagulya

    (@shinephp)

    1 year ago

    User Role Editor does not delete any database table. When you delete plugin URE via ‘Delete’ link under its row in the plugins list at the “Plugins” page URE deletes records it added to the wp_options database table. That’s it.

    There is no wp_capabilities table between database tables which belong to WordPress. If you search/write about data where WordPress stores user roles it is the record in the wp_options database table. Pay attention that ‘wp_’ here is the WordPress database prefix set in wp-config.php.

    If you have another database prefix, e.g. ‘cs123_’, record with user roles will have option_name field value set to ‘cs123_user_roles’. More information here: https://shinephp.com/how-to-change-wordpress-user-role-capabilities/

    If you write about selected user (ID=NN) permissions, it is the database record inside wp_usermeta database table, which you can find this way:

    SELECT * FROM wp_usermeta WHERE user_id=NN AND meta_key=’wp_capabilities’;

    And ‘wp_’ inside command above is the database prefix again which can be different.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Why your plugin delete table wp_capabilities?’ is closed to new replies.