Need help fixing wp_usermeta table

  • Resolved Lisa

    (@lisafoxnet)


    9 years, 4 months ago

    Hi-

    I moved a site from GoDaddy to A2hosting and now I can not access my admin area. When I try to log in, all I see is the Dashboard bar across the top (like you are editing the front end, or if you are only a subscriber). I do not see the WP dashboard that an administrator would see.

    I moved the site by exporting the database in .sql format on GoDaddy. Then I installed WP on A2 server, emptied the database and imported the GoDaddy SQL file. Everything on the front end of the site is fine.

    This is a single site, not a multisite.

    Here is what I have tried so far:
    -deactivate/reactive both plugins and themes via FTP
    -uploaded a fresh copy of the wp-admin folder
    -got new SALT keys and deleted browser cache/cookies
    -verified that my admin profile in wp_usermeta does have user level 10

    I put in a support ticket to A2hosting and they couldn’t figure it out either. They suggested I hire an expert WP developer. I’ve worked with WP for several years now and I’m not quite ready to throw in the towel. 🙂

    Linux server using MYSQL 5.6 and PHP5.5.38

    I’m comfortable navigating the tables in the database using PHPMyAdmin. Does anyone have any idea what has gone wrong?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator t-p

    (@t-p)

    9 years, 4 months ago

    Is this the WP codex guide you followed:
    https://codex.wordpress.org/Moving_WordPress

    Thread Starter Lisa

    (@lisafoxnet)

    9 years, 4 months ago

    Hi, thanks for the quick response.

    Yes, I did follow the recommended protocol if you are not changing URLs or directories. I did update the wp-config file with the new database name, user and password. I manually uploaded the files in the plugins, uploads and themes directories.

    Moderator t-p

    (@t-p)

    9 years, 4 months ago

    please do not publish your personal info in these public forums.

    I have deleted the screenshot.

    Try Enabling debugging and post the results.

    Thread Starter Lisa

    (@lisafoxnet)

    9 years, 4 months ago

    Since it didn’t contain my username/password, I felt it was safe. Thanks for looking out for me.

    I enabled debug mode and there were 2 errors with plugins. I deleted those plugins and the error messages went away, but the problem of not seeing the admin dashboard remains.

    Thread Starter Lisa

    (@lisafoxnet)

    9 years, 4 months ago

    Figured it out….

    When I imported the GoDaddy SQL file into the new database, the table prefixes were not the standard wp_xxxx. I knew this, but decided to go ahead and change the table prefixes themselves, rather than change the wp-config file to match what the database table prefix actually was. Why I chose the harder route, I’m not sure. Maybe because it was late and I should have been in bed?

    Anyway….

    So I dumped the database, re-uploaded the GoDaddy SQL file and changed the wp-config file where it has the $table_prefix = xxxxx

    Problem solved. I can now access the admin dashboard. Marking this topic closed.

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

The topic ‘Need help fixing wp_usermeta table’ is closed to new replies.

Tags