<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Just a note...<br>
<br>
I had a similar issue with the script. I only have one tuner (and
A-180) but it has been added and deleted several times since initial
install, such that (with multirec) when I look at tuner status I see
Tuner 5, Tuner 6, Tuner 7, Tuner 8 and Tuner 9. The script wasn't too
happy with that, putting entries in for tuner 1, which doesn't exist
(most people's setups probably don't have this problem). <br>
<br>
Also, one of my channels had a ' in the call sign/name field, which
broke the generated SQL. I hand edited the file to change ' to '' (two
single ticks, not a double) and it worked (well, aside from the above
issue). <br>
<br>
Another issue: I checked my DTA box and found the VCT ID. When I
looked at the generated tables, however, the channels that it named
(like 18.1, 18.2 etc) for that ID were not the same as the channels
that a normal scan produced. For example, on 18, scan (in Myth, not
the dvb-util command) showed I had 18#0 through 18#7 or so, but
scte65scan said I had 18.1, 18.2 and 18.3. Scan had more, and on most
channels there as a #0 entry, whereas scte65scan never reported any .0
channels (.1 being the lowest, always). Makes me think there is a
programmer's 0 issue involved. The fact scan produced more channels
than scte65scan may be the fact that I have extended digital service,
and one cable box that is capable of getting several more channels than
the DTA box. Perhaps those channels belong to that service tier, but
I'm not sure. My box isn't hooked to a TV at the moment, its hooked to
a HD-PVR waiting extremely patiently for official support (I'm really
not comfortable with non-official repos or running trunk), so I can't
easily see what it's VCT_ID is at the moment.<br>
<br>
Jeff.<br>
<br>
<br>
Brad Fuller wrote:
<blockquote
cite="mid:df41a9e40906150929k7121df3an6eccb97a5ae5d10b@mail.gmail.com"
type="cite">
<pre wrap="">On Mon, Jun 15, 2009 at 9:11 AM, Mark Knecht<a class="moz-txt-link-rfc2396E" href="mailto:markknecht@gmail.com"><markknecht@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Mon, Jun 15, 2009 at 8:44 AM, Brad Fuller<a class="moz-txt-link-rfc2396E" href="mailto:bradallenfuller@gmail.com"><bradallenfuller@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Mon, Jun 15, 2009 at 7:32 AM, Mark Knecht<a class="moz-txt-link-rfc2396E" href="mailto:markknecht@gmail.com"><markknecht@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Mon, Jun 15, 2009 at 7:24 AM, Brad Fuller<a class="moz-txt-link-rfc2396E" href="mailto:bradallenfuller@gmail.com"><bradallenfuller@gmail.com></a> wrote:
<SNIP>
</pre>
<blockquote type="cite">
<pre wrap="">
Thanks Roy. I didn't see a reference to sourceid in the link you gave.
I guess my question should be a little less fuzzy. I fear that
dtv_multiplex is a table that both pcHDTV3000 and HDHR (and any other
digital card) uses and thus the sourceid in the resulting .sql file
could be off. And, if I use \as is' I might delete my currect OTA HDHR
or my pchdtv3000 table.
Can anyone confirm that and if so, how do I tell?
</pre>
</blockquote>
<pre wrap="">Could you back up your current database, run the command, and then
look to see what happened?
</pre>
</blockquote>
<pre wrap="">I could, but it would be a lot better to understand the dB from an expert.
</pre>
</blockquote>
<pre wrap="">How will you determine whether the person who responds is a dB expert? ;-)
</pre>
</blockquote>
<pre wrap=""><!---->
Heck, I don't know. If Michael Dean spoke up, I would be pretty sure
it was right ;-)
Anyway, mythweb tools told me what sourceid is from what card (after I
deciphered the channels numbers to what belonged to what sourceid)
Here's how my tuners lineup:
sourceid Tuner connected to
1 PVR-250 analog cable
2 pchdtv3000 ATSC OTA
3 HDHR 0 ATSC OTA
4 DCH3416 digital cable
I'm want to insert a new table and the .sql that scte65scan created
said to delete sourceid 1. That doesn't sound good to me.
Note that I do have HDHR 1 in my mythtv-setup, but I've never scanned
for channels and so I assume that's why there is not sourceid for it.
Using the MySQL Query Browser, I see that there are two sourceid's in
the dtv_multiplex table: 2 and 3. That makes sense to me since those
are the two tuners connected to OTA. However, I don't know why the
DCH3416 settop box isn't in there too, since it's digital cable. I can
only guess it's in another table.
---
AH... I just queried on cardinput table and I see:
cardid sourceid displayname
1, 1, 'Comcast Analog'
2, 2, 'pcHDTV3000 ATSC'
3, 3, 'HDHR ATSC'
5, 4, 'DCH3416'
4, 4, ''
</pre>
</blockquote>
<br>
--<br>
I haven't smoked for 2 years, 9 months and 4 weeks, saving $4,651.29
and not smoking 31,008.63 cigarettes.
</body>
</html>