[13:42:05] is there a problem with beta? [13:42:36] http://en.m.wikipedia.beta.wmflabs.org/wiki/Main_Page loads HTML only (no css), and http://en.m.wikipedia.beta.wmflabs.org doesn't load at all [14:45:37] Coren: beta sown [14:45:39] *down [16:41:09] 3Wikimedia Labs / 3deployment-prep (beta): depolyment-prep (beta) down - 10https://bugzilla.wikimedia.org/68684 (10Steinsplitter) 3NEW p:3Unprio s:3normal a:3None Beta is atm down. [16:42:23] Steinsplitter: grammar false [16:42:43] 3Wikimedia Labs / 3deployment-prep (beta): depolyment-prep (beta) down - 10https://bugzilla.wikimedia.org/68684 (10Steinsplitter) p:5Unprio>3Highes s:5normal>3major [16:43:08] gifti: oh, indeed [16:43:21] 3Wikimedia Labs / 3deployment-prep (beta): deployment-prep (beta) down - 10https://bugzilla.wikimedia.org/68684 (10Steinsplitter) [17:09:43] 3Wikimedia Labs / 3deployment-prep (beta): deployment-prep (beta) down - 10https://bugzilla.wikimedia.org/68684#c1 (10Tim Landscheidt) 5NEW>3RESO/DUP *** This bug has been marked as a duplicate of bug 68574 *** [17:09:44] 3Wikimedia Labs / 3deployment-prep (beta): beta labs not responding; API shows 503 from varnish - 10https://bugzilla.wikimedia.org/68574#c4 (10Tim Landscheidt) *** Bug 68684 has been marked as a duplicate of this bug. *** [19:03:28] So I have a tool which will (optionally) authorise via OAuth midway through its data entry portion [19:04:06] Thus, when I get the callback, I want to resume the session that I just left, including the data entered [19:05:10] but I'm struggling to think about how I would achieve that? I'm using PHP, so just $_SESSION? With a key and then a server side look up from cache, or just whack all the data in there? [19:05:28] Jarry1250: hey! just use session, yes. [19:06:05] Jarry1250: you should use a different backend for sessions, since otherwise you can't put too much data in $_SESSION (which uses cookies, IIRC) [19:06:29] https://github.com/nicolasff/phpredis#php-session-handler has an example [19:07:44] ExcitedPanda: Well I'm on toollabs, so I guess I can just do this manually (pass a key via $_SESSION and hand it over to redis?) [19:08:04] (...which can then pass me back data?) [19:08:20] (sorry if thats actually a stupid idea, never tried redis before) [19:08:55] Jarry1250: yeah, you can do that too. but you can get that 'for free' by adding the following lines to your PHP script somewhere at the start [19:09:14] ini_set('session.save_handler', 'redis'); [19:09:14] ini_set('session.save_path', 'tcp://tools-redis:6379'); [19:09:21] (copied from http://phpave.com/redis-as-a-php-session-handler/) [19:09:51] ExcitedPanda: Oooh, I shall try this. [19:10:16] Hopefully it'll play nice with OAuth. [19:10:29] (I guess I want to prefix my $_SESSION keys?) [19:10:33] Jarry1250: yup [19:10:53] Jarry1250: ini_set('session.prefix', ''); [19:11:05] Ideal :) [19:11:13] :) [19:45:18] Hi. When I run the query "SELECT user_name,user_editcount FROM user WHERE user_editcount BETWEEN 3000 AND 3200;" on nlwiki_p with "sql nlwiki_p" and then typing the command, I get https://www.irccloud.com/pastebin/HbcB2Eqa as result. When running the query SELECT user_name,user_editcount FROM user GROUP BY user_editcount DESC LIMIT 10000; (exact command = [19:45:19] sql nlwiki_p < editcount10000.sql > test333.txt), some users seems missing: http://pastebin.com/E9viFuVu [19:46:11] I (southparkfan) show up in the first query, but not in the other one. Is this normal? [19:53:07] SPF|Cloud: Yes. GROUP BY selects just one row per group. Most DBs (and IIRC the SQL standard) thus require a "MIN(user_name)", "MAX(user_name)", etc. to spell out which user_name to pick, MySQL & Co. "allow" you to just say user_name and it will pick whatever suits its mood. [19:55:59] okay, and what should I do to let the query also include the "missing entries"? [19:56:08] scfc_de: hey! PM for a min? [19:56:34] SPF|Cloud: Your first query?! :-) [20:03:51] scfc_de: it's for http://nl.wikipedia.org/wiki/Wikipedia:Statistieken/Gebruikers_volgens_bewerkingen [20:05:53] the original query I ran was SELECT concat( '# ',user_name,' (bewerkingen:',user_editcount,')') FROM user GROUP BY user_editcount DESC LIMIT 10000;. After some messing the query I want to use for that list is SELECT concat( '# {{intern|1=title=Gebruiker:',user_name,'|2=',user_name,'}} (bewerkingen:',user_editcount,')') FROM user GROUP BY user_editcount DESC [20:05:53] LIMIT 10000;. [20:07:18] the GROUP BY is to order it from most edits to less edits - the purpose of the list in general. Idk how I should order it without running it with order by :|. [20:08:15] SPF|Cloud: Use "[...] FROM user ORDER BY user_editcount DESC"?! [20:08:41] k [20:11:24] running it without LIMIT 10000 doesn't work either, sorry.. [20:12:53] SPF|Cloud: What does "doesn't work" mean? [20:13:09] did you actually try order by? [20:16:51] 22:12:55 SPF|Cloud: What does "doesn't work" mean? <- I get the same problem, with or without LIMIT (you told a query without LIMIT) [20:17:21] hmmm [20:18:02] SPF|Cloud: What is the exact query you are trying to run, and what is the exact error message that you get? [20:18:44] command: sql nlwiki_p < editcount10000.sql > test323.txt - sql file = SELECT concat( '# {{intern|1=title=Gebruiker:',user_name,'|2=',user_name,'}} (bewerkingen:',user_editcount,')') FROM user GROUP BY user_editcount DESC; [20:19:16] SPF|Cloud: You want to get all users with editcount higher than 10.000 edits? [20:20:16] multichill: wait a sec. [20:20:46] you miss rows? group by and order by are not equivalent [20:21:07] I'll try group by then [20:21:07] MariaDB [nlwiki_p]> SELECT user_name, user_editcount FROM user WHERE user_editcount > 10000 ORDER BY user_editcount DESC limit 10; [20:21:23] RomaineBot 1428204 [20:21:33] multichill: for http://nl.wikipedia.org/wiki/Wikipedia:Statistieken/Gebruikers_volgens_bewerkingen, I try SELECT concat( '# {{intern|1=title=Gebruiker:',user_name,'|2=',user_name,'}} (bewerkingen:',user_editcount,')') FROM user GROUP BY user_editcount DESC LIMIT 10000; [20:21:44] It should return a similiar list [20:21:52] omg! [20:21:59] Oh [20:22:42] One moment [20:22:47] 22:20:48 you miss rows? group by and order by are not equivalent <- that was the problem [20:22:55] SPF|Cloud: I said you should use "ORDER BY user_editcount" instead of "GROUP BY edit_count". [20:23:03] thanks! :) [20:23:09] oh sorry, didn't saw it then [20:23:22] so glad :) [20:23:36] I guess issue solved [20:29:17] SPF|Cloud: Als je nog handig vindt : https://tools.wmflabs.org/multichill/queries/nlwp/top_edit_users.sql en https://tools.wmflabs.org/multichill/queries/nlwp/top_edit_users.txt [20:29:39] oh dat kan ook [20:29:57] ik zat met join te prutsen om gebruikers uit te sluiten met de botflag [20:30:09] Oh, ja ik zie dat er nu een nette tabel is [20:30:13] Zal het er eens uitvissen [20:30:35] SELECT concat( '# {{intern|1=title=Gebruiker:',user_name,'|2=',user_name,'}} (bewerkingen:',user_editcount,')') FROM user WHERE user_editcount >= '1' ORDER BY user_editcount DESC; zal de query voortaan worden geloof ik [20:30:47] alleen nog ff kijken of die lijst dan niet té groot gaat worden [20:32:24] SPF|Cloud: https://tools.wmflabs.org/multichill/queries/nlwp/top_edit_users.sql [20:33:39] Ik weet niet of mensen dat trouwens wel willen. [20:33:57] Ik weet dat andere wiki's een opt out hebben [20:34:17] wat willen? [20:34:35] Een lijst van iedereen met het aantal edits [20:35:15] als iemand eruit wilt dan kan dat gewoon [20:35:58] maar als zoiets echt problematisch is dan kan het denk ik wel op de beoordelingslijst [20:36:49] Dit is wel een beetje my first database query ;-) [20:37:23] dat ik echt wat simpele queries kan doen is ook pas sinds gisteren [20:37:47] Op een of andere reden beginnen mensen altijd met edit counters [20:38:04] serieus? [20:38:14] Ja [20:38:20] Dat was in de Toolserver tijd al zo [20:38:36] Op een gegeven moment waren er wel 10 verschillende edit counters [20:38:47] het begon eigenlijk meer als een grapje in een PM met smile [20:39:41] Ik weet niet meer welke dat was en of die verhuisd is, maar je had altijd een vrij mooie met allerlei grafieken etc [20:40:30] ik weet alleen dat ik een sql quiz foutloos deed en bij een html quiz 5 fouten maakte (beide 20 vragen) [20:45:29] btw multichill, van WHERE user_editcount > 10000 heb ik hier gewoon even WHERE user_editcount >= '1' - anders zou het eigenlijk een half-onnodig lijstje worden [20:45:40] of moet de naam veranderd worden ;)