[mythtv] can't start backend - sql query error ?

[Simon Allcorn]

Hi Daniel,

thanks for the response - it turned out to be some duff data in the
channel table:

mysql> SELECT chanid, serviceid, mplexid, atscsrcid, cardinputid FROM
channel, cardinput, capturecard WHERE channel.channum='3' AND      
cardinput.sourceid = channel.sourceid AND       capturecard.cardid =
cardinput.cardid AND       capturecard.cardtype = 'DVB' AND      
cardinput.cardid = '2';
+--------+-----------+---------+-----------+-------------+
| chanid | serviceid | mplexid | atscsrcid | cardinputid |
+--------+-----------+---------+-----------+-------------+
|   1006 |      8261 |       2 |         0 |           2 |
|   1041 |      NULL |    NULL |      NULL |           2 |
+--------+-----------+---------+-----------+-------------+


after removing the 2nd line (delete from channel where serviceid is
NULL;) the backend started with no problem !

Simon


On 3/13/06, Daniel Kristjansson <danielk at cuymedia.net> wrote:
> On Mon, 2006-03-13 at 20:51 +0000, Simon Allcorn wrote:
> >
> > 2006-03-13 20:45:01.679 DVB#0 ERROR - Failed to get channel options
> > for channel 4.
>
> What is the mplexid for this channel? If it isn't set to a valid
> multiplex, then this is the problem.
>
> -- Daniel
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>