[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 21:32:17 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).

is there anything other than optimize_mythdb.pl I can do to fix it?

Before you ask, read the FAQ!
then search the Wiki, and this list,
Mailinglist etiquette -

More information about the mythtv-users mailing list