[00:31:43] Hi, how do I customise the menu at the bottom of every pages "Politique de confidentialité | À propos de XXX | Avertissements" [00:52:33] Customise? [00:53:12] Probably using the ArticleViewFooter or probably more likely the SkinCopyrightFooter hook [00:55:11] Reedy, I want to remove and add things [00:55:29] !hook SkinCopyrightFooter [00:55:29] https://www.mediawiki.org/wiki/Manual:Hooks/SkinCopyrightFooter [10:55:15] How can I make a upgrade von 1.28.0 to 1.29.0 ? [10:56:03] 1.28.2 [11:10:34] !upgrade [11:10:34] http://www.mediawiki.org/wiki/Manual:Upgrading [11:36:38] Is there a way to display 1 random image from a list of images? [12:29:21] hey guys, does anyone know what Wikipedia uses to have cloud9 IDE when editing script/css pages? [12:39:12] what is "cloud9 IDE" and what makes you think Wikipedia uses that? [12:39:56] !e CodeEditor [12:39:57] https://www.mediawiki.org/wiki/Extension:CodeEditor [13:01:05] thanks @reedy [13:01:16] I remembered the name of the editor incorrectly, but thanks :P [13:01:38] well, ace is part of c9 [13:01:40] or something [16:32:38] Why does composer hate php 7.2? or did I miss a module with my install [16:33:07] Is 7.2 even released yet? [16:33:11] What version of composer? [16:33:30] whatever version falls under getcomposer.org, and it's in the PPA from that ondrej guy [16:33:45] I get an ascii picture of a middle finger and this error: php: symbol lookup error: php: undefined symbol: pcre_jit_exec [16:33:53] lol [16:34:23] that finger ascii is not okay :/ [16:34:31] That kinda sounds like php is fscked [16:34:35] then again I figured running composer would stop making my fresh mw 1.29 install stop just echoing run(); sooo [16:35:01] Well, to be fair I mostly inferred the ascii picture because this is starting to get annoying [16:35:20] if it's just echoing run.. That sounds like a php issue tohugh [16:35:35] Why do you always take the program's side Reedy [16:35:43] Ulfr: I can blame you if it helps [16:35:59] Well, you usually do. It's all like, oh you messed up Ulfr. It's not the code's fault [16:36:13] EXCEPT that one time there really was a crippling bug [16:38:28] Would someone mind checking if I'm in the twilight zone or if this ppa is really hosed and I have worse than usual luck? ppa:ondrej/php [16:53:29] I accidentially deleted my LocalSettings. [16:53:37] Where is the install script placed? [16:54:05] The install guide is frustratingly silent on this. [16:55:53] svip: install script? [16:56:23] svip: the normal installer is in the mw-config/ directory. there's also a command-line script at maintenance/install.php [16:57:36] MatmaRex: It'snot a problem if I install over an existing database, right? [16:57:43] As in, it won't delete it. [16:58:02] svip: no idea. i would imagine that it wouldn't let you do that though [16:58:26] svip: the only thing you really *need* in your LocalSettings.php is the $wgDBwhatever settings. you can just recreate that by hand if you know where your database it [16:59:28] OK. [17:13:25] MatmaRex: It worked. [17:13:41] Although, I see some reference til templates starting with #, that I have no idea what I meant by. [17:13:58] Such as {{#ipa:{{{1}}}}}, but it yields nothing. [17:14:18] I cannot remember what a template starting with # means. [17:14:25] svip: that looks like a parser function. presumably you had some extension installed that added that [17:15:28] Oh gah. [17:15:34] Well, thanks. [17:15:38] I don't have time to fix that now. [17:16:38] It looks like I may have written my own extension that I now deleted, because I wasn't thinking. [17:17:11] Ah well... [17:17:51] I have to go. [17:18:04] At least the important data, the content, was saved. [17:23:03] I'm trying to run the update.php script from an app-server which tries to connect to a db server. I get the error [17:23:06] "No route to host" [1] http://dpaste.de/wT5n [17:23:25] But I can ping the db server from the app server. [17:23:42] And it looks like I can traceroute too, but the !X means "communication administratively prohibited" Prohibited by what? The security group (aka firewall) for these hosts on AWS allows all traffic for all protocols from anywhere. [17:24:05] Can you connect to mysql on the command line? [17:29:58] Reedy: no.... ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.50.53' (113) [17:30:29] so it's not specifically an MW issue [17:30:41] does your wiki work? [17:31:23] I'm in the middle of setting it up with an ansible playbook, and it dies at this stage [17:31:46] I agree this is not a mw problem, but looks like an AWS problem [17:31:54] mmm, I'd probably concur there, yeah [17:33:06] I'm no AWS expert, but I really have no idea why two hosts that can SSH, ping etc. and have ports wide open still don't talk mysql [17:34:03] I'll go check "internal" firewalld rules on A and B [17:37:02] So one of two things [17:37:05] either all the ports aren't open [17:37:18] or mysql isn't binding on the right ports/to the right ips [17:44:41] SOLVED.... the ansible role had not yet set appropriate firewalld rules on the db server. I *thought* mysql/3306 was open, but it wasn't [17:45:05] heh [17:45:36] * freephile slaps forehead DOH! [19:34:01] @Reedy: in my case, the playbook was setting up rules in firewalld, but Firewalld has "zones" and I configured it to put rules into the "trusted" zone, without setting the default interface eth0 to use "trusted". [20:19:09] Hi [20:19:14] Anyone here good at SQL? [20:19:22] I've got a malfunction in query [20:19:44] https://quarry.wmflabs.org/query/20707 It's returning an entry I am not sure it should be [20:21:10] What's wrong with it? [20:21:34] https://en.wikipedia.org/wiki/File:Yevgeny_Kabanov.jpg shouldn't be in it [20:21:48] Why not? [20:21:49] But shows up in the query results , so my logic is flawed somewhere [20:22:03] Reedy : Because that file IS in use... [20:22:13] The query should be finding ones that aren't [20:24:20] Replag? [20:24:22] Link corruption? [20:24:29] Had a look for that page name/id in those tables? [20:24:38] Possibly but I think my logic may be flawd [20:24:51] Well, check that first, it's relatively easy [20:24:54] Can you check the query itself... [20:24:56] ? [20:25:10] It wouldn't be the first time labs had bad replicas [20:26:08] Is there a phabricator thread for possible replica glitches? [20:26:28] The other option is simplifying the query. Remove one of the joins etc [20:26:53] Do you have suggestions on how to possibly do that? [20:27:22] your second left join makes no sense to me [20:27:41] it looks like you're looking to exclude files in Category:All_orphaned_non-free_use_Wikipedia_files from the results, is that correct? [20:27:56] Skizzerz: Yes [20:28:05] Because they are already known about [20:28:16] may be better to write that as NOT EXISTS(SELECT ...) instead, to make the intent more clear [20:28:20] although it shouldn't impact the resultset [20:28:53] (if mysql's optimizer is any good, it'll make the query a bit faster though, as it'll let you do a left anti-semi-join instead of a full left join) [20:29:19] At which point I start drooling as my mind melts :( [20:29:46] anyway, I don't see any real logic errors from a cursory glance [20:30:09] Hence my suggestion to say to check the datasource [20:30:14] Which is puzzling because the list should exclude - https://en.wikipedia.org/wiki/File:Yevgeny_Kabanov.jpg [20:30:24] so I recommend following Reedy's advice :) [20:30:31] Which should actually have one of the relevant ID's [20:30:50] a good first thing to do is expand the select to include additional columns [20:30:56] so you can see why it's not being filtered out [20:30:58] Is there a fast query to see what the databse thinks it's seeing? [20:31:08] seeing? [20:31:26] SELECT CONCAT('File:', p.page_title), * FROM page p ... [20:31:41] will let you see the result of all of the joins [20:31:59] you may want to add a WHERE clause to filter to just the file(s) in particular that are wrong [20:35:02] OKAY [20:35:13] I am clearly incompetent [20:35:26] I give ti what I think is vlaid synatx and it isn't [20:35:33] ? [20:35:53] link? [20:36:09] https://quarry.wmflabs.org/query/20707 was the query in question [20:36:54] hmm [20:37:00] does mysql not let you put * after column lists? [20:37:22] It should, yeah [20:37:46] Apparently ... [20:37:48] oh [20:37:51] does it need tablename.* ? [20:38:00] maybe... [20:38:18] I'm not sure how you show all rows in a query if you have joined stuff... [20:38:28] * should do it [20:38:28] looks like it [20:38:37] if you remove your concat [20:38:47] the "double quotes" are non-standard SQL btw, but mysql accepts it [20:38:50] OR [20:38:54] put the * first seems to work [20:38:54] technically all SQL strings must be 'single quotes' [20:39:32] does naming the concat column work? [20:39:37] e.g. CONCAT(...) AS foo, * [20:39:44] I don't have a mysql prompt open to test [20:39:47] I took the CONCAT out completly [20:39:53] It still doesn't like ,* [20:39:59] no , in front [20:40:03] if you removed the concat.. [20:40:21] just SELECT * if you took out the concat [20:45:52] Query is running currently [20:45:58] It's taking a while [20:46:24] And might not work due to a bug someone mentioned the other day about having 2 tables of the same name in the join [20:47:03] I think the whole query might need rethinking [20:52:04] https://quarry.wmflabs.org/query/20707 [20:52:05] Hmm [20:52:22] The labs copy has no il_from enntry [20:52:39] It should have an article name or a key reference if the image is in use right? [20:52:51] Could be various reasons wy not [20:52:56] The query is working [20:52:58] Let's see what the actual db servers have [20:53:21] Assuming there isn't a peske redirect involved [20:53:52] page_id is 50272227 [20:54:01] For what? [20:54:04] The image [20:54:11] or the page where it's used? [20:54:21] the image [20:55:02] hmm [20:55:06] Something's not making sense [20:55:11] select * from imagelinks where il_to = 'Yevgeny_Kabanov.jpg'; [20:55:11] +----------+---------------------+-------------------+ [20:55:11] | il_from | il_to | il_from_namespace | [20:55:12] +----------+---------------------+-------------------+ [20:55:12] | 50272052 | Yevgeny_Kabanov.jpg | 0 | [20:55:15] +----------+---------------------+-------------------+ [20:55:16] 1 row in set (0.00 sec) [20:55:26] https://quarry.wmflabs.org/query/20707 [20:55:30] Is what I am seeing [20:55:42] I saw [20:55:50] But as I was saying earlier, simplify it [20:55:50] https://quarry.wmflabs.org/query/20709 [20:55:54] There's no rows [20:56:02] The labs replicas are rong for some reason or other [20:56:05] *wrong [20:56:14] Time to raise a ticket? [20:56:26] If you wouldn't mind doing so :) [20:56:33] Why can't you? :P [20:56:53] because I was sure this had been tracked before in a previous one [20:57:08] And I don't have a direct access to the db [20:57:20] I only have the Quarry view [20:57:36] Something is wrong though [20:57:38] Doesn't matter if you don't [20:57:48] Me giving you the information is fine :) [20:57:59] It's not like I've disclosed any secrets [20:58:14] * Reedy files a bug [20:58:24] is il_to meant to be a page title or a page_id though? [20:58:39] to is a page id, from is a title [20:58:53] Now I'm confused [20:59:07] other way round [20:59:17] And might be querying the wrong thing.... [20:59:29] And I am going to need a strait-jacket soon... XS [20:59:32] *XD [20:59:35] sorry [21:00:14] And I can't type emoticons either at the moment [21:01:31] https://phabricator.wikimedia.org/T172567 [21:05:05] Thanks [21:17:37] And on something else - https://testpilot.firefox.com/experiments/voice-fill?sample_rate=0.01&snippet_name=6927#utm_source=desktop-snippet&utm_medium=snippet&utm_campaign=TPQ4&utm_term=6927 [21:17:58] I appreciate work was being done on Text to Speech already... [21:18:06] Were there plans for Speech to text as well? [21:26:10] This is something WMF/mediawiki should be getting in on. [21:26:45] "OK Wikipeida, Find me the article on SQL...." ;) [21:26:56] Ask the mobile team ;) [21:27:04] I suspect there's echo applications for that [21:27:11] *Wikipedia sorry [21:27:22] Reedy: Are the mobile team on IRC? [21:27:36] Yah, they have a channel #wikimedia-mobile [21:27:43] Else, search and file a bug? [21:28:20] "Looking for more detailed information? Alexa also has Wikipedia integrated out of the box, just say “Alexa, Wikipedia: [subject].” It will give your some brief info, but you can hear even more by saying “Alexa, tell me more”."