mysql problem ?

Use this forum if you want to discuss a problem or ask a question related to a hMailServer beta release.
Post Reply
User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

mysql problem ?

Post by layer » 2005-03-01 18:51

hie,

i have maked a "verify comand" whith phpmyadmin and i have received some errors:

Problems with indexes of table `hm_accounts`
PRIMARY and INDEX keys should not both be set for column `accountid`
Problems with indexes of table `hm_adsynchronization`
PRIMARY and INDEX keys should not both be set for column `synchid`
Problems with indexes of table `hm_aliases`
PRIMARY and INDEX keys should not both be set for column `aliasid`
Problems with indexes of table `hm_deliverylog`
PRIMARY and INDEX keys should not both be set for column `deliveryid`
Problems with indexes of table `hm_deliverylog_recipients`
PRIMARY and INDEX keys should not both be set for column `deliveryrecipientid`
Problems with indexes of table `hm_distributionlists`
PRIMARY and INDEX keys should not both be set for column `distributionlistid`
Problems with indexes of table `hm_distributionlistsrecipients`
PRIMARY and INDEX keys should not both be set for column `distributionlistrecipientid`
Problems with indexes of table `hm_dnsbl`
PRIMARY and INDEX keys should not both be set for column `sblid`
Problems with indexes of table `hm_domain_aliases`
PRIMARY and INDEX keys should not both be set for column `daid`
Problems with indexes of table `hm_domains`
PRIMARY and INDEX keys should not both be set for column `domainid`
...

i'm using mysql 4.1.10...

thanks

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

Post by martin » 2005-03-01 21:07

Where do you find the Verify-command?
I tried Check, Analyze, Repair and Optimize under "Operations". All of these returned OK and no failure error message.

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

Post by layer » 2005-03-01 23:40

martin wrote:Where do you find the Verify-command?
I tried Check, Analyze, Repair and Optimize under "Operations". All of these returned OK and no failure error message.
sory, the option is "check", the table give all thigs OK but at the end it give that errors...

thanks

Post Reply