Don’t know if this is your problem but please note that some of the rows (records) in your usermeta
table use the database prefix when composing the meta_key
values for a user’s capabilities and user_level.
Michael,
Thank you for your reply, where would I fix those rows?
Thanks.
Anyone? How can I fix the rows? I don’t know where to look. Thanks in advance. 🙂
Hi did you ever figure this out? I just did after having the same problem.
I had renamed all the wp tables in the database and updated the config.php. The blog continued to work normally until I tried to log in and kept getting:
You do not have sufficient permissions to access this page.
I have found out that just renaming the tables and updating the config wasn’t enough. You have to update three records:
go into your phpmyadmin to your _options table find record: wp_user_roles or xxx_user_roles and rename it to match your table prefix.
Next go into your wp_usermeta or xxx_usermeta table find and edit: wp_capabilities, wp_autosave_draft_ids and wp_user_level
and do the same thing, rename to match your table prefixes.
Things should begin working for you after.
Grab the script linked to in this post and try it:
http://wordpress.org/support/topic/53261/page/3?replies=91#post-352032
Hope this helps,
-drmike
Thanks for the reply. I ended up dumping it and starting fresh. There weren’t many entries or comments to worry about.
Frawsty,
Your solution was the ticket for me.
I copied my db tables and moved wordpress to a different website. I thought I had edited all the url references in the actual wordpress configs and also in the db tables. But I completely missed the prefixes on table field names in the xxx_options and xxx_usermeta tables.
That completely fixed it!
Thank you!