[mythtvnz] Install: trouble with starting channel

[Chris Bayley]

On Jan 5, 2011, at 8:43, Nick Rout <nick.rout at gmail.com> wrote:

> On Tue, Jan 4, 2011 at 9:37 PM, chris <chris at thebayleys.net> wrote:
>> On 04/01/11 13:46, Kenneth Dixon wrote:
>> 
>> On 4 January 2011 13:13, Chris Bayley <chris at thebayleys.net> wrote:
>>> 
>>> That's basically correct, trouble is 'StartingChannel' is a drop down box
>>> that won't populate even after a successful scan! Frustrating as I think
>>> that is the only staring between me and myth nirvana. Interestingly there is
>>> a bug lodged against 0.23 which has another user experiencing the same
>>> problem with a DVB-T card. That bug shows as fixed for 0.24(which I am
>>> using). It's getting pretty close to 'Use the Source Luke!' time !
>>> Curiously when I use setup to add a new capture card not one but two cards
>>> are added to the database! Exiting setup gives me warnings about startup
>>> channel on two cards.
>>> I wonder what you have in your DB ?
>>> Will now spend some time fixing motorbikes until frustration subsides !
>>> Kind regards,
>>> Chris Bayley
>> 
>> Ah I see, do your channels have a "Video Source"  in the backend setup (or
>> sourceid in channels table in DB)?
>> 
>> looks like double tuner entry could be the "Max recordings:" setting in
>> capture card -> recording options. This produces extra entries and allows
>> multiple recording off one tuner as long as the recorded channels are on the
>> same multiplex. Mine is a dual tuner and has 6 entries in the DB all up and
>> my "Max recordings" setting is 3 for each tuner, so it adds up.
>> 
>> Ken
>> 
>> 
>> 
>> _______________________________________________
>> mythtvnz mailing list
>> mythtvnz at lists.linuxnut.co.nz
>> http://lists.ourshack.com/mailman/listinfo/mythtvnz
>> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>> 
>> I believe at present it might be some database related issue. I notice the
>> following SQL error in the backend log which doesn't look too good:
>> 
>> SELECT channum, callsign, channel.chanid,        atsc_major_chan,
>> atsc_minor_chan,        name, icon, mplexid, visible,
>> channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT
>> JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN
>> cardinput         ON cardinput.sourceid = channel.sourceid JOIN
>> capturecard       ON cardinput.cardid   = capturecard.cardid WHERE
>> sourceid='1';
>> ERROR 1052 (23000): Column 'sourceid' in where clause is ambiguous
>> 
>> That looks ambiguous SQL to me but maybe someone who knows SQL and it's
>> versions distinctions better than I can comment ?
>> 
>> I am running 0.24 from pcmenery ppa
> 
> why?
> 
> 

Coz I have pmcenery added for the latest iPhone interfaces and didn't have  it pinned. 
I shall revert to 0.23 this morning and see where I get to.
Tell me: on the input connections pages after you do a scan for channels  the 'starting channel' drop down is populated right ?

Cheers,
Chris