[mythtv] DVB scanning problems

[Preston Crow]

On Thu, 2005-07-21 at 22:17, Preston Crow wrote:
> The scan finds the transports as expected, but then doesn't find any
> channels.  If I rescan on the existing transports it tells me:
> 
> 2005-07-21 22:13:17.190 DVB#0 ERROR - Could not find capture card for transport 77
> 2005-07-21 22:13:17.190 DVB#0 ERROR - Could not find capture card for transport 78
> 2005-07-21 22:13:17.191 DVB#0 ERROR - Could not find capture card for transport 79
> 2005-07-21 22:13:17.191 DVB#0 ERROR - Could not find capture card for transport 80
> 2005-07-21 22:13:17.192 DVB#0 ERROR - Could not find capture card for transport 81
> ...

I found what's causing that.

In the database, capturecard.videodevice is "/dev/dvb/adapter0/dvr0" but
in the code, it is querying for it by '0' in dvbchannel.cpp.

#ifdef PRESTON
        QString thequery =
            QString("SELECT cardid FROM capturecard "
                    "WHERE videodevice = '%1'").arg(dvbdevice(DVB_DEV_DVR, cardnum));
#else
        QString thequery =
            QString("SELECT cardid FROM capturecard "
                    "WHERE videodevice = '%1'").arg(cardnum);
#endif

That gets it past my immediate problem.  It is still not working
correctly, but I need to dig further.

So the question is, is the query broken, or should my database just have
a number in that field?  (And shouldn't the query also check that
cardtype='DVB')