summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorThomas Petazzoni <thomas.petazzoni@free-electrons.com>2017-11-02 16:47:52 (GMT)
committerThomas Petazzoni <thomas.petazzoni@free-electrons.com>2017-11-02 16:47:52 (GMT)
commitece79505869ed01d5c860a02a795d516a27c97a1 (patch)
tree409ff1708d46981d5693c81af897035603adb873
parent5e08b8f88850f6ca56b57da923c434b7f264e33f (diff)
downloadbuildroot-test-ece79505869ed01d5c860a02a795d516a27c97a1.tar.gz
buildroot-test-ece79505869ed01d5c860a02a795d516a27c97a1.tar.bz2
graph.php: fix query for recent MySQL versions
Signed-off-by: Thomas Petazzoni <thomas.petazzoni@free-electrons.com>
-rw-r--r--web/graph.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/web/graph.php b/web/graph.php
index eeafa68..e486f55 100644
--- a/web/graph.php
+++ b/web/graph.php
@@ -9,7 +9,7 @@ $myData = new pData();
$db = new db();
-$sql = "select * from (select sum(status=0) as success,sum(status=1) as failures,sum(status=2) as timeouts,count(*) as total,date(builddate) as day from results group by date(builddate) order by builddate desc limit 180) as foo order by day;";
+$sql = "select * from (select sum(status=0) as success,sum(status=1) as failures,sum(status=2) as timeouts,count(*) as total,date(builddate) as day from results group by date(builddate) order by date(builddate) desc limit 180) as foo order by day;";
$ret = $db->query($sql);
if ($ret == FALSE) {