Problems with indexes of tables in mySQL

[Trout69]

HI All,

 

Im sure u are already aware of my login in problems, and while i was trying to troubleshoot this i did a check tables in mySQL and found the following problems:

 

Problems with indexes of table `coupon_gv_customer`

PRIMARY and INDEX keys should not both be set for column `customer_id`

 

Problems with indexes of table `coupon_gv_queue`

PRIMARY and INDEX keys should not both be set for column `unique_id`

 

Problems with indexes of table `phpbb_sessions`

PRIMARY and INDEX keys should not both be set for column `session_id`

 

Problems with indexes of table `scart`

PRIMARY and INDEX keys should not both be set for column `cartid`

 

Does anyone know whether this is causing problems? How can i fix it?

 

Donna

[kgt]

Shouldn't be causing problems, but a primary key field is a type of index, so it's a waste to have an index and a primary key index on a field. It won't hurt, but it does make inserts slower, so it's best to remove the regular index.