<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Bit of a late addition to my own query here but thought it might be useful to reference this howto which solved my problem (as the article points out - all database repair efforts were ineffective until I did the following:</div><div><br></div><ol class="MailOutline"><li>Stop the database.<span class="Apple-style-span" style="font-family: Verdana; line-height: 18px; "></span></li><li><span class="Apple-style-span" style="font-family: Verdana; line-height: 18px; ">Run: $> myisamchk -nr /var/lib/mysql/mythconverg/recordedseek.MYI </span></li><li><font class="Apple-style-span" face="Verdana"><span class="Apple-style-span" style="line-height: 18px;">Start database and log-in</span></font></li><li><font class="Apple-style-span" face="Verdana"><span class="Apple-style-span" style="line-height: 18px;">Run SQL command: REPAIR TABLE recordedseek;</span></font></li><li><font class="Apple-style-span" face="Verdana"><span class="Apple-style-span" style="line-height: 18px;">Exit database</span></font></li><li><font class="Apple-style-span" face="Verdana"><span class="Apple-style-span" style="line-height: 18px;">Run: $> mythcommflag --rebuild </span></font></li></ol><div><font class="Apple-style-span" face="Verdana"><span class="Apple-style-span" style="line-height: 18px;"><br></span></font></div><div><font class="Apple-style-span" face="Verdana"><span class="Apple-style-span" style="line-height: 18px;">Full post: <span class="Apple-style-span" style="font-family: Helvetica; line-height: normal; "><a href="http://www.mythtvtalk.com/forum/archive/o_t/t_5884">http://www.mythtvtalk.com/forum/archive/o_t/t_5884</a></span></span></font></div><div><br></div><div><br></div><div><br></div><br><div><div>On 2/09/2008, at 9:54 PM, Graeme Woollett wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Duncan Kennington wrote:<br><blockquote type="cite">Try running the commercial flagger over one of the recordings again -<br></blockquote><blockquote type="cite">that should recalculate the recordedseek table. If not check the<br></blockquote><blockquote type="cite">contents of recordedseek (or is it recordedmarkup?) in the DB for the<br></blockquote><blockquote type="cite">recording in question.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote>Running the repair table tool in PHPMyAdmin also fixes this problem :-)<br><br>_______________________________________________<br>mythtvnz mailing list<br><a href="mailto:mythtvnz@lists.linuxnut.co.nz">mythtvnz@lists.linuxnut.co.nz</a><br><a href="http://lists.ourshack.com/mailman/listinfo/mythtvnz">http://lists.ourshack.com/mailman/listinfo/mythtvnz</a><br>Archives <a href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/</a><br></div></blockquote></div><br></body></html>