[00:58:28] Hello, can someone help me with a question about recent changes? [00:59:39] My site tags recent changes with a foreign ID so we can query RC with the specific ID. After running maintenance/rebuildrecentchanges.php, the IDs are lost. Does anyone know if there are upgrades which address this problem? Running 1.21.1 [01:04:40] CatcatK: what is the purpose of the foreign ID? RC_ID normally handles that [01:07:13] it's an ID that maps to our own data, like an articleID [01:10:12] CatcatK: keep in mind tables like recent changes are not designed to stick around. [01:10:34] rebuildrecentchanges deletes what you have and re-creates it via other tables [01:11:21] Yes, that's what we found. How would you recommend us to store this piece of information per RC? [01:13:16] CatcatK: depends on what your trying to do. rev_id, or or log id [01:15:28] Think of mapping several pages to an article, and we use rctag to query the recent changes belong to that article [01:16:35] I actually think this is a design flaw from Mediawiki because the change_tag table isn't truncated either. It might have been an overlook. [01:17:07] CatcatK: I think the revision table uses that [01:18:16] yes, there's ct_rev_id = rev_id [01:18:45] CatcatK: without getting a better understanding of what/how your data/extension works its hard to figure out what you really need [01:20:10] CatcatK: the change tags have no relation to the recent changes table [01:20:23] which is why they dont get truncated [01:21:18] Really? I thought ct_rc_id = rc_id [01:22:44] because once we run the maintenance script, we can no longer query recent changes by the tag. [01:22:57] CatcatK: that is used to display tags in the recent changes table [01:23:39] CatcatK: why do you run that script more than once in a great while [01:24:08] Our usage is like this, we tag 50 pages with "mario". 5 of those pages were edited and showed up in the /mario/Special:RecentChanges (a special page we made to list recent changes belonged to a tag) [01:24:29] once the script is ran, the Special:RecentChanges page is empty [01:25:09] CatcatK: that script isnt designed to be run regularly, why is it being run? [01:25:27] we actually ran it without knowing it was a part of rebuildall.php [01:25:51] we ran rebuildall to refresh the Pages with Broken File category [01:26:05] ah [01:27:37] I will try to hack the rebuildrecentchanges script to retain the tag from the query then. [01:27:41] Thanks for your help so far! [01:28:34] CatcatK: the ideal solution would be a little different [01:28:46] Let's hear it [01:30:03] CatcatK: what I would write is a script to query rc table, find all affected revision ids see if those are in ct table, and then update the associated tc_rc_id field with the new rc_id [01:30:41] thats really the only way to rebuild/update it [01:31:38] the way that the RC table is re-built is by deleting it, and reparsing everything and recreating the table that way [01:32:05] ah ok [01:32:22] what's the rev_id in rc? [01:32:47] (sorry, not very familiar with the tbl structure yet) [01:32:50] its the primary key for the table. [01:33:03] used for several queries [01:33:18] its also auto-incremental too [01:33:31] thus you cannot change/keep it [01:35:02] CatcatK: https://www.mediawiki.org/wiki/Manual:Database_layout [01:35:55] That's great! I will look into this [01:35:57] thanks a lot [01:37:07] CatcatK: np [02:59:01] Using VisualEditor, if I use a text style of Preformatted, it places spaces in front of its contents. If I press enter, it starts a new paragraph and a new line that can have a separate gray box. If I go into source and remove the blank line, VE can show multiple lines together. If I switch that area to style Paragraph, it shows an enter character (<-^ ish but a single character) that I can copy and [02:59:03] paste to use. Is there a way I can type this single enter rather than a double enter to start a new paragraph? (Without copy/pasting.) [03:02:05] If I copy that character into vim and xxd it, it shows as 0x0a (LF.) Pressing CTRL+Shift+U, 0A, enter, unfortunately does the same thing as enter on the keyboard, inserting in source a double enter. [05:21:16] hmm is there some faster way to delete spam with SmiteSpam? [11:49:17] hi [11:49:35] i found urls on a wiki like this "//blablabla" [11:49:47] how to make the "//" be "https"? [11:50:25] i forgot the correct name forthis [11:58:42] biberao: // will be https if the page where are inserted is https. If you want to force https use https:// urls and not // [12:04:28] hum ok thanks [12:04:32] another thing [12:04:42] whats the best way to add a background image on a wiki? [12:05:30] upload image somewhere and use site CSS for background-image [12:06:53] ok got it [12:06:54] thanks [12:07:39] can i define like #mw-head to add an image there? [12:10:48] ok it works but when adding on common.css doesnt work so [12:10:52] gonna try something different [12:12:02] not working :| [12:12:21] it works on inspector not adding to vector.css or common.css [12:12:34] oh wait it worked now [12:12:54] :D now which part would be the div for the background? [12:13:26] that's up to you [12:14:28] should i add it to body? [12:15:21] the real question here is, where do you want the background to appear? [12:15:46] like behind the content [12:17:19] it can cover the footer and sidebar [12:19:21] if it's behind, it can't cover [12:19:25] yes [12:19:28] i need it behind [12:19:54] try to set the background image on the body [12:23:33] ok the body covers most of it [12:24:51] but doesnt work on common.css nor vector.css [12:27:03] where it works, then? [12:29:54] working :D [12:32:38] so i can force https for // [12:32:39] how? [12:32:51] ah [12:32:55] ok i read what you said better [12:32:56] :D [12:35:39] thankd [12:35:41] thanks [12:35:49] yw [15:46:06] Hi, can i load the same extension twice with a different name or something? [15:49:12] better not hum [16:34:44] Anyone doing sitemaps by use of an extension? [16:38:52] I wonder if we could breake the url into different priorities like some for images and other for pages [16:46:29] !wg SitemapNamespacesPriorities [16:46:29] https://www.mediawiki.org/wiki/Manual:%24wgSitemapNamespacesPriorities [16:46:39] well it is possible with that [16:46:47] i was trying to use this autositemap [16:47:06] but i was trying to see if i could adapt it to be able to change priorities [16:47:19] But from reading it adapts itself from revisions [16:48:36] I'd say google doesn't give a f** about sitemaps. It uses it only to warn you in search console about problematic URLs, but nothing of relevance [16:48:52] id say the same [16:49:05] round(self::getPriority(),1 <- thats the priority settings on the php file [16:49:08] but the coder says this also [16:49:26] # 0.0.3: added 'priority' and 'changefreq' tags management in the 'Options' form. (2006/09/16) [16:49:39] # 0.0.4: Unicode support, gmdate format, exponential and quadratic priorities. (2006/09/17) [16:50:33] either use this or use default sitemap generator with crontab [16:50:51] i Wonder if with addUrl is possible to break an url into like images and all [16:53:00] thanks [18:22:09] Hi, upon upgrading to 1.32, we lost Special:PopularPages. is there a way to get it back, or is there an alternative? [18:38:43] Hmm… A page has the content #REDIRECT [[page]] but it does not redirect. It just loads the page - for example - index.php/File:File-name.png and shows the image and that there’s a redirect. Is there something that needs to be configured to make the page automatically redirect? [18:46:14] To generate the sitemap for the wiki i need to have NS_FILE generated once a month [18:46:27] and another pages once a week. [18:46:31] is there a way to have this? [21:00:56] "Estimated Input Latency [21:00:58] 570 ms" [21:01:04] anyway to improve this? [21:17:01] Is there a way to get something like the former special:popularpages in 1.32? [22:01:46] Anyone? [22:28:42] I guess not. [22:32:50] :\ [22:39:17] GuidodB: have you looked at the HitCOunters extension? [22:39:22] !e HitCounters [22:39:22] https://www.mediawiki.org/wiki/Extension:HitCounters