My MythTV installation hasn't been working for a couple of weeks and I hadn't gotten around to fixing it until today; shows you how much TV matters to me when I'm busy. It was a really easy error to fix - simply a crashed table which was quick to diagnose and fix even though I hadn't ever encountered anything of the sort before. For Google-searchers, the error from mythbackend was as follows:
<snip>
2006-11-28 17:38:35.805 DB Error (UpdateMatches):
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
</snip>
To fix it, I simply had to login to the database, 'use mythconverg;', and issue the command 'repair table program;'. As noted below, make sure you see those semicolons. Simple.
Thanks. Fixed the same problem for me. For anyone else that finds this via google: Type "mysql -p" on the terminal. Type "use mythconverg" at the new mysql prompt. Type "repair table program;" (notice the semicolon). Wait until it is done, then type "quit". Voila.
I also encountered this problem and thank you very much for being precisely the ONLY hit on Google for this - I solved the problem in 2 secs flat thanks to your article.
Thanks
ditto above post.
Thanks again.. :D
Much appreciated. Just ran into this problem myself when I rebooted my mythtv backend server.
Thanks!
Andrew.
Worked great. You are now not the only Google hit for this...although the other hit looks suspiciously similar. He did not even bother to change the tense of "issue". ;-)
yeah, the "repair table" thing works, but this almost happens to my DB every day - and it's not much fun. Havn't found a solution for it yet. only thing i can think of is a cron-job that repairs the crashed tables... But don't like that solution. Something is probably causing MySQL to crash... but what?