[mythtv-users] dvb channel data into myth. (revisited)

[John Pullan]

On 09/11/05, Frank Simorjay <franks at simorjay.com> wrote:
> John you rock, thanks.
>
>
>
>  Obviously I was over complicating things. So I guess the scan tool has been
> inserting the pid, which has been the culprit.
>
>
> So what connects the channels to the channel listing? Is it the channel
> name?
>

xmltvid, which I can't help you with, I'm afraid, if the full scan
isn't working for you, you'll have to add the ids by hand.

> Also is there a way to pick a tuner to watch, since I have a PVR500 and the
> pchdtv3000. I want to prevent overlapping channels, is this possible?
>
> 004:555000000:QAM_256:7 <- can I change the 004 104 to prevent overlap?
> 005:555000000:QAM_256:8
> 006:555000000:QAM_256:9
>

Err, pass ;p

> Last,
> During the insert I see a lot of the following errors.
>
> 2005-11-09 15:21:43.458 DB Error (searching for transport):
> Query was:
> SELECT mplexid FROM dtv_multiplex WHERE sourceid= 1 AND frequency=561000000
> AND
> inversion="a" AND modulation=qam_256;
> Driver error was [2/1054]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown column 'qam_256' in 'where clause'
>
> 2005-11-09 15:21:43.458 DB Error (searching for transport.):
> Query was:
> SELECT mplexid FROM dtv_multiplex WHERE sourceid= 1 AND frequency=561000000
> AND
> inversion="a" AND modulation=qam_256;
> Driver error was [2/1054]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown column 'qam_256' in 'where clause'
>
>


This looks like a bug could you try this this  patch please.

Index: dvbconfparser.cpp
===================================================================
--- dvbconfparser.cpp   (revision 7827)
+++ dvbconfparser.cpp   (working copy)
@@ -332,7 +332,7 @@
                          .arg(m.fec.toString());
         break;
     case ATSC:
-        queryStr+=QString("modulation=%1;")
+        queryStr+=QString("modulation=\"%1\";")
                          .arg(m.modulation.toString());
         break;
     }

Regards
--
John