IRC log for #uphpu on 20090810

00:04.07*** join/#uphpu justincarmony (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net)
00:04.07*** mode/#UPHPU [+v justincarmony] by ChanServ
00:12.54*** mode/#UPHPU [+v DexterTheDragon] by ChanServ
00:26.03*** join/#uphpu justincarmony (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net)
00:26.03*** mode/#UPHPU [+v justincarmony] by ChanServ
00:43.58*** join/#uphpu DexterTheDragon (n=admin@oalug/member/blackchaos)
00:43.58*** mode/#UPHPU [+v DexterTheDragon] by ChanServ
01:10.33*** join/#uphpu DexterTh1Dragon (n=admin@216-160-233-108.slkc.qwest.net)
01:24.51*** join/#uphpu octavian (n=lugard@fl-71-48-249-43.dhcp.embarqhsd.net)
01:25.51*** part/#uphpu octavian (n=lugard@fl-71-48-249-43.dhcp.embarqhsd.net)
02:39.11*** join/#uphpu DexterTheDragon (n=admin@oalug/member/blackchaos)
02:39.11*** mode/#UPHPU [+v DexterTheDragon] by ChanServ
03:06.59*** join/#uphpu Utah_Dave (n=David@c-67-172-225-101.hsd1.ut.comcast.net)
03:06.59*** mode/#UPHPU [+o Utah_Dave] by ChanServ
04:50.11*** join/#uphpu Utah_Dave1 (n=David@c-67-172-225-101.hsd1.ut.comcast.net)
04:53.55*** join/#uphpu Utah_Dave2 (n=David@c-67-172-225-101.hsd1.ut.comcast.net)
05:11.32*** join/#uphpu Utah_Dave (n=David@c-67-172-225-101.hsd1.ut.comcast.net)
05:11.32*** mode/#UPHPU [+o Utah_Dave] by ChanServ
08:41.11*** part/#uphpu Utah_Dave (n=David@c-67-172-225-101.hsd1.ut.comcast.net)
12:40.40*** join/#uphpu jtsnow (n=chatzill@151.118.130.129)
14:16.37*** join/#uphpu justincarmony (n=justinca@98.202.44.233)
14:16.37*** mode/#UPHPU [+v justincarmony] by ChanServ
14:19.23herlomindjuju: ping
14:54.09*** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com)
14:54.09*** mode/#UPHPU [+o fungus] by ChanServ
14:57.59*** join/#uphpu mgeary (n=mgeary@166.70.44.49)
14:58.38mgeary~yow
15:13.25*** join/#uphpu cro (n=cro@166-70-222-105.ip.xmission.com)
15:19.13jtsnowGood morning all
15:20.29jtsnowIf anyone is interesting in attending the Utah Drupal user group meetup next week, here is the info: http://groups.drupal.org/node/24727
15:21.11jtsnowIf someone could add it to the uphpu.org events calendar as well, that would be awesome
15:23.24fungusmindjuju would be the one to add it to the uphpu.org site.
15:23.57fungusbut herlo could add it to the Utah Tech Events calendar too
15:26.07jtsnowCool, it would be much appreciated
15:45.38*** join/#uphpu thebigdog (n=thebigdo@dsl093-228-015.slc1.dsl.speakeasy.net)
15:45.39*** mode/#UPHPU [+o thebigdog] by ChanServ
16:00.28*** join/#uphpu SunSparc (n=sparky@173-8-91-177-Utah.hfc.comcastbusiness.net)
16:00.51*** mode/#UPHPU [+v SunSparc] by ChanServ
16:01.11SunSparc~happy
16:01.12ibotsunsparc: you know that feeling you get when you don't like somebody, but they like you; well, you're not quite encouraging that feeling so go away from me! or at http://www-i2.informatik.rwth-aachen.de/Software/Haskell/
16:01.50SunSparc~happy ibot
16:13.24SunSparc~monday
16:13.25ibotextra, extra, read all about it, monday is when everything breaks for no apparent reason, creating so many problems that it takes you until friday to get back to normal. at which point one more thing breaks that takes you the whole weekend to fix, or and on a more positive note, Monday is a brand new day at the beginning of a brand new week, a place to start over and improve on last week.  :)
16:17.13*** join/#uphpu burnin (n=burnin@204-228-142-196.ip.xmission.com) [NETSPLIT VICTIM]
16:17.13*** mode/#UPHPU [+v burnin] by irc.freenode.net
16:56.10SunSparc~rlart
16:56.11ibotinstalls a bad bootloader on eco and turns eco into a brick
16:57.00ecoDick.
17:00.25SunSparcNo, SunSparc.
17:00.26SunSparc:)
17:00.51*** join/#uphpu _psychic_ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net)
17:00.51*** mode/#UPHPU [+v _psychic_] by ChanServ
17:04.01fungusNo, http://www.youtube.com/watch?v=k1Yl0-1UDX0
17:06.11SunSparcfungus: Wow... just, wow...
17:06.53fungusCame from: http://www.imdb.com/title/tt0307516/
17:07.42fungusScarred me permanently as a child
17:07.50SunSparcLOL
17:09.47_psychic_*nsfw
17:11.08funguslol, the only "kids" video that is nsfw.  :)
17:11.37fungus~headphones++
17:12.24unumif only more people had watched that video they would get the female gentila right
17:14.12SunSparcsrsl
17:14.14SunSparcy
17:20.00herlojtsnow: yeah, check out the utah tech events calendar, very useful
17:20.34herloUtah Tech Events Calendar -  http://sn.im/ute-calendar  [www_google_com]
17:23.22jtsnowherlo: yes, great resource! Who do I contact to add an event?
17:23.51herlojtsnow: me
17:23.57herloclint@utos.org
17:24.15jtsnowok, thanks!
17:25.20herlonp
17:28.04*** join/#uphpu Citrus (n=Citrus@pool-173-63-39-114.nwrknj.fios.verizon.net)
17:28.29Citruscan someone help me with SELECT min(comment_id) FROM comment WHERE comment_chosen_id=$featureid GROUP BY comment_chosen_id
17:29.02mgearyah
17:29.07mgearyyou want to do a groupwise min
17:29.13mgearysimilar to a groupwise max
17:29.14Citrusyes
17:29.16mgearyyou need a subquery
17:29.17Citrusi guess lol
17:29.21Citruswhat's going on is
17:29.24Citrusunder comment_chosen_id = 2
17:29.32Citrusthe minimum comment_id is 14
17:29.38Citrushowever it's choosing the overall minimum comment_id
17:29.39Citruswhich is 1
17:29.42mgearyyep
17:29.48mgearyhttp://jan.kneschke.de/projects/mysql/groupwise-max
17:30.10mgeary(just substitute min for max)
17:30.13Citrusnice
17:30.14Citrusthanks
17:31.51Citrusso what exactly does group_by do then
17:32.13mgearywell, it makes so each unique value of that field is only represented once
17:32.32mgearyHOWEVER, in the other fields, you have no guarantee of which row in the grouped-together rows is actually being represented
17:32.42mgearywhich is why you need the subquery
17:33.04mgearyyou cannot specify a sort order on grouped-together rows without doing a subquery
17:33.36Citrusalright so i see that i have to create a temporary table
17:33.40mgearyno
17:33.47mgearyi don't think so
17:34.06mgearyat least, not explicitly
17:34.27mgearyyou need to create a subquery that you're joining against, which is kind of a temporary table, but you're not really explicitly creating it
17:36.14Citrushmm
17:36.20Citrusim looking at that link you gave me and it says to create a temporar ytable
17:36.44mgearywell, look at the heading "How to solve the same problem in 10 different ways"
17:36.50mgearythat's one of the 10, but not the one you want
17:37.14DexterTheDragonwhy doesn't SELECT comment_id FROM comment WHERE comment_chosen_id=$featureid ORDER BY comment_id LIMIT 1 work?
17:38.09Citrusit's giving me comment_ids
17:38.16Citruswhere comment_chosen_id does not equal $featureid
17:38.26mgearyhttp://dpaste.com/77844/
17:38.33mgearythat's the kind of thing i'd recommend
17:38.51Citrusyeah i was looking at that
17:38.57Citrusbut co1 and co2 are temporary tables they created earlier
17:39.17DexterTheDragonno they're not
17:39.33DexterTheDragonco1 is Country and co2 is the subselect
18:06.20CitrusSELECT min(comment_id) FROM comment WHERE comment_chosen_id = $featureid GROUP BY comment_chosen_id
18:06.26Citrusthere's something wrong and $featureid isn
18:06.28Citrus't being passed on
18:06.31Citrusany ideas?
18:07.08DexterTheDragonCitrus: pastebin the chunk of code where the query is
18:07.50Citrushttp://pastebin.com/m35728cde
18:07.52Citrusthe echo doesn't even work
18:07.56Citruson the bottom
18:07.57Citrusthe first one works though
18:09.10*** join/#uphpu Lone_Wanderer (n=Dan@c-67-169-246-153.hsd1.ut.comcast.net)
18:09.10*** mode/#UPHPU [+v Lone_Wanderer] by ChanServ
18:09.56DexterTheDragondo you get results if you run the query in mysql?
18:10.12Citruswell i can't
18:10.16Citrusi just substitute 2 for $featurei
18:10.16Citrusd
18:10.18Citrusand yeah it works
18:15.37*** join/#uphpu mindjuju1 (n=mindjuju@mail.billgood.us)
18:23.02Citrusgot it figured out
18:23.09Citrusgotta do $row['min(comment_id)']
18:24.39*** join/#uphpu beandog (n=steve@gentoo/developer/beandog)
18:24.39*** mode/#UPHPU [+v beandog] by ChanServ
18:29.07DexterTheDragonor alias the row
18:32.30Citrusfor (; $minid <= $maxid && $minid <= $row['MAX(comment_id)']; $minid++)
18:33.01Citrus$minid is 14
18:33.04Citrus$maxid is 18
18:33.08Citrusmax(comment_id) is 15
18:33.10Citrusbut it runs only once
18:33.57Citrusnevermind i figured it out
18:50.48cycokilrs/sheesh/oh/
19:23.19*** join/#uphpu justincarmony (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net)
19:23.19*** mode/#UPHPU [+v justincarmony] by ChanServ
20:02.23mgeary~rlart
20:02.24ibotcuts off DexterTheDragon's head with a halberd that could have been a little bit sharper
20:02.41SunSparcOuchie
20:03.40DexterTheDragon~dtdhit mgeary
20:03.41ibotACTION stikes at mgeary with the fire of the cat seizure causing a very bad flesh wound!
20:04.26mgearypsh. a mere flesh wound
20:04.38SunSparc~squeeze Citrus
20:04.38ibotACTION squeezes the juice out of Citrus until there just ain't nothin left
20:04.46SunSparcHow appropriate
20:15.06*** mode/#UPHPU [+o mindjuju] by ChanServ
20:15.55mindjuju~macattack dexterthedragon
20:15.55ibotACTION mixes nitrate, cellulose and acide to make nitor manite and lobs it at dexterthedragon... Boom !
20:45.27*** join/#uphpu blendmaster1024 (i=9b649e97@gateway/web/freenode/x-0d2f35810a8df98e)
20:46.05wpsI love how my wife doesn't care about latest and greatest
20:46.18wpsshe wants a new something and I can give her my old one and get a new one for myself
20:47.24mindjujui know you're not talking cameras
20:47.31wpsI wish
20:47.33mindjujucause didn't you already have the 20D ?
20:47.45wpsyeah… but that's like 5 years old now man!
20:47.48wps:)
20:47.56wpsI was talking iPhones specifically
20:48.29wpsshe said she doesn't really care about the 3GS, so I should be able to pass my 3G to her and get the new one
20:49.19*** join/#uphpu blendmaster1024 (i=9b649e97@gateway/web/freenode/x-310f6ec4de51d323)
20:53.46mgearyhey folks
20:53.51mgearywhy wouldn't sed be finding this match:
20:54.36mgearys/<a href='javascript:popUp\(\"popup\.php\?ad=\d+\",440,390\)'>/XX/g
20:54.46mgearyi think it might be the double-quotes.
20:54.57mgearyshould i be doing something other than \" for quotes?
20:57.37orsonjI'm not sure you need to escape anything actually
20:58.42orsonjI usually do that stuff in vi though, it does it a titch differently.
20:59.18mgearyi'm writing a bash script
20:59.21*** join/#uphpu PoeticIntensity (n=jason@67.214.232.162)
20:59.21*** mode/#UPHPU [+v PoeticIntensity] by ChanServ
20:59.30PoeticIntensity~hello
20:59.30ibotHowdy Bub
20:59.39PoeticIntensity~flip ibot
20:59.40ibotACTION gives ibot the .|.. ..|.
20:59.41mgearyi know you need to escape regex special chars, like . and \
21:01.12orsonjwell yeah. after that you probably need to escape anything that bash might interpret.
21:01.25Lone_Wandererescaping characters is a pain
21:01.33orsonjno kidding
21:01.35beandogsi.
21:03.03mgearyyeah
21:04.54beandogthat reminds me, how I found some really odd bug in escapeshellcmd/args the other day
21:04.59wpsinteresting
21:05.12beandogI can't remember off the top of my head what it was, but I remember it was a major wtc I had to workaround
21:05.23beandoganyway.
21:05.28beandogfud--
21:05.33beandogPHP on CLI is a bit tricky.
21:05.37Lone_Wandereryes it is
21:05.43Lone_WandererAlso: Awesome.
21:06.53mgearydoes sed not use pcre by default?
21:07.46wpsbeats the crap out of bash
21:08.06mgearythat's fine, except when you want to use things like "cut", "sed", etc.
21:08.21beandogI'd much rather write CLI scripts in bash
21:08.30beandogexcept that I dont know all the nice string functions, so I use php
21:08.52DexterTheDragonrather do console scripts in python or ruby
21:08.58mgearypython++
21:09.35mgearyso... anyone know the answer about pcre + sed ?
21:09.51fungussed -r
21:10.35mgearysed: illegal option -- r
21:10.39mgeary:/
21:10.45funguson a mac?
21:10.47mgearyyeah
21:10.52DexterTheDragon~mac--
21:11.24SunSparc~karma mac
21:11.24ibotmac has neutral karma
21:11.27fungusit's a different switch, but there is one.
21:12.01mgearyah
21:12.04mgeary-E, methinks
21:12.30fungusthat sounds about right
21:12.45DexterTheDragonthats actually a bsd problem
21:12.50DexterTheDragonwhich
21:12.53DexterTheDragon~bsd--
21:12.55fungusDexterTheDragon is right.
21:13.01fungus~bsd++
21:13.39fungus-E makes more sense, since it means "extended" regexp
21:14.41*** join/#uphpu _psychic__ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net)
21:30.02beandogare joins across databases just notoriously slow in mysql?
21:30.41beandogmyisam, if that matters
21:30.57DexterTheDragonjoins across databases are notoriously bad
21:31.11beandogDexterTheDragon, yah?  never done it much with mysql
21:31.23beandogI had to do it allllllllllll the tiiiiiiiiiiiime with sql server, and it was never a problem.
21:31.30beandogI mean, aside from being annoying.
21:35.44*** join/#uphpu _psychic_ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net)
21:35.44*** mode/#UPHPU [+v _psychic_] by ChanServ
21:41.37beandogwow, this is really slow.
21:51.50SunSparc~speedup beandog
21:51.51ibotACTION glues some racing wheels to beandog and watches beandog burn some rubber
21:54.18SunSparc~itunes
21:54.19ibotit has been said that itunes is a badass media manager/player that lets the user make "smart" playlists, or the DRM nazi. getting out of the DRM ring, or fail
21:54.36SunSparc~itunes++
21:57.14*** join/#uphpu blendmaster1024 (n=olpc@75-162-130-134.slkc.qwest.net)
22:49.25*** join/#uphpu justincarmony (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net)
22:49.25*** mode/#UPHPU [+v justincarmony] by ChanServ
23:01.29SunSparcHappy Family Home Evening!
23:18.00*** join/#uphpu wps (n=wps@208.53.47.251)
23:18.11*** mode/#UPHPU [+o wps] by ChanServ
23:20.33*** part/#uphpu mgeary (n=mgeary@166.70.44.49)
23:30.38*** join/#uphpu cro (n=cro@166-70-222-105.ip.xmission.com)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.