Help!! I Screwed up my WP

Question

I was trying to clear up some empty tables left behind by other previously used plugins. As such i was trying to delete the GD Star rating plugin and now I cannot access my WP admin. i get the 'You do not have sufficient permissions to access this page'

I turned on the debug to true and saw the errors caused by lots of plugins. So I disabled all of them, but nothing helps:

This was the query I had run (and then just checked the output and clicked 'Drop' which messed it up.

SELECT * 
FROM  `mydomain_main`.`wp_options` 
WHERE (
`option_id` LIKE  '%ratings_%'
OR  `blog_id` LIKE  '%ratings_%'
OR  `option_name` LIKE  '%ratings_%'
OR  `option_value` LIKE  '%ratings_%'
OR  `autoload` LIKE  '%ratings_%'
)

Can someone please please advise

Answer 1

since i posted as a comment and most people miss the good tips that are in the comments, I'm posting again as an answer

The reason is because GD Star rating plugin creates custom capabilities and your query deleted all references of %rating% it deleted the wp_user_roles option which holds all capabilities roles.

the solution would be to re create that option in options table (usually wp_options) with the default value just like I answered here .

Answer 2

You probably don't want to hear this, but I would suggest to reinstall WordPress and put your backups back. In the end that would be the fastest, easiest and most 'secure' = as in making sure you're not forgetting something which might cause issues in the future.