[11:16:23] Ryan_Lane: Around? [11:50:50] yep [11:51:26] RoanKattouw_away: here now. I believe I fixed the IRC issue. commented out $wgRC2UDP options [12:53:48] Cool [12:54:38] Yay, sudo works for me now, thanks! [13:01:25] Ryan_Lane: Can you grow /var/tmp for me by like a few gigs? It's 19G and I need to put 20G in there [13:14:10] Ryan_Lane: Never mind, I found a way around it. You should also know that the clock on commons.prototype is 6 hours behind, it thinks it's 07:14 EST now [13:14:56] Also, the server's timezone should be UTC [13:23:39] RoanKattouw: The irc-push thing from the Prototype Commons seems fixed - my recent test edit didnt show up [13:24:04] RoanKattouw_away: here now. I believe I fixed the IRC issue. commented out $wgRC2UDP options [13:25:43] Alrighty [18:08:03] RoanKattouw: are you around? [18:08:19] RoanKattouw showed me some trick for exporting templates en masse from Mediawiki [18:11:44] Yes I'm here [18:11:56] In Special:Export, there's an include templates checkbox [18:12:18] Which will include all templates used on the exported pages and their dependencies (in theory) [18:15:57] right, I am working with that now [18:17:10] is there any reasonable way to flatten categories from here? (I realize this is a huge research problem generally) [18:17:28] I just want to export all License_tags and then any other templates listed in subcategories [18:17:47] I have a script you can use to get all subcats of a category and the images in them [18:17:53] Used it to populate the commons prototype [18:17:54] that would be great [18:18:11] i don't want images though, this is templates. I could modify it perhaps. [18:18:20] although I guess I want the related images too [18:18:54] My email is really boring [18:19:14] *flipzagging subscribes werdna to NAMBLA-talk [18:19:28] flipzagging: http://mediawiki.pastebin.com/cf13yLXz [18:19:41] Change 6 (image) to 8 (template) throughout [18:19:48] Danese claims to get 800 or something emails a day [18:20:01] I'm not sure this is 'success' IMO [18:20:16] require( "dbSettings.php" ); --> make sure you have $dbSettings = array( 'user'=>'username', 'password=>'yourpass'); in that file or hack something else up [18:20:23] I wouldn't consider that success [18:20:44] She'd have nearly 10k e-mails after she totally disappears for a week [18:21:13] ok this presumes I can shell into a live server, which in theory I am supposed to be able to do, but have never done [18:21:29] Oh right, that script only runs on the toolserver :) [18:21:29] or some other server with access to live dbs? [18:21:33] ok [18:21:37] time to learn about toolserver [18:22:26] With some small modifications it would probably run on the cluster as well [18:22:34] Do you have shell access on the cluster? [18:24:25] I believe I was told I did [18:24:32] what is page_namespace 14 ? [18:24:34] categories? [18:24:36] Category [18:24:37] ah yes [18:26:04] flipzagging, RoanKattouw: I get enough emails, they're just all reallly boring [18:27:03] Yeah most I get is wikibugs-l and mediawiki-cvs [18:27:15] Thank God I'm not on foundation-l [18:30:53] RoanKattouw: maybe in the meantime I can ask you to run this script & put the results somewhere I can read? [18:31:03] Let me finalize what I need so I don't have to ask twice [18:31:37] Sure [18:31:40] Hey guillom [18:31:50] I finished doing the imports on your list [18:31:58] hi [18:31:59] hey guillom [18:32:00] awesome [18:32:02] how was the parade [18:32:12] it was great [18:32:18] I took tons of pictures [18:32:21] I forgot about PD_NASA and PD_US_Army because my script grossly underestimated them and they were huge [18:32:24] hope some of them will turn to be not to bad [18:32:30] ok [18:32:43] RoanKattouw: have filters for those [18:32:46] What parade did you go to? [18:32:47] salut guillom [18:33:07] werdna: I don't filter those except putting them in separate folders, I still manually go through all of them [18:33:09] RoanKattouw, St. Patrick's Day's [18:33:13] hi andrew [18:33:14] Ah [18:33:29] guillom: isn't that later in the week [18:33:33] I don't know these things [18:33:41] but the party at my uni is wednesday [18:33:44] St. Patrick's Day is on the 17th, I believe [18:33:50] but the Parade & festival were today [18:33:58] closest weekend. [18:34:26] Do they celebrate St. Patrick's at all in France? Or even know about it? [18:34:41] it's closely associated with Irish immigrant communities, also drinking [18:35:23] they know about it alright; mainly because they drink more beer than usual on this day [18:35:23] :) [18:35:35] guillom: beer? [18:35:46] I thought the french only drank red wine [18:36:05] haha [18:36:13] good one :) [18:36:24] In Argentina, when Cristophe went to get drinks, he would always bring back red wine for all [18:36:49] well, because if they have the choice, some of them will probably choose red wine [18:36:52] Who's Christophe again? [18:36:58] but beer is cheaper and more casual [18:37:00] RoanKattouw, schiste [18:37:16] member of the board of WMFR [18:37:20] Ah [18:38:16] flipzagging: You'll have to e-mail me about the category flattening thing, I'm off to bed soon [18:38:22] He's the most stereotypically French person I've met :p [18:38:37] heh :) [18:38:58] by the way, I saw Tim Bartel at the parade [18:39:05] I waved at him but he didn't see me [18:39:28] we were taking pictures at the same crossroads (2nd & Market= [18:39:30] ) [18:39:37] Tim Bartel... isn't he german? [18:39:40] he is [18:39:43] but he works for wikia [18:39:48] I guess he was in town [18:39:49] Roan: sorry [18:39:52] um, ok [18:39:56] or, he has a doppelganger here [18:40:16] werdna, I haz pix to prove it! [18:40:19] young-ish guy? [18:40:34] flipzagging: No worries, you can't be expected to keep track of everyone's timezones [18:40:34] RoanKattouw: can I get you to just flatten Category:License_tags and give me the list of names? I can paste it into the export form and go from there [18:40:36] Yet [18:40:43] On it [18:41:12] thanks, this is going to save me a lot of tedium [18:41:40] will this export associated images too? [18:42:15] No this just does the templates [18:42:20] argh [18:42:33] ok so [18:42:35] But you can use a wanted images-like query to grab a list of missing images [18:42:42] Once you've imported the templates [18:42:51] ok how does that work [18:43:14] or point me at docos [18:43:55] http://toolserver.org/~catrope/neil.catlist [18:43:59] YAY [18:44:15] RoanKattouw: did we tell you you're awesome? today I mean? [18:44:27] Bascially you run the following query against the database [18:46:34] SELECT CONCAT("File:", il_title) FROM imagelinks LEFT JOIN page ON page_title=il_title AND page_namespace=6 WHERE page_id IS NULL GROUP BY il_title; [18:47:48] thanks, that's clear [18:48:10] i [18:48:34] that was a vim command, wrong window. [18:48:56] :D [18:50:02] It amazes me that we have a license template for Abu Ghraib images [18:50:15] http://commons.wikimedia.org/wiki/Template:AbuGhraibPic [18:50:26] haha [18:51:21] http://news.bbc.co.uk/2/hi/americas/8565637.stm --> that's why stick shifts are safer, they can be stopped even when the brakes fail or when the accelerator jams :) [18:53:32] you can always just pull the handbrake [18:53:57] Hm yeah I guess that doesn't really fail very often as it's just a cable [18:54:13] though in some cars that can jam [18:55:12] for example, one of the cars my family has uses an electronic handbrake [18:55:32] Ouch [20:31:02] hehe, i know how danese feels. I used to get 10k mails in a week when I was still a VLC developer :D [20:36:30] 10k? [20:36:33] what were they all? [20:37:09] well, vlc has over 50 dependencies on other opensource projects..... [20:37:43] and i used to answer about 70% of all mail sent to our project [20:39:36] oh and yes, that was crazy, and you can't keep doing that for year after year :D [20:50:23] were they actual emails sent by actual humans? [20:50:25] or mailing lists? [20:50:37] or bug reports? [20:51:05] a large mix, but i think that about 30% was human mail that needed answering