MSQL error

[fryman]

After doing a check on all my tables I got these 2 errors:

Problems with indexes of table `category`
UNIQUE and INDEX keys should not both be set for column `name`
Problems with indexes of table `user`
UNIQUE and INDEX keys should not both be set for column `username`

Is this something I should be concerned about? How can I fix it?

EDIT: sorry, please move this post to the database board

[digitalpoint]

It's basically a waste of resources if you have two indexes that are indexing identical columns. For example, if both indexes for category are indexing just the one "name" column, I would just drop the index that is NOT the UNIQUE one (since there are more validation restrictions on that one). The UNIQUE one can do more (in terms of validation) than the other one, but the other one can't do anything for you that the UNIQUE one doesn't already do.

Confusing enough for ya? :)

[fryman]

I knew you would stop by this thread :D

Yeah, sure is confusing... so, if I go to phpmyadmin and select the "Repair Table" option will it fix this?

[digitalpoint]

No... because the table isn't broken, it just has a redundant/extra index. Someone (or something) had to add it, so someone (or something) will have to remove it.

[fryman]

I see... so, which one should I delete, or how can I find out which one I should delete?

[digitalpoint]

Attach a screenshot of your index list for that table. :)