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

Steven Adeff adeffs.mythtv at gmail.com
Sat Jul 17 15:27:18 UTC 2010


On Fri, Jul 16, 2010 at 7:01 PM, Greg <greg12866 at nycap.rr.com> wrote:
> 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...

yea, I don't think it's a crashed table as that and the optimize
script both run without any errors.



-- 
Steve
http://www.mythtv.org/wiki/User:Steveadeff
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette


More information about the mythtv-users mailing list