[Bug 330272] Re: mythbackend silently fails with QSqlQuery::exec: empty query

[Roy Thompson]

@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

** Attachment added: "mythbackend log"
   http://launchpadlibrarian.net/31005328/mythbackend.log-20090830.gz

-- 
mythbackend silently fails with QSqlQuery::exec: empty query
https://bugs.launchpad.net/bugs/330272
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs at lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs