aboutsummaryrefslogtreecommitdiffstats
path: root/admin/stats.php
diff options
context:
space:
mode:
authornikrou <nikrou@piwigo.org>2010-06-04 19:39:02 +0000
committernikrou <nikrou@piwigo.org>2010-06-04 19:39:02 +0000
commite49ff390d34685200cb2148aeded472c56bf1b68 (patch)
tree3085b2b1b2dbe35832db17a3650f46cc447efce5 /admin/stats.php
parentcb00a22449e6f83c58da275dfcc5984b6100b964 (diff)
Bug 1717 fixed : SQLite: access failure on Admin > Tools > History
hour function doesn't exists Merge from trunk. git-svn-id: http://piwigo.org/svn/branches/2.1@6464 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--admin/stats.php7
1 files changed, 5 insertions, 2 deletions
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);