Support » Fixing WordPress » Administrator Role Disabled

  • Hello WP developers in the house, firstly I don’t know if this is the right place to post this question or somewhere else, I urge the mode to help move it to the right section if this place isn’t meant for my question.

    I have been having a tough time troubleshooting what could possibly go wrong with my database where I couldn’t login with an Administrator privilege/capabilities.

    The site in question was done few years ago, sometimes around 2014 and has been left un-updated since then, but regular posts update has been on going up till April 2017.

    The Developer who developed this website denied my client some administrator privileges which includes: theme/plugin edit/updates, etc. which means my client can only do post, edit and delete posts. but can’t upload or edit themes and plugins, and the developer is nowhere to be found.

    The problem is now that I’m the new person to handle this project henceforth, I couldn’t login to WP dashboard area using the new Administrator user that I created for myself through phpMyAdmin in order to install and edit theme and plugins from WP dashboard. Any attempt to login with Administrator username will be redirected to homepage with blank screen.

    As per my client request, I have just migrated the website from the old hosting to the new one and have done all the necessary things required for smooth transition but still can’t login with Admin access but I can login with any other user role lesser than admin which will not be enough for me to install and customize the theme.

    I have also tried to delete all the users I met on ground and created a new admin role, but this wouldn’t still work.

    Also note that I was able to upgrade wordpress to current version 4.7.5

    Thank you

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi,
    If you have created a user with administrator capabilities then you must have to add 2 meta keys in usermeta table also.
    Have you done that?

    If not here are the queries that you can use to add meta keys for user role and capabilities. Just replace user id with your new created user id.

    INSERT INTO databasename.wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, ‘4’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

    INSERT INTO databasename.wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, ‘4’, ‘wp_user_level’, ’10’);

    Thanks

    Thank you @latifpala for responding to my call, I have searched this forum and various solutions which didn’t work for me before I decided to open my thread here were provided and your solution was among numerous ones I have tried without success.

    This just baffles me and don’t know what else to do at this stage.

    Hi,
    Have you or anyone else has change the prefix of database tables?
    Wordpress stores 2 values in options table whose prefix is same as wp database table prefix.

    Thanks!

    You can run following query to check if is there any entries available or not with your current database prefix.

    Remember to change %wp_% to your database prefix.

    SELECT * FROM wp_options WHERE option_name LIKE ‘%wp_%’

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Administrator Role Disabled’ is closed to new replies.