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

[Douglas Peale]

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.