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

Michael T. Dean mtdean at thirdcontact.com
Thu Jul 15 05:25:05 UTC 2010

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


More information about the mythtv-users mailing list