| 00:47.00 | *** join/#uphpu bhosie (~bhosie@c-98-202-142-106.hsd1.ut.comcast.net) |
| 01:08.27 | *** join/#uphpu pelaofeliz (~pelaofeli@67.137.236.66) |
| 01:22.26 | *** join/#uphpu bhosie (~bhosie@c-98-202-142-106.hsd1.ut.comcast.net) |
| 02:09.47 | *** join/#uphpu TuxToaster (~TuxToaste@c-67-186-238-165.hsd1.ut.comcast.net) |
| 02:20.57 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 03:05.00 | *** join/#uphpu macnewbold (~Adium@c-98-202-75-24.hsd1.ut.comcast.net) |
| 03:05.00 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 03:52.04 | *** join/#uphpu Utah_Dave (~David@c-174-52-212-119.hsd1.ut.comcast.net) |
| 03:52.04 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 04:03.24 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 04:03.24 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 04:21.48 | josephscott | $rlart |
| 04:21.48 | raifbot | whips out his power stapler and staples eggyknap's foot to the floor. |
| 04:28.47 | *** join/#uphpu ninnypants1 (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 04:51.11 | *** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 04:51.11 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 04:57.34 | josephscott | $chuck-fact |
| 04:57.34 | raifbot | Outer space exists because it's afraid to be on the same planet with Chuck Norris. |
| 04:57.39 | josephscott | $weather sandy, ut |
| 04:57.39 | raifbot | josephscott - current weather for sandy, ut - Clear 0f / -18c Humidity: 40% Wind: NE at 11 mph |
| 05:00.21 | carmony | heh |
| 05:00.26 | carmony | you like raifbot don't you, josephscott |
| 05:00.47 | josephscott | $8ball do I like raifbot? |
| 05:00.47 | raifbot | josephscott - Very doubtful. |
| 05:00.50 | josephscott | haha! |
| 05:00.53 | carmony | lol |
| 05:02.31 | josephscott | carmony: fyi, it is winter, time to start carrying around a coat |
| 05:02.37 | carmony | lol |
| 05:02.47 | carmony | it looked deceptively warm today |
| 05:02.52 | ninnypants1 | $weather provo, ut |
| 05:02.52 | raifbot | ninnypants1 - current weather for provo, ut - Partly Cloudy 10f / -12c Humidity: 29% Wind: NW at 16 mph |
| 05:03.13 | carmony | $weather ogden, ut |
| 05:03.13 | raifbot | carmony - current weather for ogden, ut - Clear 8f / -13c Humidity: 28% Wind: NE at 18 mph |
| 05:04.40 | ninnypants1 | yeah it was terrible today. I walked by the river and almost froze to death |
| 05:06.09 | josephscott | $weather sandy, ut |
| 05:06.09 | raifbot | josephscott -* current weather for sandy, ut - Clear 0f / -18c Humidity: 40% Wind: NE at 11 mph |
| 05:06.19 | josephscott | you guys have it warm, it is zero here :-) |
| 05:06.57 | ninnypants1 | Thom Allen just posted about it being -10 wherever he is. |
| 05:07.21 | josephscott | with the wind earlier, weather.com listed sandy as feels like -13 |
| 05:09.07 | ninnypants1 | provo feels like -7 |
| 05:10.54 | *** join/#uphpu bradym_ (~bradym@c-98-207-87-104.hsd1.ca.comcast.net) |
| 05:10.55 | *** mode/#UPHPU [+v bradym_] by ChanServ |
| 05:55.17 | ninnypants1 | $chuck-fact |
| 05:55.17 | raifbot | If you can see Chuck Norris, he can see you. If you can't see Chuck Norris you may be only seconds away from death. |
| 14:37.19 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 14:40.43 | *** join/#uphpu itimber (~Adium@106.73.124.24.cm.sunflower.com) |
| 14:40.43 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 14:45.49 | *** join/#uphpu TuxToaster (~TuxToaste@c-67-186-238-165.hsd1.ut.comcast.net) |
| 15:07.11 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 15:15.23 | *** join/#uphpu macnewbold (~Adium@66.60.115.30) |
| 15:15.23 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 15:17.23 | *** join/#uphpu TuxToaster (~TuxToaste@173-10-25-150-BusName-utah.ut.hfc.comcastbusiness.net) |
| 15:44.22 | *** join/#uphpu SunSparc (~sparky@24-104-129.146.hfc.mediarain.com) |
| 15:44.23 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 15:48.58 | mindjuju | ugh, yeah, see, the way it works is, if you don't tell me you're going to rearrange your office so that we can schedule it as a project, and you arbitrarily unplug everything and move it around the way you like it, your stuff isn't going to work until I get there. and since it isn't scheduled, it's not going to happen on a time you specify |
| 15:53.31 | TuxToaster | mindjuju: +1 |
| 15:53.44 | TuxToaster | gotta love when someone does that |
| 15:58.27 | mindjuju | oh man, it just went up 2 full orders of magnitude |
| 15:59.12 | mindjuju | the lady is so dumb, she ACTUALLY, NO JOKE put in cardboard into a gas furnace to divert the hot air jets away from her desk, i'm calling the AC guys as i type to have them set it up the way she wants it before she burns down the warehouse |
| 16:00.33 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 16:01.17 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 16:01.17 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:02.33 | TuxToaster | WOW |
| 16:02.37 | TuxToaster | that's just insane. |
| 16:04.18 | TuxToaster | when my wife and I first got married, the furnace in her house would only turn on two of the five burners sometimes, and so she was in the habit of running a piece of paper across them to ignite the other burners |
| 16:14.23 | *** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com) |
| 16:14.23 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:15.31 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 16:16.52 | mgeary | mindjuju: ping |
| 16:22.00 | *** join/#uphpu wps (~wps@76.8.223.101) |
| 16:22.00 | *** mode/#UPHPU [+o wps] by ChanServ |
| 16:23.20 | *** join/#uphpu cro1 (~cro@204-228-149-217.ip.xmission.com) |
| 16:27.04 | *** join/#uphpu TuxToaster (~TuxToaste@173-10-25-150-BusName-utah.ut.hfc.comcastbusiness.net) |
| 16:28.18 | *** join/#uphpu TuxToaster_ (~TuxToaste@173-10-25-150-BusName-utah.ut.hfc.comcastbusiness.net) |
| 16:36.33 | *** join/#uphpu Utah_Dave (~Utah_Dave@72-166-51-162.dia.static.qwest.net) |
| 16:36.33 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:37.37 | *** join/#uphpu Utah_Dave (~Utah_Dave@72-166-51-162.dia.static.qwest.net) |
| 16:37.37 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:50.31 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 16:53.11 | *** join/#uphpu jtsnow (~jtsnow@74-95-52-198-Utah.hfc.comcastbusiness.net) |
| 17:03.58 | *** join/#uphpu _psychic_ (~johnander@64.0.193.15) |
| 17:03.58 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 17:23.31 | *** join/#uphpu cycokilr (~cycokilr@216.112.116.6) |
| 17:40.24 | macnewbold | ~firedrill mindjuju |
| 17:40.44 | *** part/#uphpu macnewbold (~Adium@66.60.115.30) |
| 17:40.48 | *** join/#uphpu macnewbold (~Adium@66.60.115.30) |
| 17:40.48 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 17:49.06 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 17:52.29 | TuxToaster | firedrill? lol |
| 18:08.53 | macnewbold | he better practice before his lady burns down the warehouse |
| 18:09.45 | *** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 18:09.45 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 18:14.31 | Utah_Dave | Oh, man. I just finished up redoing some database queries that have been a thorn in my side for over 6 months |
| 18:15.07 | Utah_Dave | each has a subquery and group by and having |
| 18:15.31 | Utah_Dave | finally got it all sorted out in my head got them right. The old ones weren't always accurate and were slow |
| 18:17.04 | mindjuju | ping mgeary |
| 18:19.01 | TuxToaster | Utah_Dave: nice! |
| 18:19.52 | macnewbold | congrats |
| 18:19.56 | macnewbold | i know exactly how that goes |
| 18:20.01 | macnewbold | bad db queries can ruin your day |
| 18:20.20 | TuxToaster | or worse, even. heh |
| 18:23.12 | mgeary | ~rce |
| 18:23.12 | ibot | hmm... rce is Resume-Changing Experience: an event caused by such boneheadedness that the only good that comes of it is the opportunity to freshen up your resume as you abandon all hope of keeping your current job |
| 18:26.00 | *** join/#uphpu undertakingyou (~will@67.214.250.163) |
| 18:26.00 | *** mode/#UPHPU [+v undertakingyou] by ChanServ |
| 18:36.17 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 18:36.17 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 18:36.45 | mindjuju | ah josephscott, i was telling you something yesterday about wordpress, then realized you werent in the chan |
| 18:36.58 | josephscott | :-) |
| 18:37.03 | mindjuju | but that upgrade process really works well |
| 18:37.12 | mindjuju | :) |
| 18:39.09 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 18:53.21 | undertakingyou | Anyone in here have any experience with zend_pdf? |
| 18:53.41 | *** join/#uphpu jtsnow (~jtsnow@74-95-52-198-Utah.hfc.comcastbusiness.net) |
| 18:54.19 | mindjuju | carmony is a zend user |
| 18:54.31 | carmony | undertakingyou: I've used it in the past |
| 18:54.50 | mindjuju | failing that, I made pdfs in php using pdfphp or something like that |
| 18:54.56 | mindjuju | worked VERY well |
| 18:55.43 | undertakingyou | So I have a PDF that I open, draw various text, and output to the browser. Works great. My concern is when I go to print it, it defaults to page size letter and I have the pages as 8.5X14. Is there a way to force the page print size? |
| 18:55.49 | undertakingyou | Or am I messing it all up? |
| 19:00.33 | mindjuju | so does the pdf measure 8.5 x 14 ( aka pdf is fine,it's printer issue) or is does the pdf measure 8.5 x 11 |
| 19:05.09 | mindjuju | josephscott, got a minute? |
| 19:05.30 | mindjuju | or carmony, i know you've worked with this |
| 19:05.52 | josephscott | mindjuju: ? |
| 19:05.59 | mindjuju | i've got a small problem, our SEO guy posted something and it hit reddit and now the site is coming up SLOW |
| 19:06.13 | carmony | lol |
| 19:06.16 | carmony | alright |
| 19:06.20 | mindjuju | how do i approach even solving this? |
| 19:06.27 | carmony | tequila |
| 19:06.28 | carmony | I mean |
| 19:06.29 | carmony | :P |
| 19:06.33 | mindjuju | :) |
| 19:06.44 | carmony | ok, what is running the website? |
| 19:06.50 | mindjuju | apache |
| 19:06.57 | carmony | so LAMP? |
| 19:07.02 | mindjuju | yup, LAMP |
| 19:07.11 | carmony | ok, are you using a PHP framework? |
| 19:07.22 | carmony | or is it a blog like WordPress? |
| 19:07.27 | mindjuju | its actually a wordpress |
| 19:07.28 | mindjuju | yup |
| 19:07.48 | carmony | ok |
| 19:08.12 | macnewbold | mindjuju: if your mysql has slow query logging turned on that might point directly at your culprit(s) |
| 19:08.18 | josephscott | mindjuju: APC installed for PHP? |
| 19:08.27 | macnewbold | we found one extension running the exact same update to wp_options on every pageload |
| 19:08.28 | josephscott | and wp-super-cache for WP |
| 19:08.47 | mindjuju | i'll have to check on those, the reddit link is going directly to a cosplay pic though |
| 19:08.52 | mindjuju | not a hmtl or php page |
| 19:09.06 | josephscott | a static image? |
| 19:09.09 | mindjuju | yup |
| 19:09.13 | josephscott | that should load fast |
| 19:09.21 | mindjuju | yeah, that's what i would have thought |
| 19:09.32 | carmony | whats the link? |
| 19:09.33 | josephscott | where is the image hosted? |
| 19:09.59 | mindjuju | k, remember, this is cosplay, and 2. i didn't post it |
| 19:10.12 | carmony | lol |
| 19:10.31 | mindjuju | it's a girl in her briefs and a shirt, i guess it's an anime thing, any way, here it is |
| 19:10.32 | mindjuju | http://mydisguises.com/wp-content/uploads/2009/03/perfect-cosplay.jpg |
| 19:11.09 | mindjuju | how can I tell what apache is doing/ |
| 19:11.16 | carmony | lol, victor! |
| 19:11.24 | mindjuju | hey! i swear i didn't post it! |
| 19:11.26 | carmony | haha |
| 19:11.27 | carmony | ok |
| 19:11.33 | carmony | one option is apachetop |
| 19:11.48 | mindjuju | hey cool, yeah, i need somethign like top to tell me what up |
| 19:12.14 | mindjuju | yum says it doesn't know about apachetop |
| 19:12.24 | carmony | what OS you running? |
| 19:13.21 | mindjuju | centos 5, don't know what version |
| 19:13.29 | mindjuju | uname -r |
| 19:13.29 | mindjuju | 2.6.18-164.11.1.el5PAE |
| 19:14.07 | carmony | ok, I think I might have gotten apachetop for centos off rpm-forge |
| 19:14.24 | mindjuju | oh, i found it, it's centos 5.5 |
| 19:14.34 | mindjuju | k, i'll look for apachetop there |
| 19:16.11 | josephscott | mindjuju: well how is the server holding up? |
| 19:16.26 | josephscott | start with the basic, general items |
| 19:16.29 | josephscott | run top |
| 19:16.33 | josephscott | is it using swap? |
| 19:16.35 | josephscott | CPU? |
| 19:16.56 | josephscott | also, this could be a network/bandwidth issue and not a server one |
| 19:17.04 | josephscott | do you have network/bandwidth stats/graphs? |
| 19:17.22 | josephscott | on the server level, are you running munin or something to track stats on the server resources? |
| 19:17.36 | mindjuju | @josephscott, here is top info |
| 19:17.37 | mindjuju | http://pastebin.com/xsyJNFvV |
| 19:17.53 | mindjuju | not running munin, though i've seen you talk about it |
| 19:18.31 | josephscott | there are other options besides munin, but the idea is to track historical data about resource utilization on the server |
| 19:18.37 | josephscott | so that you can id spikes |
| 19:19.43 | josephscott | is the filesystem hosting that image file local to the server or is it a network mount? |
| 19:19.57 | mindjuju | local |
| 19:20.07 | carmony | also, you could run vnstat |
| 19:20.09 | carmony | I think that is it |
| 19:20.44 | carmony | yeah, vnstat -l |
| 19:20.44 | mindjuju | vnstat comes up in google |
| 19:20.56 | carmony | see if it is on yum |
| 19:21.08 | mindjuju | no, i'll see about install though |
| 19:22.02 | mindjuju | is there anything to do to immediately relieve the pressure? i'm guessing since we don't kno0w the exact bottleneck, we are |
| 19:22.06 | carmony | yeah, I think on our CentOS 5 server we added the rpmforge repo to yum |
| 19:22.17 | josephscott | yikes, requested that URL with curl, took 2:28 ! |
| 19:22.32 | mindjuju | i know |
| 19:22.33 | carmony | its not even a very big image |
| 19:22.41 | mindjuju | yeah, i'm not sure why she's tanking |
| 19:23.19 | carmony | hrm |
| 19:23.52 | josephscott | this is why things like munin are important, right now we are shooting in the dark |
| 19:24.04 | josephscott | mindjuju: where is that server hosted? |
| 19:25.00 | mindjuju | liquidweb |
| 19:25.11 | josephscott | and bandwidth graphs? |
| 19:25.13 | mindjuju | checking the utlitization there, should have those stats here in a sec |
| 19:25.26 | josephscott | I'm curious if this is a server issue or a network issue |
| 19:28.15 | carmony | his pipe could be full :P |
| 19:28.28 | carmony | thats what happened with alienware arena the other day |
| 19:28.31 | josephscott | liquidweb may have a specific limit, no idea |
| 19:29.01 | josephscott | also, what is the server setup? shared, VPS, dedicated? |
| 19:29.21 | mindjuju | dedicated |
| 19:30.58 | mindjuju | we're at 3x the normal traffic |
| 19:36.23 | carmony | hrm |
| 19:36.31 | undertakingyou | mindjuju: On the pdf it measures 8.5X14. Both by zend_pdf getWidth() and getHeight(), and by adobe reader document properties. |
| 19:39.57 | carmony | ok, one emergency option is to do an alias |
| 19:40.04 | carmony | er |
| 19:40.08 | carmony | a redirect in apache |
| 19:40.27 | carmony | you could throw the image up somewhere else |
| 19:40.36 | carmony | and have apache redirect to the new location |
| 19:42.02 | carmony | mindjuju: Example: Redirect 301 /uploads/file.jpg http://www.example.com/uploads/file.jpg |
| 19:42.12 | carmony | http://www.justincarmony.com/blog/2008/10/10/local-lamp-developement-user-content/ |
| 19:44.59 | carmony | running to lunch real quick |
| 19:46.24 | carmony | do I need a coat? |
| 19:46.28 | carmony | $weather ogden, ut |
| 19:46.28 | raifbot | carmony - current weather for ogden, ut - Sunny 15f / -9c Humidity: 22% Wind: SW at 2 mph |
| 19:46.38 | carmony | .... that is a yes |
| 19:49.36 | josephscott | snap, I think I might have just found a bug that has been hanging around for a few months |
| 19:49.47 | josephscott | $weather sandy, ut |
| 19:49.47 | raifbot | josephscott - current weather for sandy, ut - Sunny 15f / -9c Humidity: 31% Wind: N at 5 mph |
| 19:50.03 | mgeary | $weather Nome, AK |
| 19:50.03 | raifbot | mgeary - current weather for Nome, AK - Cloudy 11f / -12c Humidity: 90% Wind: N at 7 mph |
| 19:50.47 | mgeary | wow, what does 11 degrees feel like at 90% humidity? |
| 19:53.32 | ninnypants | I'd rather not think about it... |
| 19:54.46 | SunSparc | It is a balmy 262 kelvin here in Orem. |
| 19:58.00 | itimber | $weather Kansas City, KS |
| 19:58.00 | raifbot | itimber - current weather for Kansas City, KS - Sunny 13f / -11c Humidity: 48% Wind: NW at 12 mph |
| 19:59.23 | mindjuju | ~carmony++ |
| 19:59.27 | mindjuju | ~josephscott++ |
| 19:59.58 | mindjuju | we've upped the max connections in httpd.conf and lowered the keep alive time |
| 20:00.00 | josephscott | mindjuju: did you get it figured out? |
| 20:00.09 | mindjuju | yeah, page is popping now |
| 20:00.37 | josephscott | nice, curl shows the image load only takes .5 seconds now |
| 20:01.47 | mindjuju | yeah, don't bother looking at the image, it's a cosplay thing and well, kinda nsfw |
| 20:01.59 | mindjuju | depends on if bikinis are ok at work or no |
| 20:02.06 | mindjuju | any way, thx everybody for help! |
| 20:02.11 | mindjuju | GREATLY appeciated! |
| 20:02.47 | mindjuju | heh |
| 20:02.53 | mindjuju | i did give a warning before! |
| 20:29.52 | mgeary | now here's a song title for the archives... |
| 20:30.21 | mgeary | where's MY squadron of benevolent butterflies??! |
| 20:37.13 | *** join/#uphpu jkr801 (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 20:38.36 | SunSparc | ~butterfly mgeary |
| 20:39.45 | undertakingyou | oh man, that should do something |
| 20:39.51 | mgeary | ibot, butterfly $1 is <action> catches a horde, nay a SQUADRON, of benevolent butterflies and wraps $1 in their loving embrace |
| 20:39.51 | ibot | okay, mgeary |
| 20:39.56 | mgeary | ~butterfly SunSparc |
| 20:39.57 | ibot | ACTION catches a horde, nay a SQUADRON, of benevolent butterflies and wraps SunSparc in their loving embrace |
| 20:40.10 | SunSparc | lol |
| 20:56.51 | mgeary | good call. My kids haven't seen that, i don't think |
| 20:58.28 | TuxToaster | lol @ the butterflies. |
| 20:59.15 | TuxToaster | $chuck-fact |
| 20:59.15 | raifbot | Chuck Norris made a Happy Meal cry. |
| 21:00.23 | mindjuju | one of the sites we saved today was a steampunk site, now i'm spending a few minutes learning what steampunk actually is |
| 21:00.46 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 21:03.37 | DexterTheDragon | ~shame mindjuju |
| 21:03.37 | ibot | Shame on you mindjuju! |
| 21:03.59 | mindjuju | this, is awesome! http://steampunkcostume.com/2010/06/22/steampunk-usb-flash-drives/ |
| 21:04.24 | mindjuju | it'd be doubly cool if the gears moved while plugged in |
| 21:08.15 | mindjuju | @DtD - http://www.uproxx.com/wp-content/uploads/2011/01/Star-Wars-Flowchart.png |
| 21:08.27 | mindjuju | apparently my profession is to be a sith apprentice, not sure how that happened |
| 21:08.54 | mindjuju | well, actually i do, it was that jar jar question that shifted me that way |
| 21:09.06 | *** join/#uphpu Heartsbane (tsharpe@unaffiliated/heartsbane) |
| 21:09.06 | *** mode/#UPHPU [+v Heartsbane] by ChanServ |
| 21:13.37 | TuxToaster | anyone know where Ruby's default path might be for includes? |
| 21:16.55 | DexterTheDragon | TuxToaster: ruby -e 'puts $LOAD_PATH' |
| 21:18.57 | TuxToaster | ooh |
| 21:19.19 | TuxToaster | that's nice. |
| 21:19.24 | TuxToaster | ty DtD :-) |
| 21:19.33 | mindjuju | DtD is a smartie! |
| 21:19.37 | TuxToaster | ~DexterTheDragon++ |
| 21:46.43 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 21:55.36 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 21:57.31 | *** join/#uphpu redroy1 (~Adium@67.137.120.26) |
| 22:00.12 | josephscott | carmony: awesome! http://www.youtube.com/watch?v=R55e-uHQna0&feature=player_embedded |
| 22:00.23 | carmony | josephscott: I know, right? |
| 22:00.48 | josephscott | just teach him to use his powers only for good :-) |
| 22:11.41 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 22:15.52 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 22:29.36 | *** join/#uphpu jtsnow (~jtsnow@74-95-52-198-Utah.hfc.comcastbusiness.net) |
| 22:37.18 | mindjuju | that's awesome josephscott! |
| 22:41.43 | *** join/#uphpu PoeticIntensity (~jason@76.8.222.23) |
| 22:41.43 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 22:41.48 | PoeticIntensity | any cakephp guys around? |
| 22:41.52 | PoeticIntensity | I'm having a brainfart. |
| 22:42.05 | PoeticIntensity | SunSparc..... |
| 22:42.19 | PoeticIntensity | how would I do a simple query based on grouping, but without grouping explicitly...? |
| 22:42.33 | SunSparc | PoeticIntensity: Example? |
| 22:42.34 | PoeticIntensity | I wanna do select count(id) where client_id = $x |
| 22:42.44 | PoeticIntensity | should be very easy, but..... I'm having a tough time. |
| 22:43.07 | SunSparc | You are just trying to get a query count? |
| 22:43.17 | PoeticIntensity | The group-by example has an explicit group-by... |
| 22:43.20 | PoeticIntensity | yeah.. |
| 22:43.22 | PoeticIntensity | it's a very easy counter. |
| 22:43.29 | PoeticIntensity | based on one condition. |
| 22:44.10 | PoeticIntensity | the exact query I wanna perform is "SELECT COUNT(id) FROM sessions WHERE client_id = |
| 22:44.12 | PoeticIntensity | $x |
| 22:44.57 | PoeticIntensity | It's killin' me because I *know* it's easy... Been in the book for about 30 minutes now, and I can't seem to grasp how to get it done, and I don't wanna use "query".. Trying to wean myself from that. |
| 22:46.09 | SunSparc | Good call. Let me check it... |
| 22:46.19 | PoeticIntensity | Thanks, dude. |
| 22:46.32 | PoeticIntensity | oh, wait... |
| 22:46.44 | PoeticIntensity | find('count') - I think that'll do it. |
| 22:46.55 | PoeticIntensity | yeah... |
| 22:47.04 | SunSparc | heh |
| 22:47.06 | SunSparc | Good job |
| 22:47.13 | mindjuju | ~smack pi |
| 22:47.13 | ibot | ACTION smacks pi upside the head. |
| 22:48.11 | PoeticIntensity | totally unnecessary, ibot. |
| 22:48.14 | PoeticIntensity | ibot - smack yourself |
| 22:48.24 | *** join/#uphpu Muad`Dib (~sparky@24-104-129.146.hfc.mediarain.com) |
| 22:48.24 | *** mode/#UPHPU [+v Muad`Dib] by ChanServ |
| 22:48.25 | PoeticIntensity | ~smack ibot |
| 22:48.26 | ibot | ACTION smacks ibot upside the head. |
| 22:48.31 | PoeticIntensity | there we go |
| 23:04.03 | *** join/#uphpu _psychic_ (~johnander@64.0.193.15) |
| 23:04.03 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 23:13.27 | *** join/#uphpu jtsnow (~jtsnow@74-95-52-198-Utah.hfc.comcastbusiness.net) |
| 23:49.20 | mindjuju | man that is so weird, I just setup the mysql db the way i like it, i bolt it down with mysql_secure_installation and now i can't log in |
| 23:49.24 | mindjuju | ...sigh.... |
| 23:52.24 | SunSparc | mindjuju: Now THAT is secure. |
| 23:52.32 | mindjuju | yeah, no doubt |
| 23:53.09 | mindjuju | yipes! i'll be late for school, see you gents later |
| 23:53.27 | SunSparc | ~bye mindjuju |
| 23:53.27 | ibot | no |
| 23:53.32 | SunSparc | :) |
| 23:53.44 | SunSparc | I guess you cannot leave. |
