LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 09-05-2006, 06:08 PM   #1
GTBlackwell
Member
 
Registered: Aug 2003
Location: MO, USA
Distribution: Mandrake 9.1/9.2(Laptop)
Posts: 117

Rep: Reputation: 15
Question 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?

Last edited by GTBlackwell; 09-07-2006 at 11:04 PM. Reason: discovered new errors
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
vsftpd on Fedora 4 - empty/incomplete directory listings REdward Linux - Networking 0 08-19-2005 04:56 PM
wireless broadcast finder linuxhippy Linux - Wireless Networking 1 07-31-2005 06:59 AM
Mac like finder for linux bubagump17 Linux - Software 3 04-26-2005 04:50 AM
not used package finder darkleaf Linux - Software 4 10-11-2004 02:40 AM
X Window Finder (xwf)? thew00t Linux - Software 1 05-04-2004 03:35 PM


All times are GMT -5. The time now is 07:56 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration