irclog2html for #uphpu on 20070104

00:02.28beandogreally?
00:02.31beandogthat would be cool.
00:03.13Lone_WandererI think I need some coke.  Corner store time.
00:05.42beandogLone_Wanderer: no go?
00:05.44mindjujuxilch|w
00:05.45beandogLone_Wanderer: what was the problem
00:06.16xilch|whey mindjuju
00:06.18*** join/#uphpu macnewbol1 (n=mac@cg.dsl.xmission.com)
00:06.18*** mode/#UPHPU [+o macnewbol1] by ChanServ
00:06.35mindjujucan you PM me the info for that printer in Idaho that you mentioned
00:07.43*** mode/#UPHPU [+v xilch|w] by ChanServ
00:13.56Lone_Wandererbeandog: yeah, I rolled it back.  It said that it was processing the php.ini's that had the extensions in them but they weren't showing up.
00:15.01beandogsucky.
00:15.09Lone_Wandereryeah
00:16.26Lone_WandererAlso, it looks like Coke has stopped making the Black Cherry Vanilla flavor :(
00:32.23*** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
00:34.23timinatorI'm out guys... later
00:48.39*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
00:48.39*** mode/#UPHPU [+v beandog] by ChanServ
00:56.46*** join/#uphpu burnin (n=burnin@42dbe40e.dsl.aros.net)
01:29.21herloso I've run into a function I've not heard of before and can't seem to find any references to it.  It's in a wordpress theme
01:29.45herlothe function is get_option, and my best guess is that it's getting options out of some ini file
01:29.52herloanyone heard of this?
01:35.56*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
01:35.56*** mode/#UPHPU [+o macnewbold] by ChanServ
02:37.18*** join/#uphpu macnewbol1 (n=mac@cg.dsl.xmission.com)
02:37.18*** mode/#UPHPU [+o macnewbol1] by ChanServ
02:47.40*** join/#uphpu Utah_Dave (n=boucha@d103.digis.net)
02:47.40*** mode/#UPHPU [+o Utah_Dave] by ChanServ
03:05.31*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
03:05.31*** mode/#UPHPU [+v beandog] by ChanServ
03:05.50*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
03:05.50*** mode/#UPHPU [+o macnewbold] by ChanServ
03:55.32*** join/#uphpu wps (n=wps@208.53.47.251)
03:55.32*** mode/#UPHPU [+o wps] by ChanServ
04:48.56*** join/#uphpu janix (n=janix60@c-67-177-59-226.hsd1.ut.comcast.net)
07:29.38*** join/#uphpu macnewbol1 (n=mac@cg.dsl.xmission.com)
07:29.38*** mode/#UPHPU [+o macnewbol1] by ChanServ
07:42.24*** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net)
07:42.24*** mode/#UPHPU [+o thebigdog] by ChanServ
09:47.38*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
09:47.38*** mode/#UPHPU [+o macnewbold] by ChanServ
10:33.20*** join/#uphpu macnewbol1 (n=mac@cg.dsl.xmission.com)
10:33.20*** mode/#UPHPU [+o macnewbol1] by ChanServ
11:22.30*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
11:22.30*** mode/#UPHPU [+o macnewbold] by ChanServ
13:17.59*** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net)
13:17.59*** mode/#UPHPU [+v timinator] by ChanServ
13:18.24timinatormorning guys
13:34.11dripgm timinator
13:53.29*** join/#uphpu macnewbol1 (n=mac@cg.dsl.xmission.com)
13:53.29*** mode/#UPHPU [+o macnewbol1] by ChanServ
14:09.32*** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
14:09.32*** mode/#UPHPU [+o Utah_Dave] by ChanServ
14:30.56*** join/#uphpu jsmith (n=jsmith@70.5.246.8)
14:30.56*** mode/#UPHPU [+v jsmith] by ChanServ
14:56.34*** join/#uphpu gibba[w] (i=gibbawho@209-253-35-21.ip.mcleodusa.net)
15:02.08*** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net)
15:02.08*** mode/#UPHPU [+o wps] by ChanServ
15:19.25*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
15:19.26*** mode/#UPHPU [+v beandog] by ChanServ
15:23.43*** join/#uphpu fungus (n=fungus@2001:470:1f00:645:250:8dff:fe71:9a6b)
15:23.43*** mode/#UPHPU [+o fungus] by ChanServ
15:25.12dataw0lfherlo: it's a WP function, it's a wrapper for get_settings() (another WP function)
15:25.38herlodataw0lf: thx, figured it out hours ago
15:25.54dataw0lfcoolio
15:26.00herlostill don't like my solution, however...
15:26.36dataw0lfwhat's that?
15:26.58herloI was just trying to change the headline image in the new theme I chose at http://www.gamesutah.org
15:27.17herloIt had this sort of gay paint card look
15:27.37herloand it suggested I change the custom image, so I did, and added my image
15:27.50herlobut it still kept the paint background...
15:28.35herloit was basing it's check on if some variable was set, and the get_options() function was supposed to return false for my custom image to work
15:29.09herloinstead, I ended up replacing the variable with my header image.  so now it works permanently.  It's a solution, but I wish it wasn't that way...
15:29.17herlodataw0lf: thanx though...
15:30.36dataw0lfhm
15:30.54herlowell, 1/2 day at least...
15:31.05dataw0lfheck yea, it's snowing here
15:31.21dataw0lfI did some wicked rail tricks last night
15:31.35dataw0lfand busted my head open
15:32.55herlooops
15:33.01herlosorry to hear that
15:33.16dataw0lfnah, I shouldn't have taken my helmet off
15:37.24dataw0lfhttp://www.chicagotribune.com/classified/automotive/columnists/chi-0701010141jan01,0,5874175.column?coll=chi-elections-utl
15:43.45*** join/#uphpu cyco|w (n=cyco@66.114.120.2)
15:44.14beandogg'morning all
15:44.22timinatormorning
15:49.32beandogherlo: is that your site
15:49.48herlobeandog: http://www.gamesutah.org, yeah
15:50.16dataw0lfmornin
15:58.57beandoglooks cool
15:58.59beandogwhat kinda games you into
16:15.34mindjujuwow, that's funny dataw0lf
16:15.35mindjujuOne United employee appeared emotionally shaken by the sighting and "experienced  some religious issues" over it, one co-worker said.
16:16.01mindjujucourse, what exactly that means is yet to be determined
16:16.42mindjujui'd guess crapping his pants and saying OMG!  would qualify as "some religious issues"
16:24.23*** join/#uphpu mgeary (n=mgeary@166.70.44.49)
16:24.28mgearymorning folks
16:24.45dataw0lfg'morning
16:25.04mgearyhey, semi-OT, but does anyone here use the "yum" package manager?
16:25.49dataw0lfyes.
16:25.55dataw0lfand it isn't OT
16:27.05mgearyi've got a hosted server that uses yum, and i'm trying to upgrade the MySQL version. Do you know how i configure yum to "know about" a more recent version?
16:27.31jsmithmgeary: Define a different repository in a .repo file in /etc/yum.repos.d
16:27.43dataw0lfchange your repos
16:28.05mgearyand how do i find a good repository?
16:28.40jsmithmgeary: Depends on your OS.  FedoraTracker.org for Fedora.  DAG is pretty good for Fedora and CentOS
16:28.58oldsrepository or supository?
16:29.01olds;)
16:29.03dataw0lfsuppository*
16:29.05mgearyheheh
16:29.19mgearyolds: you've been talking to my grandmother again, haven't you?
16:29.22dataw0lfI'm looking at the bottle right now...
16:30.19mindjujutalking about OT, fungus, did you see the latest from the RIAA ?
16:30.47fungusNope.  What they up to now?
16:30.56dataw0lfthe trillion dollar lawsuit?
16:31.05mgearyoh, yeah. that's just nasty
16:31.09mindjujuthey petitioned the Copyright Royalty board to adjust the rate that they are compensated
16:31.18mindjujuthey want more cut and leave the artists less
16:31.58mindjujuand by the way, I hear the EFF has a petition of like 90,000 signatures to ask Congress to not allow RIAA to sue individuals
16:32.03dataw0lfthey're a corporation, they have no moral obligations.  Their whole existence is based on making money.
16:32.16fungusNot surprised.  the greedy bastards are desperately trying to hang onto a dying business model that has screwed so many good artists.
16:32.34mindjujuv true
16:32.58*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
16:32.58*** mode/#UPHPU [+o macnewbold] by ChanServ
16:33.09macnewboldhehe
16:33.48mindjujuheh
16:34.00mgearyhy don't blame me, i voted for Pete
16:34.53mindjujui wonder what his Orrin's take from the RIAA is this year?  Last year in "campaign contributions" it was like 125k
16:34.55dataw0lfdon't hate Orrin, he supports the troops
16:35.02beandogOrrin is a half-wheat.
16:35.11beandogI hope he drowns in his own pool of ignorance and stupidity.
16:35.20dataw0lfjeez
16:35.25dataw0lfstop the hate, child!
16:35.59fungusI don't hate him, I detest his politics.
16:36.20beandogof course, I think all politicians are corrupt buttheads, so whatever.
16:36.23dataw0lfyou hate the troops!
16:37.57mindjujubrb
16:38.03fungusAnyone who can't handle an intelligent discussion about the politics of war just invoke the "You don't support our troops" crap.
16:38.13dataw0lfyea, go leave and receive your call from your terrorist friends!
16:38.27dataw0lffungus: I think it's awesome.
16:39.25fungusI mean, what in the hell does, supporting the troops have to do with holding our leaders responsible for their actions/decisions.  
16:39.43dataw0lfyou're a terrorist.
16:40.20funguslol, that's the other idiot argument.
16:40.51beandogI'm moving to canada
16:40.54beandogthey dont have any enemies.
16:41.06dataw0lfexcept wild, rampaging moose
16:41.07timinatorthey don't have any balls either
16:41.08fungusBow to RMS or... else.
16:41.38dataw0lftiminator: America has balls?
16:41.40dataw0lfhar
16:42.02dataw0lfa bunch of rich guys sending poor teenagers to collect resources for 'em.
16:42.09timinatorI'm not doin' it today DW
16:42.12dataw0lfyea, that's balls alright.
16:42.27dataw0lfI'm just sayin'.
16:42.42mgeary<dragging the room back to only semi-OT-edness> okay, so why is it that FedoraTracker only lists MySQL v.3.23.x ? am i not understanding something? I mean, that's a pretty dang old version....
16:43.41dataw0lfI see 5.0.22
16:43.57mgearyi'm assuming it's because the server's running FedoraCore3
16:43.59thebigdoganyone have any good podcast resources for tech/computer
16:44.29mgearybut i'm sure that mysql 5.x works on FC3... :/
16:44.33beandogwhats the latest fedora?
16:44.37beandogisnt it 5 or something?
16:44.40*** join/#uphpu macnewbol1 (n=mac@cg.dsl.xmission.com)
16:44.40mgearyyeah, think so
16:44.40*** mode/#UPHPU [+o macnewbol1] by ChanServ
16:44.40dataw0lfyea
16:44.51dataw0lfmgeary: upgrade to 4
16:45.34mgearyif i just download an RPM from mysql.com, can yum deal with that?
16:45.49thebigdogmgeary, you can roll your own
16:45.53dataw0lfprobably not
16:46.19beandogeven if you did get the latest mysql rpm, it would probably need deps that still isnt in fedora 3
16:46.46dataw0lfmgeary: what version of glibc are you using?
16:46.55jsmithbeandog: The lateset is FC6, and it comes with MySQL 5.0.27
16:47.12mgeary<PROTECTED>
16:47.28jsmithmgeary: Just do "yum localinstall /path/to/the/rpm/you/downloaded/mysql.rpm
16:47.35mgearythat's what i'm looking for
16:47.52fungusthebigdog: My fave podcasts are on the Twit network.  http://twit.tv  and IT conversations sometimes.
16:48.04dataw0lfmgeary: rpm -q glibc
16:48.15mgearyglibc-2.3.6-0.fc3.1
16:48.15thebigdogfungus, ty i check it out
16:48.47dataw0lfmgeary: download the rpm and give 'er a try, then.
16:50.22mgearywould the Red Hat Enterprise RPM work on Fedora? (more of a FreeBSD/OS X user than a Linux user). Or should i go with the "generic" linux RPM?
16:52.06dataw0lfno idea, I don't use Fedora.
16:52.23dataw0lfI'd probably go with the generic package.
16:53.03jsmithmgeary: You can try it...
16:53.20jsmithI'd probably try the RHEL one first
16:56.32beandogoh my gosh, skype wins the worst website ever award.
16:57.22beandogfirst of all, its a navigation nightmare
16:57.27beandogand if you go to the homepage, it logs you out.
16:58.04dataw0lfand it's ridiculously ugly
16:59.03jsmithWell, what more can you expect from a car with the hood welded shut?
17:00.28dataw0lfthat it has a new change of oil?
17:13.40*** join/#uphpu fungus (n=fungus@2001:470:1f00:645:250:8dff:fe71:9a6b)
17:13.40*** mode/#UPHPU [+o fungus] by ChanServ
17:19.44oldswhy do you hate freedom?
17:30.10dataw0lfnow freedom must be fundamental, in Johannesburg, or South Central
17:30.25dataw0lfon the mic, cuz someone should tell em, to kick in the township rebellion
17:30.30dataw0lfyeaaaa, what about that, sucka?
17:30.59*** join/#uphpu jsmith (n=jsmith@70.5.246.8)
17:30.59*** mode/#UPHPU [+v jsmith] by ChanServ
17:37.28dataw0lffor all the diamonds, they'll use a pair of clubs to beat the spades
17:37.46dataw0lfI mean, c'mon, even if you don't like RATM, you gotta recognize that those are some pretty clever lyrics
17:47.55*** join/#uphpu macnewbol1 (n=mac@cg.dsl.xmission.com)
17:47.55*** mode/#UPHPU [+o macnewbol1] by ChanServ
17:53.58mgearyspeaking of freedom...
17:54.01mgearyhttp://www.thecarpetbaggerreport.com/archives/9513.html
17:54.09mgearywhile we're OT anyway ;)
17:55.43*** join/#uphpu swb (n=designsi@70.98.111.41)
17:55.49*** mode/#UPHPU [+v swb] by ChanServ
17:57.10dataw0lfmgeary: dude he has to read our mail cuz of all the terrorists.
17:57.56mgearyyeah, and, uh, you know, if you're not sending/receiving illicit mail, um, WHY do you have a problem with it, riiiiiight?  9.9
17:58.19mgeary*sigh*
17:58.28fungusThis is why everyone should have an SMIME cert, or a PGP key
17:58.55mgearyfungus: hard to PGP sign a first-class, US postal service letter ;)
17:59.24dataw0lfmgeary: xactly.  you must be sending bombs through the mail.
17:59.45mgearyah, see, i always send my bombs via FedEx
18:03.06dataw0lffreedom isn't that important anyways.
18:03.45mgearywell, now the terrorists have less to hate us for
18:04.32dataw0lfI don't think the terrorists hate us because of our freedom.
18:04.43beandogseriously.
18:04.49mgearywell then you're not listening ;)
18:04.51beandogthey hate us for poking our fingers in every international scenario.
18:04.56dataw0lfbeandog: so true
18:04.58beandogwhich, I really cant blame them.
18:04.59dataw0lfspecifically, Israel.
18:05.16dataw0lfmgeary: oh, I listen just fine.
18:05.46*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
18:05.46*** mode/#UPHPU [+o macnewbold] by ChanServ
18:06.20dataw0lfjust enclose it in tags
18:06.26mgearyhehe
18:09.08gibba[w]anyone in here ever worked with the Omniture services?
18:09.21dataw0lfjsmith used to work for Omniture.
18:09.46jsmithI probably know way too much about them ;-)
18:09.58dataw0lfI wish we had someone who used to work for WebTrends so I could get this dang scenario analysis
18:10.02dataw0lfworking*
18:10.15gibba[w]we just had a web conference with them ... pretty impressive stuff
18:10.19jsmithBut as a former Omniture employee, I can honestly say their product rocks!
18:11.14gibba[w]yeah i was pretty wowed by its sheer massiveness and feature rich  ... ness
18:11.44jsmithdataw0lf: Naw, they stopped paying me when I stopped working for them
18:12.09dataw0lflies!
18:12.41dataw0lfthe twin towers were detonated from within on 9/11!
18:13.05dataw0lfgrassy knoll...
18:13.08dataw0lfmeh
18:13.38gibba[w]btw ... dataw0lf ... was good to meet ya while you were here ... you commin around again any time soon?
18:13.47dataw0lfnext friday
18:13.58mindjujugeek lunch gibba[w] - you going?
18:14.31gibba[w]where at?
18:14.33synicoh sweet, where's the foodz this time?
18:14.50mindjujuKyoto Resturant - 1/12/07 - 1p
18:15.04synicjapanese?
18:15.08dataw0lfyou get a free dataw0lf with every meal
18:15.09mindjujuyup
18:15.12synicsweet.
18:15.24gibba[w]yeah i'll be there
18:15.38mindjujucoolio ,  2 more people coming
18:15.47dataw0lfmindjuju: I'm coming, I already told you this
18:15.58mindjujuyup, i gots your RSVP
18:16.04gibba[w]dataw0lf: get my cell # from optikal when you get in town and hit me up ... we can party like rockstars
18:16.16dataw0lfno, no, no 'like'
18:16.24dataw0lfwe're going to party cuz we are rock stars!
18:17.18dataw0lfok, seriously, I cannot find any documentation on how to troubleshoot scenarios in WebTrends
18:17.36dataw0lfI added the meta tags to the pages
18:17.46dataw0lfand just to be safe I defined the exact urls for each step
18:18.04dataw0lfnot working
18:19.37thebigdogclearfield is getting pounded with snow
18:19.44thebigdogdrip, you better come home early
18:19.53*** join/#uphpu _psychic_ (n=_psychic@71.32.228.156)
18:19.53*** mode/#UPHPU [+v _psychic_] by ChanServ
18:19.56dripoh yeah?
18:20.06dripalready sticking to the streets?
18:20.12thebigdogoh yeah
18:20.21dripwe're getting snow too but it's not sticking yet.
18:20.44dripI'd love to come home and have a siesta
18:20.48thebigdogwe got about 2in
18:21.37mindjujudraper's got jack ... just cold and raining
18:21.40mindjujureminds me of houston
18:24.04dataw0lflots of snow over hurr
18:25.02dataw0lfwhat do you guys think of JS that tracks actual mouse movements then uses XHR to store them at intervals, then creates a heat map out of it?
18:25.23dataw0lfcrazyegg.com creates a heat map, but it's lame because it just shows where people have clicked
18:26.05dataw0lfthink it's feasible to create something that actually tracks mouse movement and stores it via XHR?
18:30.31swbhow would you know if the mouse was lifted off the mousepad?
18:30.43swbI think eye tracking is better http://www.eyetools.com/
18:31.58dataw0lfsure eye tracking is better.
18:32.15dataw0lfhow am I supposed to track that with JavaScript, though?
18:33.37dataw0lfthe basic premise is that mouse location, when averaged together in an algorithm, may show some useful information in a heat map
18:33.49dataw0lfI know that I highlight everything I read to facilitate speed reading
18:35.13swbsounds innovative, I haven't seen anything like that before
18:36.21dataw0lfyou think it's worth a try?
18:36.55dataw0lfI started hacking at the code a couple days ago but got distracted with the Firefox Addon API
18:37.55swbyeah, sounds like something you could market (almost like an expansion on the crazyegg click map)
18:38.04swbwhat does everyone else think?
18:38.40swbjsmith? optikal?
18:39.31jsmithswb: I try not to think between the hours of 8:30am and 5:30pm
18:55.38*** join/#uphpu burnin (n=burnin@42dbe40e.dsl.aros.net)
18:57.07gibba[w]hang on whats goin on?
18:58.37dataw0lfthinking of creating a JavaScript / Python app that detects mouse location with JS then sends it in an XHR to a Python script that takes that data and stores it, then can create a heatmap based upon collected data
19:01.19optikalinteresting indeed
19:01.33dataw0lfrather than this click heatmap crap
19:02.36optikalYou should definitely do it.. I'd happily play with it on our sites and see what kind of results it gets
19:03.08optikalI'm ordering that JS book today
19:03.42optikalProb be a lil till I can get around to it though, got some a Python idea I wanna get rolling first
19:10.37*** join/#uphpu wps_ (n=wps@67.108.236.230.ptr.us.xo.net)
19:33.35*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
19:33.35*** mode/#UPHPU [+o macnewbold] by ChanServ
19:34.17macnewboldanyone know what "Far End RS FEC (I/F)" means in the WAN stats on an actiontec gt701 means? I've got 45/0 in about 90 min and I think that might be bad
19:34.24macnewboldI've been having terrible luck with my connection lately
19:36.56mindjujuheat maps and JS?  no way!  the best way to see what your clients are doing is with bo2k!
19:38.41fungusmacnewbold: http://www.broadbandreports.com/faq/13287
19:38.47mindjujurhyming was unintended
19:38.52fungus45, doesn't sound bad enough to worry about.
19:43.04fungusMy Far End RS REC is at 6161/0 after 9 days.  About the same as yours.
19:43.19macnewboldhm, okay
19:43.38macnewboldI'm totally frustrated with my stupid actiontec
19:43.44macnewboldthe cisco was supposed to arrive yesterday
19:43.55fungusOoh, which cisco?
19:44.00macnewboldbut the fedex guy went back to the station without delivering it
19:44.02macnewbold678 of course ;)
19:45.02dataw0lfmacnewbold: Yea, Far End RS FEC would be huge if that was a problem
19:45.40dataw0lfJust get rid of that Craptiontec asap, I hate those dang things.
19:45.42fungusahh, they are good, but I was going to be super super jealous if you said it was an 800 series router.
19:45.54macnewboldoh, I wish
19:49.00fungusThis card would be fun, if you had a PC as your router.
19:49.01fungushttp://www.sangoma.com/datasheets/p_s518adsl-specs
19:50.35macnewboldyeah
19:51.31dataw0lfhttp://stderr.ws/dump/homockup.png yea / nay ?
19:51.35dataw0lfoptikal / gibba[w] ?
19:56.18dataw0lfcool
19:56.43dataw0lfI thought it looked like crap, shows how much I know about design.
19:56.45dataw0lf(nothing)
19:58.43optikalNot Found now
19:58.49dataw0lfyea, just removed it
19:58.52optikalI musta been too slow~
20:00.30gibba[w]dataw0lf, are those particular shades of orange a necessity?
20:00.30gibba[w]cause it feels a bit overpoweringly contrasty and bright
20:00.34optikalI WISH I KNEW WHAT ORANGE YOU WERE TALKING ABOUT :(
20:00.57dataw0lfplz don't do that mindjuju
20:01.05mindjujubro, wouldn't do that to ya
20:01.20dataw0lfk
20:01.20mindjujubut i did see it and like it
20:01.34dataw0lfcuz my NDA would possess me and force me to put a boot in yer butt
20:02.01mindjujubrb
20:02.21dataw0lfmindjuju: I know you wouldn't, I wouldn't post it in here if I thought it'd be a problem.
20:03.36dataw0lfalright, lunch time, I'm gonna go make a sammich
20:03.48dataw0lfand work on this heatmap code at my desk
20:27.45*** join/#uphpu Black_Ch1os (n=admin@70-57-91-148.slkc.qwest.net)
20:29.09*** join/#uphpu jakea (n=jakea@128.187.205.163)
20:47.30*** join/#uphpu Lone_Wanderer (n=chatzill@c-67-166-97-184.hsd1.ut.comcast.net)
20:47.30*** mode/#UPHPU [+v Lone_Wanderer] by ChanServ
20:47.48Lone_WandererBonjour
20:55.37*** join/#uphpu Black_Chaos (n=admin@70-57-91-148.slkc.qwest.net)
20:56.49*** join/#uphpu jsmith (n=jsmith@70.5.246.8)
20:56.49*** mode/#UPHPU [+v jsmith] by ChanServ
20:58.55dripthebigdog: still snowing up there?
20:59.03thebigdoga little
20:59.07driphow much did you get?
20:59.10thebigdogbut still comin down
20:59.14thebigdogabout 3in
20:59.30dripnot too bad then
21:00.33thebigdognot too bad...but you might need a lttle more time commuting home
21:04.59dataw0lfconsidering that SLC drivers are the worst in the country
21:05.09Lone_WandererOh crap, I forgot that it's snowing up there.
21:05.39fungusEww, yuck.  It's snowing?
21:05.52Lone_WandererThat's what I heard anyway.
21:05.53fungusah, hell.  this sucks.
21:06.46Lone_Wanderermacnewbold: ping
21:08.04macnewboldLone_Wanderer: pong
21:08.12Lone_WandererCan I PM you?
21:08.28macnewboldI don't know, can you?
21:08.31macnewboldgo ahead
21:35.49beandogslc drivers are way too slow.
21:36.11swbdepends on where you are in in the valley, imo
21:36.27swbI think ppl drive faster the more West you are
21:37.08thebigdogall drivers suck
21:37.18swbhehe
21:37.23swbtrue!
21:37.29thebigdogincluding myself
21:45.46*** join/#uphpu brasto (n=brasto@71-219-149-94.slkc.qwest.net)
21:45.46*** mode/#UPHPU [+v brasto] by ChanServ
21:46.26brastois daniel crookston one of the #uphpu frequenters?
21:46.35dataw0lfhe just quit
21:46.44dataw0lfDan == Lone_Wanderer
21:46.51brastoah, ok
21:46.57brastomight he be back again soon?
21:47.08dataw0lfprobably
21:48.35brastoi have a question for you dataw0lf... let me find the link first...
21:50.22dataw0lfk
21:50.39brastohttp://forums.mysql.com/read.php?100,122988,122988#msg-122988
21:51.39brastomore info:the only MySQL limit on VIEWS is no subqueries in the FROM clause.  
21:52.07brastoand other self-join queries work fine.
21:52.57thebigdogwhat is the error you get when you create the view?
21:53.10brastono error when i create it
21:53.53brastoit creates fine, and runs fine as a query
21:54.11brastobut the view statement changes as indicated in that thread
21:54.16dataw0lfyou only get the error when you select from the view?
21:55.02brastoyes, and that error is something like "Ambiguous field: groupName"
21:55.20dataw0lftry putting backtics around groupName
21:55.25thebigdogchange your alias to something else
21:55.28thebigdogliek gName
21:56.10brastoi'll try that now. one moment...
21:56.32brastoi think i tried it once, but i don't remember the result
21:57.14dataw0lfthebigdog: backticks would accomplish the same thing
21:57.37thebigdogperhaps
21:57.49dataw0lfsure it would.
21:59.45brastodataw0lf - same result.  the error is: Column 'GroupName' in field list is ambiguous
22:00.04brastoin the original statement, it is not ambiguous
22:00.14thebigdogwhat?
22:00.30thebigdogif you run the select statement alone does it work?
22:00.49brastohowever, MySQL breaks the FROM clause when it makes a VIEW, so it becomes ambiguous
22:01.21thebigdogwhen you say breaks? what does it do?
22:01.40thebigdogremoves the alias to the tables?
22:02.28dataw0lfwhat MySQL version?
22:02.51dataw0lf4.1?
22:04.20brastodataw0lf - mysql version 5
22:04.29brastoonly version 5+ supports views
22:04.56brastoby "breaks", I mean the from clause changes from this
22:05.07brastoFROM MyABgroup AS node,
22:05.08brastoMyABgroup AS parent
22:05.14brastoto this:
22:05.23brastoFROM MyABgroup
22:06.09macnewboldhave you tried running "explain" on it? both as a query and as a create view statement?
22:06.19macnewboldhm
22:06.37brastothebigdog - I've installed pgsql, but have not been able to use it as i don't know the default password.
22:06.51thebigdogwhat os?
22:07.03dataw0lfsu postgres
22:07.05dataw0lfadduser
22:07.07dataw0lfor whatever it is
22:07.16brastofreebsd and suse and windows - tested on all
22:07.19macnewboldyou might try matching up all the groupName and GroupName instances - it might not like the name differences
22:07.54brastoI removed groupName, and changed it to theGroup
22:09.12brastoexplain - does that go before the entire statement?
22:10.03dataw0lfyes
22:12.14brastoi'm not sure how to interpret the result, but:
22:12.27thebigdogi think it has to do with the handler
22:12.37brastoid select_type table type possible_keys key key_len ref rows Extra
22:12.45brasto1  SIMPLE  node  ALL  UniqueLeft  NULL  NULL  NULL  34  Using temporary; Using filesort
22:12.54brasto1  SIMPLE  parent  ALL  UniqueLeft, UniqueRight  NULL  NULL  NULL  34  Range checked for each record (index map: 0x6)
22:13.00brastothat's the result
22:13.03dataw0lfthebigdog: possibly
22:13.49thebigdogbrasto what db engine you using myisam?
22:14.04brastomyisam
22:16.09brastoexplain create view does not work:
22:16.26brastoYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE VIEW viewGroupTree AS
22:16.34dataw0lfno, explaining on a view is done like so:
22:16.45dataw0lfexplain select * from <view>;
22:17.24dataw0lfexplain only goes before select statements.
22:18.05brastowould it be helpful to run that since we know the problem anyway? namely, that the FROM clause loses the 2 aliases to the same table for a self-join?
22:19.09thebigdogbrasto...take dw's suggestion and see if quoting everythings helps
22:19.34brastobacktics for table names?
22:19.42brastoif so, trying now
22:20.01thebigdoglike SELECT `node`.`GroupID`
22:20.43dataw0lfdunno, might be a legitimate bug
22:21.00thebigdogperhaps
22:23.39brastobackticks around table and field names yields the same results
22:25.49brastook, i'll see if i can reach someone on the dev team at MySQL
22:25.57brastoany ideas on how to do this?
22:26.29brastohere's another, much simpler question:
22:27.36brastoI like doing everything possible at the database level.  For this, MySQL views make a great tool.
22:27.52beandogviews++
22:28.10mindjujuman!  it's snowing like a maddog out here!
22:28.15brastoeg: Instead of a long select statement joining tables in a properly normalized database, use a view, and put this in your php code:
22:28.53thebigdogviews are nice...and view of view x2
22:29.04brastoselect [fieldNames] from [ViewName] where [FilterTheResults];
22:29.41brastolooks like beandog and thebigdog agree
22:29.51brastoany other thoughts?
22:29.53thebigdogtoo bad mysql does not support materialized views
22:30.07thebigdogdrip loves those
22:30.18brastomaterialized views?
22:30.25thebigdogupdatable views
22:30.36brastoah
22:30.47thebigdogoracle supports them...pgsql no :(
22:30.59brastosort of like a transaction-capable view?  it auto updates the original table?
22:31.04thebigdogthere might be limited support in psql
22:31.08jsmiththebigdog: pgsql doesn't support materialized views?
22:31.14brastothat can get complex when you have joined tables...
22:31.23thebigdogi thought there was a package for it
22:31.54thebigdoghttp://www.jonathangardner.net/PostgreSQL/materialized_views/matviews.html
22:32.11thebigdogits a semi-hack
22:32.48brastoi'm not sure i would ever want to update through a view
22:32.57brastothat just doesn't seem safe to me
22:33.06thebigdogyeah it really is limited to do...but a nice feature
23:36.54*** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com)
23:36.54*** mode/#UPHPU [+o macnewbold] by ChanServ
23:42.08*** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net)
23:42.08*** mode/#UPHPU [+o wps] by ChanServ
23:42.35*** part/#uphpu mgeary (n=mgeary@166.70.44.49)
23:48.29dataw0lfmy hair has now reached 4 inches.  Huzzah!
23:54.03wpsreminds me that I need a haircut
23:56.47dataw0lfanyone seen Brady lately?
23:56.59_psychic_No idea why someone would want 4" nose hair. None.
23:59.08dataw0lf_psychic_: one word: braids.
23:59.30dataw0lfIf anyone sees Brady tell him to give me a holler (I think he's 'bradym')

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.