Edit:
looks like your mod removes a required field:
http://www.vbulletin.com/forum/bugs3...iew&bugid=1218
Quote:
If you have done a new install and are getting errors while searching, this column is missing. Please run the following query to add it:
Code:
ALTER TABLE `search` ADD `completed` SMALLINT UNSIGNED NOT NULL DEFAULT '1';
|
I think if you alter your xml file to not include:
Quote:
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "search` ADD `completed` tinyint(1) default NULL");
|
and:
Quote:
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "search` DROP `completed`");
|
This might work because completed has to have a default of not null to work and you are altering it to change to null as the default. You also can not remove this field