PhpDig.net

PhpDig.net (http://www.phpdig.net/forum/index.php)
-   Script Installation (http://www.phpdig.net/forum/forumdisplay.php?f=37)
-   -   db indexes (http://www.phpdig.net/forum/showthread.php?t=1651)

baskamer 12-17-2004 05:33 AM
db indexes
 
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

Code:
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:
Code:
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;


All times are GMT -8. The time now is 04:16 AM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.