From 92d9dddd2bc5b3b61d7c63e2f5fd48d5b3597db3 Mon Sep 17 00:00:00 2001 From: plegall Date: Mon, 17 Oct 2005 21:11:19 +0000 Subject: - bug 154 fixed: "Calendar category, too precise dates". Bug came from the bigger precision of creation_date and available_date in images tables. Need to retrieve only the year-month-day information. git-svn-id: http://piwigo.org/svn/trunk@896 68402e56-0260-453c-a942-63ccdbb3a9ee --- doc/ChangeLog | 7 +++++++ include/category_calendar.inc.php | 4 +++- 2 files changed, 10 insertions(+), 1 deletion(-) diff --git a/doc/ChangeLog b/doc/ChangeLog index 2d17c54dc..b53b56630 100644 --- a/doc/ChangeLog +++ b/doc/ChangeLog @@ -1,5 +1,12 @@ 2005-10-17 Pierrick LE GALL + * bug 154 fixed: "Calendar category, too precise dates". Bug came + from the bigger precision of creation_date and available_date in + images tables. Need to retrieve only the year-month-day + information. + +2005-10-17 volcom + * new: history details by month,day 2005-10-15 Pierrick LE GALL diff --git a/include/category_calendar.inc.php b/include/category_calendar.inc.php index 2ef31d7e0..a355a9339 100644 --- a/include/category_calendar.inc.php +++ b/include/category_calendar.inc.php @@ -157,7 +157,9 @@ elseif (!isset($page['calendar_day'])) // creation of hash associating the number of the day in the month with // the number of picture for this day : $calendar_days $query = ' -SELECT DISTINCT('.$conf['calendar_datefield'].') AS day, COUNT(id) AS count +SELECT + DISTINCT DATE_FORMAT('.$conf['calendar_datefield'].', \'%Y-%m-%d\') AS day + , COUNT(id) AS count FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id '.$page['where'].' AND '.$conf['calendar_datefield'].' -- cgit v1.2.3