[mythtv-users] Problems please help Mythbackend gives a query error
MythTV
mythtv at hribnak.com
Sun Feb 29 20:01:37 EST 2004
Not sure what I did but I can not fix the problem. when I run mythbackend
now I get:
/usr/bin/mythbackend
Starting up as the master server.
2004-02-29 17:58:46 mythbackend version: 0.14.20040123-1 www.mythtv.org
2004-02-29 17:58:46 Enabled verbose msgs : important general
DB Error (findAllProgramsToRecord):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime,
program.endtime, program.title, program.subtitle, program.description,
channel.channum, channel.callsign, channel.name, oldrecorded.starttime IS
NOT NULL AS oldrecduplicate, program.category, record.recpriority,
record.recorddups, recorded.starttime IS NOT NULL as recduplicate,
record.type, record.recordid, recordoverride.type, program.starttime -
INTERVAL record.preroll minute, program.endtime + INTERVAL record.postroll
minute, program.previouslyshown FROM record INNER JOIN channel ON
(channel.chanid = program.chanid) INNER JOIN program ON (program.title =
record.title) LEFT JOIN oldrecorded ON ( oldrecorded.title IS NOT
NULL AND oldrecorded.title <> '' AND program.title = oldrecorded.title
AND oldrecorded.subtitle IS NOT NULL AND oldrecorded.subtitle <> '' AND
program.subtitle = oldrecorded.subtitle AND oldrecorded.description
IS NOT NULL AND oldrecorded.description <> '' AND program.description =
oldrecorded.description ) LEFT JOIN recorded 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 ) LEFT JOIN recordoverride ON ( record.recordid
= recordoverride.recordid AND program.chanid = recordoverride.chanid
AND program.starttime = recordoverride.starttime AND program.endtime =
recordoverride.endtime AND program.title = recordoverride.title AND
program.subtitle = recordoverride.subtitle AND program.description =
recordoverride.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/-1]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.record' doesn't exist
How can I fix this..
Thanks
Oh I am runing mythtv 0.14
More information about the mythtv-users
mailing list