WordPress.org

Forums

Update Core: "You do not have sufficient permissions to access this page." (9 posts)

  1. edmond4
    Member
    Posted 4 years ago #

    I've updated manually to WordPress 3.0.1. The installation otherwise didn't work as an automatic update.

    I've scoured the web for hours, over a day now, done and then had to undo some things. I'm sure my post is one that will exasperate some, and if so, please just ignore it. I am not here to incur wrath for being totally clueless about editing tables in a database. I can login and create a backup archive, but beyond that, clueless, not opposed to an education, but haven't found anything bare bones simple in telling how to edit or change permissions, metadata etc, which other posts on this topic would seem to indicate might be where the problem is solved.

    Though in Dashboard it says I'm using the current WP update of 3.0.1, if I go to the "wp-admin/update-core.php page of my blog. It gives the error:

    "You do not have sufficient permissions to access this page."

    I am not a MySql database guy at all. I don't want to touch the database at all if it is not the root of my problem. A misstep there opens up a huge can of worms.

    I keep finding "closed" topics with this problem, so I'm having to post something new.

    If I do need to go in and edit something in the database, how on earth do I do so? There are snippets of code given on forums, but not a single clue is given on how to edit such code, or even find the "table" data. If I knew how to do it, I'd take some screen shots and put up a tutorial on the basics of how to go in and do this.

    If anyone has any helps they can give, I'd appreciate it. You must assume with me, that I hardly know a thing about MySQL Database and Configuration. It's all Greek to me, and pointers, places to read up are most warmly welcome.

  2. James Huff
    Volunteer Moderator
    Posted 4 years ago #

    It sounds like your account may have lost admin privileges for some reason.

    Access your database via phpMyAdmin (most hosting providers offer this in their control panel), go to the wp_users table and find the row for your user_login . Note the ID of this row. Now, go to the wp_usermeta table and find the wp_capabilities row for your user_id . Set the value of this row to a:1:{s:13:"administrator";b:1;}

  3. edmond4
    Member
    Posted 4 years ago #

    I thank you James for responding. Now, the clueless part again.

    I can get to the phpMyAdmin, then I can go to wp_users, then I see first listed a "user_login." I then see that is the "field" then I have the "Type, collation, Attributes, Null, Default, Extra, then Action. I can't detect what the ID is or where I read the ID in all of that.

    Next, if I go to wp_usermeta, I don't see the "wp_capabilities" anywhere.

    I see: "umeta_id" "user_id," "meta_key," "meta_value." These have the same as described above, field, type, collation, attributes, null, default, extra, action. But I don't see anything that correlates to what your trying to help me with.

    So I'm missing the most basic understanding of something that would seem totally stupid to most. I'm in a strange world in this PhpMYAdmin area.

  4. James Huff
    Volunteer Moderator
    Posted 4 years ago #

    Actually, it sounds like you're missing some key database rows. Do you have a pre-upgrade backup that you can restore from?

  5. edmond4
    Member
    Posted 4 years ago #

    I would have some backups. I don't know how far back I would have to go before finding one that would be intact, if this be the problem.

    How would the database lose some key rows?

    Perhaps I should put up a temporary account to test a restored database to see what it looks like, huh?

  6. James Huff
    Volunteer Moderator
    Posted 4 years ago #

    I would have some backups. I don't know how far back I would have to go before finding one that would be intact, if this be the problem.

    Basically, start with the most recent backup and keep moving backwards until the problem is resolved.

    How would the database lose some key rows?

    In this case, it could have been anything. Database corruption, server filesystem corruption, faulty plugin, incomplete upgrade, etc.

    Perhaps I should put up a temporary account to test a restored database to see what it looks like, huh?

    That's how I'd start. You'll have to access your newly restored test backup database via phpMyAdmin (most hosting providers offer this in their control panel) and manually change the siteurl and home values to the location of the test blog.

  7. davecr
    Member
    Posted 4 years ago #

    Here's a twist - I get the "You do not have sufficient permissions to access this page" message ONLY on the admin.php edit post/page pages. Total admin access to all else, including add new post/page.

    I have done everything, from disabling all plugins, switching to 2010 theme, fresh install of wp 3.0.1, and deleting recently added plugins.

    Any tips would be most appreciated, thank you!

  8. Choja
    Member
    Posted 4 years ago #

    I'm having the same problem but when I go to the wp_users table there is nothing in there. It says:

    No tables found in database.

    Please help, I'm losing hair :/

  9. studioryu
    Member
    Posted 4 years ago #

    I am really, really new to WP, and have come across the same problem after install...

    From the previous solution offered by James, in the table called 'wp_usermeta' I added a new row called 'wp_capabilities' and entered in a:1:{s:13:"administrator";b:1;} and updated the 'user_id' using PHPMyAdmin...it seems to be working fine now.

    It does look to be that this version of the WP 3.1 Dev Suite table structure might be missing a row on installation.

    However, the information offered by James initially really helped me figure out what might be the issue. Thank you!

Topic Closed

This topic has been closed to new replies.

About this Topic