Support » Fixing WordPress » You do not have sufficient permissions to access this page

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi, your post is very confusing to me. Why would anybody change the database prefix on an existing installation?
    But maybe this page is useful to you: http://codex.wordpress.org/Creating_Tables_with_Plugins
    I don’t think a security update would change anything related to the database structure.

    Like you said, need for table prefix change is very rare or one could think of it at the time of installation. However it is needed in some migrations and that is why WordPress developers have thought about it and include that as an option in wp-config.php

    e.g. Scenario

    You already have a site with table prefix wp_. Later date you want to download and improve the site locally and upload that to the same host to get feedback from your visitors.

    Since the original tables are with wp_ your new version table names should start with a different prefix to reside in same database without colliding with your existing site data. So you may choose site1_ as your table prefix. Then you can import the new tables in to same host db while having exiting site and new site files in two different folders.

    Thanks, that fixed it. I had to put 3 blogs into one database so I had to change the prefix and like you had, it broke my blogs. Here’s my SQL version of your post:

    update site1_usermeta set meta_key = ‘site1_capabilities’ where meta_key = ‘wp_capabilities’;

    update site1_usermeta set meta_key = ‘site1_user_level’ where meta_key = ‘wp_user_level’;

    update site1_usermeta set meta_key = ‘site1_autosave_draft_ids’ where meta_key = ‘wp_autosave_draft_ids’;

    update site1_options set option_name = ‘site1_user_roles’ where option_name = ‘wp_user_roles’;

    Hello!!

    i have this problem and i dont kwon hot to fix it
    some body could helpme please?

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

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