From fd0f465c59415c73bf6cf926a73804b32807c969 Mon Sep 17 00:00:00 2001 From: nikrou Date: Fri, 4 Jun 2010 19:36:56 +0000 Subject: Fix bug 1717 : SQLite: access failure on Admin > Tools > History hour function doesn't exists git-svn-id: http://piwigo.org/svn/trunk@6463 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/stats.php | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'admin') diff --git a/admin/stats.php b/admin/stats.php index b693ebcaa..1ce07649a 100644 --- a/admin/stats.php +++ b/admin/stats.php @@ -116,14 +116,17 @@ check_status(ACCESS_ADMINISTRATOR); $query = ' SELECT date, - HOUR(time) AS hour, + hour(time) AS hour, MAX(id) AS max_id, COUNT(*) AS nb_pages FROM '.HISTORY_TABLE.' WHERE summarized = \'false\' GROUP BY + date, + hour + ORDER BY date ASC, - HOUR(time) ASC + hour ASC ;'; $result = pwg_query($query); -- cgit v1.2.3