nronksr

It works up to 3.0.5 for sure. I haven’t checked out the latest structure, but they don’t make drastic changes in minor revision numbering. I’d guess it would work with 3.1.1 as well…

I’m currently running 3.0.5 – haven’t upgraded to 3.1.1 yet (which is presently the latest) so no guarantees. But the revision number you listed as 3.0.1 would def. work for the fix above.

rizwp:
The problem is your database is wasn’t fully updated with the plugin and the code it ran with the new releases. In order to update them fully you need to also run the SQL statement that follows.

Do you have access to phpMyAdmin?

If so, login to phpmyadmin. Click on SQL at the top (should be 2nd tab)

Now copy/paste the line of code:

UPDATE ‘PREFIX_usermeta’ SET ‘meta_key’ = REPLACE( ‘meta_key’ , ‘wp_’, ‘PREFIX_’ );

Change the word PREFIX in the code above to whatever you renamed your table_prefix for your wordpress install. Then click the GO button. This will fix your administrative privileges in the database and thus fix your WP.

The Security scanner isn’t up to date. It misses changing 4 permissions in the _usermeta table.

wp_capabilities
wp_usersettings
wp_usersettingstime
wp_dashboard_quick_press_last_post_id

If you run this SQL query and change prefix to whatever you renamed it, it will fix your permissions issues:

UPDATE 'PREFIX_usermeta' SET 'meta_key' = REPLACE( 'meta_key' , 'wp_', 'PREFIX_' );

Example:
UPDATE 'ea_usermeta' SET 'meta_key' = REPLACE( 'meta_key' , 'wp_', 'ea_' );