[mythtv-users] db error in mythbackend log, don't know what to do about it

[Greg]

On 07/16/2010 05:32 PM, Steven Adeff wrote:
> On Thu, Jul 15, 2010 at 1:25 AM, Michael T. Dean
> <mtdean at thirdcontact.com>  wrote:
>    
>>   On 07/14/2010 11:07 PM, Steven Adeff wrote:
>>      
>>> 2010-07-13 11:58:31.820 Error preparing query: UPDATE channel SET
>>> last_record =
>>> NOW() WHERE chanid = :CHANID
>>> 2010-07-13 11:58:31.836 Driver error was [2/1054]:
>>> QMYSQL3: Unable to prepare statementDatabase error was:
>>> Unknown column 'last_record' in 'field list'
>>>
>>> 2010-07-13 11:58:31.844 DB Error (insert_program -- channel
>>> last_record):Query was:
>>> UPDATE channel SET last_record = NOW() WHERE chanid = :CHANID
>>> Bindings were:
>>> :CHANID=4250
>>> Driver error was [2/1064]:
>>> QMYSQL: Unable to execute queryDatabase error was:
>>> You have an error in your SQL syntax; check the manual that corresponds to
>>> your
>>> MySQL server version for the right syntax to use near ':CHANID' at line 1
>>>
>>>
>>> anyone know what this means and/or how to fix it?
>>>        
>> The above indicates your DB schema is broken or you're running some MythTV
>> component against a wrong-version schema.
>>
>> I'd guess, though, the real issue is that you have one or more crashed MySQL
>> tables.  Time for an optimize_mythdb.pl (since the schema version the above
>> implies is from 4 years ago).
>>      
> is there anything other than optimize_mythdb.pl I can do to fix it?
>
>    
mysqlcheck  -u root  -p   --repair mythconverg

This is what I use to repair my crashed tables...