[08:16:20] <akshatji>	 Hello mediawiki, I have a request from the community. I was recently a part of amFOSS-Wikimedia hackathon (https://meta.wikimedia.org/wiki/Wikimedia_-_amFOSS_Hackathon) so I was working on a revision slider issue (https://phabricator.wikimedia.org/T200697). Being new to wikimedia I was a bit confused with the technologies used. Due to these confusions I while contributing and assigning a issue to myself and me and my peer contributor did some 
[08:16:22] <akshatji>	 mistakes and we got blocked on phabricator. My username is Akshatji800. I request the community to look into this and please consider our mistake as a lack of knowledge of wikimedia technologies issue and unblock me from using phabricator so that I can continue contributing.
[09:24:46] <p858snake>	 yes, leave the channel a whole two minutes after you ask a question
[11:30:46] <Archimedes1560[m>	 🤔
[12:16:47] <klaas>	 anyone got an idea why the _linktarget table would be missing after an upgrade from 1.35 to 1.39?
[18:02:56] <kj7rrv>	 Hello! I accidentally locked myself out of the only bureaucrat account on a wiki by setting up 2FA then accidentally resetting my YubiKey. I have root access to the server. How can I recover my account? Disabling 2FA is okay if needed; I'm the only person using it and I have a good password.
[18:04:34] <kj7rrv>	 (sorry, I might not see responses right away, but I'll stay connected so I'll see them later)
[18:13:41] <RhinosF1>	 kj7rrv: you can disable 2FA
[18:14:42] <kj7rrv>	 RhinosF1, so I would just disable the extension in LocalSettings.php?
[18:14:54] <RhinosF1>	 kj7rrv: https://github.com/wikimedia/mediawiki-extensions-OATHAuth/blob/REL1_39/maintenance/disableOATHAuthForUser.php
[18:15:01] <RhinosF1>	 That script should help
[18:15:29] <kj7rrv>	 Thank you! After I do that, will I be able to set 2FA up again?
[18:17:18] <RhinosF1>	 Yep
[18:17:34] <RhinosF1>	 Just log in to your user & enable it as you did before
[18:21:15] <kj7rrv>	 Thank you! THat worked!
[18:52:40] <Guest61>	 Hello, can anyone help me understand the following error message. I am updating from rel 1.37 to rel 1.39. When I run update.php I get the following error: Fatal error: Uncaught Exception: Unable to open file /home/customer/www/encyclopediaofbuddhism.org/public_html/skins/pivot/skin.json: filemtime(): stat failed for
[18:52:40] <Guest61>	 /home/customer/www/encyclopediaofbuddhism.org/public_html/skins/pivot/skin.json
[18:54:51] <RhinosF1>	 Guest61: does the file exist?
[18:55:05] <Guest61>	 yes
[18:55:21] <Guest61>	 actually double-checking now
[18:55:36] <RhinosF1>	 Are the permissions correct?
[18:55:45] <Vulpix>	 Guest61: Looks like somewhere in your LocalSettings.php you have something like this: wfLoadSkin( 'pivot' );  - Skin names usually have the first character uppercase, maybe it should be wfLoadSkin( 'Pivot' );
[18:56:04] <Vulpix>	 file names are case sensitive
[18:56:30] <Guest61>	 wow, that is interesting!
[18:57:34] <Guest61>	 This LocalSettings.php worked for rel 1.37; but obviously something changed for the new release. I will try changing that.
[18:57:49] <Guest61>	 much appreciated
[18:59:03] <Guest61>	 your were correct about the line in LocalSettings.php. Here is the line: wfLoadSkin( 'pivot' );
[18:59:09] <Guest61>	 So I will try that change
[19:00:40] <RhinosF1>	 Vulpix: good catch
[19:01:00] <RhinosF1>	 And is there any extension that ain’t starting with an uppercase letter
[19:01:04] <RhinosF1>	 Could that not be magic
[19:11:43] <Guest61>	 Vulpix: your suggestion worked! Thank you! It would have taken me a few years to figure this one out on my own. :)
[19:16:45] <Guest61>	 The permissions were okay, btw :RhinosF1 thank you
[19:16:56] <RhinosF1>	 Np
[19:17:26] <Guest61>	 I am amazed how simple that fix was. :)
[19:24:47] <paulx>	 I found even apcu is in the list in the results of "php -m" commend, it is still not enabled when looking at php info, anyone has idea why?
[19:25:02] <Reedy>	 CLI and webserver can have different config
[19:25:43] <paulx>	 what should I do next? not quite familiar with either CLI and webserver.... :(
[19:26:50] <paulx>	 or maybe I should ask this way: how to ensure apcu is enabled webserver/mediawiki ?
[19:28:23] <Reedy>	 it's not a MW specific question
[19:28:42] <Reedy>	 And you can almost certainly google for it ;)
[19:29:30] <paulx>	 yeah I did, the problem is I followed the same instructions, but it works on my test instance, but not on my prod instance...
[19:35:23] <paulx>	 and the php.ini file on identical on the two instance
[19:58:16] <Reedy>	 There's obviously some differences
[19:58:47] <Reedy>	 Whether the enabled modules, or installed... or something hasn't been restarted
[20:00:39] <kj7rrv>	 Could merging sysop/bureaucrat accounts somehow corrupt MediaWiki: namespace CSS files?
[20:00:58] <Reedy>	 seems unlikely..
[20:01:02] <kj7rrv>	 Common.css isn't working and shows "Error
[20:01:02] <kj7rrv>	 There is currently no text in this page. You can search for this page title in other pages, search the related logs, or create this page. " when I go to it
[20:01:13] <kj7rrv>	 If I edit it it shows an edit conflict
[20:01:14] <Reedy>	 Have you recently upgraded MW?
[20:01:18] <kj7rrv>	 In the page history it's fine
[20:01:21] <kj7rrv>	 A few months ago
[20:01:38] <kj7rrv>	 I'm using the latest UserMerge
[20:01:46] <kj7rrv>	 Was that not a good idea?
[20:02:05] <Reedy>	 what version are you running?
[20:02:08] <Reedy>	 of MW
[20:02:28] <kj7rrv>	 1.37.1
[20:02:59] <gromit>	 Do I need to run update.php on a minor version update? 
[20:03:17] <Reedy>	 gromit: Not usually, no
[20:03:27] <Reedy>	 It won't harm anything, but in most cases, it won't change anything
[20:05:53] <gromit>	 Reedy: thanks for the info :) 
[20:05:57] <kj7rrv>	 I disabled UserMerge in LocalSettings and now the wiki times out when I try to isit it
[20:06:36] <Reedy>	 o_0
[20:07:33] <kj7rrv>	 Hmm maybe it's unrelated; it's happening with a static site on the same server too
[20:07:44] <kj7rrv>	 Could rebooting make anything worse?
[20:07:49] <kj7rrv>	 (rebooting the server)
[20:08:06] <kj7rrv>	 Oh the static site just loaded
[20:08:27] <kj7rrv>	 But a 30-character txt file shouldn't take a minute to load
[20:08:43] <Reedy>	 check it's load etc
[20:09:20] <kj7rrv>	 Oh it's running clamscan
[20:09:55] <kj7rrv>	 Load average is 12.60 on a dual core server
[20:10:26] <Reedy>	 that'd explain things being slooow
[20:11:42] <kj7rrv>	 Disabling the usermerge extension did not cause the timeouts, but it also didn't fix the CSS issue
[20:11:51] <kj7rrv>	 so it looks like something's wrong in the database
[20:12:03] <Reedy>	 The usermerge extension should only really be doing something when you actively merge the user
[20:12:08] <kj7rrv>	 Is there a maintenance script to correct inconsistencies in the database?
[20:12:14] <kj7rrv>	 I did merge two users into another
[20:12:33] <kj7rrv>	 I did it from the account into which they were merged; IDK if that matters
[20:12:52] <Reedy>	 Were one of those users the person that last edited the CSS page in question?
[20:13:05] <kj7rrv>	 Yes
[20:13:30] <Reedy>	 Does the history correctly show it as the user you merged it into?
[20:13:41] <kj7rrv>	 Yes
[20:14:05] <kj7rrv>	 I merged KJ7RRV-1 and KJ7RRV-root into KJ7RRV; not sure which one I last used
[20:14:06] <kj7rrv>	 https://w7bkg.org/w/index.php?title=MediaWiki:Common.css&action=history
[20:14:43] <Reedy>	 https://w7bkg.org/w/index.php?title=MediaWiki:Common.css&oldid=173
[20:14:46] <Reedy>	 I see text
[20:14:55] <Reedy>	 but not on https://w7bkg.org/wiki/MediaWiki:Common.css
[20:14:55] <kj7rrv>	 Yeah that works
[20:14:58] <kj7rrv>	 Exactly
[20:15:04] <kj7rrv>	 ANd the CSS isn't being applied
[20:15:17] <Reedy>	 look what page.page_latest is in the DB
[20:15:39] <kj7rrv>	 Do I do that with an SQL query?
[20:15:59] <Reedy>	 yeah
[20:17:31] <Reedy>	 https://w7bkg.org/w/index.php?title=MediaWiki:Common.css&action=info
[20:17:33] <Reedy>	 is weird too
[20:17:38] <Reedy>	 Total number of edits	7
[20:17:39] <Reedy>	 Total number of distinct authors	2
[20:18:16] <kj7rrv>	 Yeah I've edited it several times from different accounts
[20:18:59] <Reedy>	 yeah, but the history doesn't show 7 edits
[20:19:14] <kj7rrv>	 Yeah I noticed tha
[20:19:16] <kj7rrv>	 *that
[20:19:41] <Reedy>	 IIRC that's a query of the number of revisions...
[20:20:27] <kj7rrv>	 Is there a maintenance script that does something like fsck for the db?
[20:34:16] <kj7rrv>	 Why could MediaWiki work, but `mysql -u username -p` with the password entered on the next line, not work, using the same credentials from LocalSettings.php?
[20:34:38] <RhinosF1>	 try sql.php
[20:35:16] <kj7rrv>	 RhinosF1, that worked, thanks!
[20:36:28] <Reedy>	 kj7rrv: Possibly sockets vs tcp
[20:37:45] <kj7rrv>	 Reedy, oh yeah could be
[20:38:45] <kj7rrv>	 I get an error when I try to run a qery with sql.php
[20:39:15] <RhinosF1>	 which is?
[20:39:50] <kj7rrv>	 I can't get it to pipe to termbin for some reason and it's too long to copy
[20:40:05] <kj7rrv>	 I'll use less and copy and paste parts of it to dpaste
[20:41:30] <kj7rrv>	 Actually it looks like the whole thing fits on the screen
[20:41:30] <kj7rrv>	 https://dpaste.org/0dyX6
[20:42:02] <kj7rrv>	 The wiki itself works fine other than the CSS issue
[20:43:53] <kj7rrv>	 I can edit too
[20:44:06] <Reedy>	 Can you delete the page?
[20:44:37] <kj7rrv>	 Delete Common.css?
[20:44:50] <kj7rrv>	 No, it doesn't work
[20:44:53] <kj7rrv>	 I already tried
[20:45:24] <kj7rrv>	 Should I try rebooting the servr
[20:45:25] <kj7rrv>	 :
[20:45:25] <kj7rrv>	 ?
[20:46:07] <Reedy>	 You can try, doubt it'll fix much
[20:47:20] <kj7rrv>	 okay, it's rebooting
[20:50:44] <kj7rrv>	 It's still giving that error when I use sql.php
[20:51:50] <Reedy>	 if you pass -h 127.0.0.1 to mysql it will probably work fine
[20:53:52] <kj7rrv>	 That didn't work
[20:55:02] <kj7rrv>	 I have this in LocalSettings.php:
[20:55:03] <kj7rrv>	 https://dpaste.org/isv7M
[20:55:39] <Reedy>	 -h localhost then?
[20:55:41] <kj7rrv>	 When I run `mysql -h 127.0.0.1 -u pbarc_wiki -p` then enter the password, I get `ERROR 1045 (28000): Access denied for user 'pbarc_wiki'@'localhost' (using password: YES)`
[20:55:49] <Reedy>	 though that should be the same...
[20:56:21] <kj7rrv>	 No, still doesn't work
[20:56:59] <kj7rrv>	 Should I try as MariaDB root?
[20:57:10] <Reedy>	 can if you want
[20:59:32] <kj7rrv>	 That worked
[21:02:00] <kj7rrv>	 Now how di I find  page.page_latest
[21:02:01] <kj7rrv>	 ?
[21:02:58] <Reedy>	 select page_latest from page where page_title = 'Common.css';
[21:04:20] <kj7rrv>	 1002
[21:05:01] <Reedy>	 That looks wrong
[21:05:09] <Reedy>	 You've "lost" some revisions from what I can
[21:05:10] <Reedy>	 tell
[21:05:36] <kj7rrv>	 oh okay
[21:05:40] <kj7rrv>	 that doesn't sound good
[21:05:48] <Reedy>	 https://w7bkg.org/w/index.php?title=MediaWiki:Common.css&action=history shows the only has revision 173
[21:06:01] <kj7rrv>	 well it's not the end of the world if I have to revert to that revision
[21:06:08] <kj7rrv>	 hopefully no content pages were affected
[21:06:11] <Reedy>	 you can look in the revision table to see if the revisions are there...
[21:10:22] <kj7rrv>	 There is a revision 1002
[21:10:50] <kj7rrv>	 And it's for the same page
[21:11:21] <Platonides>	 maybe it's the error with the user transition?
[21:12:23] <Reedy>	 look at rev_actor, rev_user, rev_user_name?
[21:12:33] <Reedy>	 Also, fwiw, if you're on 1.37, you are on an unsupported MW version
[21:13:03] <kj7rrv>	 I only have rev_actor out of those, and it's 0 on revs 173 and 1002
[21:13:14] <kj7rrv>	 oh, I didn't know 1.37 is unsupported
[21:13:42] <Reedy>	 I wouldn't be surprised if the version of user merge you're running doesn't work fully/correctly/properly with the actor migration
[21:13:50] <kj7rrv>	 could be
[21:13:58] <kj7rrv>	 What should rev_actor be?
[21:14:03] <kj7rrv>	 The user ID?
[21:14:05] <Platonides>	 still, I would expect user merge to fail, not break
[21:14:15] <Platonides>	 kj7rrv: the corresponding entry of the actor table
[21:15:12] <kj7rrv>	 My actor ID is 1
[21:15:36] <kj7rrv>	 Should I run UPDATE rev_actor=1 IN pbarc_wikirevisions WHERE rev_actor=0?
[21:16:00] <kj7rrv>	 that's not valid SQL but I will fix it if it's the right idea
[21:17:25] <kj7rrv>	 rev_actor is 0 even on edits that aren't mine so that's not the issue
[21:17:33] <kj7rrv>	 it's 0 on all edits
[21:17:39] <Platonides>	 I don't remember how it was used in 1.37
[21:17:54] <Platonides>	 the migration took a few releases
[21:18:19] <Platonides>	 rev_actor=0 look wrong to me, though
[21:18:25] <Platonides>	 but such update would probably break it more
[21:18:39] <Platonides>	 what did you update it from, and when?
[21:18:45] <Reedy>	 rev_actor=0 looks odd, especially if the user id/username fields are gone
[21:18:54] <kj7rrv>	 I don't think I ever have upgraded this MW installation
[21:19:06] <kj7rrv>	 Reedy,  the user id and name fields are nonexistent
[21:19:12] <Reedy>	 That's what I mean
[21:19:16] <kj7rrv>	 it doesn't have those columns
[21:19:22] <Reedy>	 MW did, at one point
[21:19:26] <Reedy>	 Not saying yours did, but MW did
[21:19:49] <kj7rrv>	 It sounds like maybe I should be trying to back up the content and reinstall MW, not fix this installation?
[21:19:50] <Reedy>	 >  rev_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL,
[21:20:13] <Reedy>	 It's almost like the column was added, but never populated
[21:20:32] <kj7rrv>	 hmm that's weird
[21:20:56] <kj7rrv>	 I don't think that's what's causing the Common.css issue, since every edit has actor=0
[21:21:19] <kj7rrv>	 Including 173, the edit that is showing on Common.css
[21:21:42] <Reedy>	 Platonides: Looking back, rev_actor was the only field still there in REL1_35 too
[21:21:50] <Platonides>	 https://w7bkg.org/wiki/Special:Export/MediaWiki:Common.css returns no content
[21:22:34] <kj7rrv>	 Platonides, https://w7bkg.org/w/index.php?title=MediaWiki:Common.css&oldid=173
[21:22:36] <Platonides>	 if rev_actor was unused, there should be rev_user and rev_user_text
[21:22:58] <Platonides>	 kj7rrv: sure, but there's some inconsistency for Mediawiki
[21:23:14] <Reedy>	 do you have any migration variables set in LocalSettings?
[21:23:16] <kj7rrv>	 yeah something is definitely wrong
[21:23:30] <kj7rrv>	 Reedy, i don't think so, how would I identify them?
[21:23:33] <Platonides>	 I guess you don't have any backup of the database?
[21:23:50] <kj7rrv>	 no, I don;t
[21:24:26] <kj7rrv>	 oh this isn't the only affected page
[21:24:32] <kj7rrv>	 there are content pages affected too
[21:24:57] <Reedy>	 Platonides: https://github.com/wikimedia/mediawiki-extensions-UserMerge/commit/671e8c0d76d21418e84cce00d5a9c81d0f8e5011 REL1_34 dropped them all
[21:25:11] <kj7rrv>	 I might call my hosting company and see if they can reset my server to its state a few hours ago
[21:25:42] <Reedy>	 Have you only just done the user merge(s)?
[21:27:05] <kj7rrv>	 yeah, just a few hours ago
[21:27:47] <kj7rrv>	 I found a backup from eight months ago, so it would be better than nothing
[21:28:06] <Reedy>	 Do you only have one user on your wiki?
[21:28:15] <Reedy>	 there is an attachLatest.php maintenance script
[21:28:20] <Reedy>	 I'm curious what it would do in your case
[21:28:44] <kj7rrv>	 No, I have quite a few users
[21:28:56] <kj7rrv>	 Well not a lot, about 10
[21:29:13] <kj7rrv>	 Only two others have edited IIRC
[21:29:43] <Platonides>	 well, that 8-months-old backup could be useful to compare how were (some) things supposed to be
[21:29:58] <kj7rrv>	 I could call them and ask if they would be okay with their edits showing under my name
[21:30:08] <Reedy>	 If your hosting company has a backup from a few hours ago
[21:30:21] <kj7rrv>	 It wouldn't be ideal but they would probably be okay with it if that's the only way to fix the site
[21:30:39] <kj7rrv>	 It doesn't look like the hosting company makes bacups available to customers
[21:30:52] <Reedy>	 It's probably not the only way... But when you've got a non standard breakage...
[21:30:57] <kj7rrv>	 They're only for their use in restoring servers if something goes wrong on their end
[21:31:18] <Reedy>	 my dev wiki has 99 revision rows with rev_actor of 0... one of the pages has a page_title of 0
[21:31:28] <Reedy>	 which is kinda fun
[21:33:36] * Platonides finds select count(*) From mw_revision where rev_actor=0 -> +----------+
[21:33:39] <Platonides>	 |   133542
[21:33:46] <Reedy>	 62 different pages with revisions with a rev_actor=0
[21:33:59] <Platonides>	 all the revisions have rev_actor 0 :S
[21:34:19] <Reedy>	 Wouldn't be surprised if it's related to imports pre actor
[21:34:31] <kj7rrv>	 Only three people other than me have edited, and I think all of them will be okay with their edits being attributed to a generic account
[21:34:34] <Reedy>	 or just imports generally
[21:35:02] <kj7rrv>	 I think I'll go with the option of attaching edits to one user
[21:35:12] <kj7rrv>	 (after asking everyone, ofc)
[21:37:23] <Platonides>	 hmm
[21:37:45] <Platonides>	 if rev_actor is 0, and there is no rev_user or rev_user_text, where does it take the user from?
[21:38:10] <kj7rrv>	 Idk, but every edit I've found in histories shows the correct user
[21:39:39] <Platonides>	 ah mw_revision_actor_temp
[21:40:08] <Platonides>	 do you have that table?
[21:44:31] <kj7rrv>	 yes
[21:46:10] <kj7rrv>	 And a lot of edits there show an actor ID that doesn't exist
[21:46:25] <kj7rrv>	 It was likely the ID of one of my merged accounts
[21:47:03] <kj7rrv>	 Should I change all uses of the nonexistent ID to my main account's ID?
[21:47:07] <kj7rrv>	 Platonides, 
[21:48:31] <Platonides>	 that might fix it, yes
[21:48:50] <kj7rrv>	 The worst thing it could do is show wrong attribution, right?
[21:48:56] <Platonides>	 make a db backups before changing the database
[21:49:25] <kj7rrv>	 okay, I wil
[21:50:31] <kj7rrv>	 mysqldump --all-databases -p > db_dump.sql?
[21:50:37] <Platonides>	 then you can do UPDATE revision_actor_temp SET revactor_actor=<actor id for KJ7RRV> WHERE revactor_actor=<actor id for KJ7RRV-root>
[21:50:49] <Platonides>	 kj7rrv: yes, that works
[21:54:01] <kj7rrv>	 update pbarc_wikirevision_actor_temp set revactor_actor = 1 where revactor_actor = 20; did not fix it
[21:54:15] <kj7rrv>	 the query worked but the wiki still isn't working right
[21:55:28] <kj7rrv>	 Well it had some benefit; some formerly broken pages now work
[21:56:15] <Platonides>	 :)
[21:56:44] <Platonides>	 did you merge more users?
[21:57:34] <kj7rrv>	 I merged two, and I found the other user's id and merged it, and it's back to normal! Thank you!
[21:58:59] <Platonides>	 :D
[22:00:15] <kj7rrv>	 And the most recent edit to Common.css is indeed edit #1002.
[22:00:27] <kj7rrv>	 Now I'm making a backup. :D
[22:00:35] <kj7rrv>	 (another one)
[22:01:20] <Platonides>	 glad it got fixed
[22:01:46] <kj7rrv>	 I'll definitely make backups before any significant changes in the future.
[22:06:21] <Reedy>	 maybe worth upgrading too
[22:06:29] <Reedy>	 it might prevent this issue in future
[22:09:03] <kj7rrv>	 I will upgrade when I have time
[22:09:24] <kj7rrv>	 We're planning to move to a new server in a couple months, so I'll probably wait until then
[23:13:10] <Prodigion3714[m]>	 it seems to me that it's impossible to add items to the TOOLBOX from the SkinBuildSidebar hook.
[23:14:11] <Prodigion3714[m]>	 it runs the callback(), then the next statement ignores anything in the array... (full message at <https://libera.ems.host/_matrix/media/v3/download/libera.chat/d0b9f46592dad18ee743aa7241238cd78824ccff>)
[23:15:19] <Prodigion3714[m]>	 https://gerrit.wikimedia.org/g/mediawiki/core/+/master/includes/skins/Skin.php#1474
[23:20:21] <Prodigion3714[m]>	 SidebarBeforeOutput hook is run after this, which allows you to append