[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