View Single Post
Old 12-01-2007, 11:48 AM  
Emil
Confirmed User
 
Emil's Avatar
 
Join Date: Feb 2007
Location: Sweden
Posts: 5,651
Quote:
Originally Posted by Boobs View Post
what i do is download the whole database and open it with wordpad and edit it from there
Didn't know I could do that, thanks! I got it working now.


Will post the solution here so I can find it next time I got problems with the same thing. ;-)

You do not have sufficient permissions to access this page.

Even when attempting to login as admin. The cause? Simple, some of the Wordpress options are actually saved using the Wordpress prefix. You will now need to open up your favourite MySQL admin tool and modify the following:

In table ${NEW_WP_PREFIX}_options:

* Option ${OLD_WP_PREFIX}_user_roles

In table ${NEW_WP_PREFIX}_usermeta:

* Option ${OLD_WP_PREFIX}_capabilities
* Option ${OLD_WP_PREFIX}_user_level
* Option ${OLD_WP_PREFIX}_autosave_draft_ids


Source:
http://www.lildude.co.uk/2007/05/how...-table-prefix/
__________________
Free 🅑🅘🅣🅒🅞🅘🅝🅢 Every Hour (Yes, really. Free ₿itCoins.)
(Signup with ONLY your Email and Password. You can also refer people and get even more.)
Emil is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote