Opened 18 years ago
Closed 18 years ago
#1588 closed patch (fixed)
patch for stats module sql error
Reported by: | 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')
Note: See
TracTickets for help on using
tickets.