Hi Everyone,

I know very little about databases, but when looking through phpmyadmin at users table, I noticed the following errors:

1) PRIMARY and INDEX keys should not both be set for column `uid`
2) More than one INDEX key was created for column `uname`

Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 3 uid
uname INDEX None uname
email INDEX None email

uiduname INDEX None uid
uname
unamepass INDEX None uname
pass

Not sure if I should be worried or not, any help appreciated.

Thanks!

Mercury

One of those messages is valid, the other is a bug in phpmyadmin, by the looks of it.

The one about the primary key and index being the same is wrong, it's not taking into account the fact that the index is a multiple column index.

The message about two indexes on uname is true, it's unnecessary to have the single index on uname.

But those messages from myphpadmin are just there to bring it to your attention, they are not errors. The core developers could optimize the database somewhat by removing that extra index, it might save milliseconds when registering a new user, or updating user details, but it's not something to worry about.

Thanks for the respons! I'll not worry about it then.

Cheers,

Mercury