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

Raymond Wagner raymond at wagnerrp.com
Mon Sep 27 00:52:37 UTC 2010


  On 9/26/2010 20:12, Douglas Peale wrote:
> On 09/26/2010 05:02 PM, Raymond Wagner wrote:
>>   On 9/26/2010 18:19, Douglas Peale 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
>>> 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.
>>>
>> According to the commit, MythTV, MythWeb, and both sets of bindings were
>> all updated at exactly the same revision.  There is no need to 'catch
>> up', as they were never out of sync.
>>
>> http://svn.mythtv.org/trac/changeset/26518
> But as sometimes happens, they did not both get into http://ppa.launchpad.net/mythbuntu/0.24/ubuntu for this mornings update. It
> is likely that it will be fixed by tomorow mornings update, hence I wait.
>

You could simply apply the update yourself.  It's all of two whole lines 
you have to change.


More information about the mythtv-users mailing list