Saturday, September 20th, 2014, 09:12 UTC | ||
[09:12:52] | MythLogBot (MythLogBot!~bot@mythtv/developer/beirdo) has quit (Client Quit) | |
[09:18:16] | stuartm: | !trout myself |
[09:18:16] | ** MythLogBot slaps myself with a trout on behalf of stuartm... ** | |
[09:25:53] | jpabq (jpabq!~quassel@mythtv/developer/jpabq) has quit (Ping timeout: 240 seconds) | |
[09:26:29] | jpabq (jpabq!~quassel@mythtv/developer/jpabq) has joined #mythtv | |
[09:34:28] | andreaz (andreaz!~andre_000@p5792344E.dip0.t-ipconnect.de) has quit (Read error: Connection reset by peer) | |
[09:41:10] | stuartm: | ok ... seems to be working again |
[09:57:43] | SteveGoodey: | stuartm: Sorry to be a pain. Beirdobot appears to have lost the top left icon? src="/img/mythtv.png |
[09:59:52] | stuartm: | fixing that atm |
[10:03:12] | stuartm: | done |
[10:03:25] | stuartm: | if there are any more problems let me know |
[10:10:54] | stuartm: | lets see if it continues to work now I've logged out ... |
[10:11:11] | stuartm: | yes, good |
[10:12:20] | SteveGoodey: | stuartm: Cheers. |
[10:13:01] | stuartm: | all our downstream changes are now officially in our beirdobot fork |
[10:13:19] | stuartm: | which will make it easier in the future |
[10:25:50] | joki (joki!~joki@p5486178E.dip0.t-ipconnect.de) has quit (Ping timeout: 258 seconds) | |
[10:26:35] | aberrios_ (aberrios_!~aberrios@195.130.201.200) has quit (Ping timeout: 258 seconds) | |
[10:27:11] | aberrios_ (aberrios_!~aberrios@195.130.201.200) has joined #mythtv | |
[10:28:29] | aloril_ (aloril_!~aloril@dsl-tkubrasgw2-54faa3-2.dhcp.inet.fi) has quit (Ping timeout: 258 seconds) | |
[10:31:10] | gigem_ (gigem_!~david@pool-71-170-165-247.dllstx.fios.verizon.net) has joined #mythtv | |
[10:31:11] | gigem_ (gigem_!~david@pool-71-170-165-247.dllstx.fios.verizon.net) has quit (Changing host) | |
[10:31:11] | gigem_ (gigem_!~david@mythtv/developer/gigem) has joined #mythtv | |
[10:31:30] | robink (robink!~quassel@unaffilated/robink) has quit (Ping timeout: 258 seconds) | |
[10:31:33] | gigem (gigem!~david@mythtv/developer/gigem) has quit (Ping timeout: 258 seconds) | |
[10:31:48] | jst_ (jst_!~quassel@198.199.94.175) has joined #mythtv | |
[10:32:07] | robink (robink!~quassel@unaffilated/robink) has joined #mythtv | |
[10:32:22] | jst (jst!~quassel@198.199.94.175) has quit (Ping timeout: 258 seconds) | |
[10:34:33] | joki (joki!~joki@p5486178E.dip0.t-ipconnect.de) has joined #mythtv | |
[10:39:12] | aloril (aloril!~aloril@dsl-tkubrasgw2-54faa3-2.dhcp.inet.fi) has joined #mythtv | |
[10:42:39] | Warped (Warped!~Warped@108-85-161-113.lightspeed.cicril.sbcglobal.net) has quit (Quit: ChatZilla 0.9.90.1 [Firefox 32.0.2/20140917194002]) | |
[10:54:02] | SteveGoodey (SteveGoodey!~steve@host86-132-97-125.range86-132.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
[11:11:42] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
[11:13:57] | jpharvey__ (jpharvey__!~jpharvey@host109-148-236-123.range109-148.btcentralplus.com) has quit (Ping timeout: 246 seconds) | |
[11:27:30] | jpharvey__ (jpharvey__!~jpharvey@host109-148-236-123.range109-148.btcentralplus.com) has joined #mythtv | |
[12:26:28] | jpharvey__ (jpharvey__!~jpharvey@host109-148-236-123.range109-148.btcentralplus.com) has quit (Ping timeout: 272 seconds) | |
[12:39:06] | jpharvey__ (jpharvey__!~jpharvey@host109-148-117-72.range109-148.btcentralplus.com) has joined #mythtv | |
[13:12:15] | bill6502 (bill6502!~bill@205.178.26.43) has joined #mythtv | |
[13:40:17] | dekarl1 is now known as dekarl | |
[13:57:02] | skd5aner (skd5aner!~skd5aner@229.sub-70-198-68.myvzw.com) has quit (Ping timeout: 272 seconds) | |
[13:57:38] | skd5aner (skd5aner!~skd5aner@229.sub-70-198-68.myvzw.com) has joined #mythtv | |
[14:04:54] | stuartm: | gigem_: appears some of the scheduler code is not using bound values – https://forum.mythtv.org/viewtopic.php?f=2&t=363 |
[14:11:30] | stuartm: | hmm, looks like that might be a custom rule actually |
[15:04:48] | nephyrin (nephyrin!~neph@2620:101:80fc:224:7a2b:cbff:fe9e:2e67) has quit (Ping timeout: 260 seconds) | |
[15:09:05] | nephyrin (nephyrin!~neph@2620:101:80fc:224:7a2b:cbff:fe9e:2e67) has joined #mythtv | |
[15:32:19] | gigem_: | stuartm: It should be "LIKE 'Dragons'' Den'" where the ' is doubled instead of escaped with a \. Is that from a custom rule or a search rule? The former runs a dummy query to try catch bad syntax from the user. I'm not sure how the latter works. |
[15:32:23] | gigem_ is now known as gigem | |
[15:33:27] | stuartm: | gigem: looks like a custom rule to me because of the hdtv > 0 immediately follow it, and the fact that all the LIKE queries I looked at in our code use bound parameters |
[15:34:22] | stuartm: | gigem: the dummy query sounds like what he's describing when he says – "the sql statements passed the initial format checks" |
[15:39:40] | gigem: | stuartm: I agree. I was just testing a title search myself to be absolutely sure. Going to test a custom rule now to see if lets me put in a bad rule. |
[15:40:31] | stuartm: | I'll ask for more info, including whether he created this rule through the frontend or through mythweb |
[15:56:24] | gigem: | Find out which database and version he is using. AFAICT, mysql allows both \' and '' to represent a ' in a '-enclosed string. Both appear to work fine for me with mysql-5.5.39. |
[16:04:32] | stichnot (stichnot!~stichnot@mythtv/developer/stichnot) has quit (Ping timeout: 260 seconds) | |
[16:11:59] | stichnot (stichnot!~stichnot@mythtv/developer/stichnot) has joined #mythtv | |
[17:37:29] | bill6502 (bill6502!~bill@205.178.26.43) has left #mythtv () | |
[17:52:41] | natanojl (natanojl!~jonatan@c83-252-231-38.bredband.comhem.se) has joined #mythtv | |
[19:18:53] | stuartm_ (stuartm_!~gbee@mythtv/developer/stuartm) has joined #mythtv | |
[21:08:17] | natanojl (natanojl!~jonatan@c83-252-231-38.bredband.comhem.se) has quit (Ping timeout: 272 seconds) | |
[21:15:52] | skd5aner: | stichnot: well, I don't know if I know Colin or not, but pass my thanks along to him as well... Seriously, this is a totally different ballgame. I have to use HD-PVRs exclusively now, so I finally have a decent UX again. |
[22:15:00] | stuartm_ (stuartm_!~gbee@mythtv/developer/stuartm) has quit (Quit: Bye) |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.