Ubuntu
mythtv package

  1. Bug #330272
  2. Comment #18

Comment 18 for bug 330272

Revision history for this message
Roy Thompson (roy-haematic) wrote :

@Kelvinelk

I use EIT only, no mythfilldatabase.

I have a log from it falling over last night, with bind values displayed, here is the first error message:

222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz DB Error (Looking up chanID):
Query was:
SELECT chanid, useonairguide FROM channel, dtv_multiplex WHERE serviceid = :SERVICEID AND networkid = :NETWORKID AND transportid = :TRANSPORTID AND channel.mplexid = dtv_multiplex.mplexid AND channel.sourceid = :SOURCEID
Bindings were:
:NETWORKID=9018, :SERVICEID=23680, :SOURCEID=2, :TRANSPORTID=20480
Driver error was [2/1064]:
QMYSQL3: Unable to execute query
Database 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 ':SERVICEID AND networkid = :NETWORKID AND transportid ' at line 1

After this it looks like every SQL statement fails and the backend is unresponsive from the frontend or mythweb.

Full log attached. Warning:it is 6 meg when uncompressed.

I can't see anything wrong with this query and it runs fine if I run it in mysql, although it does not return any rows.

Roy