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

Douglas Peale Douglas_Peale at comcast.net
Mon Sep 27 02:41:28 UTC 2010


On 09/26/2010 05:52 PM, Raymond Wagner wrote:
>  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.

That would require compiling it myself. Unfortunately, my attempts to compile mythTV have resulted in many errors.
The missmatch only prevents me from using mythweb for one day, it does not affect recordings. I can live without mythweb for one
day.


More information about the mythtv-users mailing list