[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