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

Steven Adeff adeffs.mythtv at gmail.com
Fri Jul 16 00:52:48 UTC 2010


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).
>
> Mike

interesting, I have optimize_mythdb.pl run every night via cron, and
as a check I ran it manually myself and it didn't fix it.


-- 
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