[mythtv-users] SD UK - "To be announced" data in listings

[Simon Hobson]

Mike Bibbings <mike.bibbings at gmail.com> wrote:

> I am seeing similar to you on both my lineups UK Freesat and Freeview on my main mythtv backend.

Ah, so it's not just me then !


> I use the following sql to get a listing of "real" guide data remaining for each channel:
> 
> select MAX(program.endtime) AS "Last_End_Date", channel.name,channel.channum, channel.chanid, channel.xmltvid, DATEDIFF(MAX(program.endtime), NOW()) as Guide_Days_Remaining,channel.sourceid from program left join channel on channel.chanid = program.chanid where program.title<>"To Be Announced"  group by chanid order by Last_End_Date;

Thanks for saving me the effort of working that one out.

Dave Pearson <lists at the-pearsons.co.uk> wrote:

> As far as I can work out, most (all?) channel schedules are only updated overnight on a Friday. So, if you run your mythfilldatabase around 02:00 AM tonight, you should find that your listings are updated up till Friday 7th October.

That is confirmed by SD, I had this very prompt response from them :
> Our upstream performs a bulk update from the providers on Thursday and daily updates in case of errors or changes

And doing an update this evening has upped most channels from 8 to 15 days.

> There are some channels that seem to have a longer set of results, up to 21 days in some cases

Yes, I'm seeing that too.