Migrating site Admin Problems

  • positiveperspective

    (@positiveperspective)


    9 years, 10 months ago

    I have recently mirrored my main WP site and placed an exact copy under subdomain. I copied tables and changed tables prefix, updated the wp_config so it matches new prefix, I edited rows in options table so home and url match new address, I also changed in options table all that had old prefixes.

    For some reason my admin (same as in original site) does not have permission to add posts or add elements to the menu structure. Instead, for example in New Post Creation I get Submit for Review button instead of Publish.

    I redone site migration twice, I updated WP automatically, then I did it again manually. I am out of ideas why this does not work. I have a feeling that there is some mismatch with prefixes in tables, or problem with permissions in user capabilities.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator James Huff

    (@macmanx)

    9 years, 10 months ago

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

    If you are not using Multisite, 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;}

    Thread Starter positiveperspective

    (@positiveperspective)

    9 years, 10 months ago

    Error persists after following Your instructions.

    Moderator James Huff

    (@macmanx)

    9 years, 10 months ago

    Hm, that’s rather odd.

    Try migrating again, but this time, follow this guide: https://codex.wordpress.org/Moving_WordPress#Changing_Your_Domain_Name_and_URLs

    Thread Starter positiveperspective

    (@positiveperspective)

    9 years, 10 months ago

    already done that tutorial

    Moderator James Huff

    (@macmanx)

    9 years, 10 months ago

    Are you absolutely sure? What you described initially doesn’t match it.

    Sorry, but I’ll admit, this is a new one for me. Especially if you have entered the capabilities value exactly as directed above, that would force the account to have Administrator privileges, that’s a hard-coded value, no real way to otherwise override it, so what’s happening to you doesn’t make much sense. What you’re describing though is an account with Contributor privileges: https://codex.wordpress.org/Roles_and_Capabilities#Capability_vs._Role_Table

    My only thought then is that wp-config.php is not pointed at the correct database or table prefix.

    Thread Starter positiveperspective

    (@positiveperspective)

    9 years, 10 months ago

    when trying to add new post I get this:
    Warning: Creating default object from empty value in /customers/7/5/b/positiveperspective.eu/httpd.www/en/wp-admin/includes/post.php on line 632

    Thread Starter positiveperspective

    (@positiveperspective)

    9 years, 10 months ago

    I spent already some ten hours on trying to solve this. I don’t understand it neither. I have set capabilities as you wrote. and wp-config.php has new prefix provided. same database as website is on subdomain of same space.

    Thread Starter positiveperspective

    (@positiveperspective)

    9 years, 10 months ago

    yes, it seems that my admin is treated as contributor.

    Moderator James Huff

    (@macmanx)

    9 years, 10 months ago

    Hm, perhaps some plugin or theme function is getting in the way. Let’s at least rule those out.

    Try manually resetting your plugins (no Dashboard access required). If that resolves the issue, reactivate each one individually until you find the cause.

    If that does not resolve the issue, access your server via SFTP or FTP, or a file manager in your hosting account’s control panel, navigate to /wp-content/themes/ and rename the directory of your currently active theme. This will force the default theme to activate and hopefully rule-out a theme-specific issue (theme functions can interfere like plugins).

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Migrating site Admin Problems’ is closed to new replies.