CODEWITHSUNDEEP
databasewordpress
Terri McKee
Terri McKee

Reputation: 53

WP not giving an ID in my wp_users table

wp_users is creating users but without an ID in the table.

Upvotes: 0

Views: 717

Answers (3)

Gautam Tak
Gautam Tak

Reputation: 129

It is auto incremented.

No need to define when you create the users.

for the more info, please visit the wordpress.com for any help.

Upvotes: 0

Ma9ic
Ma9ic

Reputation: 1125

Make sure your settings for ID looks like this in MySql and ensure AUTO_INCREMENT is ticked.

Upvotes: 1

Hobo
Hobo

Reputation: 7611

Did you create wp_users manually? The ID column should be defined as auto_increment by default; extracting from one of my databases shows:

CREATE TABLE `wp_users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

Try altering the column as described in this question.

Might be worth checking that the other tables have the correct structure as well (auto_increment, indices, etc). The correct definitions can be found in schema.php, here.

Upvotes: 0

Related Questions