[mythtv] DVB Changes / Patch Applied

[Andrew Wilson]

I'd like to second that though - getting rid of the drop in the schema
updgrade.

The scanning didn't work for me, and left me with an unfinished
channels table which I had to hack by hand to get the system up again.

Channel scanning got stuck when the last mux did not tune in, the
scanner thread never dropped out after 20 min, and the last message in
the log was

2005-01-25 22:32:40.492 SIScan#0: Transport Failed to Tune

Also I noticed that it has picked up two mplex's (2 and 3 below)
broadcasting the same stuff, only with a 166kHz offset. Maybe you need
to do a duplicate check and pick the one with the strongest DVB stats.
Mplex 7 in the list below is bogus, Maybe need to look at how this
table is populated.

mysql> select mplexid,constellation,frequency from dtv_multiplex;
+---------+---------------+-----------+
| mplexid | constellation | frequency |
+---------+---------------+-----------+
|       1 | qam_16        | 570000000 |
|       2 | qam_64        | 538000000 |
|       3 | qam_64        | 538166670 |
|       4 | qam_16        | 513833330 |
|       5 | qam_16        | 642000000 |
|       6 | qam_16        | 618000000 |
|       7 | qam_16        | 746000000 |
+---------+---------------+-----------+
7 rows in set (0.02 sec)





On Thu, 27 Jan 2005 11:41:07 +1100, Nigel Pearson
<nigel at ind.tansu.com.au> wrote:
> 
>         Taylor, while we are talking about database schema, ...
> 
> On 25/01/2005, at 2:00 AM, Taylor Jacob wrote:
> > I want to collect a list of the dtv_privatetype entries that are
> > needed for
> > peoples networks and shove them into 1 schema update just before .17
> > instead of
> > multiple schema updates for something so trivial.
> 
> 
>         The current schema drops three old DVB tables from the DB.
> This is fine if you are only using CVS or 0.16, but if you
> swap between them then the database will be stuffed.
> 
>         I realise that the new code doesn't need dvb_channel,
> dvb_pids and dvb_sat, and I don't know the "policy" for old tables,
> but how do you feel about dropping the SQL DROP from schema upgrade
> 1063?
> 
> --
> Nigel Pearson, nigel at ind.tansu.com.au | "Peacemaking is our profession"
> Telstra BI&D, Sydney, Australia       | Motto of Burpelson Airforce Base
> Office: 8255 4222    Fax:  8255 3153  | Commanded by Gen. Jack D. Ripper
> Mobile: 0408 664435  Home: 9792 6998  |        Dr Strangelove
> 
> 
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
> 
> 
>