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

Michael T. Dean mtdean at thirdcontact.com
Sun Sep 26 21:41:02 UTC 2010


  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


More information about the mythtv-users mailing list