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

[Simon Allcorn]

Hi,

I've got the latest (ish - I did a svn update last night) version
checkout / compile on my myth box (2 dvb cards, in the uk). All was
working well (so often the way :)  ) however after I've upgraded I get
an sql error:

sal at freevo ~ $ mythbackend
2006-03-13 20:45:01.576 Using runtime prefix = /home/sal
2006-03-13 20:45:01.606 New DB connection, total: 1
2006-03-13 20:45:01.610 Connected to database 'mythconverg' at host: localhost
2006-03-13 20:45:01.616 Current Schema Version: 1130
Starting up as the master server.
2006-03-13 20:45:01.634 New DB connection, total: 2
2006-03-13 20:45:01.635 Connected to database 'mythconverg' at host: localhost
2006-03-13 20:45:01.637 mythbackend: MythBackend started as master server
2006-03-13 20:45:01.671 DVB#0 Using DVB card 0, with frontend 'LSI
L64781 DVB-T'.
2006-03-13 20:45:01.675 New DB connection, total: 3
2006-03-13 20:45:01.676 Connected to database 'mythconverg' at host: localhost

2006-03-13 20:45:01.678 DVB#0 ERROR - Could not find dvb tuning
parameters for mplex 0
2006-03-13 20:45:01.679 DVB#0 ERROR - Failed to get channel options
for channel 4.

anyway if I start it again with  --verbose database  (my whitespaces)

2006-03-13 20:47:18.110 Connected to database 'mythconverg' at host: localhost
2006-03-13 20:47:18.112 MSqlQuery:

SELECT

frequency,         inversion,      symbolrate,
fec,               polarity,       dvb_diseqc_type,
diseqc_port,       diseqc_pos,     lnb_lof_switch,
lnb_lof_hi,        lnb_lof_lo,     sistandard,
hp_code_rate,      lp_code_rate,   constellation,
transmission_mode, guard_interval, hierarchy,
modulation,        bandwidth,      cardinputid

FROM

dtv_multiplex, cardinput, capturecard

WHERE

dtv_multiplex.sourceid = cardinput.sourceid
AND       dtv_multiplex.mplexid  = 0
AND       cardinput.cardid       = capturecard.cardid
AND       cardinput.cardid       = 1

2006-03-13 20:47:18.112 DVB#0 ERROR - Could not find dvb tuning
parameters for mplex 0


if I run this against my db I get no results - however if I change
dtv_multiplex.mplexid = 1 (I've got data for 1,2,3,4,5,6) then I get a
row returned !

Does anyone have a clue whats happening here ?


Simon