REPLACE INTO should only be used if the data deletion is wanted.

[platal.git] / modules / search.php

diff --git a/modules/search.php b/modules/search.php
index 06c729a..6a2a1e3 100644 (file)
--- a/modules/search.php
+++ b/modules/search.php
@@ -266,9 +266,10 @@ class SearchModule extends PLModule
         if ($nbResults == 0) {
             $res = $q."|-2\n";
         }
-        XDB::query('REPLACE INTO  search_autocomplete
-                          VALUES  ({?}, {?}, {?}, NOW())',
-                    $type, $q, $res);
+        XDB::query('INSERT INTO  search_autocomplete (name, query, result, generated)
+                         VALUES  ({?}, {?}, {?}, NOW())
+               ON DUPLICATE KEY  result = VALUES(result), generated = NOW()',
+                   $type, $q, $res);
         echo $res;
         exit();
     }