[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)
<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?
looks like database corruption.
Regards
Ian Dobson
More information about the mythtv-dev
mailing list