[10:52:11] Hey, I got a media wiki here that causes all sorts of trouble, first and foremost it times out when i try to reset the password. Is there any way i can debug this? [11:41:16] I have a few articles showing up in a category, but there is no [[Category:name_here]] in the content. What's the best way to debug it? Example article: https://www.freecadweb.org/wiki/EM_FHNode category list: https://www.freecadweb.org/wiki/Category:External_Workbenches and the content when editing: https://paste.gnome.org/pdvfwwshw [11:57:21] Hi. Does anyone know how this page is created? https://en.wikipedia.org/wiki/Wikipedia:List_of_Wikipedians_by_number_of_edits [11:59:39] A bot, iirc [12:00:05] pefi: templates? [12:03:22] Reedy so to make a top 100 List of editors it's best to create a bot? And if you can't use a bot, what would be the second best approche? [12:05:43] Why can’t you use a bot? [12:06:12] To get the list it’ll require an sql query, so you’re probably going to want at least a script to format the results [12:06:19] Even if you manually paste it [12:07:26] a bot needs an account right [12:07:48] No [12:08:01] It could edit anon, or use a users accounts [12:08:02] oohh ok [12:08:22] Wikipedia usually uses bots for separation [12:08:31] so I could use my account [12:09:28] So I want to make a list of top creator and top editor of the month [12:10:33] Reedy is this the right page to read https://www.mediawiki.org/wiki/Manual:Creating_a_bot ? [12:11:14] Ready: 10/10!!!! Thank you! [12:20:51] Reedy: 10/10!!!! Thank you! (I guess I need glasses...) [12:22:36] nick9162: only of mediawiki already has an api that provides the stats you want [12:22:44] if it doesn't, you'll have to query the database directly [12:22:52] sudo ./create [12:22:59] oops, wrong window ;) [12:23:19] duesen how do I query the database directly [12:23:33] is there a tutorial page? [12:24:34] nick9162: for wikimedia projects, we have the Quarry service for this kind of thing. YOu can find instructions and example queries there. https://de.wikipedia.org/wiki/Wikipedia:Technik/Labs/Quarry [12:25:08] For your own wiki, you'll have to talk to your wiki's database though, not use Quarry. Instructions for that are generic to MySQL. You can probably also use something ly PhpMyAdmin [12:25:33] wait, i linked to the german doc page [12:25:43] I need it for my own [12:26:13] Is that what I need? https://www.mediawiki.org/wiki/Manual:Database_access [12:26:20] german is fine :D [12:26:45] nick9162: ah :) but this may be more comprehensive: https://meta.wikimedia.org/wiki/Research:Quarry [12:27:22] Manual:Database_access is more for developers, not for one-off live queries [12:27:35] yes I need for dev [12:27:54] there are two things to learn for you: 1) how to talk to your database at all. thatÄ's not really specific to mediawiki 2) how to formulate the query that you want [12:28:05] So I write a script where I access the database and then output it to a page right [12:28:07] you can probably find example queries for user edit statistics somewhere [12:28:34] yes, you can write such a script. you can do that within the framework of mediawiki, or independently. [12:28:56] you could indeed create a mediawiki extension that provides user statistics nicely on the wiki [12:29:07] in fact, chances are, suich an extension already exists somewhere [12:29:22] hmm question is how to find it :D [12:29:34] there are a lot extensions on mediawiki [12:29:39] but ok [12:32:06] nick9162: i can't find such an extension. but if you want an exampel for how to make an extension that calculates stats and displays them, maybe have a look at https://www.mediawiki.org/wiki/Extension:Statistics [12:32:37] ok, thank you [12:33:12] nick9162: here's an example query finding the users with most edits: https://quarry.wmflabs.org/query/5009 [12:33:50] if all you care about it the last 30 days, you can also use the recentchanges table. it may be easier to use than the revision table (but only has 30 days worth of linfo) [12:34:24] I think that would also be ok [12:35:28] so maybe I need to have a look how it gets the information, parse it an display it to my page [12:36:30] everything sounds so difficult, hope it's easier than it sounds :D [12:36:52] But now at least I have some ideas, links and examples [12:37:04] thank you duesen [16:46:29] Greetings. Is it possible to get the articles with a given word in a specified given time period over the api? Or how would you do such a task? [18:04:42] do you mean edits/diffs containing them? [18:05:23] also how far back are you trying to look [19:34:03] Can't seem to find any documentation for the tags used in MediaWiki:Titleblacklist , etc.. Any idea what page that'd be listed on? [19:34:29] couldn't find anything on trying to search for it [19:35:09] https://www.mediawiki.org/wiki/Extension:TitleBlacklist#Blacklist [19:35:49] Not the most obvious though [19:38:27] can't figure out why that wasn't showing in search results [19:39:16] MW search sucks? ;) [19:40:00] well BESIDES that ... I have my search set to "Everything" by default [19:48:14] side note - shouldn't that extension really be completely merged into Abuse Filter? [19:48:57] Dunno [19:49:00] It's kinda different [20:30:41] Hey. If you want to replace some parts of some articles, what would be the best way to do it? For example all articles from 2018 in a given category. [23:06:04] is someone here who can help with visual editor? [23:18:03] maybe, it really depends on the problem [23:22:00] im stucking at the installation. parsoid is installed, visual editor installed. when i open the webpage i get the following error: [23:22:17] Fatal error: Uncaught Exception: Unable to open file /www/htdocs/.../wiki/extensions/visualeditor/extension.json: filemtime(): stat failed for /www/htdocs/.../wiki/extensions/visualeditor/extension.json in /.../wiki/includes/registration/ExtensionRegistry.php:136 Stack trace: #0 [23:22:17] /www/htdocs/.../wiki/includes/GlobalFunctions.php(52): ExtensionRegist [23:22:17] ry->queue('/www/htdocs/...') #1 /www/htdocs/.../wiki/LocalSettings.php(146): wfLoadExtension('visualeditor') #2 /www/htdocs/.../wiki/includes/Setup.php(124): require_once('/www/htdocs/...') #3 /www/htdocs/.../wiki/includes/WebStart.php(81): require_once('/www/htdocs/...') #4 [23:22:18] /www/htdocs/.../wiki/index.php(41): require('/www/htdocs/...') #5 {main} t [23:22:18] hrown in /www/htdocs/.../wiki/includes/registration/ExtensionRegistry.php on line 136 [23:22:33] what could be the problem? [23:23:14] Does /www/wiki/extensions/visualeditor/extension.json exist? [23:23:32] Chances are you want to use VisualEditor not visualeditor in your wfLoadExtension() call [23:24:53] jes it exists. will take a look [23:25:44] It's likely case sensitive [23:25:55] so it needs to be looking at /www/wiki/extensions/VisualEditor/extension.json [23:26:52] yes, VisualEditor worked with V & E [23:27:02] thanks a lot