View Single Post
Old 12-17-2004, 03:51 PM   #3
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
As baskamer pointed out, seven tables have duplicate indexes, so to remove the duplicate indexes, run the following queries.

Code:
# Update from the 1.8.5 version
# Add the table prefix if needed
# ---------------------------------
ALTER TABLE excludes DROP INDEX ex_id;
ALTER TABLE includes DROP INDEX in_id;
ALTER TABLE keywords DROP INDEX key_id;
ALTER TABLE logs DROP INDEX l_id;
ALTER TABLE sites DROP INDEX site_id;
ALTER TABLE spider DROP INDEX spider_id;
ALTER TABLE tempspider DROP INDEX id;
Note: If you did a fresh install of PhpDig v.1.8.6 after the date of this post, do not run these queries, as the init_db.sql file has been updated to prevent the duplicate indexes.

Also, some credits and copyright information was updated, plus the contributions directory has been removed. The files that were in the contributions directory have been placed in the includes and locales directories instead.

If you downloaded PhpDig v.1.8.6 after the date of this post, the changes in this post have already been applied to the package.
__________________
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