| Wednesday, November 2nd, 2011, 00:11 UTC | ||
| [00:11:13] | jpabq_ (jpabq_!~jpabq@mythtv/developer/jpabq) has quit (Quit: jpabq_) | |
| [00:45:56] | pheld (pheld!~heldal@cl-5.osl-01.no.sixxs.net) has quit (Quit: Leaving.) | |
| [01:03:44] | Malard (Malard!~Malard@xbmc/staff/malard) has quit (Ping timeout: 258 seconds) | |
| [01:04:48] | davide (davide!~david@host70.16.intrusion.com) has quit (Remote host closed the connection) | |
| [01:05:15] | davide (davide!~david@host70.16.intrusion.com) has joined #mythtv | |
| [01:09:20] | reynaldo (reynaldo!~rverdejo@pc-147-56-101-190.cm.vtr.net) has quit (Ping timeout: 252 seconds) | |
| [01:40:56] | iamlindoro: | !seen dblain |
| [01:40:56] | MythLogBot: | dblain was last seen 9 hours 16 minutes 24 seconds ago |
| [01:55:15] | ** stuarta yawns ** | |
| [01:55:37] | iamlindoro: | you should be yawning, isn't it like crazy-thirty in the UK? |
| [01:55:50] | stuarta: | 2am yes |
| [01:56:28] | stuarta: | overnight maintenance window :) |
| [01:56:33] | iamlindoro: | yuck |
| [01:56:43] | stuarta: | tis the breaks in operations |
| [02:08:57] | biffhero (biffhero!~Adium@c-67-161-68-178.hsd1.ca.comcast.net) has joined #mythtv | |
| [02:09:39] | biffhero: | ah, yes, I meant for -users. |
| [02:09:53] | biffhero (biffhero!~Adium@c-67-161-68-178.hsd1.ca.comcast.net) has left #mythtv () | |
| [02:10:13] | ** stuarta detects a clueful users ** | |
| [02:10:15] | stuarta: | -s |
| [02:21:27] | smoothifier (smoothifier!smoothifie@gateway/shell/anapnea.net/x-mchtqaycpuvpgeve) has joined #mythtv | |
| [02:21:35] | smoothifier (smoothifier!smoothifie@gateway/shell/anapnea.net/x-mchtqaycpuvpgeve) has left #mythtv () | |
| [02:22:34] | smoothifier (smoothifier!smoothifie@gateway/shell/anapnea.net/x-mchtqaycpuvpgeve) has joined #mythtv | |
| [02:22:40] | smoothifier (smoothifier!smoothifie@gateway/shell/anapnea.net/x-mchtqaycpuvpgeve) has left #mythtv () | |
| [03:10:29] | zombor (zombor!~zombor_@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [03:35:50] | kc (kc!~Casper@unaffiliated/kc) has joined #mythtv | |
| [04:44:47] | saintdev (saintdev!~saint@unaffiliated/saintdev) has quit (Quit: It's the end of the world as I know it.) | |
| [05:09:23] | Goga777 (Goga777!~Goga777@shpd-92-101-147-245.vologda.ru) has joined #mythtv | |
| [05:15:50] | Unhelpful (Unhelpful!~quassel@rockbox/developer/Unhelpful) has quit (Quit: http://quassel-irc.org - Chat comfortably. Anywhere.) | |
| [05:16:14] | Unhelpful (Unhelpful!~quassel@rockbox/developer/Unhelpful) has joined #mythtv | |
| [05:19:44] | tomimo (tomimo!~kurre@xdsl-83-150-88-111.nebulazone.fi) has quit (Ping timeout: 260 seconds) | |
| [05:20:03] | tomimo (tomimo!~kurre@xdsl-83-150-88-111.nebulazone.fi) has joined #mythtv | |
| [05:39:45] | Goga777 (Goga777!~Goga777@shpd-92-101-147-245.vologda.ru) has quit (Remote host closed the connection) | |
| [06:02:33] | saintdev (saintdev!~saint@unaffiliated/saintdev) has joined #mythtv | |
| [06:07:09] | jmartens (jmartens!~jmartens@s5597ca60.adsl.wanadoo.nl) has joined #mythtv | |
| [06:36:55] | jmartens (jmartens!~jmartens@s5597ca60.adsl.wanadoo.nl) has quit (Quit: Leaving.) | |
| [06:51:35] | jmartens (jmartens!~jmartens@109.232.42.33) has joined #mythtv | |
| [06:55:06] | rsiebert_ (rsiebert_!~quassel@e179132095.adsl.alicedsl.de) has joined #mythtv | |
| [07:08:14] | kc (kc!~Casper@unaffiliated/kc) has quit (Ping timeout: 256 seconds) | |
| [07:41:56] | map7 (map7!~map7@ppp118-209-74-113.lns20.mel4.internode.on.net) has joined #mythtv | |
| [07:42:04] | kormoc (kormoc!~kormoc@mythtv/developer/kormoc) has left #mythtv () | |
| [07:56:05] | pheld (pheld!~heldal@cl-5.osl-01.no.sixxs.net) has joined #mythtv | |
| [08:07:24] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Quit: Ex-Chat) | |
| [08:12:55] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
| [08:28:11] | rsiebert___ (rsiebert___!~quassel@e179132095.adsl.alicedsl.de) has joined #mythtv | |
| [08:36:25] | Malard (Malard!~Malard@80.229.214.81) has joined #mythtv | |
| [08:49:40] | stuartm: | wagnerrp: just the bit in the middle |
| [10:04:35] | Malard (Malard!~Malard@80.229.214.81) has quit (Changing host) | |
| [10:04:35] | Malard (Malard!~Malard@xbmc/staff/malard) has joined #mythtv | |
| [10:05:02] | mike|2 (mike|2!~mike@c-76-115-119-121.hsd1.or.comcast.net) has quit (Remote host closed the connection) | |
| [10:05:47] | mike (mike!~mike@c-76-115-119-121.hsd1.or.comcast.net) has joined #mythtv | |
| [10:06:13] | mike is now known as Guest11386 | |
| [10:10:57] | reynaldo (reynaldo!~rverdejo@pc-147-56-101-190.cm.vtr.net) has joined #mythtv | |
| [10:16:21] | kc (kc!~Casper@unaffiliated/kc) has joined #mythtv | |
| [10:23:17] | davide_ (davide_!~david@host70.16.intrusion.com) has joined #mythtv | |
| [10:26:01] | mzanetti_ (mzanetti_!~mzanetti@server1.muehlhaeuser.de) has joined #mythtv | |
| [10:27:36] | ikonia_ (ikonia_!~irc@bender.dnsdata.co.uk) has joined #mythtv | |
| [10:28:14] | rsiebert___ (rsiebert___!~quassel@e179132095.adsl.alicedsl.de) has quit (Remote host closed the connection) | |
| [10:28:21] | ikonia_ (ikonia_!~irc@bender.dnsdata.co.uk) has quit (Client Quit) | |
| [10:28:22] | GreyFoxx (GreyFoxx!~greg@2607:ae00:fff9::1) has quit (*.net *.split) | |
| [10:28:22] | aloril (aloril!~aloril@dsl-tkubrasgw3-fe7ef900-153.dhcp.inet.fi) has quit (*.net *.split) | |
| [10:28:24] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.58) has quit (*.net *.split) | |
| [10:28:24] | Cougar (Cougar!~cougar@kkk.version6.net) has quit (*.net *.split) | |
| [10:28:24] | sphery (sphery!~mdean@mythtv/developer/sphery) has quit (*.net *.split) | |
| [10:28:24] | foobum (foobum!~mythtv@78-105-15-213.zone3.bethere.co.uk) has quit (*.net *.split) | |
| [10:28:24] | joe__ (joe__!~jmk@64.73.32.135) has quit (*.net *.split) | |
| [10:28:24] | xris (xris!~xris@mythtv/developer/xris) has quit (*.net *.split) | |
| [10:28:24] | purserj (purserj!~purserj@113.212.99.150) has quit (*.net *.split) | |
| [10:28:24] | mzanetti (mzanetti!~mzanetti@server1.muehlhaeuser.de) has quit (*.net *.split) | |
| [10:28:26] | danielk22 (danielk22!~danielk@96.57.9.142) has quit (*.net *.split) | |
| [10:28:27] | ghoti (ghoti!~paul@scratch.it.ca) has quit (*.net *.split) | |
| [10:28:27] | iamlindoro (iamlindoro!~iamlindor@mythtv/developer/iamlindoro) has quit (*.net *.split) | |
| [10:28:27] | wagnerrp (wagnerrp!~wagnerrp_@mythtv/developer/wagnerrp) has quit (*.net *.split) | |
| [10:28:27] | anykey_ (anykey_!~guedel@46-126-245-147.dynamic.hispeed.ch) has quit (*.net *.split) | |
| [10:28:27] | Seeker` (Seeker`!~cjo20@gateway/shell/ubottu/x-ngaruhwwgdjmhxau) has quit (*.net *.split) | |
| [10:28:27] | Beirdo (Beirdo!~gjhurlbu@mythtv/developer/beirdo) has quit (*.net *.split) | |
| [10:28:27] | map7 (map7!~map7@ppp118-209-74-113.lns20.mel4.internode.on.net) has quit (*.net *.split) | |
| [10:28:27] | simonckenyon (simonckenyon!~simoncken@195.7.61.12) has quit (*.net *.split) | |
| [10:28:28] | Chutt (Chutt!~ijr@cpe-76-190-198-203.neo.res.rr.com) has quit (*.net *.split) | |
| [10:28:28] | rsiebert_ (rsiebert_!~quassel@e179132095.adsl.alicedsl.de) has quit (*.net *.split) | |
| [10:28:28] | brfransen (brfransen!~brfransen@64.179.142.146) has quit (*.net *.split) | |
| [10:28:28] | J-e-f-f-A (J-e-f-f-A!~J-e-f-f-A@unaffiliated/j-e-f-f-a) has quit (*.net *.split) | |
| [10:28:28] | gregL_ (gregL_!~greg@cpe-74-76-125-87.nycap.res.rr.com) has quit (*.net *.split) | |
| [10:28:29] | davide (davide!~david@host70.16.intrusion.com) has quit (*.net *.split) | |
| [10:28:29] | sutula (sutula!sutula@nat/hp/x-ynnbcuexgwdepiux) has quit (*.net *.split) | |
| [10:28:30] | taylorr (taylorr!~taylorr@unaffiliated/elmojo) has quit (*.net *.split) | |
| [10:28:30] | PointyPumper (PointyPumper!~pintlezz@190.244.65.185) has quit (*.net *.split) | |
| [10:28:30] | alla (alla!~alla@203.7.155.137) has quit (*.net *.split) | |
| [10:28:31] | ybot (ybot!~quassel@61.14.141.36) has quit (*.net *.split) | |
| [10:28:31] | jpabq- (jpabq-!~jpabq@174-28-167-122.albq.qwest.net) has quit (*.net *.split) | |
| [10:28:31] | Anduin (Anduin!~awithers@pdpc/supporter/professional/anduin) has quit (*.net *.split) | |
| [10:29:05] | ybot (ybot!~quassel@61.14.141.36) has joined #mythtv | |
| [10:29:20] | rsiebert_ (rsiebert_!~quassel@e179132095.adsl.alicedsl.de) has joined #mythtv | |
| [10:32:31] | map7 (map7!~map7@ppp118-209-74-113.lns20.mel4.internode.on.net) has joined #mythtv | |
| [10:32:31] | brfransen (brfransen!~brfransen@64.179.142.146) has joined #mythtv | |
| [10:32:31] | J-e-f-f-A (J-e-f-f-A!~J-e-f-f-A@unaffiliated/j-e-f-f-a) has joined #mythtv | |
| [10:32:31] | gregL_ (gregL_!~greg@cpe-74-76-125-87.nycap.res.rr.com) has joined #mythtv | |
| [10:32:31] | simonckenyon (simonckenyon!~simoncken@195.7.61.12) has joined #mythtv | |
| [10:32:31] | danielk22 (danielk22!~danielk@96.57.9.142) has joined #mythtv | |
| [10:32:31] | ghoti (ghoti!~paul@scratch.it.ca) has joined #mythtv | |
| [10:32:31] | iamlindoro (iamlindoro!~iamlindor@mythtv/developer/iamlindoro) has joined #mythtv | |
| [10:32:31] | Chutt (Chutt!~ijr@cpe-76-190-198-203.neo.res.rr.com) has joined #mythtv | |
| [10:32:31] | wagnerrp (wagnerrp!~wagnerrp_@mythtv/developer/wagnerrp) has joined #mythtv | |
| [10:32:32] | anykey_ (anykey_!~guedel@46-126-245-147.dynamic.hispeed.ch) has joined #mythtv | |
| [10:32:32] | Seeker` (Seeker`!~cjo20@gateway/shell/ubottu/x-ngaruhwwgdjmhxau) has joined #mythtv | |
| [10:32:32] | Beirdo (Beirdo!~gjhurlbu@mythtv/developer/beirdo) has joined #mythtv | |
| [10:32:47] | jpabq- (jpabq-!~jpabq@174-28-167-122.albq.qwest.net) has joined #mythtv | |
| [10:33:10] | Anduin_ (Anduin_!~awithers@c-71-204-162-27.hsd1.ca.comcast.net) has joined #mythtv | |
| [10:33:11] | aloril (aloril!~aloril@dsl-tkubrasgw3-fe7ef900-153.dhcp.inet.fi) has joined #mythtv | |
| [10:33:50] | purserj (purserj!~purserj@hosting.collaborynth.com.au) has joined #mythtv | |
| [10:33:54] | alla (alla!~alla@203.7.155.137) has joined #mythtv | |
| [10:34:09] | foobum (foobum!~mythtv@78-105-15-213.zone3.bethere.co.uk) has joined #mythtv | |
| [10:34:17] | joe__ (joe__!~jmk@64.73.32.135) has joined #mythtv | |
| [10:35:53] | sutula (sutula!sutula@nat/hp/session) has joined #mythtv | |
| [10:36:25] | taylorr (taylorr!~taylorr@cpe-173-095-145-027.nc.res.rr.com) has joined #mythtv | |
| [10:36:58] | Cougar (Cougar!~cougar@kkk.version6.net) has joined #mythtv | |
| [10:37:42] | kwmonroe (kwmonroe!~kwmonroe@32.97.110.58) has joined #mythtv | |
| [10:43:28] | kc (kc!~Casper@unaffiliated/kc) has quit (Read error: Connection timed out) | |
| [10:51:33] | PointyPumper (PointyPumper!~pintlezz@190.244.65.185) has joined #mythtv | |
| [10:58:40] | sutula (sutula!sutula@nat/hp/session) has quit (Changing host) | |
| [10:58:41] | sutula (sutula!sutula@nat/hp/x-xpgpgkhwrrkojaxb) has joined #mythtv | |
| [10:59:45] | GreyFoxx (GreyFoxx!~greg@2607:ae00:fff9::1) has joined #mythtv | |
| [11:12:37] | ikonia (ikonia!~irc@bender.dnsdata.co.uk) has joined #mythtv | |
| [11:13:28] | ikonia (ikonia!~irc@bender.dnsdata.co.uk) has quit (Changing host) | |
| [11:13:28] | ikonia (ikonia!~irc@unaffiliated/ikonia) has joined #mythtv | |
| [11:22:21] | ikonia (ikonia!~irc@unaffiliated/ikonia) has left #mythtv () | |
| [12:04:38] | davide_ (davide_!~david@host70.16.intrusion.com) has quit (Remote host closed the connection) | |
| [12:05:01] | davide_ (davide_!~david@host70.16.intrusion.com) has joined #mythtv | |
| [12:05:01] | davide_ (davide_!~david@host70.16.intrusion.com) has quit (Changing host) | |
| [12:05:01] | davide_ (davide_!~david@mythtv/developer/gigem) has joined #mythtv | |
| [12:14:18] | kth (kth!~kth@unaffiliated/kth) has joined #mythtv | |
| [12:14:55] | kth (kth!~kth@unaffiliated/kth) has quit (Client Quit) | |
| [12:40:21] | xris (xris!~xris@xris.forevermore.net) has joined #mythtv | |
| [12:50:10] | Captain_Murdoch (Captain_Murdoch!~cpinkham@mythtv/developer/CaptainMurdoch) has quit (Ping timeout: 252 seconds) | |
| [12:50:28] | sphery (sphery!~mdean@user-0c6s50s.cable.mindspring.com) has joined #mythtv | |
| [12:50:29] | kth (kth!~kth@dyndsl-085-016-234-203.ewe-ip-backbone.de) has joined #mythtv | |
| [12:50:29] | kth (kth!~kth@dyndsl-085-016-234-203.ewe-ip-backbone.de) has quit (Changing host) | |
| [12:50:29] | kth (kth!~kth@unaffiliated/kth) has joined #mythtv | |
| [12:51:46] | kth (kth!~kth@unaffiliated/kth) has quit (Client Quit) | |
| [12:56:06] | willcooke (willcooke!will@conference/ubuntudevelopersummit/x-snracmaskwnnamam) has joined #mythtv | |
| [12:56:06] | willcooke (willcooke!will@conference/ubuntudevelopersummit/x-snracmaskwnnamam) has quit (Changing host) | |
| [12:56:07] | willcooke (willcooke!will@canonical/willcooke) has joined #mythtv | |
| [13:03:19] | Captain_Murdoch (Captain_Murdoch!~cpinkham@ip72-218-58-187.hr.hr.cox.net) has joined #mythtv | |
| [13:03:19] | Captain_Murdoch (Captain_Murdoch!~cpinkham@ip72-218-58-187.hr.hr.cox.net) has quit (Changing host) | |
| [13:03:19] | Captain_Murdoch (Captain_Murdoch!~cpinkham@mythtv/developer/CaptainMurdoch) has joined #mythtv | |
| [13:09:17] | map7 (map7!~map7@ppp118-209-74-113.lns20.mel4.internode.on.net) has quit (Read error: Operation timed out) | |
| [13:20:56] | zombor (zombor!~zombor_@kohana/developer/zombor) has joined #mythtv | |
| [13:23:35] | simonckenyon (simonckenyon!~simoncken@195.7.61.12) has quit (Remote host closed the connection) | |
| [13:25:18] | simonckenyon (simonckenyon!~simoncken@195.7.61.12) has joined #mythtv | |
| [13:35:17] | j-rod|afk is now known as j-rod | |
| [13:48:15] | wagnerrp: | stuartm: so the "Revert ..." and "This reverts commit ..." was added automatically? |
| [13:53:59] | willcooke (willcooke!will@canonical/willcooke) has quit (Ping timeout: 252 seconds) | |
| [14:09:25] | stuartm: | yes |
| [14:22:42] | willcooke (willcooke!will@canonical/willcooke) has joined #mythtv | |
| [14:24:20] | kth (kth!~kth@unaffiliated/kth) has joined #mythtv | |
| [14:24:43] | kth (kth!~kth@unaffiliated/kth) has quit (Client Quit) | |
| [14:33:33] | willcooke (willcooke!will@canonical/willcooke) has quit (Quit: We will learn more of his wisdom later) | |
| [14:34:29] | Computer_Czar (Computer_Czar!~Unknown@69.4.155.83) has joined #mythtv | |
| [14:57:26] | kth (kth!~kth@unaffiliated/kth) has joined #mythtv | |
| [14:57:38] | kth (kth!~kth@unaffiliated/kth) has quit (Client Quit) | |
| [15:10:12] | jpabq_ (jpabq_!~jpabq@mythtv/developer/jpabq) has joined #mythtv | |
| [15:14:55] | Malard (Malard!~Malard@xbmc/staff/malard) has quit () | |
| [16:17:08] | andreax (andreax!~andreaz@p4FC12F7A.dip.t-dialin.net) has joined #mythtv | |
| [16:18:21] | jmartens (jmartens!~jmartens@109.232.42.33) has quit (Quit: Leaving.) | |
| [16:47:24] | rsiebert (rsiebert!~quassel@g231186050.adsl.alicedsl.de) has joined #mythtv | |
| [16:47:41] | rsiebert__ (rsiebert__!~quassel@e179132095.adsl.alicedsl.de) has quit (Ping timeout: 240 seconds) | |
| [16:48:05] | rsiebert_ (rsiebert_!~quassel@e179132095.adsl.alicedsl.de) has quit (Ping timeout: 240 seconds) | |
| [16:48:55] | dblain (dblain!~dblain@c-76-127-227-175.hsd1.ma.comcast.net) has joined #mythtv | |
| [16:48:55] | dblain (dblain!~dblain@c-76-127-227-175.hsd1.ma.comcast.net) has quit (Changing host) | |
| [16:48:55] | dblain (dblain!~dblain@mythtv/developer/dblain) has joined #mythtv | |
| [16:59:26] | jmartens (jmartens!~jmartens@s5597ca60.adsl.wanadoo.nl) has joined #mythtv | |
| [17:04:49] | davide_ (davide_!~david@mythtv/developer/gigem) has quit (Remote host closed the connection) | |
| [17:05:13] | davide_ (davide_!~david@host70.16.intrusion.com) has joined #mythtv | |
| [17:05:13] | davide_ (davide_!~david@host70.16.intrusion.com) has quit (Changing host) | |
| [17:05:13] | davide_ (davide_!~david@mythtv/developer/gigem) has joined #mythtv | |
| [17:08:31] | kormoc (kormoc!~kormoc@mythtv/developer/kormoc) has joined #mythtv | |
| [17:14:19] | xris (xris!~xris@xris.forevermore.net) has quit (Changing host) | |
| [17:14:20] | xris (xris!~xris@mythtv/developer/xris) has joined #mythtv | |
| [17:15:32] | dblain: | iamlindoro: Still looking for me... get without power for a few days. |
| [17:15:51] | dblain: | err been |
| [17:29:57] | stuartm: | overground electricity cables? |
| [17:30:41] | dblain: | underground in my neighborhood but fed from aboveground lines :( |
| [17:45:28] | iamlindoro: | dblain: Just wondering if it would immediately occur to you what the bug I am running into with GetProgramGuide |
| [17:45:46] | iamlindoro: | It appears related to the GROUP BY statements in guide.cpp |
| [17:46:03] | iamlindoro: | Which appears to try to squash down by chanid, channum, callsign, program title |
| [17:46:35] | iamlindoro: | But the output when there are two sources with same channels is sometimes that you get two channel rows, one with part of the programming, and the rest on the other |
| [17:47:13] | iamlindoro: | In my guide of ~400 channels, I see it maybe 2 dozen times, and it tends to vary by the programming |
| [17:47:33] | iamlindoro: | but it makes it hard to build a usable guide since some rows only half half of their programming |
| [17:48:12] | iamlindoro: | Queries in question, excerpted: http://pastebin.com/j8Kp7Dwj |
| [17:48:19] | iamlindoro: | and let me get an example of the xml output |
| [17:51:33] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has joined #mythtv | |
| [17:53:17] | dblain: | I'm not a SQL expert, but it looks fine. With nothing else to go on, I'd simplify the query by removing the joins and see if the duplicates persist. Also you might want to check the tables in question to make sure you don't have duplicate rows (maybe mfdb is adding dupes incorrectly). |
| [17:58:53] | kormoc: | dblain, in this case, it's getting too few rows, not too many |
| [18:01:32] | kth (kth!~kth@unaffiliated/kth) has joined #mythtv | |
| [18:02:29] | iamlindoro: | dblain: The joins are in the fundamental SQL. and work in the program guide in the UI... the group bys are only present in the Guide Service |
| [18:03:12] | iamlindoro: | Let's say I have chanids 1702 and 2702... both the same callsign, channum, and programming... in some returns, asking for 8–10 AM, you'll get 8–9 on one row, and 9–10 on the other |
| [18:03:27] | iamlindoro: | the two rows always total the correct output, but neither has the correct full output |
| [18:07:48] | kormoc: | iamlindoro, do you want a single row or two full rows? |
| [18:08:41] | iamlindoro: | the former, but I could live with the latter because then at least you could grad a grid properly |
| [18:10:16] | iamlindoro: | Basically, I am drawing a guide by iterating through the channel rows, bu when you get two, each with part, this happens: http://www.fecitfacta.com/brokenguide.png |
| [18:14:44] | kormoc: | iamlindoro, do they have different program.listingsource values? |
| [18:16:18] | iamlindoro: | kormoc: Looks like no, all programs in my guide have a listingsource of "2" |
| [18:18:14] | kormoc: | try changing 'ORDER BY program.chanid' to 'ORDER BY channel.sourceid, program.chanid' |
| [18:18:18] | iamlindoro: | kormoc, dblain: here is an example I've edited together: http://pastebin.com/dPmjErNe |
| [18:18:55] | iamlindoro: | SPROUT with chanid 2119 has programming from 10–11:30, sprout with 3119 has programming from 11:30–1 |
| [18:20:29] | zombor (zombor!~zombor_@kohana/developer/zombor) has quit (Read error: Connection reset by peer) | |
| [18:21:31] | zombor (zombor!~zombor_@kohana/developer/zombor) has joined #mythtv | |
| [18:22:54] | iamlindoro: | kormoc: Doesn't seem to make a difference |
| [18:23:00] | kormoc: | hrm |
| [18:24:12] | kth (kth!~kth@unaffiliated/kth) has quit (Quit: Leaving.) | |
| [18:39:16] | ThisNewGuy (ThisNewGuy!~doug@pool-74-102-15-78.nwrknj.fios.verizon.net) has joined #mythtv | |
| [18:52:29] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Ping timeout: 240 seconds) | |
| [19:05:52] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
| [19:09:51] | dblain: | iamlindoro: what happens if you remove the group by for channel.callsign |
| [19:12:37] | iamlindoro: | dblain: heh, then it gets a thousand times worse :) Every program is in a distinct channel row |
| [19:13:26] | dblain: | I wouldn't expect that to happen unless channel.channum is null. |
| [19:13:50] | dblain: | what about adding channel.callsign back in and removing channel.channum |
| [19:22:38] | iamlindoro: | dblain: Sorry, you're right-- I removed the group by callsign and it was roughly the way it was before-- trying removing the channum now |
| [19:23:33] | iamlindoro: | Seems not to make much of a difference either :( |
| [19:24:11] | iamlindoro: | So weird how most channels work, but it's just a few dozen or so where the wrong results are returned |
| [19:24:20] | iamlindoro: | or rather, incomplete results |
| [19:33:35] | dblain: | iamlindoro: Looking at the sql and your xml sample, I'm confused. The sql looks like startTime would be the root item being grouped, yet the xml has channel being the root (so to speak). |
| [19:34:36] | dblain: | Is it possible the code reading the data from the result set is restructuring the data? If so, maybe re-ordering the order by clause will fix it? |
| [19:35:43] | iamlindoro: | dblain: I don't know, you wrote the guide API :) I will look, though |
| [19:39:41] | dblain: | Did I?... oops, I must be getting old... memory failing. |
| [19:42:16] | iamlindoro: | Actually, I think I may see the issue |
| [19:42:20] | iamlindoro: | I think the SQL is fine |
| [19:42:55] | iamlindoro: | if ( nCurChanId != pInfo->GetChanID() ) |
| [19:43:03] | iamlindoro: | That's how it increments to the next <Channel> |
| [19:43:29] | iamlindoro: | which means all overlaps with differing chanid but same everything else will just produce a new <channel>, right? |
| [19:43:50] | dblain: | looks like it. |
| [19:43:56] | iamlindoro: | Might be better to check callsign, since that's our "official" merging method? |
| [19:44:28] | iamlindoro: | (and if this ends up being it, I am sorry for the wild goose chase) |
| [19:45:17] | dblain: | Sounds right. Not a problem. I wasn't much help anyway! (didn't even realize it was my code we were talking about :/ ) |
| [19:46:35] | iamlindoro: | Thanks for the help all the same-- I will play around with it and report back |
| [20:01:33] | SteveGoodey (SteveGoodey!~steve@host86-177-145-244.range86-177.btcentralplus.com) has joined #mythtv | |
| [20:11:34] | iamlindoro: | dblain: So switching to callsign for new rows is *much* better-- not only 7 channels left with the problem, but I will play with the grouping options, and check my DB data on those channels... thanks to you and kormoc |
| [20:13:51] | iamlindoro: | s/not/now/ |
| [20:17:01] | jmartens (jmartens!~jmartens@s5597ca60.adsl.wanadoo.nl) has quit (Ping timeout: 240 seconds) | |
| [20:17:25] | jmartens (jmartens!~jmartens@s5597ca60.adsl.wanadoo.nl) has joined #mythtv | |
| [20:38:26] | zombor (zombor!~zombor_@kohana/developer/zombor) has quit (Remote host closed the connection) | |
| [20:39:19] | Mousey (Mousey!~wtfisme@ross154.net) has joined #mythtv | |
| [20:52:36] | SteveGoodey (SteveGoodey!~steve@host86-177-145-244.range86-177.btcentralplus.com) has quit (Remote host closed the connection) | |
| [21:01:43] | Anduin_ (Anduin_!~awithers@c-71-204-162-27.hsd1.ca.comcast.net) has quit (Ping timeout: 255 seconds) | |
| [21:06:22] | andreax1 (andreax1!~andreaz@p4FC12CCB.dip.t-dialin.net) has joined #mythtv | |
| [21:06:28] | andreax (andreax!~andreaz@p4FC12F7A.dip.t-dialin.net) has quit (Ping timeout: 260 seconds) | |
| [21:07:09] | RDV_Linux (RDV_Linux!~doug@CPE1caff7df6774-CM00252eac6f40.cpe.net.cable.rogers.com) has quit (Remote host closed the connection) | |
| [21:33:29] | JEDIDIAH__ (JEDIDIAH__!~jedi@cpe-76-185-75-39.tx.res.rr.com) has quit (Ping timeout: 276 seconds) | |
| [21:34:38] | JEDIDIAH__ (JEDIDIAH__!~jedi@cpe-76-185-75-39.tx.res.rr.com) has joined #mythtv | |
| [21:37:56] | JEDIDIAH__ (JEDIDIAH__!~jedi@cpe-76-185-75-39.tx.res.rr.com) has quit (Read error: Connection timed out) | |
| [21:38:20] | JEDIDIAH__ (JEDIDIAH__!~jedi@cpe-76-185-75-39.tx.res.rr.com) has joined #mythtv | |
| [22:01:39] | ThisNewGuy (ThisNewGuy!~doug@pool-74-102-15-78.nwrknj.fios.verizon.net) has quit (Ping timeout: 244 seconds) | |
| [22:07:40] | jmartens (jmartens!~jmartens@s5597ca60.adsl.wanadoo.nl) has quit (Quit: Leaving.) | |
| [22:09:06] | danielk22: | iamlindoro: I remember you did some work on the Cable TV channel scanner, do you have Cable TV with non-encrypted channels? I'm looking for some streams with SCTE PSIP so I can flesh out what remains to be done for SCTE PSIP parsing. When present it should allow us to extract channel numbers and names on cable tv stations. |
| [22:09:44] | iamlindoro: | danielk22: Sure, just tell me what you'd like, I can get you a scan-- I do have cable, and do have a fair number of clearqam channels |
| [22:10:28] | iamlindoro: | Will be a couple of hours, I'll head home soon but have to get a workout in before I settle down |
| [22:10:37] | danielk22: | iamlindoro: A full ts grab for about about a minute on one of those (which is not an OTA station) should do it. |
| [22:10:58] | iamlindoro: | danielk22: Any way of knowing whether those channels will have SCTE PSIP? |
| [22:11:24] | iamlindoro: | I'd hate to have you download one I didn't know would work for you |
| [22:13:29] | danielk22: | iamlindoro: "dvbstream -o 8192 > dump.ts" to do the grab, "mythutil --pidprinter --infile dump.ts --pids 0x1ffb" to print the tables. |
| [22:13:52] | iamlindoro: | danielk22: Will do. Should be able to get it done in ~ 2–3 hours |
| [22:14:45] | danielk22: | It should print at least a "Cable Virtual Channel Section", but it may run into trouble, since it's 100% untested. :) |
| [22:15:10] | iamlindoro: | If it crashes, I'll know I'm on to something ;) |
| [22:15:15] | danielk22: | ypu :) |
| [22:15:19] | danielk22: | yup :) |
| [22:17:03] | iamlindoro: | Ah, I just finally focused |
| [22:17:08] | iamlindoro: | You're talking about the SCTE-65 tables |
| [22:17:13] | iamlindoro: | yeah, I've got those |
| [22:19:27] | iamlindoro: | ah, not 65, but it's neighbor-- thought 1ffb was SCTE-65, but that's 1ffc |
| [22:19:46] | iamlindoro: | anyway, I'll just follow instructions and leave it to you ;) |
| [22:28:04] | danielk22: | Yeah I'm looking for the SCTE-65, maybe it's 0x1ffc you can check by just using mythutil --pidcounter --infile dump.ts |
| [22:29:07] | danielk22: | I know we can already decode some of it because of the overlap with ATSC A/65, but I think we need a couple more tables before we can use it for the scan. |
| [22:30:40] | danielk22: | I have cable but my operator encrypts everything that isn't OTA. :| |
| [22:34:35] | natanojl (natanojl!~jonatan@c83-252-237-63.bredband.comhem.se) has quit (Ping timeout: 276 seconds) | |
| [22:48:18] | Dave123 (Dave123!~dave@cpe-74-74-200-106.rochester.res.rr.com) has joined #mythtv | |
| [23:00:03] | kc (kc!~Casper@unaffiliated/kc) has joined #mythtv | |
| [23:01:42] | alla (alla!~alla@203.7.155.137) has left #mythtv () | |
| [23:20:17] | zombor (zombor!~zombor_@kohana/developer/zombor) has joined #mythtv | |
| [23:26:08] | Anduin (Anduin!~awithers@pdpc/supporter/professional/anduin) has joined #mythtv | |
| [23:41:32] | kc (kc!~Casper@unaffiliated/kc) has quit (Ping timeout: 276 seconds) | |
| [23:43:35] | andreax1 (andreax1!~andreaz@p4FC12CCB.dip.t-dialin.net) has quit (Read error: Connection reset by peer) | |
| [23:46:01] | eharris (eharris!~eharris@99-179-7-82.lightspeed.austtx.sbcglobal.net) has quit (Ping timeout: 244 seconds) | |
| [23:46:36] | AlphaWolf (AlphaWolf!~AlphaWolf@ip72-222-240-23.ph.ph.cox.net) has joined #mythtv | |
| [23:47:17] | AlphaWolf (AlphaWolf!~AlphaWolf@ip72-222-240-23.ph.ph.cox.net) has left #mythtv () | |
| [23:52:58] | danielk22 (danielk22!~danielk@96.57.9.142) has quit (Ping timeout: 258 seconds) | |
| [23:53:16] | kc (kc!~Casper@unaffiliated/kc) has joined #mythtv | |
| [23:53:39] | eharris (eharris!~eharris@99-179-7-82.lightspeed.austtx.sbcglobal.net) has joined #mythtv | |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.
