[07:59:04] !help Hi, I got report to on sr.wikisource users can not patrol changes, only can new pages. [08:10:13] yeah [08:10:16] there's no !help [08:10:21] plus see my previous question [08:17:27] I no see it [08:18:34] Oh, I found in log [08:18:48] Krenair: We need and RC patrolling [08:25:24] I talked with Urbanecm [08:25:32] I know how to fix now. Tnx! [11:00:08] Morning [11:00:16] Anyone here good with SQL queries? [11:00:20] Hi ShakespeareFan00 [11:00:25] How can I help you? [11:00:30] https://quarry.wmflabs.org/query/18892 [11:00:39] Isn't dropping out some entries it should [11:00:46] File:2002_PORT_Philippe-Vandenberg©Picture-Julien-Vandevelde.jpg [11:00:55] for example shoudl not be listed [11:01:03] What do you want to know? [11:01:03] Suggesting the query is flawed [11:01:27] Urbanecm: How to fix the query so it doesn't list images that it shouldn't [11:01:47] Firstly I need to know what images you want to have displayed [11:02:05] Urbanecm: Images lacking an {{information}} template [11:02:11] but that are not in certain categories [11:02:37] or which have certain other maintainence templates [11:03:28] The Query is series of LEFT JOIN's to do an elimination of material based on templates and category links [11:03:42] So you want to know images without {{information}} minus files in some categories minus files using defined maintainence templates? [11:03:46] Did I understand you right? [11:03:48] Yes [11:03:58] Ok, looking on your query, please wait a moment [11:04:22] Currently it has 5 images still listed that based on the templates and categories I'd given as parameters it shouldn't be [11:04:42] Looking, will tell you what I discovered [11:05:38] ShakespeareFan00, are you looking for images on commons or on enw? [11:05:44] *enwiki [11:06:28] enwiki [11:07:09] ok [11:08:15] * Urbanecm is re-running the query [11:16:58] ShakespeareFan00, hmm. It seems like db bug to me [11:17:37] see https://pastebin.com/raw/D7tf6KUU [11:17:55] one of mistakenly displayed file isn't in categorylinks [11:18:31] Ha, null edit fixes it [11:22:20] ShakespeareFan00, in short. There is problem with data in categorylinks, because they are not sometime correct [11:22:31] Hence, your query reports correct result [11:23:06] but as data in DB are incorrect (at least on db replicas), you don't expect the result [11:23:19] You can force the data in categorylinks to rebuild by nullediting the file. [11:23:27] If you rerun your query without changes, it should magically work [11:23:29] ShakespeareFan00, ^^^ [11:34:19] AH.. [11:34:24] So I just need to be patient [11:34:53] (I'm used to when the tools'labs erver sometimes took days to update it's replication) [11:35:20] No, those data are permanently incorrect, unless somebody edit the page [11:35:22] ShakespeareFan00, ^^ [11:35:40] There's a phab task for it, don't have the number currently [11:35:45] Ah... [11:35:58] So I need to edit the pages that get listed in error? [11:36:06] (reviewing them at the same time)? [19:45:43] I added this to my LocalSettings.php file, but the string doesn't appear in the footer. Any idea what I'm doing wrong? https://www.irccloud.com/pastebin/UcWAUkCd/ [19:48:38] PhoenixFlames, footertext? [19:48:42] is that a thing? [19:49:00] I thought so? [19:49:01] https://www.mediawiki.org/wiki/Manual:Footer [19:49:37] I mean, it doesn't work. So who knows. [19:50:01] hmm [19:50:20] not in Vector [19:50:31] I'm using Vector, of course. :/ [19:50:36] nor MonoBook [19:51:10] So how do I add static text to the footer? [19:53:18] Yeah, looks like Vector is looping over a footerlinks array, then footericons. [19:53:21] No static text [19:57:31] The message MediaWiki:Copyright is one method [19:58:10] What's that, bawolff ? [19:58:34] The page on your wiki named MediaWiki:Copyright is shown at the bottom of all (non-special) pages [19:58:34] * PhoenixFlames edits VectorTemplate.php and calls it a day. [19:58:43] Oh, thanks. [19:58:54] But I already have a copyright notice I'm using, seperately. [19:59:01] The usual intention being if you have to put a copyright notice on your wiki [20:00:17] Thanks! [21:46:31] Have a question for anyone looking... [21:47:04] Phantom873: Ask :) [21:47:15] I can't seem to resolve this issue. I've tried many things and nothing seems to help [21:47:18] https://usercontent.irccloud-cdn.com/file/34Y5mL6G/image.png [21:47:33] I have root and sudo access on a Ubuntu VPS [21:48:14] is this a wikimedia VM? [21:48:50] Yes. Wikimedia install [21:49:06] https://usercontent.irccloud-cdn.com/file/hvNcK8kA/image.png [21:49:09] I've just ran a Google search and saw some related post about it [21:49:22] https://www.mediawiki.org/wiki/Topic:U1d7v1r2lfvt84cs [21:49:27] https://www.mediawiki.org/wiki/Topic:Roc8u8kdlhgo3x6i [21:49:40] I've ran *many* google searches... [21:49:40] https://superuser.com/questions/1183462/cannot-create-process-proc-open-failed-to-open-stream-permission-denied [21:49:57] If you'll look at those links you're posting, the issue hasn't been solved [21:50:11] Phantom873: Hmm... Not a big fan of Lua to be honest, so maybe someone with more experience can help :) [21:50:19] Phantom873: is open_basedir specified in php ? [21:50:21] Phantom873: Sure, they haven't as I've seen. [21:50:59] also, albeit most unlikely to be wrong, what are /dev/null permissions? [21:51:25] open_basedir https://usercontent.irccloud-cdn.com/file/wBZe2zdD/image.png [21:51:27] not set [21:52:28] /dev/null is 0666 [21:53:02] and the binary is there? [21:54:27] I'm not Linux fluent... clarify binary. I think I know what you mean, but I want to be Army proof here [21:55:15] the file that should be executed [21:55:24] not sure how it is named... [21:58:14] I'm not sure what we are talking about then. I'm sorry [21:59:58] Platonides: since the Mediawiki install in question is a private non-wikimedia instance should I be in #mediawiki? [22:00:54] that would have been more suited [22:01:09] too many irc channels :P [22:01:32] My apologies, I'll relocate. (I know what you mean. I idle in at least 35 WMF channels alone)