irclog2html for #uphpu on 20050815

02:16.22*** join/#uphpu synic (n=synic@c-67-177-16-249.hsd1.ut.comcast.net)
03:15.22bigdog_utwhatz up all?
03:16.03synicjust getting ready to go to bed
03:17.30bigdog_utwhat?
03:17.36bigdog_utit is only 9am
03:17.38bigdog_utlol
03:17.41bigdog_ut9pm
03:18.40synicgetting ready means playing foobillard for an hour or two, and ircing meanwhile.
03:18.57bigdog_utnice
04:52.33dataw0lf-sup guys
04:52.51dataw0lf-I miss you man!
04:52.53dataw0lf-*sniff*
05:38.52*** join/#uphpu cycoboy (n=cycokilr@c-67-166-121-149.hsd1.ut.comcast.net)
06:39.05*** join/#uphpu dataw0lf__ (n=dataw0lf@c-24-10-173-249.hsd1.ut.comcast.net)
07:14.11*** part/#uphpu dataw0lf__ (n=dataw0lf@c-24-10-173-249.hsd1.ut.comcast.net)
13:24.32*** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com)
13:48.39*** join/#uphpu dataw0lf (n=dataw0lf@66.219.227.114)
14:13.45*** join/#uphpu mindjuju (n=mindjuju@216.20.238.225)
14:17.42*** join/#uphpu wps (n=wade@66.237.80.85)
14:17.50*** mode/#uphpu [+o wps] by ChanServ
14:53.04*** join/#uphpu tr0gd0rr (n=icechat5@12.174.39.194)
14:54.42macnewboldcheck this out, yall:
14:54.44macnewboldhttp://www.embeddedarm.com/news/netbsd_toaster.htm
14:59.37tr0gd0rrthat's rad... i think i need a toaster in my office now
15:02.06*** join/#uphpu mindjuju (n=mindjuju@216.20.238.225)
15:09.24*** join/#uphpu diskotec|w (n=virc@12.125.156.114)
15:20.33*** join/#uphpu osynic (n=synic@pdpc/supporter/student/synic)
15:22.42*** join/#uphpu synic (n=synic@66.239.17.226.ptr.us.xo.net)
15:33.44*** join/#uphpu jsmith (n=jsmith@64.50.35.114.2O7.net)
15:35.06*** join/#uphpu Utah_Dave (n=boucha@0-1pool138-31.nas28.salt-lake-city1.ut.us.da.qwest.net)
15:57.03scottuh oh. I was sending out about a thousand emails with php through IIS and after a few minutes I got a CGI timeout error saying the process was deleted because it took too long. any ideas of a way to figure out how many emails it sent out before it died?
15:57.33scottI know it sent out quite a few
15:57.54mindjujuthe fastest way is through the email server
15:58.12mindjujuare you relaying through an email server or just from the web server?
15:58.23scottrelaying through an email server.
15:58.37scottand I don't have access to its logs
15:58.46mindjujuhmmm
16:01.57mindjujuwhile i think PHP can document the error, if logging enabled, i don't think it will tell you where it stopped.
16:02.41dataw0lfnot unless you specify it.
16:05.47scottalright, found the email server admin
16:06.14scotthe gave me the last few emails queued, now to see if what order php was sending them in (or what order mysql gave them)
16:06.20mindjujuway cool!  what program ya'll running for mail?
16:07.14dataw0lfI'm aguessing Exchange.
16:07.37wpsaguessing?
16:07.42Utah_Davehey dataw0lf:  how was defcon?
16:07.56*** join/#uphpu fungus (n=fungus@firebat.aros.net)
16:08.03dataw0lfUtah_Dave: adventuresome.
16:08.04mindjujuhey wps, your college grad now, aren't ya?
16:08.10wpsindeed
16:08.10dataw0lfwps: yes, aguessing, shuddup.
16:08.14wps:)
16:08.17mindjujucongrats!
16:08.17synicdataw0lf: how early is too early to call tierra?
16:08.22*** part/#uphpu fungus (n=fungus@firebat.aros.net)
16:08.22dataw0lfsynic: right now
16:08.33dataw0lfactually
16:08.36syniclazy sonofa
16:08.36dataw0lfcall his ass
16:08.49synicI'll wait another hour
16:08.51scottmindjuju: no clue, he was grepping the logs on a tru64 system is all I know
16:09.00dataw0lfsynic: screw that, I'm calling him if you don't.
16:09.12synicalright... tell him to call me.
16:09.15synic:P
16:09.15dataw0lfk
16:10.25dataw0lfhehe
16:10.28*** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a)
16:10.29dataw0lfdone
16:11.10dataw0lfhe probably went to sleep right after I woke him up so I wouldn't count on him calling in the next hour or so.
16:11.28dataw0lfit took him 5 minutes to get the phone to his ear
16:12.31synichaha, he called.
16:12.49mindjujuscott: he should be able to give you some indicator of where it stopped if he is searching (grep) the logs.  Not familiar with tru64 -- we are using mercury mail
16:17.29dataw0lftru64 you say?
16:17.36dataw0lfI'm Tru64 SE certified.
16:17.46dataw0lfyou're using a Tru64 machine for a mail server?
16:17.51dataw0lfthat makes the baby jesus cry.
16:18.00mindjuju!
16:18.02mindjujulol!
16:19.14mindjujuthe only thing i know about tru64 is that it is Unix based.  what up with it?
16:23.13dataw0lfit's ok.
16:23.19dataw0lfbest filesystem in the world.
16:24.42mindjujuthat sux, i just realized i missed the bbq.  
16:24.55dataw0lfyeah, thanks alot.
16:25.26mindjujudid you further hurt your karma with the gnawing on meat and such?
16:25.54dataw0lfoh, yeah, I was eating an italian sausage with juice dripping down my chin right in front of fungus with a big smile.
16:26.02dataw0lfI believe I even mentioned something about how evil I was, yes fungus?
16:26.10mindjujunice!
16:26.48dataw0lfmmmm italian sausage.
16:26.53dataw0lfgod that stuff is good.
16:27.13dataw0lfit's like crack but, like, better
16:27.16funguseww.
16:27.39mindjujulove italian sausage...
16:27.43dataw0lffungus: did you see my soul escaping from my body in little puffs as I ate the sausage?
16:28.08synicpff, your soul escaped a long time ago
16:28.32scottalright, so I found the last person who was emailed, but I'm a little confused: in what order does MySQL give you records when you don't give it an ORDER BY?
16:29.09jsmithscott: It could be in any order...
16:29.47mindjujuactually, scott, all things being equal, you should be able to find out who needs to be emailed by taking the query out of the PHP page you wrote and copy that to a new page and have it display the results
16:29.57mindjujuthen find on the page the last email addy that was sent to
16:30.08mindjujuthe ones below should be the ones you have yet to send to
16:30.14mindjujuall things being equal
16:30.19scottit looks like reverse alphabetical order on the last name
16:31.00scottyeah, the problem is this program won't let me just put in a list of emails..it only takes a query statement
16:31.19scottso I need to write a query to get only the records after the last one that was emailed
16:32.43mindjujuso just to double check, it appears that the query pulled reverse alphabetical?  i would have thought it'd pull in the order of record creation
16:33.13scottSELECT DISTINCT t1.email, CONCAT(t1.firstname,' ',t1.lastname) AS name FROM dinner_invitees AS t1 LEFT JOIN dinner_attendees AS t2 ON t1.email=t2.email WHERE t2.email IS NULL
16:33.53scottsame here, but it doesn't look like it.
16:35.27mindjujuwell, i'd say the way to go would be to mod your sql statement to use between (seems like MySQL has this function though I know MSSQL does)
16:39.00mindjujuand say the last person was john smith, you'd mod your statement to
16:39.01mindjujuSELECT DISTINCT t1.email, CONCAT(t1.firstname,' ',t1.lastname) AS name  
16:39.01mindjujuFROM dinner_invitees AS t1  
16:39.01mindjujuLEFT JOIN dinner_attendees AS t2 ON t1.email=t2.email  
16:39.01mindjujuWHERE t1.lastname
16:39.01mindjujuBETWEEN 'Smith' and 'A'
16:39.02mindjujuAND t2.email IS NULL
16:44.11mindjujuactually, i think i used that wrong, i think you have to mention the earliest letter first, then the later, so it would be BETWEEN 'A' AND 'Smith'
16:44.16scottI can't find BETWEEN in the mysql docs
16:44.20mindjujudang
16:44.45mindjujulet me see if i have an instance of mysql somewheres
16:49.33mindjujuk, scott, here is the deal
16:49.42mindjujuyou know it is in reverse order
16:49.53mindjujuso, you can say this
16:49.55mindjujuSELECT *  
16:49.55mindjujuFROM `users`
16:49.55mindjujuWHERE `lname` < 'G'
16:50.36mindjujuyou don't need to specify the other end, because you want it to include all records
16:50.45mindjujuso, lets mod your original statement
16:52.22mindjujui beleive it should look like this
16:52.23scottalright, got that
16:52.23mindjujuSELECT DISTINCT t1.email, CONCAT(t1.firstname,' ',t1.lastname) AS name  
16:52.23mindjujuFROM dinner_invitees AS t1  
16:52.23mindjujuLEFT JOIN dinner_attendees AS t2 ON t1.email=t2.email  
16:52.23mindjujuWHERE t1.lastname < 'Smith'
16:52.23mindjujuAND t2.email IS NULL
16:52.41mindjujubut, test it out first to make sure you get the results you need
16:53.06mindjujui've had about total 15 hours sleep over last several days
16:53.14mindjujunot sure my figurin' is as good as it should be
16:54.42scottyeah, I've been testing it in mysql-front
16:55.15mindjujuway cool
16:57.23scottI'm not sure it's in reverse alphabetical order on last name though now :)
16:58.45macnewboldyou could use a limit statement
16:58.47macnewboldto get the right set
16:59.12macnewboldor use lname not in ('name1','name2',...'name328');
16:59.17macnewboldto get the ones that weren't sent yet
17:01.50mindjujumac
17:02.28mindjujuyo mac!
17:02.32mindjuju~wake mac
17:02.32jbotmac: GOOD MORNING!!!
17:07.57scottSELECT DISTINCT t1.email, CONCAT(t1.firstname,' ',t1.lastname) AS name FROM dinner_invitees AS t1 LEFT JOIN dinner_attendees AS t2 ON t1.email=t2.email WHERE t1.lastname < 'Fox' OR t1.lastname > 'Ward' AND t2.email IS NULL
17:08.55scottbizarre ordering. it gave me the names in reverse alphabetical order starting at ward, down to A, then gives the ones at the end (rest of W, Y, Z)
17:09.41scottI think there might be some problem with the end of that select statement though
17:10.22scottlike the OR and AND are maybe wrong. how do I get the AND to apply to both the t1.lastname < 'Fox" and the t1.lastname > 'Ward'?
17:10.59scottWHERE t2.email IS NULL  AND t1.lastname < 'Fox' OR t1.lastname > 'Ward'
17:13.00scottthat looks right
17:18.35macnewboldmindjuju: sup?
17:18.50macnewbold(you have to say "macnewbold" or it doesn't make any noise...)
17:19.05macnewbold(if I had a dollar for every time someone said mac but wasn't talking about me...)
19:32.24*** join/#uphpu Alphahawk (n=Alphahaw@70.56.105.158)
20:08.13*** join/#uphpu tierra (n=tierra@dsl093-225-126.slc1.dsl.speakeasy.net)
20:12.52*** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a)
20:53.13*** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a)
20:53.28*** join/#uphpu Utah_Dave (n=boucha@0-1pool138-31.nas28.salt-lake-city1.ut.us.da.qwest.net)
21:31.50*** join/#uphpu Ruis (n=ruise@71.4.77.130.ptr.us.xo.net)
21:32.22Ruisi know this is a *nix question, but does anyone know if it's possible to change permissions on a file that you are not the owner of, but are in the group that file belongs to?
21:33.26fungusI believe you can if you have write access to the file.
21:39.25*** join/#uphpu diskotec|w (n=virc@12.125.156.114)
21:39.29*** join/#uphpu tierra (n=tierra@dsl093-225-126.slc1.dsl.speakeasy.net)
21:41.16*** join/#uphpu wps (n=wade@66.237.80.85)
21:41.20*** mode/#uphpu [+o wps] by ChanServ
21:43.56*** join/#uphpu synic (n=synic@66.239.17.226.ptr.us.xo.net)
21:44.10*** part/#uphpu Ruis (n=ruise@71.4.77.130.ptr.us.xo.net)
22:21.18fungusdataw0lf's home video.  http://www.bpninc.com/evideo/video_mac_hi.mov
23:15.27*** join/#uphpu eco|w (n=eco@dsl093-225-126.slc1.dsl.speakeasy.net)
23:24.48*** join/#uphpu eco|w (n=eco@dsl093-225-126.slc1.dsl.speakeasy.net)

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.