Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: I’m no longer super admin. What happened?


@mercime
Keymaster

@mercime

@kevbow, this does deal with WP/MU/MS user capabilities. (backup database before trying anything below)

1 login your phpMyAdmin, select database and click to browse your xxx_users table (xxx=prefix used); check if there is “1” under ID column for the site/super admin

2 a. if there is, then go to xxxx_usermeta table; check under user_id column with “1” and see if it’s something like – if wpmu
xxx_1_capabilities is a:2:{s:13:”Administrator”;b:1;s:13:”administrator”..
user_login – value = admin

2b. If there is, also go to xxx_sitemeta table; check under site_admin “1” column and see if in row
your admin_email = is correct
admin_user_id = 1
site_admins = a:1:{i:0;s:7:”yourusername”;}
… and if not, then click on pencil icon and correct this then click on “Go” link

2c If there’s none, recreate by running SQL query
INSERT INTO ‘wp_usermeta'(‘umeta_id’,’user_id’,’meta_key’,’meta_value’) VALUES
(1, 1, ‘nickname’, ‘admin’),
(2, 1, ‘rich_editing’, ‘true’),
(3, 1, ‘admin_color’, ‘fresh’),
(4, 1, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’),
(5, 1, ‘wp_user_level’, ’10’);

Skip to toolbar