| GTBlackwell |
09-05-2006 06:08 PM |
MythTV: database errors
I noticed a few days ago that the Program Finder in MythTV has stopped showing all the shows listed in the guide.
For example:
It lists no programs showing under A, H, K, O, and P.
It's not showing listings for 24, House, The Office, Grey's Anatomy, 24, The Daily Show, The Colbert Report, and many others.
It was working fine a week ago when I used it to schedule the House premier that should still be listed. I've run Mythfilldatabase to make sure I had all the possible listings, but it's giving me database errors:
Code:
2006-09-07 06:54:09.075 Updating programs.
2006-09-07 06:54:09.078 DB Error (Inserting into program table):
Query was:
INSERT IGNORE INTO program (chanid, starttime, endtime, title, subtitle, description, showtype, category, category_type, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, programid) SELECT chanid, starttime, endtime, title, subtitle, description, showtype, dd_genre.class, category_type, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, dd_v_program.programid FROM dd_v_program LEFT JOIN dd_genre ON (dd_v_program.programid = dd_genre.programid AND dd_genre.relevance = '0');
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/program' is marked as crashed and should be repaired
2006-09-07 06:54:09.082 DB Error (Inserting into programrating table):
Query was:
INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT chanid, starttime, 'MPAA', mpaarating FROM dd_v_program WHERE mpaarating != '';
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/programrating' is marked as crashed and should be repaired
2006-09-07 06:54:09.085 DB Error (Inserting into programrating table):
Query was:
INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT chanid, starttime, 'VCHIP', tvrating FROM dd_v_program WHERE tvrating != '';
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/programrating' is marked as crashed and should be repaired
2006-09-07 06:54:09.708 DB Error (Inserting into credits table):
Query was:
INSERT IGNORE INTO credits (chanid, starttime, person, role) SELECT chanid, starttime, person, role FROM dd_productioncrew, dd_v_program, people WHERE ((dd_productioncrew.programid = dd_v_program.programid) AND (dd_productioncrew.fullname = people.name));
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/credits' is marked as crashed and should be repaired
2006-09-07 06:54:09.712 DB Error (Inserting into programgenres table):
Query was:
INSERT IGNORE INTO programgenres (chanid, starttime, relevance, genre) SELECT chanid, starttime, relevance, class FROM dd_v_program, dd_genre WHERE (dd_v_program.programid = dd_genre.programid);
Driver error was [2/145]:
QMYSQL3: Unable to execute query
Database error was:
Table './mythconverg/programgenres' is marked as crashed and should be repaired
2006-09-07 06:54:09.713 Program table update complete.
2006-09-07 06:54:09.906 New DB connection, total: 5
2006-09-07 06:54:09.908 Connected to database 'mythconverg' at host: localhost
2006-09-07 06:54:09.928 Data fetching complete.
2006-09-07 06:54:09.928 Adjusting program database end times.
2006-09-07 06:54:09.933 fix_end_times query failed: SELECT chanid, starttime, endtime FROM program WHERE (DATE_FORMAT(endtime,'%H%i') = '0000') ORDER BY chanid, starttime;
2006-09-07 06:54:09.933 fix_end_times failed!
2006-09-07 06:54:09.933 Marking generic episodes.
2006-09-07 06:54:09.936 Found -1
2006-09-07 06:54:09.936 Marking repeats.
2006-09-07 06:54:09.942 Found -1
2006-09-07 06:54:09.943 Unmarking new episode rebroadcast repeats.
2006-09-07 06:54:09.946 Found -1
To my knowledge, I haven't changed any of the Myth settings. Anyone encountered anything like this before? I really don't want to have to go through the trouble of re-installing mythTV again.
On a related matter, (and keeping in mind that I'm a mySQL noob) how can I stop Myth from trying to delete recordings whose video files were already removed outside of MythTV? |
