Fixing permissions after a Wordpress prefix change
Let’s say that you renamed your Wordpress tables.
There may be several reasons for this. For instance, you installed Virtual Multiblog to support more than one blog with the same setup.
And now, you are facing the dreaded “You do not have sufficient permissions to access this page”
What to do, what to do?
Turns out, after some research, I found out that there is a proper procedure for us lazy webmasters:
1. Download the force-upgrade script and run it. It’s a fairly old script but since it all it does is invoke Wordpress’ upgrade mechanism, it still works very well with 2.7. I know, it’s not an upgrade! But you can also run the script to right some wrongs…
2. Using your favourite SQL editor, edit the “usermedata” table. Let’s say that your old table prefix was ‘wp_’ and your new prefix is ‘wp_new_’ you would type this simple SQL command to make sure that your first user is still admin:
update wp_new_usermeta set meta_value='a:1:{s:13:"administrator";b:1;}' where meta_key='wp_new_capabilities' and user_id=1; |
Similar Posts:
- Four Top Wordpress Code Highlighters Reviewed
- Rich-text editor in Sharepoint with Firefox
- Bespin in Titanium: From The Jaws Of Victory…
- Wordpress Toolbar Plugin and Wordpress Prefixes: A Fix
- Help Blog Editors Reliably Discover Your API
If you enjoyed this post, make sure you subscribe to my RSS feed!
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.
Comments
No comments yet.
Leave a comment