Moving WordPress Admin issue Help Please!

  • Resolved ODGraphics

    (@odgraphics)


    13 years, 10 months ago

    Hi Guys

    I posted this in another trend here on wordpress can someone have a look and see if you can help below link to trend and also post

    https://www.ads-software.com/support/topic/moving-wordpress-admin-issue?replies=1

    this is my first post for help on wordpress and i would really apperacate if you could help me out.
    Below steps that I went through to move wordpress from my old site / provider to a new hosting provider.
    However i have run into a major issue with admin right changing to subscriber and non admin.
    I ran a force upgrade script but this is where im stuck, i was told that this could be overcome by following the steps in the link below to add user through phpMyAdmin.
    https://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database

    HOWEVER when I went through the user rights steps as described above and logged in I only seem to have “basic” admin rights as in Plug-in tab does not appear and it asks me to contact administrator to upgrade plugins etc

    Below are the steps i followed:

    ? Create new fresh database (DB) in your service providers phpMyAdmin with a user who has full permissions

    ? import wordpress mySql file into fresh DB

    ? Inside in your old WordPress files change the wp-config.php file to the DB_username, DB_pass & DB_name that correspond to the new database you just created in your service providers phpMyAdmin.

    ? FTP SME WordPress file from local computer to wwwroot folder on your services provider.

    ? Go to https://www.example.com/wp-admin
    ? Enter your SME username and password

    After i did this I was presented with “you do not have permissions to access this page” and i had to download and run the following:

    Force Upgrade of WordPress (https://txfx.net/files/wordpress/force-upgrade.phps) for more information on this script see (https://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-to-access-this-page/)

    the above reset the old user rights in mySQL file back to subscriber then i went into the phpMyAdmin -> WP_usermeta -> wp_capabilities back to a:1:{s:13:”administrator”;s:1:”1″;}

    I then went back to the wp-admin logged in as admin and password the user rights changed alright from subscriber to admin BUT still the plug-ins tab is missing and its asking me to contact the administrator to upgrade plugins etc can anyone help please!

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

  • The force upgrade looks like it’s supposed to be used to go from 1.5 to 2.0, and you have 3.0? If you do not have the plugins menu item then it does not appear that you have full administrative privileges, but that of possibly an editor.

    Try this for your wp_capabilities meta value for your admin user:

    a:1:{s:13:”administrator”;b:1;}

    Thread Starter ODGraphics

    (@odgraphics)

    @rayholt thanks for getting back to me on this regarding force upgrade script i checked this before i ran it and it works on all versions of wordpress as it just flushes various aspects of wordpress and db so i dont think that is causing the issue. regarding your suggestion for putting

    a:1:{s:13:”administrator”;b:1;}

    into the meta capabilities section can you advise where i can find more information on what this does is there codex on this as i think i have tried the above to no avail ill try this again and get back if im still having issues by the way is there an error log or something that wordpress creates that might help?

    Thread Starter ODGraphics

    (@odgraphics)

    @rayholt thanks again for getting back to me on this i have just updated the wp_capabilities to a:1:{s:13:”administrator”;b:1;} butit still has not given me full admin rights any ideas?

    Thanks again for looking at this issue

    Thread Starter ODGraphics

    (@odgraphics)

    Think I have sorted this i just replaced the wp_user_roles with a fresh version in from a fresh install of wordpress on my local machine and it seems to have resolved the issue for now i hope ……

    Thread Starter ODGraphics

    (@odgraphics)

    For those of you interested see below before and after wp-user-roles maybe you can spot what was causing the issue

    ——————————————————————————
    ORIGNAL MYSQL wp_user_roles file
    ——————————————————————————

    a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:74:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;b:1;s:12:”delete_users”;b:1;s:12:”create_users”;b:1;s:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:12:”remove_users”;b:1;s:9:”add_users”;b:1;s:13:”promote_users”;b:1;s:18:”edit_theme_options”;b:1;s:13:”delete_themes”;b:1;s:6:”export”;b:1;s:24:”NextGEN Gallery overview”;b:1;s:19:”NextGEN Use TinyMCE”;b:1;s:21:”NextGEN Upload images”;b:1;s:22:”NextGEN Manage gallery”;b:1;s:19:”NextGEN Manage tags”;b:1;s:29:”NextGEN Manage others gallery”;b:1;s:18:”NextGEN Edit album”;b:1;s:20:”NextGEN Change style”;b:1;s:22:”NextGEN Change options”;b:1;s:12:”manage bkpwp”;b:1;s:14:”manage_backups”;b:1;s:16:”download_backups”;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:34:{s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:10:{s:12:”upload_files”;b:1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:1;s:22:”delete_published_posts”;b:1;}}s:11:”contributor”;a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:5:{s:10:”edit_posts”;b:1;s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:2:{s:4:”read”;b:1;s:7:”level_0″;b:1;}}}

    ——————————————————————————
    FRESH INSTALLMYSQL wp_user_role file
    ——————————————————————————

    a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:63:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;b:1;s:12:”delete_users”;b:1;s:12:”create_users”;b:1;s:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:12:”remove_users”;b:1;s:9:”add_users”;b:1;s:13:”promote_users”;b:1;s:18:”edit_theme_options”;b:1;s:13:”delete_themes”;b:1;s:6:”export”;b:1;s:12:”manage_roles”;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:34:{s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:10:{s:12:”upload_files”;b:1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:1;s:22:”delete_published_posts”;b:1;}}s:11:”contributor”;a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:5:{s:10:”edit_posts”;b:1;s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:2:{s:4:”read”;b:1;s:7:”level_0″;b:1;}}}

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Moving WordPress Admin issue Help Please!’ is closed to new replies.