On Sunday 26 June 2005 08:58 pm, Paul Leppert wrote: > On 6/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > > Paul Leppert wrote: > > > On 6/25/05, *Michael T. Dean* <[EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > <snip> > > You can do the same with > > mysqlcheck (it's really not important to have mysqlrepair, so don't > > worry about it). > > > > mysqlcheck -r -umythtv -pmythtv mythconverg > > Okay, so I ran the above and get the following output (everything says > "OK"): > [EMAIL PROTECTED] ~]$ mysqlcheck -r -umythtv -pmythtv mythconverg > mythconverg.callsignnetworkmap OK > mythconverg.capturecard OK > mythconverg.cardinput OK > mythconverg.channel OK > mythconverg.codecparams OK > mythconverg.conflictresolutionany OK > mythconverg.conflictresolutionoverride OK > mythconverg.conflictresolutionsingle OK > mythconverg.credits OK > mythconverg.dtv_multiplex OK > mythconverg.dtv_privatetypes OK > mythconverg.dvb_channel OK > mythconverg.dvb_pids OK > mythconverg.dvb_sat OK > mythconverg.dvb_signal_quality OK > mythconverg.dvdinput OK > mythconverg.dvdtranscode OK > mythconverg.favorites OK > mythconverg.filemarkup OK > mythconverg.gallerymetadata OK > mythconverg.gamemetadata OK > mythconverg.housekeeping OK > mythconverg.jobqueue OK > mythconverg.jumppoints OK > mythconverg.keybindings OK > mythconverg.keyword OK > mythconverg.mamemetadata OK > mythconverg.mamesettings OK > mythconverg.musicmetadata OK > mythconverg.musicplaylist OK > mythconverg.mythlog OK > mythconverg.neskeyword OK > mythconverg.nestitle OK > mythconverg.networkiconmap OK > mythconverg.oldfind OK > mythconverg.oldprogram OK > mythconverg.oldrecorded OK > mythconverg.people OK > mythconverg.phonecallhistory OK > mythconverg.phonedirectory OK > mythconverg.pidcache OK > mythconverg.profilegroups OK > mythconverg.program OK > mythconverg.programgenres OK > mythconverg.programrating OK > mythconverg.recgrouppassword OK > mythconverg.record OK > mythconverg.recorded OK > mythconverg.recordedcredits OK > mythconverg.recordedprogram OK > mythconverg.recordedrating OK > mythconverg.recordingprofiles OK > mythconverg.recordmatch OK > mythconverg.recordoverride OK > mythconverg.schemalock OK > mythconverg.settings OK > mythconverg.smartplaylist OK > mythconverg.smartplaylistcategory OK > mythconverg.smartplaylistitem OK > mythconverg.snessettings OK > mythconverg.videobookmarks OK > mythconverg.videocategory OK > mythconverg.videogenre OK > mythconverg.videometadata OK > mythconverg.videometadatacountry OK > mythconverg.videometadatagenre OK > mythconverg.videosource OK > mythconverg.videotypes OK > mythconverg.websites OK > [EMAIL PROTECTED] ~]$ > Doesn't seem like it thinks anything has a problem. Any ideas on what to > check next? > Thanks for your help, > phlepper
Strange...looks like your recordedmarkup table got hosed somehow. I dumped the table structure from my database so that you can re-create it in yours. Just take the attached file and run this command: mysql -u mythtv -p mythconverg < recordedmarkup.sql You can change "mythtv" to whatever the username is that you use for the database. After doing this, you should be good to go. Just go into your recordings, and have commercial flagging done to one of them. See if it works. If so, then I guess you could add all of your shows to a playlist and have flagging run on all of them to get them all back into shape again. I did this once before I realized that all I had to do was repair the table....and boy did it take a while for a couple hundred recordings :-) Hope this does it for you. ~Lou
-- MySQL dump 9.11 -- -- Host: localhost Database: mythconverg -- ------------------------------------------------------ -- Server version 4.0.24 -- -- Table structure for table `recordedmarkup` -- CREATE TABLE recordedmarkup ( chanid int(10) unsigned NOT NULL default '0', starttime datetime NOT NULL default '0000-00-00 00:00:00', mark bigint(20) NOT NULL default '0', offset varchar(32) default NULL, type int(11) NOT NULL default '0', PRIMARY KEY (chanid,starttime,mark,type) ) TYPE=MyISAM;
pgpI6gPhQ2f91.pgp
Description: PGP signature
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users