| 00:04.59 | supernovia | if I'm getting duplicate key errors when running insert intos in an upgrade script |
| 00:05.34 | supernovia | is there a way to just update a particular row instead of insert, without having to totally redo their sql? |
| 00:06.03 | supernovia | this is in mysql |
| 00:06.16 | supernovia | and I'm checking which version.. |
| 00:06.34 | jsmith | REPLACE INTO |
| 00:06.45 | jsmith | Insert if it doesn't exist, otherwise do an update |
| 00:06.59 | supernovia | cool - let me try tha |
| 00:08.46 | supernovia | OK - well it ran but it seems to have affected two rows when this would have only inserted one -- checking to see what happened |
| 00:08.56 | Zelut | jsmith: ohh, that would have been nice earlier. I added extra logic to check for existing and update else insert. |
| 00:10.05 | jsmith | Well, it's not very portable across databases, so I don't really recommend it in general |
| 00:10.14 | jsmith | But as a MySQL-specific hack, it works OK |
| 00:11.18 | supernovia | weird, well just one row is there with the values I'd expect, and that's good - I'm going to keep going with it. Thanks for that! |
| 00:11.34 | supernovia | last time this happened with an upgrade script I -did- rewrite the queries and that was no fun. |
| 00:16.34 | jsmith | Happy New Year, all! |
| 00:16.49 | supernovia | You too! |
| 00:18.48 | supernovia | ahh happy days... that batch of sql is done now! That went so much more smoothly than last time. :) |
| 01:07.41 | *** join/#uphpu Heartsbane (i=tsharpe@unaffiliated/heartsbane) |
| 01:07.41 | *** mode/#UPHPU [+v Heartsbane] by ChanServ |
| 01:54.33 | beandog | oy |
| 01:54.40 | beandog | I think Im done working for the day |
| 01:54.48 | beandog | anything goin on tonight? |
| 02:02.01 | romanovic | working late? |
| 02:02.24 | romanovic | i need to leave work. now. |
| 02:02.36 | romanovic | have a good new year's celebration! |
| 02:09.55 | beandog | I think Im going to go eat ice cream til I pass out |
| 02:10.25 | beandog | haagen-daaz++ |
| 02:54.15 | mindjuju | is it like rum flavored ice cream or something |
| 03:01.20 | mindjuju | i shoulda set something up for tonight |
| 04:01.22 | wps | you can set an empty var like this: |
| 04:01.26 | wps | var $something; |
| 04:01.33 | wps | can you do that same thing in an array? |
| 04:01.44 | wps | var $something['else']; |
| 04:01.49 | wps | ? |
| 04:03.25 | wps | obviously, you could do this |
| 04:03.31 | wps | $something['else'] = ''; |
| 04:03.52 | wps | but I was wondering if there was any other approach than just setting it to an empty string |
| 04:29.51 | beandog | wps: not really |
| 04:30.02 | beandog | var $something['else'] would think you are trying to reference it |
| 04:30.06 | beandog | not declare it |
| 04:30.17 | beandog | you could do $arr = array('value'); |
| 04:30.21 | beandog | er, wait |
| 04:30.22 | beandog | n/m |
| 04:30.34 | beandog | that'd be 0 => value |
| 05:11.10 | Zelut | beandog: not quite yet, but getting there. |
| 05:11.17 | Zelut | ...if I can stay awake. I'm getting too old for this. |
| 05:17.57 | beandog | yah |
| 05:18.00 | beandog | I need some cocoa |
| 05:35.49 | beandog | interesting. |
| 05:35.54 | beandog | postgres reassigns != to <> |
| 07:37.31 | *** join/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 07:37.54 | supernovia | happy new year to anyone who happens to be here! |
| 07:54.32 | *** part/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 09:48.45 | herlo | happy new year |
| 11:34.56 | *** join/#uphpu CoolCoder (n=amjithps@117.196.130.54) |
| 11:35.23 | CoolCoder | Hi, what is XML-RPC? is it simple? |
| 12:23.27 | *** part/#uphpu CoolCoder (n=amjithps@117.196.130.54) |
| 15:13.35 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) |
| 15:13.35 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 15:32.01 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 15:32.01 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:42.54 | *** join/#uphpu redroy (n=Adium@c-67-166-103-16.hsd1.ut.comcast.net) |
| 17:16.30 | beandog | isnt there some kind of function that shows you how long a PHP page has taken to load |
| 17:28.08 | justincarmony | happy new year everyone :) |
| 17:30.26 | justincarmony | beandog: not built in, but you can make a class to handle it :P |
| 17:30.41 | beandog | I could have sworn I remember seeing one |
| 17:30.48 | beandog | like execution_time or something |
| 17:40.48 | *** join/#uphpu redroy (n=Adium@c-67-166-103-16.hsd1.ut.comcast.net) |
| 17:40.55 | *** join/#uphpu cro (n=cro@75-164-96-118.tcso.qwest.net) |
| 18:39.14 | *** join/#uphpu cro (n=cro@75-164-96-118.tcso.qwest.net) |
| 19:39.59 | *** join/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 19:40.15 | Zelut | anyone have any opinions on codeigniter vs cakephp? |
| 19:43.21 | beandog | people in here won't shut up about how nice cake is |
| 19:43.25 | beandog | if that means anything |
| 19:43.39 | supernovia | agreed. |
| 19:43.55 | beandog | ~cake |
| 19:43.56 | ibot | the cake is a lie!, or so delicious and moist |
| 19:44.01 | beandog | heh |
| 19:44.02 | supernovia | I don't use either. :-/ maybe I'd be a better programmer if I had my cake. |
| 19:44.04 | supernovia | nice |
| 19:44.11 | beandog | ~yeehaw |
| 19:44.22 | beandog | ~hola |
| 19:44.27 | beandog | ~meh |
| 19:44.27 | ibot | meh int. /meh/ [The Simpsons] An interjection expressing apathy, or mgeary's favorite phrase |
| 19:44.40 | Zelut | I just stumbled onto Cake last nite, and have since found mention of some of the similar tools. |
| 19:44.50 | beandog | ~supernovia |
| 19:44.56 | Zelut | I already ran through the blog tutorial for Cake. I have to say it was _really_ simple. |
| 19:44.59 | herlo | Zelut: as in CakePHP? |
| 19:45.03 | Zelut | herlo: yeah. |
| 19:45.12 | supernovia | I'm a mystery.. |
| 19:45.38 | herlo | Zelut: frameworks like that are nice |
| 19:45.39 | supernovia | ~beandog |
| 19:45.39 | ibot | beandog is probably the gentoo guru, or a wannabe racer. a skater. the enlightened one, or <3 Janeway, or a non-girl, or has a large intestine filled with mealworms |
| 19:45.42 | beandog | ibot: supernovia is an enigma wrapped in a riddle |
| 19:45.43 | ibot | okay, beandog |
| 19:45.47 | beandog | ~supernovia |
| 19:45.47 | ibot | methinks supernovia is an enigma wrapped in a riddle |
| 19:45.48 | supernovia | w00t! |
| 19:46.29 | herlo | ibot: supernovia is also a happy mother of two awesome kiddos |
| 19:46.30 | ibot | herlo: okay |
| 19:46.40 | herlo | ~supernovia |
| 19:46.41 | ibot | supernovia is, like, an enigma wrapped in a riddle, or a happy mother of two awesome kiddos |
| 19:46.46 | supernovia | I guess it was jbot who was convinced I was some kind of crazy hippie |
| 19:47.08 | beandog | a crippie? |
| 19:47.08 | herlo | ibot and jbot are the same bot, but they might have different instances... |
| 19:47.09 | ibot | herlo: okay |
| 19:47.15 | herlo | lol |
| 19:47.18 | herlo | ~ibot |
| 19:47.19 | ibot | It's me |
| 19:47.31 | herlo | ~jbot |
| 19:47.32 | ibot | somebody said jbot was a hack!, or known to have only said one useful thing. a tool, or dating the fembots, or [TK]D-Fender's b*tch, or suck, or a pain in the ass |
| 19:47.47 | beandog | dating the fembots? lol |
| 19:48.20 | supernovia | mgeary told one of them I was a tree hugging granola person with cutoffs :-p |
| 19:48.46 | beandog | lol, thats a good one |
| 19:49.00 | supernovia | dating the fembots. heh |
| 19:50.50 | beandog | ~slow queries-- |
| 19:50.51 | ibot | ACTION attaches a ball and chain to queries-- |
| 19:51.28 | supernovia | oh speaking of slow queries, did you get that full text thing figured out beandog? |
| 19:52.13 | beandog | supernovia: mmm, kinda. |
| 19:52.19 | beandog | I havent really looked at it, I dont need it that much yet |
| 20:01.24 | supernovia | ah. (sorry, phone) |
| 20:05.15 | supernovia | well (now I'm off the phone finally) I'd love to hear how you worked it out, when you work it out. would be good to know how to do that quickly. |
| 20:06.54 | supernovia | mmm.. looking up the best way to keep just the last few lines of a file and remove the rest ... anyone know how off the top of their head? there should be some easy command... |
| 20:07.57 | supernovia | in linux of course. just got a nasty long exim_log but I want to keep the last several lines |
| 20:21.26 | Zelut | supernovia: tail? |
| 20:22.10 | supernovia | I can use that to write the last few lines to a new file then copy those to the new file |
| 20:22.33 | supernovia | er, to the old file. blah. I'm still tired. but yeah that seems to be the best bet at this point |
| 20:23.16 | supernovia | with it being a log file though I guess i have to reassign permissions and ownership and all that too... unless there's a better way |
| 20:26.55 | supernovia | probably a dumb question anyway (usually just let the system rotate the logs out) |
| 20:32.31 | supernovia | well in case it wasn't a totally goofy question: |
| 20:32.31 | supernovia | tail -n 5 log.log > tempfile; cat tempfile > log.log; rm -f tempfile |
| 20:32.31 | supernovia | works nicely and keeps permissions in place (so long as your user can write to log.log) |
| 20:35.00 | supernovia | bah. sorry that came out as three lines, and obviously 5 is probably a too-small number but whatever. anyway I am going to be quiet now. :-p |
| 20:39.19 | beandog | can you use tee? |
| 20:39.20 | beandog | instead |
| 20:39.31 | beandog | tail -f log | tee newlog |
| 20:41.01 | supernovia | I'm not familiar with tee... alas, that's why i'm at school.. I only know what I know and can find in google (and google had all kinds of funny results with the terms I'd used) |
| 21:04.09 | supernovia | tee looks handy, thanks beandog :) |
| 21:08.39 | beandog | yah |
| 21:59.53 | *** join/#uphpu justincarmony (n=justinca@c-24-10-194-172.hsd1.ut.comcast.net) |
| 22:24.39 | *** part/#uphpu justincarmony (n=justinca@c-24-10-194-172.hsd1.ut.comcast.net) |
| 22:54.10 | *** join/#uphpu redroy (n=Adium@c-67-166-103-16.hsd1.ut.comcast.net) |
| 23:43.51 | *** join/#uphpu thebigdog (n=thebigdo@207.135.132.13) |
| 23:43.51 | *** mode/#UPHPU [+o thebigdog] by ChanServ |