Title: Migrating site Admin Problems Last modified: August 31, 2016 --- # Migrating site Admin Problems * [positiveperspective](https://wordpress.org/support/users/positiveperspective/) * (@positiveperspective) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/) * 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](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426064) * 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](https://wordpress.org/support/users/positiveperspective/) * (@positiveperspective) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426068) * Error persists after following Your instructions. * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426071) * 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](https://codex.wordpress.org/Moving_WordPress#Changing_Your_Domain_Name_and_URLs) * Thread Starter [positiveperspective](https://wordpress.org/support/users/positiveperspective/) * (@positiveperspective) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426074) * already done that tutorial * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426077) * 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](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](https://wordpress.org/support/users/positiveperspective/) * (@positiveperspective) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426078) * 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](https://wordpress.org/support/users/positiveperspective/) * (@positiveperspective) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426080) * 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](https://wordpress.org/support/users/positiveperspective/) * (@positiveperspective) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426081) * yes, it seems that my admin is treated as contributor. * Moderator [James Huff](https://wordpress.org/support/users/macmanx/) * (@macmanx) * [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426142) * Hm, perhaps some plugin or theme function is getting in the way. Let’s at least rule those out. * Try [manually resetting your plugins](https://codex.wordpress.org/FAQ_Troubleshooting#How_to_deactivate_all_plugins_when_not_able_to_access_the_administrative_menus.3F)( 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](https://codex.wordpress.org/FTP_Clients), 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. ## Tags * [admin problems](https://wordpress.org/support/topic-tag/admin-problems/) * [moving-wordpress](https://wordpress.org/support/topic-tag/moving-wordpress/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 9 replies * 2 participants * Last reply from: [James Huff](https://wordpress.org/support/users/macmanx/) * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/migrating-site-admin-problems/#post-7426142) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics