[mythtv] Strange QUERY_RECORDINGS results
Stuart Morgan
stuart at tase.co.uk
Thu Oct 23 10:55:26 UTC 2008
On Thursday 23 October 2008 04:37:39 Nigel Pearson wrote:
> The backend does a query roughly like this
> for ' 26 QUERY_RECORDINGS Recording':
>
>
> mysql> SELECT
> recorded.chanid,recorded.starttime,recorded.endtime,recorded.title
> FROM recorded WHERE recorded.endtime >= NOW() AND recorded.starttime
> <= NOW();
> Empty set (0.01 sec)
<snip>
> which gives me the one recording I expect. So, there needs to be extra
> parentheses about line 1200 of programs/mythbackend/mainserver.cpp,
> right?
No, it shouldn't be necessary. The existing query works just fine for me, so
this is strange. Which version of MySQL?
--
Stuart Morgan
More information about the mythtv-dev
mailing list