PDA

View Full Version : db indexes


baskamer
12-17-2004, 05:33 AM
don't if it is a real problem but though you should know,

i updated from 1.8.0 and have migrated the db step by step to 1.8.6.

when i do a check on the table mysql report the following problem

Problems with indexes of table `phpdig_excludes`

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


Problems with indexes of table `phpdig_includes`

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


Problems with indexes of table `phpdig_keywords`

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


Problems with indexes of table `phpdig_logs`

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


Problems with indexes of table `phpdig_sites`

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


Problems with indexes of table `phpdig_spider`

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


Problems with indexes of table `phpdig_tempspider`

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

though you should know...

Charter
12-17-2004, 10:07 AM
Run the following queries to drop the duplicate index:

ALTER TABLE phpdig_excludes DROP INDEX ex_id;
ALTER TABLE phpdig_includes DROP INDEX in_id;
ALTER TABLE phpdig_keywords DROP INDEX key_id;
ALTER TABLE phpdig_logs DROP INDEX l_id;
ALTER TABLE phpdig_sites DROP INDEX site_id;
ALTER TABLE phpdig_spider DROP INDEX spider_id;
ALTER TABLE phpdig_tempspider DROP INDEX id;