IRC log for #uphpu on 20070820

01:21.29*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
01:21.29*** mode/#UPHPU [+v beandog] by ChanServ
01:34.56*** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com)
05:03.15*** join/#uphpu influx^^ (n=influx@influx.dsl.xmission.com)
08:25.41*** join/#uphpu orsonj (n=orson@b22222.bookstore.usu.edu)
10:51.37*** join/#uphpu wps (n=wps@208.53.47.251)
10:51.38*** join/#uphpu dataw0lf (i=dataw0lf@stderr.ws) [NETSPLIT VICTIM]
10:51.38*** mode/#UPHPU [+ov wps dataw0lf] by irc.freenode.net
13:07.18*** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt)
13:07.19*** topic/#uphpu is August meeting postponed until twenty-third. Sheri Bigelow presents on SEO and PHP. | UPHPU | http://www.uphpu.org
13:07.19*** mode/#UPHPU [+v jbot] by ChanServ
14:14.37*** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net)
14:14.37*** mode/#UPHPU [+v timinator] by ChanServ
14:14.57timinatormawnin
14:56.54*** join/#uphpu _psychic_ (n=_psychic@66.7.114.125)
14:56.54*** mode/#UPHPU [+v _psychic_] by ChanServ
15:05.23*** join/#uphpu mgeary (n=mgeary@166.70.44.49)
15:05.23*** mode/#UPHPU [+v mgeary] by ChanServ
15:10.47*** join/#uphpu influx^^ (i=influx@hektik.org)
15:12.34*** join/#uphpu wps (n=wps@64.0.193.149)
15:12.34*** mode/#UPHPU [+o wps] by ChanServ
15:18.39*** join/#uphpu fungus (n=olsonl@mailhub.sosstaffing.com)
15:18.41*** mode/#UPHPU [+o fungus] by ChanServ
15:22.07*** join/#uphpu SunSparc (n=sparky@66.7.114.125)
16:18.22*** mode/#UPHPU [+v orsonj] by ChanServ
16:27.27orsonj~asbestos email list
16:31.21orsonj~asbestos the email list
16:31.22jbotACTION sprays asbestos over the email list to mitigate the flames.
16:34.48wpsthanks, orsonj
16:35.07wpsno we're all going to dy
16:35.10wpsdie
16:35.22wpsnow we're all going to die
16:42.45SunSparcDeath to the Aristoe!  Long live the Republic!
16:43.35influx^^~apb jbot
16:43.36jbotACTION summons Tim to rough up jbot
16:46.42*** join/#uphpu gibba[w] (n=gibs@209-253-35-18.ip.mcleodusa.net)
16:47.35*** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net)
16:47.35*** mode/#UPHPU [+o thebigdog] by ChanServ
16:51.33timinatorsql question for ya'll
16:51.44timinatorthis doesn't work:
16:51.46timinatorSELECT b1.id, b1.ship_date, b1.picked_up_mill, b1.status FROM bible_mill_orders as b1, bible_mill_items as b2 WHERE b1.id = b2.order_id AND b1.id>20799 AND b2.product_id='4' GROUP BY b1.id ORDER BY b1.id DESC LIMIT 30
16:52.09timinatorbut there are a TON of orders w/ product_id #4
16:52.41timinatorshould I be doing a JOIN rather than this?
16:56.37SunSparcThat is a type of JOIN.
16:56.58SunSparcJust without the keywords and typical JOIN formatting.
16:57.05timinatoroh
16:58.06timinatoris b1 or b2 a reserved keyword?
16:58.09SunSparcTry taking off your conditions and add them one at a time to see if you are getting results.
16:58.13SunSparcNo
16:58.16timinatork
16:59.18thebigdogthat should work, i would take off the group by and order by first
16:59.36thebigdogyou might need to have all the selected columns in your group by
16:59.37timinatoroh wait.... I just used the SQL outside of the rest of the PHP app, and it worked..... so I must be looking at the wrong problem
17:00.01SunSparcGood catch
17:00.09timinatorthanks SunSparc and thebigdog
17:00.32SunSparcThat's what we are here for. :)
17:03.32timinatorso, on a query like that..... let me paste the current version:
17:03.47timinator<PROTECTED>
17:03.47timinatorFROM bible_mill_orders AS b1, bible_mill_items AS b2
17:03.48timinatorWHERE b1.id = b2.order_id
17:03.48timinatorAND b1.id >20799
17:03.48timinatorAND b2.product_id = '4'
17:03.48timinatorGROUP BY b2.order_id
17:03.50timinatorORDER BY b2.order_id DESC
17:03.52timinatorLIMIT 30
17:04.59timinatorso, is that pulling only the first bible_mill_items record for that b1.id, and checking just that record for product_id #4?
17:05.12timinatoror is it pulling all of the b2 records?
17:07.24timinatorI could make the query simpler for this question:
17:07.38thebigdognot sure i would have to see the result set
17:08.07SunSparcI believe it follow a Left to Right order of operations.
17:08.18timinatorSELECT b1.* FROM orders as b1, items as b2 WHERE b1.id = b2.order_id AND b2.product='4' GROUP BY b2.order_id ORDER BY b2.order_id
17:08.29timinatorthere... that's a little simpler
17:09.11thebigdogwhat is your question again
17:09.19SunSparcSo I should be taking "b1.id = b2.order_id" and comparing that until it gets a match before it applies any other conditions.  Someone else correct me if I am wrong.
17:09.41SunSparcit not I
17:10.24timinatorwell, if I've got an order that has say 4 items on it.....
17:10.34timinatorthen there'd be one order record
17:10.40timinatorand 4 items records
17:11.30timinatorso, if the products sold are products_id 1-4, then the record for prod#4 would be the 4th record
17:11.53timinatordoes that make sense?
17:12.07thebigdognope
17:12.22timinatork
17:13.44timinatorlets say that I'm selling crap.... Apple products
17:13.52timinatorand you buy a laptop and an iPod
17:14.11timinatorso I write up an order.... #500 for example
17:14.21timinatorso in my DB, I have an order table
17:14.35timinatorthis transaction is #500
17:14.42timinatorbut then I have an items table
17:15.07timinatorso I put the laptop and iPod as separate records
17:15.24timinatorbut give them `order_id`=500
17:15.37timinatorso that I can connect that to the order table
17:15.43timinatormake sense so far?
17:16.38thebigdogy
17:17.01timinatorso, then I'm looking at how many iPods I sold
17:17.08timinatorbut if I query this:
17:17.10timinatorSELECT b1.* FROM orders as b1, items as b2 WHERE b1.id = b2.order_id AND b2.product='iPod' GROUP BY b2.order_id ORDER BY b2.order_id
17:17.54timinatorthen it'll query both tables
17:18.20timinatorI'm wondering if it'll attach the first item record to the order record
17:18.29thebigdogyou want to know how many total ipods from all orders?
17:18.35timinatorso, then it'll say that that order was for a laptop
17:18.50timinatornot an ipod
17:19.19timinatornot really, I want a list of Orders that had iPods as one of the items sold
17:20.02thebigdogwhat part of the orders table do you need then? if just the order id then only query item
17:21.26*** topic/#UPHPU by wps -> meeting thursday, 23 Aug: Sheri Bigelow on SEO
17:21.31timinatornaw, I need a few things
17:21.46wpswhat do you think boys? should we have the announcement list?
17:22.00thebigdogi think we should
17:22.23thebigdogtiminator, pastebin the results from your last query
17:22.35timinatork, 1 sec
17:22.56wpsI personally like the separation
17:23.30timinatorI personally don't care.... they all dump into the same email folder anyway
17:23.43wpsk
17:24.12wpsmindjuju: did you ever hear back from Sheri?
17:24.15wpsare we good for Thursday?
17:32.30timinatorhttp://pastebin.com/d2d3a97c7
17:33.20timinatorthat the result set for
17:34.32timinatorhttp://pastebin.com/d58af8710
17:35.01thebigdogthat dont look right on the result set
17:35.31timinatornot at all.... should have hundreds there
17:36.05thebigdogwhy do you have limit on there
17:36.10thebigdogremove the limit
17:37.14timinatork
17:38.24orsonjI was thinking the output looked correct, limit makes sense as there are 30 items.
17:38.28timinatorthere should be 1,409 results
17:38.57SunSparcWhat makes you so sure about the expected result number?
17:39.01timinatorthis gives 1,409 results:  SELECT * FROM `bible_mill_items` WHERE `product_id` =4 GROUP BY `order_id`
17:39.14timinatorbut I want the info on the order
17:39.24timinators/order/orders/
17:40.38thebigdogim not sure me liking the google groups
17:40.53wpswhy's that thebigdog ?
17:41.08thebigdogi want it to go to another account and it wont do it
17:41.29orsonjtiminator: are you wanting to know what else was on the same orders as those?
17:41.30wpsyou can change the email address that your account nuses
17:41.41wpss/nuses/uses/
17:42.46orsonjtiminator: I was just saying limit 30 did in fact get you 30 lines
17:43.01timinatororsonj: no, I'm wanting to find out other info... like the customer and date sold, etc...
17:43.14orsonjwhat table is that on?
17:43.36timinatororsonj: orders
17:43.41thebigdogwps, would i need to register another email address
17:43.51thebigdogi signed up with my gmail
17:44.01thebigdogbut i want it to go to the old one i used before
17:44.21thebigdogunder manage memberships it only has one email address
17:45.03wpsyou have to create a Google Groups account in order to change your email address
17:45.27wpsit's a little confusing
17:45.43wpsif you have a gmail account, they let you sign up without a Google Groups account for some reason
17:45.49timinatorI removed the LIMIT and it worked.... thanks guys..... I meant to have it set to LIMIT 0,30 rather than LIMIT 30
17:45.52timinatorduh
17:45.55wpsbut then it's just your gmail address
17:46.15wpsif you want to use any email address, then you have to create a Google Groups account and then while managing that account, you can change your email address to anything
17:46.28timinatordon't ya hate it when you spend an hour on something that should've taken 2 seconds?!?!?!
17:46.55timinatorThanks though guys
17:47.10timinator~lart timinator
17:47.10jbotoffers timinator some herring
17:53.35thebigdog~flip timinator
17:53.36jbotACTION gives timinator the .|.. ..|.
17:53.46orsonjhmmm, google groups doesn't seem to like me relaying email off of a different server
17:54.01thebigdoggg hates me
18:04.41timinatorSunSparc, thebigdog: you remember my earlier analogy?
18:04.58timinatoris there a way to find out who bought laptops and iPods?
18:05.33mindjujuwps , PM sent
18:14.37SunSparctiminator:  I am a bit distracted, but would not something like this work:  SELECT c.customer FROM customerTable c, ordersTable o, itemsTable i WHERE c.customerId = o.customerId AND ( o.orderId = i.orderId AND i.itemName IN ('iPod','laptop') )
18:17.15timinatorI bet something along those lines would work....thanks man
18:24.15thebigdogwps you there?
18:24.20wpsyes
18:24.38thebigdogwe have any permission issues on the ggroup?
18:24.57wpswhat do you mean?
18:25.23thebigdogi get an error when i post from my email client...saying that only registered users can post...which i am a registered user
18:25.46wpshmm…  I am experiencing something strange too
18:26.01wpsI am not getting any errors, but I am not getting any email delivered for the past little while either
18:26.08wps…since I changed a setting
18:26.12wpslet me change it back and see what happens
18:27.03*** join/#uphpu _psychic_ (n=_psychic@66.7.114.125)
18:27.03*** mode/#UPHPU [+v _psychic_] by ChanServ
18:29.17*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
18:29.17*** mode/#UPHPU [+v beandog] by ChanServ
18:29.50beandog~hola
18:40.51wpshas anyone received copes of either the "reply-to test" or the "wood chuck" email that I posted to the Google Groups list?
18:41.25wpsI see that they made it to the server (they are in the archives)…  but I never received a copy
18:44.55*** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com)
18:49.59tierrawps: I see a "TEST" with content: 0:04, as well as "TEST 2 (server maintenance)" with "10:20"
18:50.07tierrano other test emails though
18:58.06wpsthese tests were sent to the google groups list, tierra
18:58.22tierraoh, Google Groups, ok
19:00.35*** join/#uphpu _psychic_ (n=_psychic@66.7.114.125)
19:00.35*** mode/#UPHPU [+v _psychic_] by ChanServ
19:00.49*** join/#uphpu SunSparc_ (n=sparky@66.7.114.125)
19:30.52mgeary~yow
19:37.28unumI'm trying to use ldap_modify and it keeps hanging on me
19:37.33unumI'm trying to run it from a web page
19:37.46unumand I have exit my browser after I run the web page
19:46.09unumI wonder if it's the ldap replication
20:02.09unumlooks like I should be using ldap_mod_replace
20:03.47*** join/#uphpu _psychic__ (n=_psychic@66.7.114.125)
20:15.11*** join/#uphpu influx^^ (i=influx@hektik.org)
20:50.52mgeary~kneecap herlo
20:51.06*** join/#uphpu mindjuju (n=mindjuju@65-121-75-195.dia.static.qwest.net)
20:51.06*** mode/#UPHPU [+o mindjuju] by ChanServ
20:53.46mgearyso....
20:54.08mgearyi did some work for the LDS church a bit ago. Posted some files for them to download on my dreamhost server...
20:54.24mgearythey come back at me with, "your domain is blocked to us."
20:54.44mgearyi figure it must be IP recycling, 'cause there's literally *nothing* on my site
20:54.50mgearythen i found this site:
20:54.53mgearyhttp://www.myipneighbors.com/
20:54.59mgearymy domain is "michaelgeary.com"
20:55.06mgearygo ahead
20:55.14mgearybut some links are NSFW
20:56.08mindjujumgeary, do you need a temp place to throw something?
20:56.13mgearynaw
20:56.17mgearyi've got a static IP at home now
20:56.21mindjujuk, was going to say, remember i owe you one
20:56.21mgearyand a fiber connection
20:56.25mgearyheh
20:56.43mgearyi was just having a hard time figuring out why the LDS church was listing my domain as a sex-related site
20:57.01mgearyi mean, i knew it was IP-based filtering, but didn't have any way of seeing what other domains were on that ip
20:58.59mindjujuugh, i just have 4 more days
20:59.14mindjujuthen 2 day vacation
20:59.37mindjujuwell, really 3 days, no work, no child, just Tiffany
21:01.15unumand you're here because....
21:05.18*** join/#uphpu _psychic_ (n=_psychic@66.7.114.125)
21:05.18*** mode/#UPHPU [+v _psychic_] by ChanServ
21:07.16SunSparc_~rlart
21:07.17jbotwhacks eco with a giant beaver's tail
21:07.51SunSparcNothing personal eco
21:08.28ecoThanks.
21:08.47SunSparceco:  Does your nick have anything to do with the ABC TV series, Lost?
21:09.23ecoNope.  It predates that by a few years.  It doesn't have anything to do with anything really.  I just wanted a short nick.
21:09.49ecoAnd he is "Eko" anyway.
21:09.57SunSparcGotcha.
21:10.03SunSparcTrue, it is.
21:30.00herlomindjuju: ping
21:30.06herlo~apb mindjuju
21:30.07jbotACTION summons Tim to stake out mindjuju
21:33.52mgeary"There are some who call me.......Tim"
21:40.52orsonjwow, amazing how many sites are hacked on the 1and1 server I am using
21:41.29orsonjI bet some of their default "tools" (forum, guestbook, etc.) are unpatched and out of date.
21:43.13*** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
21:43.13*** mode/#UPHPU [+o Utah_Dave] by ChanServ
21:53.59mindjuju~syn herlo
21:54.16mindjujuhmmm... we need to build a syn command
21:54.18mindjuju~apb herlo
21:54.19jbotACTION hires Leland to find herlo
21:54.48SunSparc~seen herlo
21:54.52jbotherlo is currently on #ubuntu-utah #utah #uphpu. Has said a total of 6 messages. Is idling for 24m 46s, last said: '~apb mindjuju '.
22:09.55*** join/#uphpu cycokilr (n=cycokilr@66.114.120.2)
22:44.00SunSparcGood stuff
22:45.29mgearyyeah, that's one of my favorites. That and Don Giovanni
22:46.36herloSunSparc: pong
22:46.53herlomindjuju: pong
22:47.05herlomindjuju: did you see my msg in #utos?
22:59.43*** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
23:02.38SunSparcherlo: Ping?
23:02.56SunSparcI was just seening you for mindjujo.
23:04.17unumso I have date string with a timezone(from postgresql) I want to convert it to a friend format but converted to a different timezone ie(14:00:00 -06 to 1:00pm pdt)
23:14.10*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
23:14.10*** mode/#UPHPU [+v beandog] by ChanServ
23:15.53SunSparcunum:  Can you restate that question?  It did not make a lot of sense to me.
23:15.58unumSunSparc: ya
23:16.14unumI reliazed strtotime took care of part of the problem
23:16.30unumis there a way to tell date you want to use a differnt timezone than the servers timezone
23:16.54unumI wonder if I have php5 on the new server...
23:21.04timinatorlater guys
23:26.35SunSparcYou can set this inline if you want http://www.php.net/manual/en/function.date-default-timezone-set.php
23:27.30SunSparcOr you can just make your own time with mktime and modify it to your liking.
23:37.16*** join/#uphpu psy[away] (n=_psychic@c-76-27-99-168.hsd1.ut.comcast.net)

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