Irrelevant is my relevant …

My mythtv frontend had stopped functioning correctly, it had stopped showing program guide data. Checking the log file told me:

Query was:
DELETE FROM program WHERE manualid = -1 OR  (manualid <> 0 AND -1 = -1)
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/program' is marked as crashed and should be repaired

To fix it, I logged into the database, ‘use mythconverg;’, and issue the command ‘repair table program;’

Very simple really:)

This entry was posted on Tuesday, May 8th, 2007 at 11:13 pm and is filed under Technical. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.