Support » Fixing WordPress » user created via SQL can't log in to dashboard

Viewing 9 replies - 1 through 9 (of 9 total)
  • If the database import failed I think you probably want to just redo it. If not, are your tables exactly the same described in this document?

    I just ran the database repair tool, and it said everything looks good. Would that be sufficient?

    I’ll start checking manually too. Are you asking me to check that in each table all the fields are present?

    Is there a tool to test permissions for the file/directory structure?

    check user_meta table admin user normally is 1 and wp_capabilities should be a:1:{s:13:"administrator";s:1:"1";}

    I have two users, ID 1 & 4. Both started out as a:1:{s:13:”administrator”;b:1;}

    I tried changing each to a:1:{s:13:”administrator”;s:1:”1″;} but that didn’t make any difference. Thanks for the try!

    Do you still have your database backup?

    I do. This site is being moved from a multisite, and I still have the site on the other server as well.

    I re-exported with Backupbuddy and again, the wp_users & wp_usermeta tables are missing.

    That might not be all 🙁

    I moved wp_users & wp_usermeta over manually. It didn’t help. There must be something else.

    Something else I notice is that the site menu in the admin bar is not that of an admin. The only link is Dashboard.

    I solved it by making a fresh WP install, then exporting the tables from the old site again, manually replacing old to new site details, and then importing over the tables of the fresh install.

    I wish I could understand why it didn’t work in the first place. I used a different name for the first user in the fresh install. Perhaps something in the imported tables conflicted with the old user ID #1. Would that make any sense? I could try to break it again by changing the user name.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘user created via SQL can't log in to dashboard’ is closed to new replies.