When I tried to check tables on mySQL i got this 'Problems'
could they be a general 'problem' or common problem if so I have not seen another post regarding similar.
I have no experience with fixing tables and could be irreversable if i try/fail .. unlike altering module codes etc.
any ideas, help, how to's info regarding the mySQL 'problems' below?
Problems with indexes of table `ec_transaction_product`
UNIQUE and INDEX keys should not both be set for column `txnid`
Problems with indexes of table `node`
PRIMARY and INDEX keys should not both be set for column `nid`
More than one INDEX key was created for column `status`
Problems with indexes of table `term_hierarchy`
PRIMARY and INDEX keys should not both be set for column `tid`
Problems with indexes of table `term_node`
PRIMARY and INDEX keys should not both be set for column `tid`
Problems with indexes of table `view_view`
UNIQUE and INDEX keys should not both be set for column `name`
Problems with indexes of table `zipcodes`
PRIMARY and INDEX keys should not both be set for column `country`
More than one INDEX key was created for column `country`
ps;because of problems related to more than 1 DB table/module not sure what Categories this post should go
