Ticket #6369: dadigi_buggy_channel.txt

File dadigi_buggy_channel.txt, 1.5 KB (added by mythtv@…, 16 years ago)

Select from mythconverg.channel and mythconverg.dtv_multiplex

Line 
1mysql> select * from channel where callsign like 'ZDF'
2 -> \G
3*************************** 1. row ***************************
4 chanid: 5102
5 channum: 002
6 freqid: NULL
7 sourceid: 5
8 callsign: ZDF
9 name: ZDF
10 icon: /home/mythtv/.mythtv//channels/zdf_de.jpg
11 finetune: NULL
12 videofilters:
13 xmltvid:
14 recpriority: 0
15 contrast: 32768
16 brightness: 32768
17 colour: 32768
18 hue: 32768
19 tvformat: Default
20 commfree: 0
21 visible: 1
22 outputfilters:
23 useonairguide: 1
24 mplexid: 43
25 serviceid: 28006
26 atscsrcid: NULL
27 tmoffset: 0
28 atsc_major_chan: 0
29 atsc_minor_chan: 0
30 last_record: 0000-00-00 00:00:00
31default_authority:
32 commmethod: -1
331 row in set (0.00 sec)
34
35mysql> SELECT * FROM `dtv_multiplex` WHERE `mplexid` = 43
36 -> \G
37*************************** 1. row ***************************
38 mplexid: 43
39 sourceid: 5
40 transportid: 1079
41 networkid: 1
42 frequency: 394000000
43 inversion: a
44 symbolrate: 6900000
45 fec: none
46 polarity: NULL
47 modulation: qam_256
48 bandwidth: NULL
49 lp_code_rate: NULL
50transmission_mode: NULL
51 guard_interval: NULL
52 visible: 0
53 constellation: NULL
54 hierarchy: NULL
55 hp_code_rate: NULL
56 sistandard: dvb
57 serviceversion: 30
58 updatetimestamp: 2009-04-19 22:17:58
591 row in set (0.00 sec)