Idle system causes corrupt recording on last viewed channel

[arizonamythtv@…]

I'm compiling 0.24 on Mythbuntu 10.04 AMD64 using a PVR150. I'm controlling a STB with a IR blaster. When the system sits idle for a few days when I attempt to watch or record the last viewed channel I end up with a corrupt recording. I know the IR blaster switched to the proper channel as the STB OSD shows the correct channel change. I've checked the db and it comes back with no errors. As a work around I run a cron job to switch the channel to an off channel that I wouldn't record then I start liveTV the recording works properly.

2011-02-04 15:38:35.947 adding: john-desktop as a client (events: 0)
2011-02-04 15:38:35.948 MainServer::ANN Monitor
2011-02-04 15:38:35.948 adding: john-desktop as a client (events: 1)  
2011-02-04 15:38:49.695 MainServer::ANN Playback
2011-02-04 15:38:49.695 adding: john-desktop as a client (events: 0)
2011-02-04 15:38:49.699 TVRec(1): Changing from None to WatchingLiveTV
2011-02-04 15:38:49.699 ChannelBase(1) Error: Setting start channel '104' failed,
                        and we failed to find any suitible channels on any input.
2011-02-04 15:38:49.700 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_$
2011-02-04 15:38:49.701 Driver error was [2/1052]:
QMYSQL3: Unable to prepare statement
Database error was:
Column 'sourceid' in where clause is ambiguous

2011-02-04 15:38:49.701 DB Error (ChannelUtil::GetChannels()):
Query was:
SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,     $
Driver error was [2/1052]:
QMYSQL: Unable to execute query
Database error was:
Column 'sourceid' in where clause is ambiguous

2011-02-04 15:38:49.703 LoadFromScheduler(): Error, called from backend.
2011-02-04 15:38:49.704 AutoExpire: CalcParams(): Max required Free Space: 2.0 GB w/freq: 15 min
2011-02-04 15:38:53.016 Finished recording 48 Hours on ID "To Catch a Stalker": channel 4104
2011-02-04 15:38:53.027 LoadFromScheduler(): Error, called from backend.
2011-02-04 15:38:53.029 AutoExpire: CalcParams(): Max required Free Space: 2.0 GB w/freq: 15 min

[sphery]

The ambiguous sourceid was fixed in master by d14b660c168b3ead0ce0ea8bec49243325e73047 . Daniel should decide whether the change is too invasive for backporting.

[danielk]

Fixed by [d65631013]

Fixes #9575. Fix an ambiguous DB query (fixed by [d14b660c16] in master).

[stuartm]

Milestone 0.24.2 deleted