This WP User’s Capability Issues

In a post I wrote a couple of days ago I made a plea for help with a WordPress Multisite issue that was plaguing me. Within 24 hours it was solved, it’s like Reclaim Hosting—but in blog comments 🙂 The issue was after migrating bavatuesdays out from under a WordPress Multisite setup into its own blog, I no longer had the ability to add new plugins and themes through the dashboard. I could do everything else, and I was stumped. I tried adding a brand new admin user with a fresh wp_user and wp_usermeta tables, but to no avail. Turns out, the issue was that related to user capabilities defined in wp_options. Boone Gorges spelled it out the the comments: 

It could be that your ‘administrator’ role doesn’t have the ‘install_plugins’ capability. This happens sometimes during the migration from Multisite, since on Multisite administrators cannot install plugins. You can check by examining the wp_user_roles value in wp_options, or with a plugin like https://wordpress.org/plugins/user-role-editor/. You can reset role caps with wp role reset administrator.

And the word on the street is that he looked like this while leaving that comment on his keyboard:

That was it, indeed, and Pat Lockley and Tom Woodward alluded to the very same thing (rich as kings on the bava!). Had no idea about wp_user_roles row in WP_options, and when I installed that plugin I was able to fix everything with a few clicks:

I just clicked and updated delete_plugins and install_plugins capabilities (as well as the install_themes and delete_themes for themes)  which fixed the values in wp_user_roles and I was back in business. Thank you Boone, Pat, and Tom for helping me out —you all rule. And now I can push forward with the rest of my blog downsizing.