Ignore:
Timestamp:
06/04/10 21:39:02 (9 years ago)
Author:
nikrou
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.1/admin/stats.php

    r6364 r6464  
    117117SELECT 
    118118    date, 
    119     HOUR(time) AS hour, 
     119    hour(time) AS hour, 
    120120    MAX(id) AS max_id, 
    121121    COUNT(*) AS nb_pages 
     
    123123  WHERE summarized = \'false\' 
    124124  GROUP BY 
     125    date, 
     126    hour 
     127  ORDER BY 
    125128    date ASC, 
    126     HOUR(time) ASC 
     129    hour ASC 
    127130;'; 
    128131$result = pwg_query($query); 
Note: See TracChangeset for help on using the changeset viewer.