Changeset 6464 for branches/2.1/admin

Timestamp:

Jun 4, 2010, 9:39:02 PM (14 years ago)

Author:

nikrou

Message:

Bug 1717 fixed : SQLite: access failure on Admin > Tools > History
hour function doesn't exists
Merge from trunk.

File:

• branches/2.1/admin/stats.php (modified) (2 diffs)

branches/2.1/admin/stats.php

@@ -117 +117 @@
 SELECT
     date,
-    HOUR(time) AS hour,
+    hour(time) AS hour,
     MAX(id) AS max_id,
     COUNT(*) AS nb_pages
@@ -123 +123 @@
   WHERE summarized = \'false\'
   GROUP BY
+    date,
+    hour
+  ORDER BY
     date ASC,
-    HOUR(time) ASC
+    hour ASC
 ;';
 $result = pwg_query($query);