[06:09:24] <Vadtec>	 I have an old database with an old 1.14 wiki in it. All I really want to do is extract a few of the pages from it. Can I do this directly from the database itself? I dont care about the revision history, just want the pages for posterity. (Been looking for the HD with this particular wiki on it for a *very* long time.)
[06:12:36] <Vadtec>	 and yes, ive already attempted upgrading things to newer versions...but 2009 was a long damn time ago
[06:22:11] <Dinoguy1000[m]>	 if the wiki is accessible as normal, use Special:Export
[06:22:35] <Vadtec>	 Dinoguy1000[m]: sadly, all i have thats reliable is the database tables
[06:23:02] <Vadtec>	 ive cloned the git repo, but apparently had all sorts of extensions installed
[06:23:08] <Vadtec>	 no idea what they would be
[06:23:56] <Dinoguy1000[m]>	 have you tried just setting the database up with a 1.14 install and seeing where that gets you?
[06:24:17] <Vadtec>	 yep, loads of PHP errors lol
[06:24:56] <Vadtec>	 hence why im here hopinh there might be a solution
[06:25:03] <Vadtec>	 hoping*
[06:25:13] <Dinoguy1000[m]>	 was the wiki public? is there any chance pages from it might've ended up on Wayback Machine?
[06:25:33] <Vadtec>	 not public sadly
[06:26:55] <Vadtec>	 wow...ubuntu 9.10...thats old, i wonder if it will even install extra packages if needed
[06:27:54] <Dinoguy1000[m]>	 this isn't related to getting pages off of it, but does the wiki have sensitive data of any type (PII, confidential info, etc.)? if not, since you seem to have the only copy of it, you should upload it somewhere to be sure nothing will happen to make you lose it again (I'm gonna sound like a broken record, but I'd suggest the Internet Archive if you can)
[06:29:07] <Vadtec>	 Dinoguy1000[m]: this wasnt that kind of wiki, it was more of a personal notes repo, back before I started putting things in git
[06:29:15] <Dinoguy1000[m]>	 aah
[06:29:20] <Vadtec>	 ive already backed it up into my NAS anyways
[06:29:27] <Vadtec>	 if i loose it i loose it
[06:29:28] <Dinoguy1000[m]>	 👍
[06:29:44] <Vadtec>	 i was only looking to get about 5 pages out of it really
[06:30:47] <Dinoguy1000[m]>	 you mentioned lots of PHP errors when you tried just using a 1.14 install, did you double-check that it had compatible versions of PHP and mySQL? <https://www.mediawiki.org/wiki/Compatibility>
[06:32:08] <Vadtec>	 yeah, the issue is, 1.14 was written for PHP 5.2/5.3, PHP 7 just isnt working, plus im fairly certain there are packages for PHP missing given its so new
[06:32:21] <Vadtec>	 if i want to go that route, ill have to use a VM
[06:32:29] <Vadtec>	 so...i can either try a VM going back to ubuntu 9.10...or put my computer science degree to use and decipher the schema to extract the info....
[06:33:21] <Dinoguy1000[m]>	 AFAIK the database just stores revisions as plaintext, so they should jump out immediately if you go that route
[06:33:24] <Vadtec>	 i mean, 1.14 was released in 2009...its not *THAT* old
[06:33:46] <Vadtec>	 wait wait...i mean its from the stone ages
[06:33:47] <Dinoguy1000[m]>	 the issue would be that you'd have wikitext in that case, not the rendered HTML, and especially if templates were used to any extent, getting from one to the other would probably not be trivial
[06:33:48] <Vadtec>	 yeah..that
[06:34:07] <Vadtec>	 wikitext is fine
[06:34:22] <Vadtec>	 and for what im after, i wasnt using any templates
[06:35:05] <Vadtec>	 what the hell, lets go for broke...ubuntu 9.10 VM it is...
[06:35:07] <Vadtec>	 lol
[06:35:31] <Dinoguy1000[m]>	 you have at least one copy of the database backed up, have you tried just sticking it on a 1.31 install or similar and running update.php?
[06:35:35] <Vadtec>	 OMG the nostalga
[06:35:45] <Vadtec>	 yeah, i have
[06:36:01] <Vadtec>	 it didnt like the old schema
[06:36:37] <Dinoguy1000[m]>	 weird, MW is supposed to support upgrading between basically any older + newer version
[06:37:01] <Vadtec>	 maybe i effed it up
[06:37:07] <Dinoguy1000[m]>	 if the vm doesn't pan out for some reason, you might have better luck with smaller jumps, then
[06:37:09] <Vadtec>	 i suppose i could try
[06:37:19] <Dinoguy1000[m]>	 like to 1.24 or something
[06:41:27] <Vadtec>	 oh, thats what the issue was, something about composer
[06:41:33] <Vadtec>	 says im on version1 and need version 2
[06:41:37] <Vadtec>	 cba to figure that out
[06:41:42] <Vadtec>	 ill try the VM real quick
[06:47:06] <Vadtec>	 oh...hey.... yer suggestion of 1.24 is getting me somewhere
[06:49:36] <Vadtec>	 Dinoguy1000[m]: hot damn, i think its working...
[06:50:04] <Dinoguy1000[m]>	 🤞
[06:50:53] <Vadtec>	 well....no errors after giving the correct permissions
[06:51:00] <Vadtec>	 lets see if it loads in the browser
[06:51:38] <Vadtec>	 holy shit...it lives!
[06:51:48] <Vadtec>	 Dinoguy1000[m]: many thanks
[06:52:06] <Vadtec>	 i guess now ill just upgrade to 1.39 lol
[06:52:17] <Dinoguy1000[m]>	 ooh, nice! happy to help 😄
[06:54:56] <Vadtec>	 Dinoguy1000[m]: thanks again
[06:55:11] <Dinoguy1000[m]>	 np 🙂
[07:04:47] <Vadtec>	 well, for whatever reason, anything newer than 1.24 is complaining, ill have to stick with it for now since i dont want to pollute this particular machine
[07:05:00] <Vadtec>	 its one of a very few i havent fully migrated to docker containers
[11:21:03] <draden>	 hello. is there any way to generate RSS in xml format for updates/articles on mediawiki?
[11:23:58] <taavi>	 draden: yes, see https://www.mediawiki.org/wiki/API:Feedrecentchanges
[11:34:28] <draden>	 actually, I've tried that, but it redirects me to a web page. I'd need to generate several links for given articles on my sites which redirect to an RSS with an XML format. i.e.: https://rathena.org/board/rss/3-support-topics-feed.xml/?member_id=61096&key=e2467f270485318499a20e11a7a0948c
[11:35:29] <Vulpix>	 maybe you have some wrong redirect rules configured on your server
[11:36:04] <Vulpix>	 works on mediawiki.org https://www.mediawiki.org/w/api.php?hidebots=1&hidecategorization=1&hideWikibase=1&translations=filter&urlversion=1&days=2&limit=50&action=feedrecentchanges&feedformat=rss
[11:36:53] <draden>	 hmm.. then i guess i'm doing something wrong in my configs
[11:39:14] <Vulpix>	 the feed is easily accessible if you go to Special:RecentChanges. There's an icon in the menu (on Monobook and Timeless skins at least) that points to an atom feed. You can change the "atom" part in the URL with rss to get an rss feed
[11:43:46] <draden>	 thank you so much for the help! i've got that!
[11:44:29] <draden>	 so can I filter this to given articles as well? or it will list all the recent changes on my site?
[14:30:59] <Guest62>	 Hi, I work on a project and installed TemplateStyle but it doesn't seems to working well as I can't see it loading styling so is there a way to check why it's not working?
[14:34:25] <Vulpix>	 Guest62: If you can inspect the HTML code of the page, a <style> tag should be present at the position where you placed <templatestyles>. Check if it's there and "looks correct"
[14:42:35] <Guest62>	 Thank you for replying Vulpix. I created a template (copied from Wikipedia) and it looks like this https://imgur.com/a/BYENsq6 and when I compared both in DevTool I notice that the template failed to load <div class="navbox-styles">.
[14:43:22] <Guest62>	 Almost all the templates looks similar (without styling) even infobox.
[15:16:45] <Guest62>	 Vulpix seems inactive can someone else please help me out? I created a template (copied from Wikipedia) and it looks like this https://imgur.com/a/BYENsq6 and when I compared both in DevTool I notice that the template failed to load <div class="navbox-styles">.
[16:02:51] <Izno[m]1>	 Guest62, check to ensure Module:Navbox/styles.css is content model sanitized-css
[16:12:39] <Guest62>	 Izno[m]1 yes the content model is Sanitized CSS as mentioned in the page information (action=info)
[16:14:41] <Izno[m]1>	 Is your copy of (English?) Wikipedia recent?
[16:14:51] <Izno[m]1>	 As in the past month or two
[16:15:47] <Guest62>	 The template was copied a few months back but the Module/Navbox/style.css was copied today.
[16:16:21] <Izno[m]1>	 Update the rest of your module pages.
[16:16:46] <Guest62>	 You mean Module:Navbox and related?
[16:16:52] <Izno[m]1>	 Yeah
[16:17:09] <Guest62>	 Ok let me do that very quickly.
[16:23:36] <Guest62>	 Izno[m]1 ok so I updated the Module:Navbox and refreshed the template page. Nothing changed at first but when I purghed cahce by adding ?action=purge in the url it start loading style so is there a way to mass purge cache?
[16:24:06] <Guest62>	 Thank you for your suggestion :)
[16:29:11] <Izno[m]1>	 There might be a maintenance script to purge things, and there's a bot or two out there that do mass null edits. Otherwise, just the job queue.
[16:35:02] <Guest62>	 Hmmm the job queue sound reasonable because setting up bot for this kind of task is quite challenging I guess.
[22:51:56] <RoyK>	 hi all. I have a defunct mediawiki installation, moved from an older system and when I try to update it, I get this - any ideas? https://paste.debian.net/1275965/
[22:57:02] <Izno>	 what version of MW did you upgrade from?
[22:57:22] <Izno>	 and why are you trying to update to 1.37?
[23:00:08] <RoyK>	 I don't remember the old mw-version. The reason I tried to update to 1.37, was that was left last I tried. This has been lying dormant for a while. I tried with 1.39.3, same thing
[23:00:51] <RoyK>	 This happened during a server move and an upgrade from debian 10 to 11
[23:01:35] <RoyK>	 looks like the old was 1.35
[23:02:33] <p858snake>	 on some of the older versions you can't jump straight to the newest via the updater anymore, although 1.35.X is a LTS so it should work
[23:03:50] <Izno>	 and still in support for a little while longer
[23:03:58] <Izno>	 in case that motivates restoring to 1.35
[23:05:10] <Izno>	 That aside, seems weird it doesn't know that categorylinks exists, that seems like you had a really old version of MW at some point
[23:05:24] <Izno>	 so, that kind of points to having a bad initial install to me
[23:06:04] <Izno>	 (nb 1.37 is out of support, which is why I asked the 2nd question above)
[23:10:55] <p858snake>	 in your wikis root directory there should be a Release-Notes-X.XX or History file which will tell you the last version that was installed
[23:12:25] <Dinoguy1000[m]>	 if you haven't already, you should save a backup of your database somewhere before trying anything else with it, too
[23:13:22] <RoyK>	 it must have been an older one
[23:13:37] <RoyK>	 damn - any chance of getting the data out of this?
[23:14:28] <RoyK>	 BrandonWM: it's been some time since this server move and I had just forgotten about this one site, which is just personal
[23:14:54] <RoyK>	 is the version number stored in the db somewhere?
[23:48:31] <Nikhil61>	 can anyone help me to solve this error https://freeimage.host/i/HOFdGB1
[23:51:46] <RoyK>	 hm... trying to 1.35 now - getting some way but I stubmled over this Wikimedia\Rdbms\DBQueryError from line 1699 of /var/www/html/wiki.karlsbakk.net/includes/libs/rdbms/database/Database.php: Error 42703: ERROR:  column "img_metadata" does not exist
[23:52:10] <RoyK>	 this is 1.35
[23:52:20] <RoyK>	 oh - I said that
[23:55:01] <Izno[m]1>	 MW doesn't really support backwards upgrades, the usual way of getting back to a state is to have taken a backup and restore from that
[23:57:35] <Nikhil61>	 sorry i didn't get what i have to do? are u talking about my error https://freeimage.host/i/HOFdGB1
[23:57:49] <Izno[m]1>	 Nikhil61 no
[23:58:33] <Nikhil61>	 ohh sorry then.