[mythtv] Strange QUERY_RECORDINGS results

ian dobson i.dobson at planet-ian.com
Thu Oct 23 11:17:29 UTC 2008

----- Original Message ----- 
From: "Stuart Morgan" <stuart at tase.co.uk>
To: "Development of mythtv" <mythtv-dev at mythtv.org>
Sent: Thursday, October 23, 2008 12:55 PM
Subject: Re: [mythtv] Strange QUERY_RECORDINGS results

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)
> 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, 
>this is strange. Which version of MySQL?

looks like database corruption.

Ian Dobson

More information about the mythtv-dev mailing list