Wordpress 2.5 - You do not have sufficient permissions…
Are you having a problem logging into your Wordpress Dashboard after upgrading? If you’re getting this message, you’re not alone:
“You do not have sufficient permissions to access this page.”
I’ve had the same problem as have many others. I’ll show you how I solved the problem on my site, and give you the articles I used as reference. It seems like the same message is being shown to users but the cause may be slightly different, and the solution as well depending on which version of Wordpress you are using.
This is what worked for me when I had problems after upgrading to Wordpress 2.5.1. I made the changes directly in my database using PHPAdmin. It’s a very good idea to do a database backup before you make these changes so you can restore if you have any problems. I can’t guarantee this will work for everyone, but it worked for me. It took a bit of hunting before I found the solution, and my host support didn’t manage to solve the problem at all. So I’m hoping this will at least help someone fix the problem a bit more easily.
I upgraded my Wordpress blog to 2.5.1 and even though the upgrade seemed to go fine I couldn’t log in to the site. Actually, I could log in but I couldn’t access the Dashboard. I tried resetting the password, submitted a support ticket to my host, tried everything I could think of, to no avail. When I tried to log in this is the message I was getting:
“You do not have sufficient permissions to access this page.”
So this is what I had to do:
- First you need to check if you Wordpress table is using a prefix. Previous versions of Wordpress used ‘wp_’ prefix as a default. I’m not sure if it’s a Wordpress thing or the way my host has now set things up, but when I install new Wordpress blogs they now have a random prefix that I’m not able to change. It looks something like this ‘wp_56n7sz_’ with the last alphanumeric set being random. So take note of what the prefix is for your table names. In these instructions be sure to substitute ‘wp_prefix_’ with whatever the prefix is in your case.
- Then I went into the wp_prefix_usermeta table using phpAdmin, clicked on the ‘Browse’ tab and changed three table names as follows (remember to substitute your prefix for ‘wp_prefix_’ :
- wp_capabilities to wp_prefix_capabilities
- wp_user_level to wp_prefix_user_level
- wp_autosave_draft_ids to wp_prefix_autosave_draft_ids
- Finally I went into the wp_prefix_options table and clicked on the insert tab to add a new row. The ‘option_name’ should be ‘wp_prefix_user_roles’ and the ‘option_value’ should be this really long line below.
a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:30:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:19:{s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:8:{s:12:”upload_files”;b:1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:11:”contributor”;a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:4:{s:10:”edit_posts”;b:1;s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:2:{s:4:”read”;b:1;s:7:”level_0″;b:1;}}}
Here are the original articles I used to come up with a fix that worked for me. If you’re having a problem with a different version of Wordpress please have a look at these articles first, the database design is a bit different for earlier versions of Wordpress and one of these articles will probably be more accurate for you.
http://wordpress.org/support/topic/53261/page/3#post-422005
http://wordpress.org/support/topic/173751?replies=2#post-750300
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
[...] Wordpress Support >> How to solve “You do not have sufficient permissions to access this page” in Wordpress >> Wordpress 2.5 - You do not have sufficient permissions… [...]