[01:47:25] <Dispenser>	 Could somebody give me SHOW INDEXES FROM externallinks; for commonwiki?
[01:54:49] <Reedy>	 Same as what's in tables.sql
[01:54:59] <Dispenser>	 Ok thanks
[01:55:04] <Jasper_Deng>	 Toolserver appears to be down
[01:55:30] <Dispenser>	 works for me
[01:55:58] <Jasper_Deng>	 timed out a few moments ago
[01:56:04] <Jasper_Deng>	 I do see the disclaimer
[01:56:06] <Jasper_Deng>	 what's it about?
[01:56:07] <Dereckson>	 On toolserver:
[01:56:15] <Dereckson>	 dereckson@willow:~$ sql commonswiki_p
[01:56:20] <Dereckson>	 mysql>  SHOW INDEXES FROM externallinks;
[01:56:21] <Dereckson>	 Empty set (0.10 sec)
[01:56:38] <Dereckson>	 Seems you need them from the real servers.
[01:56:40] <Dispenser>	 Dereckson: We don't have views of indexes on the Toolserver
[01:57:44] <Dispenser>	 Dereckson: We don't have views of indexes on the Toolserver
[01:57:59] * Dispenser  mutter something again about the up key

[01:58:42] <Dispenser>	 I'm having troubling extracting coordinates from commons, at 3+ million is taking 2 hours to just do the SELECT
[01:59:47] <Dispenser>	 So I'm looking for speed hacks
[02:24:56] <logmsgbot>	 !log LocalisationUpdate completed (1.20wmf5) at Sat Jun 16 02:24:56 UTC 2012
[02:25:07] <morebots>	 Logged the message, Master
[02:49:55] <logmsgbot>	 !log LocalisationUpdate completed (1.20wmf4) at Sat Jun 16 02:49:55 UTC 2012
[02:50:01] <morebots>	 Logged the message, Master
[08:37:01] <Nemo_bis>	 @replag
[08:37:04] <dbbot-wm>	 Nemo_bis: [s7] db26: 2s
[09:51:12] <jc37>	 Not sure if I got this to work - am I here? : )
[09:52:47] <jc37>	 Looks like it. 
[09:54:51] <jc37>	 it was suggested to me that this is the way to contact a sysadmin. would any be around?
[10:00:22] <saper>	 there are manny peole around to help
[10:00:45] <jc37>	 thank you saper
[10:00:45] <saper>	 !ask | jc37
[10:00:45] <wm-bot>	 jc37: Hi, how can we help you? Just ask your question.
[10:01:15] <jc37>	 ok (typing : )
[10:02:59] <jc37>	 awhile back, I signed up for awb. I created jc377 for use with it, but I never actually got around to tinkering with awb. Now, some has offered to help me figure it out, but I find that
[10:03:56] <jc37>	 I have forgotten the password to jc377 - and since I didn't do much with it, I guess I never set the email.  I self identified in order to get awb access at the time.  
[10:04:24] <jc37>	 it was suggested to me to ask a sysadmin if they would reset the password for me
[10:04:38] <jc37>	 and so here I am (begging : )
[10:05:05] <jc37>	 this all on en.wikipedia, btw
[10:38:58] <jc37>	 saper still there?
[10:39:21] <saper>	 yes
[10:39:58] <jc37>	 oh ok. it's been over 30 minutes with no comments from anyone. would I be better off coming back at another time?
[10:41:50] <saper>	 if it's for a bot, why not vreate another one?
[10:42:01] <saper>	 s,v,c,
[10:44:05] <jc37>	 well awb not bot. but nod simjilar situation. I  wanted that name due to similarity with my account name
[10:44:46] <jc37>	 I have no idea of the work this entails. so my apologies if the request is beyond the pale
[10:46:06] <jc37>	 just trying to keep the edit history intact (even though it looks like I only made 3 edits with jc377
[10:46:07] <saper>	 I've seen this done very ratrely if at all.
[10:46:21] <jc37>	 http://en.wikipedia.org/w/index.php?title=Wikipedia_talk:AutoWikiBrowser/CheckPage&diff=next&oldid=395640203
[10:46:31] <jc37>	 this is where I self identified
[10:47:40] <jc37>	 was unaware of that saper. as I said, I merely am following advice I received at the village pump  
[10:49:06] <jc37>	 what would be your suggestion?
[10:49:26] <saper>	 That's just an advice from fellow villagers, you know:) 
[10:50:10] <jc37>	 lol nod - just trying to figure out what to do
[10:50:25] <saper>	 for 3 edits and bot account I wouldn't bother
[10:52:20] <jc37>	 what kills me is that I can even see the number of characters when I open awb.  but since it doesn't have a "show text" ability, I can't see what I entered there . I have a feeling I got "creative" with the pssword name....
[10:55:16] <jc37>	 so you're suggesting that asking here isn't the good advice I hoped it was (as it's not likely)?
[10:56:03] <jc37>	 (that sounds weird as I read it, but I hope you understand)
[11:01:36] <jc37>	 well, looks like I have to turn into a pumpkin. Thank you for your help saper. I'll see about checking back at a later time.  
[11:08:36] <petan>	 Thehelpfulone: yes I am doing a clean up
[11:09:01] <petan>	 Thehelpfulone: there are 2 templates {{MoveToLabs}} should be used for all pages that are ready and should be moved
[13:05:38] <Dispenser>	 https://commons.wikimedia.org/wiki/Commons:Bots/Work_requests#3_million_null_edits
[13:25:28] <closedmouth>	 http://en.wikipedia.org/wiki/File%3AThe_Camden_Head_Front.jpg anyone know what in the hell has happened to this file?
[13:25:44] <closedmouth>	 s/know/able to figure out/
[13:29:46] <Dispenser>	 closedmouth: http://en.wikipedia.org/wiki/Special:FileDuplicateSearch/The_Camden_Head_Front.jpg ?
[13:31:22] <closedmouth>	 yes?
[13:31:46] <Dispenser>	 nvm
[16:30:19] <brianmc>	 Hi, I'm trying to track down a weird bit of vandalism in enWN. Try popping "{{Wikinews:Dynamic quiz/quiz|{{#time:Y/W|+1 days}}}}" into [[Special:ExpandTemplates]]. I can't figure out what's been vandalised.
[16:31:00] <brianmc>	 nevermind, someone else found it
[22:02:12] <Dispenser>	 How do I lift the purge rate limit for the Toolserver IP
[22:02:44] <Betacommand>	 Dispenser: use a bot
[22:05:37] <Betacommand>	 Dispenser: is this related to your bot request on commons?
[22:05:48] <Dispenser>	 yes
[22:06:15] <Betacommand>	 Dispenser: looks like someone can do it for you but has a question