[11:03:41] I've been getting a lot of "Sorry! We could not process your edit due to a loss of session data" lately. It seems to happen randomly and usually saving a few times will get rid of it. Any idea what could be causing it? I've tried logging out and logging back in several times as the error suggested, and my browser accepts cookies. [11:08:24] Also, when I try moving an article, it'll often just refresh the page with &action=submit added to the URL, and I'll have to press the "Move page" button several times to move said article. [11:21:04] Srdjan_m: I've heard at least another report too. Any bug report in Phabricator you're aware of? [11:21:58] None that I'm aware of. [11:41:48] sigh [11:41:49] https://quarry.wmflabs.org/query/14076 [11:41:59] can a dev run this in production? [11:42:47] CIA changed their url so I intend to update it with bot [12:01:30] ToAruShiroiNeko: well, that's obviously a very slow query [12:01:32] el_to LIKE '%www.cia.gov/cia/%' [12:01:49] how else can I identify urls containing it? [12:01:59] LIKE is only efficient if you specify a prefix [12:02:46] el_to LIKE 'Http://www.cia.gov/cia/%' ? [12:02:47] ToAruShiroiNeko: try: (el_to LIKE 'https://www.cia.gov/cia/%' OR el_to LIKE 'http://www.cia.gov/cia/%') [12:02:58] oh okay [12:03:00] assuming you wanted to just match the both protocols [12:03:05] yes [12:03:10] if you're looking for subdomain, that'll be more difficult [12:03:40] done already [12:03:43] only 31 rows :/ [12:04:00] WorldFactbook does not have subdomains I hope [12:12:21] is there an easier way to output namespace names in front of the page name? [12:12:30] sort of a full page name? [12:16:22] !ping MatmaRex [12:17:09] ToAruShiroiNeko: page_namespace [12:17:42] ah! [12:17:49] much better than inner joins I was thinking [12:17:51] (that's the namespace number, actually, not the name) [12:18:04] oh so need them innerjoins [12:18:18] i don't think we have the namespace names in the database at all [12:18:42] is there a way I can refer to them? [12:18:54] I know project: means wikipedia: [12:19:10] ToAruShiroiNeko: you could do something like CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]'), and then paste the output into a wiki page so that it gets parsed [12:19:35] I am feeding this to the bot [12:19:47] ToAruShiroiNeko: or you could manually map the numbers to names with a CASE WHEN [12:19:48] so all I need is the foo:bar format [12:20:00] bot will parse it [12:21:41] right [12:21:47] so, something like: [12:23:44] got the output [12:23:46] makes sense [12:23:50] https://quarry.wmflabs.org/query/14076 [12:24:28] ToAruShiroiNeko: http://pastebin.com/sGPSvCvg [12:24:44] if you want it to output the namespace names directly [12:24:58] i took the values from wgFormattedNamespaces and formatted them into the query [12:25:27] as you can see, it's not very convenient ;) [12:32:02] yeah [12:32:07] I jist posted it on my sandbox [12:32:33] I am surpised we have 2300 namespaces :p [12:35:30] MatmaRex in a sense bot is doing CIA's work now :p [12:35:42] ;) [12:36:38] I never thought I would touch the Israel archive [13:45:46] MatmaRex there is another matter maybe you can help me with [13:46:02] So I see entries such as {{cite web| title = CIA World Factbook: Brazil| url=https://www.cia.gov/library/publications/the-world-factbook/geos/br.html}} [13:46:23] as well as good old hyperlinks that link to the factbook, I want to convert them in using the template [13:47:14] yeah? [13:49:26] how can I filter for these, since some already use the template [13:50:03] i don't think it's possible, other than by looking at the page source [13:52:58] well yes [13:53:04] it will be several regexes [13:53:06] https://en.wikipedia.org/wiki/User:%E3%81%A8%E3%81%82%E3%82%8B%E7%99%BD%E3%81%84%E7%8C%AB/sandbox [13:53:11] 3301 entries [13:54:41] I would not object to you helping me with those regexes [15:20:19] To add onto what I said earlier: rollback won't work either. It gives me this error every time I try it regardless of trying to log in and out: "There seems to be a problem with your login session; this action has been canceled as a precaution against session hijacking." [16:07:35] Srdjan_m: please file a bug report: https://www.mediawiki.org/wiki/How_to_report_a_bug [22:02:22] RFC triage meeting starting now on #wikimedia-office