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