@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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
