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

[Douglas Peale]

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


Oddly, the listings page from Myth Front End appear to still work (though it shows far too little data to be useful).


The changes from this mornings update are as followsCommit Log for Sun Sep 26 10:20:41 2010

Upgraded the following packages:
libmyth-0.23-0 (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
libmyth-python (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
libmythtv-perl (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mytharchive (0.24.0~trunk26481-0ubuntu0~mythbuntu1) to 0.24.0~trunk26507-0ubuntu0~mythbuntu1
mythgallery (0.24.0~trunk26481-0ubuntu0~mythbuntu1) to 0.24.0~trunk26507-0ubuntu0~mythbuntu1
mythmovies (0.24.0~trunk26481-0ubuntu0~mythbuntu1) to 0.24.0~trunk26507-0ubuntu0~mythbuntu1
mythmusic (0.24.0~trunk26481-0ubuntu0~mythbuntu1) to 0.24.0~trunk26507-0ubuntu0~mythbuntu1
mythplugins-dbg (0.24.0~trunk26481-0ubuntu0~mythbuntu1) to 0.24.0~trunk26507-0ubuntu0~mythbuntu1
mythtv (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-backend (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-backend-master (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-common (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-database (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-dbg (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-frontend (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-theme-arclight (1:0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 1:0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-theme-childish (1:0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 1:0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-theme-graphite (1:0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 1:0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-theme-metallurgy (1:0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 1:0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-theme-mythbuntu (1:0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 1:0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-themes (1:0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 1:0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythtv-transcode-utils (0.24.0~trunk26507-0ubuntu0~mythbuntu1) to 0.24.0~trunk26520-0ubuntu0~mythbuntu1
mythvideo (0.24.0~trunk26481-0ubuntu0~mythbuntu1) to 0.24.0~trunk26507-0ubuntu0~mythbuntu1
mythweather (0.24.0~trunk26481-0ubuntu0~mythbuntu1) to 0.24.0~trunk26507-0ubuntu0~mythbuntu1


This is my first data base screwup, what do I need to do to fix this?