• I installed wordpress on cPanel based hosting through Fantastico.

    Then later on what i did was went to database and renamed all the table prefix and renamed wp as abc

    Then i went to wp-config.php file and changed table prefix

    $table_prefix = 'abc_';

    Now the site works fine but if i log into admin panel i get the following error
    You do not have sufficient permissions to access this page.

Viewing 7 replies - 1 through 7 (of 7 total)
  • What version of WP? Porbably older, so would (manually) upgrade to 3.0.1 which might fix it.
    Try renaming your plugins directory and create a new empty one with thesame permissions.

    CHeck the Admin account in the database.

    Thread Starter bhanu2217

    (@bhanu2217)

    Current Version 3.0.1
    Its a new installation of version 3.0.1 It’s automatic installation done by Fantastico now i just want to rename the database table prefix which i am able to do but after this unable to log into the admin panel.

    Try renaming your plugins directory and create a new empty one with thesame permissions.

    CHeck the Admin account in the database.

    Thread Starter bhanu2217

    (@bhanu2217)

    I renamed the plugins to plugins1 and then created a new empty folder called plugins.
    Admin account in the database seems fine.

    still the problem exists.

    First backup your database. Then Try this (add your domain name)
    https://YOURDOMAIN.COM/wp-admin/upgrade.php

    If it says no upgrade needed. Then in the WP database change the db_version value in the wp_options to: 15260

    Then re-run the upgrade as above.

    Thread Starter bhanu2217

    (@bhanu2217)

    Solved the problem

    In wp_usermeta or abc_usermeta

    I changed the following prefix of wp to abc

    wp_capabilities
    wp_user_level
    wp_dashboard_quick_press_last_post_id
    wp_user-settings
    wp_user-settings-time

    also in wp_options or abc_options
    I changed the following prefix of wp to abc

    wp_user_roles

    Bhanu’s solution solved my issue similarly caused by table prefix rename

    thanks bhanu

    valuepost

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error: You do not have sufficient permissions to access this page.’ is closed to new replies.