• Resolved spackletoe

    (@spackletoe)


    Looks like something went wrong during my upgrade to 2.0. My site is still up, but I can’t get to the admin section at all.

    I get this message then I try to log in with a valid account, even with the admin account:

    “You do not have sufficient permissions to access this page.”

    There were some errors on the upgrade where the table “usermeta” was not created. I’m not sure if I can manually put this in or what, but out of 3 blogs that I’ve upgraded to 2.0 so far, this one is the only one that gave me trouble.

    The only thing that I can think of that makes this one different is that it is in a database that includes 2 more WordPress blogs. Not sure if that would make a difference.

    Not sure it helps, but the blog is here: http://www.joepopp.com

    Thanks,

    -spack

Viewing 15 replies - 76 through 90 (of 93 total)
  • kennemore and candv I echo your comments, I have three new WP sites waiting and 2 to upgrade and I am sitting here with a permissions issue and its been this was for a while.

    I went digging and digging and then digging somemore, and I ran into an issue that I had seen before. I made some changes to the httpd.conf and had to restart apache, and for several minutes my issue went away. So I went into my php.ini file and disabled mmcache, and presto it worked.

    If you have mmcache or some other extensions loaded with php you might want to check and disable them and see if it changes. You can do this in one of three ways.

    Directory directive in httpd.conf,
    <Directory ‘/some/path/to/wordpress’>
    php_admin_value mmcache_enable 0
    php_admin_value mmcache_optimizer 0
    </Directory>

    PHP.ini file just comment out or turn mmcache.enable=’0′ and mmcache.optimizer=’0′

    Also do something similar with .htaccess
    php_admin_value mmcache_enable 0
    php_admin_value mmcache_optimizer 0

    You might say but I dont have mmcache installed or whatever, but this should show some of those struggling that there might be something other then WP to blame for the issue, and it might be something that you have to play with in Apache or PHP.ini.

    HTH

    Iceman42, my host won’t allow me to amend those file. Any other ideas out there?

    I have just changed the options of the Brian threaded comments [ http://meidell.dk/archives/2004/09/04/nested-comments/%5D when appear this message:
    Cheatin’ uh?
    when I tried to go to the plugin options the message was:
    You do not have sufficient permissions to access this page.
    I read all this thread and tried some suggestions but my website http://www.nelshael.com is still down T_T
    I’m waiting for other any ideas about this problem.

    Ghacks, I tried your fix and not only did it not work, but now I’ve lost my ability to work in my profile as well. previously, I was able to see my dashboard and profile but now only the dashboard remains.

    I’ve also tried the tweaked fix, and that didn’t work either.

    I’ve also renamed my plugin folder, hoping that would help, but again, no go.

    I also deleted my cache folder and re-upgraded.

    I’m on version 2.0.3 and I was having this problem BEFORE upgrading. I upgraded hoping it would fix it.

    What else can I try?

    I got the problem after upgrade from 2.0.3 -> 2.0.4
    The server is running in php_safemode

    Qurious about how to fix this.
    The plugin im trying to use again is organizer
    Disabled b4 upgrade
    Enabled after upgrade with this error
    “You do not have sufficient permissions to access this page.”

    How is this topic resolved? I’m still stuck at 2.0 and haven’t been able to upgrade to fix any security issues that have been covered since 2.0.4

    I finally fixed the problem.

    There doesn’t seem to be any clear explanation here of what is happening, so I’ll try to explain it as I understand it.

    When some people upgrade (or perhaps do a fresh install) for some reason or another some crucial tables are not being properly updated. In my case, I did an upgrade, and three tables were not updated. I had to manually add insert new data to get my WP install to work.

    All of the data that is missing relates to the new permission system. I strongly suspect that for people who skipped a version or two of WP, these tables are not being properly updated by upgrade.php, as I had no problem with WP installs where I have been doing regular updates. I think this is a bug and should be fixed.

    There are two tables and three rows of data I had to manually insert.

    The first table is the wp_usermeta table. You want it to look exactly like this (mine was empty!):

    http://www.tamba2.org.uk/wordpress/admin/

    The second table is the wp_options table. You need to add a new option called “wp_user_roles” which is not being created properly. There are only two things you need to change when you insert a new row into this table. First, “option_name” should be “wp_user_roles”. Second, the “option_value” should be set to the following very long string of text:

    a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:30:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:19:{s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:8:{s:12:”upload_files”;b:1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:11:”contributor”;a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:4:{s:10:”edit_posts”;b:1;s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:2:{s:4:”read”;b:1;s:7:”level_0″;b:1;}}}

    Once you have made those changes, you should be able to log in to your WP-Admin and manage your blog as normal.

    Hi, sorry about my terrible English.
    Just updated to 2.0.3 and got this problem. Looking at usermeta MySQL table (I’m not using the wp_ table prefix) found two prefixed meta_keys for admin user (user_id=1): wp_user_level and wp_capabilities (meta_value was correct). After renaming these keys to user_level and capabilities
    (without prefix) the problem resolved.
    I hope, this helps.

    RESOLVED:

    This issue has to do with Turck MMCACHE being enabled in PHP. (Check your ‘php.ini’ or ‘php.d/mmcache.ini’ files).

    Since part of the PHP loads are performed without some variables set (and then cached), when they are loaded from MMCACHE on the subsequent load, the variables are not present for some of the functions to create the entries in the database.

    Disable MMCACHE and flush it, or disable and wait X hours…

    Where is this php.ini!?

    Oh god, I’m confused.

    pjh, I just wanted to say thank you for your solution (on the previous page). My situation was that I’d renamed my tables and didn’t know I had to modify some of the values. Thanks!

    i tried all of above and nothing worked. i did find that the table they are talking about was empty. i tried all the hacks to no avail.

    finally, i restored my old db, wiped my install directory and installed 2.0.5 (hours fresh). i then copied my wp-config.php and wp-content additions and ran upgrade.php. came up clean!!! word to the wise – heed that warning in one of the tip pages – start with a clean install, do not install over the old directory as suggested.

    Ok, so the post by KerimFriedman is what led me to the solution of this problem. However my problem was that i migrated the website from windows to Linux host and as you may know Linux is case sensitive. my folders begin with prefix eq_ (lowercase) however if i did

    select * from eq_usermeta

    the meta_key values would look like this: EQ_user_level and EQ_capabilities. So i changed these from EQ_ to eq_ and everything started working fine for me after that. Here is what i ran:

    select * from eq_usermeta;
    update eq_usermeta set meta_key = ‘eq_user_level’ where umeta_id = 4;
    update eq_usermeta set meta_key = ‘eq_capabilities’ where umeta_id = 5;
    select * from eq_usermeta;

    Thanks everybody for contributing!

    -Alexi
    ——————————–
    http://www.HorseOnSale.com – a place to sell and buy horses!

    Hi everyone, I’ve read through all of these and I still haven’t managed to solve this problem. I’m on version 2.02 at the moment and thinking of going to 2.05 but I want to solve this problem first ideally.

    Here’s where I’m at. Firstly, I hadn’t logged onto my blog for about a week when suddenly I got the “sufficient permissions” message and no tabs in the Dashboard. I hadn’t changed a thing between visits and the site had been working fine for several months.

    I’ve checked the database and everything appears fine (except for one thing which I’ll get to in a moment). I turned off the plugins by renaming folders and files. (Is there a better way of doing this?) Anyway – no help. I removed the cache folder contents – No help. So I reversed those two changes.

    I thought it might be a hosting issue, but I have another wordpress site with the same people, which I can still access with no problems.

    Onto the one difference I noticed. In the database for the blog with the problems, I’m missing fields for “Nickname”, “First” & “Second” names for admin (ID=1). In the other database, those entries exist. Both have the “{a:1:{s:13:”administrator”;b:1;}” entry.

    I haven’t tried the .htaccess changes suggested yet. That will be next I guess.

    Leading on from all that, should I go through the up-grade process to 2.05 as a possible solution? If so, how best should I turn off plugins and other thing I might normally do from within WordPress?

    Thanks for any help!

Viewing 15 replies - 76 through 90 (of 93 total)
  • The topic ‘“You do not have sufficient permissions to access this page.”’ is closed to new replies.