[14:43:49] [[Tech]]; 62.90.100.232; /* Please advice. Those shitty browsers ( Mozilla chrom and Explorer ) issuing message "Can not load page" when I trying to open WIKIPEDIA */ new section; https://meta.wikimedia.org/w/index.php?diff=14127785&oldid=14098799&rcid=6893223 [14:49:20] [[Tech]]; 62.90.100.232; /* Since half an year ago I could not open WIKIPEDIA page. Cannot Load Page message. The browsers are thelast version. What I can do ? */ new section; https://meta.wikimedia.org/w/index.php?diff=14127871&oldid=14127785&rcid=6893236 [14:50:21] I think one topic is enough [18:15:21] [[Tech]]; Kcg2015; /* Number of rows in pagelinks table */ new section; https://meta.wikimedia.org/w/index.php?diff=14130968&oldid=14127871&rcid=6893587 [18:16:43] Hello, does anyone have a rough estimate as to the number of rows in the enwiki-latest-pagelinks.sql table? [18:22:12] goo1: no, but i can probably get one [18:22:41] that would be great! [18:23:20] I'm currently importing the table into a database and am around the 380 million rows mark. [18:23:33] I need some sort of idea where it should stop :) [18:24:19] err, even count(*) is taking forever [18:25:02] goo1: hmm, i wanted to do an 'explain select' query which gives a row number estimate (mediawiki does that internally), but apparently i can't at http://quarry.wmflabs.org/ [18:25:13] goo1: 1108279191 [18:25:22] (via SELECT TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='pagelinks';) [18:25:53] that's apparently accurate within 4% according to some random blog I found [18:29:36] thanks for that! [18:29:45] really helpful, i've been digging with no luck at all [18:29:59] over 1 billion links? [18:30:17] apparently :) [18:30:47] legoktm: EXPLAIN SELECT … (without where) [18:30:55] That tends to be okish [18:31:27] hm, that says 1001487345 [18:37:57] Thanks for all that :) [18:38:15] One last question, is there a limit on the number of pages the "what links here" page will list for you? [18:38:20] or will it always show all the pages [18:39:34] 50 but paged, e.g. https://en.wikipedia.org/wiki/Special:WhatLinksHere/Barack_Obama [18:45:23] thanks for all the help :) [18:45:32] This was very helpfull [19:27:07] Hello everyone I am back on Wikipedia. [19:31:46] I will be getting the mop back later and I plan on doing more content work. My wikibreak really helped me out. [19:35:44] Nice to know that Floquenbeam! [19:35:53] Thank you Niharika [20:12:07] !ops ^^ imposter [20:12:31] yw [20:12:35] ... [20:12:39] >.> [20:12:44] No idea who you're talking about [20:12:49] {{sofixit}} [20:13:16] legoktm: ORLY? they're in at least a half dozen channels [20:13:25] RD: see -en-admins [20:23:21] anyone here know much about the Sprint phabricator plugin? https://github.com/wikimedia/phabricator-extensions-Sprint [20:23:46] It seems to be broken after the most recent upgrade of phabricator, no longer functioning [20:26:54] twentyafterfour: ^ ? [20:27:12] I can't get it working [20:28:05] Because in the latest phabricator upgrade, they removed AphrontUsageException and replaced it with AphrontMalformedRequestException [20:41:57] legoktm: chris johnson of WMDE knows more about it than mukunda, but I don't know his nick [20:43:11] I don't think he's on irc atm [21:00:09] orion83, file a bug report? [21:00:26] I said that in -devtools ;) [21:00:28] https://phabricator.wikimedia.org/maniphest/task/create/?projects=Phabricator-Sprint-Extension [21:00:30] ah [21:00:31] thx [21:03:10] I shall! [21:03:37] I'm trying something sneaky first, just removing the three small lines of code in Sprint that use the AphrontUsageException [21:04:12] otherwise I will file [21:16:24] when in doubt, just delete the code