0

I noticed an issue after deploying a custom theme build to a Go Daddy Managed WordPress installation (client's request, RIP) wherein users created by the admin account in the WP back-end weren't showing up in the list of users.

They appear in the users database, but there appears to be no associated references in the users_metadata table (there are entries for the admin account, but that's it).

The users table says it has no primary key assigned - I'm not sure if that's part of the problem. I'm assuming that the user ID should be the primary key but clearly I'm no SQL pro here.

My client needs to be able to create users so his staff can upload content. What tree should I be barking up to fix this problem?

1 Answer 1

0

In the users table the primary key should be ID (auto-increment) and the user_login, user_nicename and user_email fields should be indexed.

In the usermeta table the umeta_id should be primary key (auto-increment) and the umeta_id and meta_key fields should be indexed.

1
  • Thanks. After following these steps, database behaviour is as expected.
    – S. Coll
    Aug 13, 2017 at 23:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.