Changeset 6518 for trunk/include/functions_search.inc.php

Timestamp:

Jun 10, 2010, 11:07:22 PM (14 years ago)

Author:

nikrou

Message:

Bug 1730 fixed : search doesn't work when database engine is not mysql
For posgresql and sqlite date must allways use day and month with two diggits.

File:

• trunk/include/functions_search.inc.php (modified) (1 diff)

trunk/include/functions_search.inc.php

@@ -224 +224 @@
   {
     $query = '
-SELECT DISTINCT(id)
+SELECT id
   FROM '.IMAGES_TABLE.' i
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id