I get very similar error message, yes, that is how I found this bug too. .... 222yyyy-22MM-22dd 22hh:22mm:22ss.22zzz DB Error (JobQueue::CleanupOldJobsInQueue: Error deleting old finished jobs.): 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:22ss.22zzz DB Error (HouseKeeper Cleaning TVChain Table): 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 -- 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@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
