Sure, 4.18.3 should not lead to the described problem due to minor changes it introduced (read changelog).
I don’t know the exact reason, but after click “Reset” button you lost access to the listed plugins definitely. “Reset” recreates WordPress built-in roles and capabilities from the scratch – that is you lose all capabilities added by plugins.
WooCommerce recreates its user capabilities during activation, but TablePress does not.
You have 2 variants to restore TablePress user capabilities:
1) add them yourself via URE’s ‘Add Capability’ button:
tablepress_access_about_screen
tablepress_access_options_screen
tablepress_add_tables
tablepress_copy_tables
tablepress_delete_tables
tablepress_edit_options
tablepress_edit_tables
tablepress_export_tables
tablepress_import_tables
tablepress_import_tables_wptr
tablepress_list_tables
or
2) deactivate TablePress plugin, delete TablePress options record from wp_option DB table
delete from wp_options where option_name='tablepress_plugin_options' limit 1;
then activate TablePress back.
The big problem in all situation that I don’t know exactly what are the affected plugins (I discoverd WooCommerce and TablePress because I’m using them daily on bases).
This issue is a complete disaster for me cuz URE broke my website.
NOTE: I use URE on many websites and I never faced this strange problem (I use same set of plugins on all my websites)
It’s really strange as URE does not touch other user capabilities during update.
If that’s applicable send to the support [at-sign] role-editor.com the links to the zipped files of problematic site and its exported MySQL database. I will try to reproduce an issue at my test environment and find the reason.
I don’t know exactly what are the affected plugins
You may setup plugins one by one to the test site and look at the ‘Custom capabilities’ section. If recently activated plugin added new user capabilities, then it was affected by resetting caps to default set and you need to restore them.
Thanks Vladimir for the good gesture. I sent the database to your e-mail.
I installed received database copy, WordPress 4.1.1, WooCommerce, TablePress and URE plugins. I deactivated/activated User Role Editor. WooCommerce is still available. I restored access to TablePress and it is still available after URE’s reactivation. Can you repeat described issue?
4. Reinstalled URE (didn’t fix anything and hide WooCommerce once again)
Do you use specific theme at problematic site, different from themes you use at other sites?
I did what you suggested nothing changed so as a last resort I sent to you username and password to the website of the sent database to examin a real test.
I restored the access to the TablePress by adding its caps manually.
I deactivated/activated URE – access to WooCommerce and TablePress is still there.
What do you mean in “its caps”? Did you know the reason of hiding them?
IMPORTANT: I’m not sure what if there are another plugins suffer from this issue.
“its caps” – TablePress use its own set of user capabilities. All they are started from ‘table_press’ as listed at my 1st answer.
I know one reason after which they were definitely disappeared and you lost access to the plugin – you used ‘Reset’ function at User Role Editor. I can not name other reasons.
As about other plugins – it depends if plugin uses its own capabilities or it does not. You may use a recommendation I made yesterday to check that.
I know one reason after which they were definitely disappeared and you lost access to the plugin – you used ‘Reset’ function at User Role Editor
Actually after modifying some caps I became unable to see “administrator” role although my account is “administrator” this may first thing I noticed before discovering the problem.
As about other plugins – it depends if plugin uses its own capabilities or it does not. You may use a recommendation I made yesterday to check that.
Although it’s unpractical solution (I’ve more than 22 plugin). How can I know which plugin needs a custom caps?
In order to see ‘Administrator’ role in the roles list you need to turn on the ‘Show Administrator role at User Role Editor’ option at ‘Settings – User Role Editor’ page ‘General’ tab. It was turned off when I looked at your site yesterday (it is the default state).
How can I know which plugin needs a custom caps?
There are 3 possible ways to know its for free:
1) Use solution I made already;
2) Read plugin source code;
3) Ask plugin author.
‘Admin menu’ add-on to the paid Pro version of User Role Editor may show capabilities needed for active plugins:
https://www.role-editor.com/block-admin-menu-items
So you may take such information from your other sites.
Thanks, I’ll double check all installed plugins to fix this issue.
unfortunately I’ll miss URE a lot but it broke my websites so I’ve to remove it from my plugins set 🙁
