[Paul M]

Originally Posted by Matt_270581

Then I import the new XML file will it try to rebuild the index? or will it just check and skip that part?

It will try again. It actually deletes any existing index and re-adds a new one.

To prevent it you will need to edit the xml and remove these lines ;

PHP Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "post DROP INDEX dateline");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "post ADD INDEX dateline (dateline)");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD lastrepcheck INT(10) UNSIGNED NOT NULL");
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET lastrepcheck = lastvisit");