Opened 18 years ago

Closed 18 years ago

#1588 closed patch (fixed)

patch for stats module sql error

Reported by: l-case@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythtv Version:
Severity: medium Keywords:
Cc: Ticket locked: no

Description

here an one liner fix for the sql query: 

--- modules/stats/handler.php   (Revision 9519)
+++ modules/stats/handler.php   (Arbeitskopie)
@@ -21,7 +21,7 @@
  *        AND program.endtime > program.starttime;
  *
 /**/
-    $where = ' WHERE true';
+    $where = ' WHERE 1';
     if ($_REQUEST['query_time'] == 'day')
         $where = ' WHERE UNIX_TIMESTAMP(starttime) > '.(time()-24*60*60);
     if ($_REQUEST['query_time'] == 'week')

Change History (1)

comment:1 Changed 18 years ago by anonymous

Resolution: → fixed
Status: new → closed
Note: See TracTickets for help on using tickets.