[mythtv] Compilation problems with dvb enabled (cvs)

[Harley Cole-Puls]

Quoting Ivor Hewitt <ivor at ivor.org>:

> rm /lib/libmyth*
> make install
> ldconfig
> 
> ldd `which mythfrontend`
> ldd `which mythbackend`

Yay... this fixed my problem. Thankyou Ivor. Lesson learned -> always check to
see if libs have been cleaned up from previous installations of programs, even
if I have done a make clean/distclean/uninstall.

However new problem...  when starting mythbackend after setting up my card and
channels i get this error

bash-2.05b# mythbackend -d
bash-2.05b# Starting up as the master server.
DB Error (getdevices):
Query was:
SELECT videodevice,vbidevice,audiodevice,audioratelimit,defaultinput,cardtype, u
se_ts,dvb_type FROM capturecard WHERE cardid = 6;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'use_ts' in 'field list'

Channel::Open(): Can't open: 
No such file or directory
Channel::Open(): Can't open: 
No such file or directory
Couldn't find input: Television on card
2004-01-13 00:36:52 Enabled verbose msgs : important general
DB Error (findAllProgramsToRecord):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime, program.end
time, program.title, program.subtitle, program.description, channel.channum, cha
nnel.callsign, channel.name, oldrecorded.starttime IS NOT NULL AS oldrecduplicat
e, program.category, record.rank, record.recorddups, recorded.starttime IS NOT N
ULL as recduplicate, record.type FROM record  INNER JOIN channel ON (channel.cha
nid = program.chanid)  INNER JOIN program ON (program.title = record.title)  LEF
T JOIN oldrecorded ON   (     oldrecorded.title IS NOT NULL AND oldrecorded.titl
e <> '' AND program.title = oldrecorded.title      AND     oldrecorded.subtitle 
IS NOT NULL AND oldrecorded.subtitle <> '' AND program.subtitle = oldrecorded.su
btitle      AND     oldrecorded.description IS NOT NULL AND oldrecorded.descript
ion <> '' AND program.description = oldrecorded.description  )  LEFT JOIN record
ed ON   (     recorded.title IS NOT NULL AND recorded.title <> '' AND
program.title = recorded.title      AND     recorded.subtitle IS NOT NULL AND
recorded.subtitle <> '' AND program.subtitle = recorded.subtitle      AND    
recorded.description IS NOT NULL AND recorded.description <> '' AND
program.description = recorded.description  ) WHERE ((record.type = 4)  OR 
((record.chanid = program.chanid)   AND   ((record.type = 3)    OR  
((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime))     AND    
((record.type = 2)      OR     ((DAYOFWEEK(record.startdate) =
DAYOFWEEK(program.starttime)       AND       ((record.type = 5)        OR      
((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))         AND        
(TIME_TO_SEC(record.endtime) = TIME_TO_SEC(program.endtime))         AND       
 (TO_DAYS(record.enddate) = TO_DAYS(program.endtime))         )       )      ) 
   )    )   )  ) ));
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'record.rank' in 'field list'

2004-01-13 00:36:54 Found changes in the todo list.



Needless to say help... please... 

well i am off to bed now... got to get up later this morning (is passed 12am
here in Adelaide). 

Help would be appreciated... i get the feeling that i have done something stupid.

Harley