© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
I get very similar error message, yes, that is how I found this bug too.
....
222yyyy-22MM-22dd 22hh:22mm:
Query was:
DELETE FROM jobqueue WHERE (status in (:FINISHED, :ABORTED, :CANCELLED) AND statustime < :DONEPURGEDATE) OR (status in (:ERRORED) AND statustime < :ERRORSPURGEDATE)
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 ':FINISHED, :ABORTED, :CANCELLED) AND statustime < :DONEPURGEDATE) OR (status in ' at line 1
222yyyy-22MM-22dd 22hh:22mm:
Query was:
SELECT DISTINCT chainid FROM tvchain WHERE endtime > :FOURHOURSAGO ;
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 ':FOURHOURSAGO' at line 1
....
I have a confession to make: my mythbackend is running on gentoo, not ubuntu!! I know know, I should log it with gentoo and/or mythtv, but this is the only reference I found to this on google felt heartened that I found someone else with the same issue.
My frontend and backend are on the same box, but I do have a real IP address set rather than 127.0.0.1 because I also use mythbackend as a upnp server.
I do use EIT with DVB-T, adapter is Hauppauge Nova-T Stick.
I am trying out --nojobqueue to see what happens...
Roy