[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