|
12-17-2004, 06:33 AM | #1 |
Green Mole
Join Date: Feb 2004
Posts: 9
|
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` |
12-17-2004, 11:07 AM | #2 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
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;
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New phpDig indexes whole site now or? | JAB Creations | The Mole Hole | 0 | 11-07-2007 04:14 AM |
Spider Indexes an Error Page | alisan | Troubleshooting | 2 | 02-13-2006 12:14 PM |
Why scan apache multi indexes? | RobM | How-to Forum | 1 | 07-09-2004 08:08 AM |
only indexes the first page... | majestique | Troubleshooting | 8 | 04-08-2004 08:34 PM |
old indexes | baskamer | How-to Forum | 1 | 03-31-2004 08:30 AM |