• My site core files are in http://example.com/assets/ and my .htaccess and index.php are in http://example.com. WP 2.5.1 is installed and all was working well yesterday morning. Its a fairly new site with only five posts and 3 comments and about 10 users.

    Then to beef up security, yesterday I changed the table_prefix in wp-config.php and changed all the table prefixes via PHPMyAdmin. I then checked that the site would display to the ordinary user and it did.

    Today I cannot get into admin, error being “You do not have sufficient permissions to access this page.”

    I’ve followed many threads here and on other sites, I’ve gone into user_meta and users via PHPMyAdmin and changed the wp- prefix to agree with my new table_prefix. However I’m still getting the error and cannot access any admin feature.

    I’ve come to a dead end. Can anyone suggest further things to check or be willing to have a look at the SQL dump?

    Thanks,
    Peter

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter newcreat

    (@newcreat)

    Here’s the user_meta data for my login…
    INSERT INTO 3550ncr_usermeta VALUES(1, 1, ‘nickname’, ‘Peter Wade’);
    INSERT INTO 3550ncr_usermeta VALUES(2, 1, ‘rich_editing’, ‘true’);
    INSERT INTO 3550ncr_usermeta VALUES(3, 1, ‘admin_color’, ‘fresh’);
    INSERT INTO 3550ncr_usermeta VALUES(4, 1, ‘3550ncr_capabilities’, ‘a:1:{s:13:”administrator”;b:1;}’);
    INSERT INTO 3550ncr_usermeta VALUES(5, 1, ‘3550ncr_user_level’, ’10’);

    And here’s the data for users…
    INSERT INTO 3550ncr_users VALUES(1, ‘username’, ‘******/*************/’, ‘admin’, ‘pwade@********.com.au’, ‘http://’, ‘2008-04-24 23:04:21’, ”, 0, ‘Peter Wade’);

    It looks correct to me!!!

    I can’t believe all these dead unanswered posts of a lot of people with same issues. I think I may just move to MovableType. I have had this issue for a long time with no replies and that sucks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘You do not have permission’ is closed to new replies.