Index: branches/5.2.x/core/units/helpers/search_helper.php =================================================================== diff -u -N -r16513 -r16655 --- branches/5.2.x/core/units/helpers/search_helper.php (.../search_helper.php) (revision 16513) +++ branches/5.2.x/core/units/helpers/search_helper.php (.../search_helper.php) (revision 16655) @@ -1,6 +1,6 @@ getSearchTable(); - $this->Conn->Query('DROP TABLE IF EXISTS ' . $search_table); - $sql = 'CREATE TABLE ' . $search_table . ' ( + $sql = 'CREATE TABLE IF NOT EXISTS ' . $search_table . ' ( `Relevance` decimal(8,5) DEFAULT NULL, `ItemId` int(11) NOT NULL DEFAULT 0, `ResourceId` int(11) DEFAULT NULL, `ItemType` int(1) NOT NULL DEFAULT 0, `EdPick` tinyint(4) NOT NULL DEFAULT 0, KEY `ResourceId` (`ResourceId`), KEY `Relevance` (`Relevance`) - )'; + ) ENGINE = MEMORY'; $this->Conn->Query($sql); + + $sql = 'TRUNCATE TABLE ' . $search_table; + $this->Conn->Query($sql); } /**