… Editing the PHPMyAdmin and SQL Query: WP_Options!
I have “dabbled” in this area before and “seen” things; however where I was about to BOLDLY go and EDIT – was just a little unnerving, I did NOT want to break the site – the client’s site!
So let me start at the beginning to tell you WHY I had to venture here and edit code:
My client had performed a WordPress upgrade to version 3.4.1, which caused his plugin, PluginBuddy Carousel (version 1.0.23), to not allow him to add anymore images – he would get an error message Cheatin uh? (this is a WP error message), so he called me.
After looking around I was thinking it was a user or password problem (later I learned we just needed to upgrade the Carousel plugin – opps!) so I asked if he had the network admin user/pass?
He answers, “I’m pretty sure – go ahead and change access to the Carousel to that.”
I change the access and now we are both locked out of Carousel and he can’t locate the user/pass! Oh NO!
So I’m thinking; lets just delete the plugin and add the newer version 1.0.24 of Carousel thinking this will fix our problem – it didn’t!!! (Client had told me he had updated all plugins before he upgraded WP – he hadn’t – lesson learned – check behind the client!)
So I turned to the PluginBuddy Forums for help – how in the heck do I change access to this plugin??
Elise Alley, one of the moderators in the iThemes Support Forums > PluginBuddy Forum, gave me a much needed helping hand and a fix.
First I did a full backup of the site using BackUpBuddy – you should ALWAYS backup your site before making major changes, upgrading, and of course playing around with permissions.
Basically what I had to do was log into the CPanel of the client’s site and then go to PHPMyAdmin, locate the wp_options table and then locate pluginbuddy_carousel (See image above). Once located I clicked on the pencil to edit. For this instance I had to change some values at the end of the string, which looked a little scary to me (to you too uh?) See image below:
What Elise had me change: at the end of the string: s:14:”manage_network”;i:0;b:0;} TO: s:16:”activate_plugins”;i:0;b:0;}
Then I clicked Save and Voila! We were able to get back into the PlugInBuddy Carousel.
- Check first to see if a plugin needs updated
- Don’t change access even if the client says he has the user/pass
- Don’t be afraid to venture to the “unknown” if you have specific instructions
- Making the journey is a learning process