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

Douglas Peale Douglas_Peale at comcast.net
Sun Sep 26 22:19:09 UTC 2010


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.

Running it fixed the mythfilldatabase issues.

Thanks.

Mythweb now reports several hundred copies of this error:

User Notice at /usr/share/mythtv/mythweb/classes/MythBackend.php, line 101:
!!NoTrans: Incompatible protocol version (mythweb=62, backend=63)!!

Looks like I have to wait for mythweb to catch up with the backends data base version.


More information about the mythtv-users mailing list