Index: trunk/kernel/include/searchitems.php =================================================================== diff -u -N -r1019 -r1025 --- trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 1019) +++ trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 1025) @@ -518,20 +518,20 @@ //echo $SelectSQL."

\n"; - if($InitTable = TRUE) + if($InitTable == TRUE) { $this->adodbConnection->Execute("DROP TABLE IF EXISTS ".$this->ResultTable); //$indexSQL = "(INDEX(Relevance), INDEX(ItemId), INDEX(ItemType), INDEX sorting (EdPick,Relevance)) "; $full_sql = "CREATE TABLE ".$this->ResultTable." ".$indexSQL.$SelectSQL; - //echo $full_sql."
\n"; + //echo "Full SQL:".$full_sql."
\n"; $this->adodbConnection->Execute($full_sql); //echo $this->adodbConnection->ErrorMsg()."
\n"; $objSession->SetVariable("Search_Keywords",$this->Phrase); } else { $full_sql = "INSERT INTO ".$this->ResultTable." (Relevance,ItemId,ResourceId,ItemType,EdPick) ".$SelectSQL; - //echo "[".htmlspecialchars($full_sql)."]
\n"; + //echo "[".htmlspecialchars($full_sql)."]
\n"; $this->adodbConnection->Execute($full_sql); //echo $this->adodbConnection->ErrorMsg()."
\n"; }