Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: User ID = 999999999?


wittmania
Member

@wittmania

OK… so I do have access to phpMyAdmin, which may not be such a good thing.

Somehow I got some things crossed up so I am now getting these messages from within the wp_users table:

!!! PRIMARY and INDEX keys should not both be set for column ID

!!!More than one INDEX key was created for column ID

!!!UNIQUE and INDEX keys should not both be set for column user_login

Here is the raw text of the indexes from that page:

Indexes:

Keyname Type Cardinality Action Field

PRIMARY PRIMARY 5 Edit Drop ID

user_login UNIQUE 5 Edit Drop user_login

user_login_key INDEX None Edit Drop user_login

ID_2 INDEX None Edit Drop ID

ID_3 INDEX None Edit Drop ID

ID_4 INDEX None Edit Drop ID

This is a longshot, but can you tell what I messed up, and how I should fix it? Sorry. I really appreciate the help.

While I wait for a response I will be banging my head against my desk for not backing up the DB before I started messing around with it. :(

Skip to toolbar