[mythtv] mythweb "stats" module thinks "true" is a column

[Robert Tsai]

I don't know if this is a MySQL thing or something, but I need to do
the following in my tree:

Index: modules/stats/handler.php
===================================================================
--- modules/stats/handler.php   (revision 9631)
+++ modules/stats/handler.php   (working copy)
@@ -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')

If it matters, my system has:

	- mysql-server 4.0.24-10ubuntu2
	- php4-mysql 4.4.0-3ubuntu2

--Rob
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20060406/ebe25b3c/attachment.pgp