[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