PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Script Installation

Reply
 
Thread Tools
Old 12-17-2004, 05:33 AM   #1
baskamer
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`
though you should know...
baskamer is offline   Reply With Quote
Old 12-17-2004, 10:07 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
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.
Charter is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 03:14 AM
Spider Indexes an Error Page alisan Troubleshooting 2 02-13-2006 11:14 AM
Why scan apache multi indexes? RobM How-to Forum 1 07-09-2004 07:08 AM
only indexes the first page... majestique Troubleshooting 8 04-08-2004 07:34 PM
old indexes baskamer How-to Forum 1 03-31-2004 07:30 AM


All times are GMT -8. The time now is 05:30 AM.


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