aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorrub <rub@piwigo.org>2007-01-08 06:14:49 +0000
committerrub <rub@piwigo.org>2007-01-08 06:14:49 +0000
commit75246a064cca42aaae0a4bf446bcbdaf6e051a6a (patch)
treedbb5066b82600443173f94348ade072cc60dce57
parent2bac6aab19aabbb8cfa552978888f749cb23d1eb (diff)
Feature Issue ID 0000601: Filter all public pages with only recent elements
Fix following problem: - if an image appears in several categories (virtual ones) - if you click on that image (the thumbnail) - i have several php warnings/errors and nothing is displayed git-svn-id: http://piwigo.org/svn/trunk@1701 68402e56-0260-453c-a942-63ccdbb3a9ee
-rw-r--r--include/section_init.inc.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/include/section_init.inc.php b/include/section_init.inc.php
index 29a5be5e8..2911d60cc 100644
--- a/include/section_init.inc.php
+++ b/include/section_init.inc.php
@@ -429,7 +429,7 @@ WHERE
{
// Main query
$query = '
-SELECT image_id
+SELECT distinct image_id
FROM '.IMAGE_CATEGORY_TABLE.'
INNER JOIN '.IMAGES_TABLE.' ON id = image_id
WHERE