From ce187863e8585421cf75e5b4854eeb4a9e0678c5 Mon Sep 17 00:00:00 2001 From: nikrou Date: Thu, 10 Jun 2010 21:07:22 +0000 Subject: 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. git-svn-id: http://piwigo.org/svn/trunk@6518 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_search.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'include') diff --git a/include/functions_search.inc.php b/include/functions_search.inc.php index 8f6af51dd..425de3e6c 100644 --- a/include/functions_search.inc.php +++ b/include/functions_search.inc.php @@ -223,7 +223,7 @@ function get_regular_search_results($search, $images_where) if (!empty($search_clause)) { $query = ' -SELECT DISTINCT(id) +SELECT id FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id WHERE '.$search_clause; -- cgit v1.2.3