[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 03:10:44 UTC 2010


On Thu, Jul 15, 2010 at 8:52 PM, Steven Adeff <adeffs.mythtv at gmail.com> 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).
>>
>> 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.
>

some more errors I'm seeing, this time when a music scan needs to
delete entries:

2010-07-15 23:06:47.131 DB Error (music delete artwork):
Query was:
DELETE FROM music_albumart WHERE filename= ? AND directory_id= ?;
Bindings were:
:DIRID=0, :FILE=AlbumArtSmall.jpg
No error type from QSqlError?  Strange...
2010-07-15 23:06:47.135 DB Error (music delete artwork):
Query was:
DELETE FROM music_albumart WHERE filename= ? AND directory_id= ?;
Bindings were:
:DIRID=0, :FILE=Folder.jpg
No error type from QSqlError?  Strange...
2010-07-15 23:06:47.139 DB Error (music delete artwork):
Query was:
DELETE FROM music_albumart WHERE filename= ? AND directory_id= ?;
Bindings were:
:DIRID=0, :FILE=AlbumArtSmall.jpg
No error type from QSqlError?  Strange...
2010-07-15 23:06:47.143 DB Error (music delete artwork):
Query was:
DELETE FROM music_albumart WHERE filename= ? AND directory_id= ?;
Bindings were:
:DIRID=0, :FILE=Folder.jpg
No error type from QSqlError?  Strange...
2010-07-15 23:06:53.126 DB Error (music delete artwork):
Query was:
DELETE FROM music_albumart WHERE filename= ? AND directory_id= ?;
Bindings were:
:DIRID=0, :FILE=cover.jpg
No error type from QSqlError?  Strange...
2010-07-15 23:09:17.170 Deleting UPnP client...


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