<br><br><div class="gmail_quote">On Mon, Sep 27, 2010 at 11:19 AM, Douglas Peale <span dir="ltr"><<a href="mailto:Douglas_Peale@comcast.net">Douglas_Peale@comcast.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im">On 09/26/2010 02:41 PM, Michael T. Dean wrote:<br>
> On 09/26/2010 05:37 PM, Douglas Peale wrote:<br>
>> I updated mythTV from <a href="http://ppa.launchpad.net/mythbuntu/0.24/ubuntu" target="_blank">http://ppa.launchpad.net/mythbuntu/0.24/ubuntu</a><br>
>> this morning, and now the listings page from Mythweb is broken.<br>
>><br>
>> The listings were working yesterday, now I get<br>
>><br>
>> !NoTrans: SQL Error: Table './mythconverg/programrating' is marked as<br>
>> crashed and last (automatic?) repair failed [#144]!!<br>
>><br>
>> followed by several other pages of error messages (let me know if you<br>
>> want them).<br>
>><br>
>><br>
>> If I run mythfilldatabase, I get a bunch of errors like this one:<br>
>><br>
>> 2010-09-26 14:29:06.452 Error preparing query: DELETE FROM<br>
>> programrating WHERE starttime>= :FROM AND starttime< :TO AND chanid<br>
>> = :CHANID ;<br>
>> 2010-09-26 14:29:06.452 Driver error was [2/144]:<br>
>> QMYSQL3: Unable to prepare statement<br>
>> Database error was:<br>
>> Table './mythconverg/programrating' is marked as crashed and last<br>
>> (automatic?) repair failed<br>
>><br>
><br>
> <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a><br>
><br>
> Mike<br>
<br>
<br>
</div>I had to do a bit of searching to find that since it was not in the path. I found it at<br>
/usr/share/mythtv-backend/contrib/maintenance.<br>
<br></blockquote><div><br><br>you should grok the locate command. <br><br>nick@media:~$ locate optimize_myth<br>/usr/share/doc/mythtv-backend/contrib/maintenance/<a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a><br>
<br></div></div>