<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 04/01/11 13:46, Kenneth Dixon wrote:
<blockquote
cite="mid:AANLkTinQGcZTs0V2+36=U35mcJNCZMXH_h0pfLQ754s7@mail.gmail.com"
type="cite"><br>
<br>
<div class="gmail_quote">On 4 January 2011 13:13, Chris Bayley <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:chris@thebayleys.net">chris@thebayleys.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#FFFFFF">
<div>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 !</div>
<div>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.</div>
<div>I wonder what you have in your DB ?</div>
<div><br>
</div>
<div>Will now spend some time fixing motorbikes until
frustration subsides !</div>
<div><br>
Kind regards,
<div>Chris Bayley</div>
</div>
<div><br>
</div>
</div>
</blockquote>
<div><br>
Ah I see, do your channels have a "Video Source" in the
backend setup (or sourceid in channels table in DB)? <br>
<br>
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.<br>
<br>
Ken<br>
<br>
<br>
</div>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
mythtvnz mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtvnz@lists.linuxnut.co.nz">mythtvnz@lists.linuxnut.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.ourshack.com/mailman/listinfo/mythtvnz">http://lists.ourshack.com/mailman/listinfo/mythtvnz</a>
Archives <a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/</a>
</pre>
</blockquote>
<br>
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:<br>
<br>
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';<br>
ERROR 1052 (23000): Column 'sourceid' in where clause is ambiguous<br>
<br>
That looks ambiguous SQL to me but maybe someone who knows SQL and
it's versions distinctions better than I can comment ?<br>
<br>
I am running 0.24 from pcmenery ppa and this upgraded the database
from the 0.23 schema - potential stuff up ?<br>
<br>
Also my MySQL is 5.0.3 (not so late) as it is on my NAS - maybe a
problem ?<br>
<br>
investigations continue....<br>
<br>
Chris<br>
</body>
</html>