Lost Administrator Level! (4 posts)

  1. carla2006
    Posted 10 years ago #

    I would really appreciate it if somebody could help us with this problem.
    We were trying to add a user as a contibutor, but instead we accidentally changed the administrator into a contributor and now we cannot enter as administrators, so our blog has no administrator at all! Any ideas on how we can solve this problem?
    Thanks for your help!

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    If you follow that, the table that is edited also has the user_level - just change it to 10 :)

  3. MichaelH
    Posted 10 years ago #

    The above solution will work for WordPress 1.5.2, but if you are using WordPress 2.0, I believe you will need to use phpMyAdmin and change two records in the wp_usermeta table for your admin user.

    For illustration, I assume you use wp_ as your database prefix.

    1. First look at the wp_user table and ascertain the ID number for the admin user you are 'fixing'.

    2. Then in the wp_usermeta table find the record where user_id is equal to the ID and where the meta_key value is wp_capabilities. Change the value of that field to a:1:{s:13:"administrator";b:1;}

    3. Then in that same table, wp_usermeta, change the record for that same user_id where the meta_key is wp_user_level. Change the value of that field to level10

    Good luck!

    [edit] WordPress 2.0.2 won't let you change your Role from Administrator to Contributer. Something funny there ....

  4. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Thanks Michael - I put a guide together:

Topic Closed

This topic has been closed to new replies.

About this Topic