Corrupted record in database

[dhighley@…]

mythbackend version: fixes/0.25 [0.25-6.fc16

MythBackend: Starting up as the master server.

2012-06-13 19:12:30.690212 E [1675/1675] CoreContext mythdbcon.cpp:823 (prepare) - Error preparing query: SELECT DISTINCT LEFT(programid, LOCATE('/', programid)) FROM oldrecorded WHERE programid <> ''
2012-06-13 19:12:30.690241 E [1675/1675] CoreContext mythdbcon.cpp:825 (prepare) - Driver error was [2/145]:
QMYSQL3: Unable to prepare statement
Database error was:
Table './mythconverg/oldrecorded' is marked as crashed and should be repaired
2012-06-13 19:12:30.690272 E [1675/1675] CoreContext mythdb.cpp:192 (DBError) - DB Error (CheckProgramIDAuthorities):
Query was:
SELECT DISTINCT LEFT(programid, LOCATE('/', programid)) FROM oldrecorded WHERE programid <> ''
No error type from QSqlError?  Strange...
2012-06-13 19:12:30.690284 I [1675/1675] CoreContext programinfo.cpp:2052 (CheckProgramIDAuthorities) - Found 1 distinct programid authorities
2012-06-13 19:12:30.690528 I [1675/2430] Scheduler mythdbcon.cpp:422 (getStaticCon) - New static DB connectionSchedCon
2012-06-13 19:12:30.695036 E [1675/2430] Scheduler mythdbcon.cpp:823 (prepare) - Error preparing query: UPDATE oldrecorded SET recstatus = :RSABORTED   WHERE recstatus = :RSRECORDING OR recstatus = :RSTUNING
2012-06-13 19:12:30.695049 E [1675/2430] Scheduler mythdbcon.cpp:825 (prepare) - Driver error was [2/145]:
QMYSQL3: Unable to prepare statement

[dhighley@…]

PDF showing partial mysql.php trace back

[dhighley@…]

Note: was able to fix the database by doing the following: mysqlcheck -r -umythtv -p<password> mythconverg

Documented here: http://www.mythtv.org/docs/mythtv-HOWTO-22.html