You do not have sufficient permissions to access this page
Are you getting "You do not have sufficient permissions to access this page." errors everywhere in the WordPress admin? I had this happening on a site, apparently the problem is that somebody changed the database prefix. It's a little suprising that this would totally break the admin, but whatever...
As usual, make a DB backup before running this code, yadda yadda..
UPDATE PREFIX_usermeta SET meta_key=REPLACE(meta_key , 'OLD_PREFIX_', 'PREFIX_');
UPDATE PREFIX_options SET option_name='PREFIX_user_roles' WHERE option_name='wp_user_roles';
Share this:
I just moved my site from IIS to LAMP server and had this issue.
Was due to case sensitivity of LAMP - Caps in IIS was ignored - gosh it took ages to work out!
Thanks for this.
I have read some articles about this and I found that plugins using jquery also makes this problem. How do I fix this? I'm using Wordprss 3.3.2.
The plugin is WPLockz.
Hoping for your positive response. Thanks
Didn't really go into wordpress expecting to have mysql knowledge, haha.
Thank you.
SELECT *
FROM `my_db`.`wpen_usermeta`
WHERE (
CONVERT( `umeta_id`
USING utf8 ) LIKE '%wpmn%'
OR CONVERT( `user_id`
USING utf8 ) LIKE '%wpmn%'
OR CONVERT( `meta_key`
USING utf8 ) LIKE '%wpmn%'
OR CONVERT( `meta_value`
USING utf8 ) LIKE '%wpmn%'
)
LIMIT 0 , 30