sorry not sure whether this should be a new post or not as have put it in an old post as well.

I am getting these errors in MySQL when i do a check on the database

Problems with indexes of table `xoops_banner`
PRIMARY and INDEX keys should not both be set for column `bid`
Problems with indexes of table `xoops_citas`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `xoops_newblocks`
More than one INDEX key was created for column `mid`
Problems with indexes of table `xoops_priv_msgs`
PRIMARY and INDEX keys should not both be set for column `msg_id`
More than one INDEX key was created for column `to_userid`
Problems with indexes of table `xoops_ranks`
More than one INDEX key was created for column `rank_min`
Problems with indexes of table `xoops_smartfaq_answers`
PRIMARY and INDEX keys should not both be set for column `answerid`
Problems with indexes of table `xoops_smartfaq_categories`
PRIMARY and INDEX keys should not both be set for column `categoryid`
Problems with indexes of table `xoops_smartfaq_faq`
PRIMARY and INDEX keys should not both be set for column `faqid`
Problems with indexes of table `xoops_users`
PRIMARY and INDEX keys should not both be set for column `uid`
More than one INDEX key was created for column `uname`
Problems with indexes of table `xoops_xhelp_department_mailbox`
PRIMARY and INDEX keys should not both be set for column `id`

could anyone tell me what i need to do to correct this or how it may have happened

Since you were receiving assistance in your previous thread (mail problems in XOOPS 2.0.9), and this problem appears to be directly related, it does not make sense that you started a new thread. This only serves to confuse people, it bumps down other people's support requests, and it makes it more difficult to provide support to you.

I am locking this thread. Please continue the discussion you were having in the "mail problems in XOOPS 2.0.9" thread.

Bet Regards,

James