[mythtv-users] Can't recorded last viewed channel

[John H]

On Sat, Jan 29, 2011 at 9:31 PM, John H <arizonamythtv at gmail.com> wrote:
> I'm having an issue that I can't figure out. If I'm watching channel
> say 104 (Analog SD) and I exit and then I come back later either by
> watching LiveTV or through a scheduled recording, I cannot record the
> channel since I ended up with just one frame for the whole show. If I
> change to channel 103 and then back to 104, I can view the proper
> recording for 104. When I say later, it has to be a few hours later. I
> mostly use it for recording so I've missed so many recording since
> I've tried to record multiple shows on the same channel one after
> another. I'm using a PVR150 on 10.04 and I'm using 0.24.
>

I cannot figure out why this is happening. Here's what I'm seeing in the FE log.

2011-02-04 15:38:50.027 VDPAU: Added 2 output surfaces (total 4, max 4)
2011-02-04 15:38:54.790 VDPAU Painter: Clearing VDPAU painter cache.
2011-02-04 15:38:54.791 MythPainter: 5 images not yet de-allocated.
2011-02-04 15:38:54.816 Clearing OpenGL painter cache.
2011-02-04 15:38:54.919 VDPAU: Created 2 output surfaces.
2011-02-04 15:38:54.919 VDPAU: Created VDPAU render device 1920x1080
2011-02-04 15:38:54.930 Player(0): Forcing decode extra audio option
on (Video method requires it).
2011-02-04 15:38:54.930 AFD Warning: ScanATSCCaptionStreams() called with no PMT
2011-02-04 15:38:54.930 AFD: Opened codec 0x3e7de10, id(MPEG2VIDEO) type(Video)
2011-02-04 15:38:54.930 AFD: codec MP2 has 2 channels
2011-02-04 15:38:54.930 AFD: Opened codec 0x368cb40, id(MP2) type(Audio)
2011-02-04 15:38:55.048 AO: Opening audio device 'pulse' ch 2(2) sr
48000 sf signed 16 bit reenc 0
2011-02-04 15:38:55.050 AudioOutput Warning: mmap not available,
attempting to fall back to slow writes
2011-02-04 15:38:55.227 AudioPlayer: Enabling Audio
2011-02-04 15:38:55.296 [mpegvideo_vdpau @ 0x7f0988e456c0]warning:
first frame is no keyframe
2011-02-04 15:38:55.297 [mpegvideo_vdpau @ 0x7f0988e456c0]warning:
first frame is no keyframe
2011-02-04 15:38:55.306 VDPAU: Added 2 output surfaces (total 4, max 4)
2011-02-04 15:38:58.953 AFD Warning: ScanATSCCaptionStreams() called with no PMT
2011-02-04 15:38:58.953 AFD Warning: ScanATSCCaptionStreams() called with no PMT
2011-02-04 15:40:54.855 [mp2 @ 0x7f0988e456c0]incomplete frame
2011-02-04 15:40:54.856 AFD Error: Unknown audio decoding error
2011-02-04 15:40:56.425 [mp2 @ 0x7f0988e456c0]Header missing
2011-02-04 15:40:56.425 AFD Error: Unknown audio decoding error

Looks like the issue is coming from the BE

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

Anyone know how to fix?