[mythtv-users] big problem with mythtv...no apparent reason

miller44 at optonline.net miller44 at optonline.net
Mon Feb 16 01:32:52 EST 2004


I recently upgraded to .14 with seemingly no problems, mythtv compiled, set up, and ran mythfilldatabase with no problems.  However when i go to start mythbackend, this happens
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. 

After searching the archives I found one more occurence of this here, 
http://www.gossamer-threads.com/perl/mailarc/gforum.cgi?post=100704;search_string=DB%20Error%20%28getdevices%29%3A;guest=2275562&t=search_engine#100704
Unfortunately there was no answer to the problem.
Can anyone shed any light on this problem?  I am really at a standstill here, i have my mythbox just chilling and would love to get it back up and running.  I had previously had it up and running on .11 with no problems, i do not understand why this all of a sudden popped up.
Thanks in advance



More information about the mythtv-users mailing list