[mythtv-users] Last night update broke listings for 0.24

Nick Rout nick.rout at gmail.com
Mon Sep 27 05:41:17 UTC 2010


On Mon, Sep 27, 2010 at 11:19 AM, Douglas Peale
<Douglas_Peale at comcast.net>wrote:

> On 09/26/2010 02:41 PM, Michael T. Dean wrote:
> >  On 09/26/2010 05:37 PM, Douglas Peale wrote:
> >> I updated mythTV from http://ppa.launchpad.net/mythbuntu/0.24/ubuntu
> >> this morning, and now the listings page from Mythweb is broken.
> >>
> >> The listings were working yesterday, now I get
> >>
> >> !NoTrans: SQL Error: Table './mythconverg/programrating' is marked as
> >> crashed and last (automatic?) repair failed [#144]!!
> >>
> >> followed by several other pages of error messages (let me know if you
> >> want them).
> >>
> >>
> >> If I run mythfilldatabase, I get a bunch of errors like this one:
> >>
> >> 2010-09-26 14:29:06.452 Error preparing query: DELETE FROM
> >> programrating WHERE starttime>= :FROM AND starttime<  :TO AND chanid
> >> = :CHANID ;
> >> 2010-09-26 14:29:06.452 Driver error was [2/144]:
> >> QMYSQL3: Unable to prepare statement
> >> Database error was:
> >> Table './mythconverg/programrating' is marked as crashed and last
> >> (automatic?) repair failed
> >>
> >
> > optimize_mythdb.pl
> >
> > Mike
>
>
> I had to do a bit of searching to find that since it was not in the path. I
> found it at
> /usr/share/mythtv-backend/contrib/maintenance.
>
>

you should grok the locate command.

nick at media:~$ locate optimize_myth
/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100927/48d16b66/attachment.htm>


More information about the mythtv-users mailing list