[05:32:32] <Naleksuh>	 Why has Special:OAuthConsumerRegistration/propose been removed?
[07:23:24] <ryzendar>	 I'm not entirely sure, but I just went through another MediaWiki installation, and I could have sworn there was a "thanks" extension checkbox, that I checked, and the generated LocalSettings.php didn't include a line for wfLoadExtension( 'Thanks' );
[07:23:47] <ryzendar>	 I could be wrong, but I'm comparing LocalSettings.php files right now, and I noticed it was missing
[07:26:13] <ryzendar>	 Also,https://mediawiki.org/wiki/Skin:Minerva_Neue states "Make sure to call wfLoadSkin after wfLoadExtension." and the generated LocalSettings.conf has wfLoadExtension( 'MobileFrontend' ); listed after wfLoadSkin( 'MinervaNeue' );
[07:26:25] <ryzendar>	 .php*
[08:19:03] <Guest77>	 Hi, the data I accessed through API contains missing values, such as NA or NULL for pageviews, contributors and redirects. How should I treat them? Should I treat them as 0 or just missing?
[08:19:43] <Guest77>	 Any advice would be much appreciated.
[09:28:57] <Reedy>	 Naleksuh: Removed from where? https://meta.wikimedia.org/wiki/Special:OAuthConsumerRegistration/propose WFM
[09:29:46] <Reedy>	 ryzendar: There's a Thanks extension, but it's not tarball bundled
[09:30:16] <Reedy>	 ryzendar: There's no way for the installer to know which to do first (without putting specific code into MW core)
[09:30:27] <Reedy>	 So it'll probably do it roughly alphasorted
[09:53:49] <ryzendar>	 Alternatively, wouldn't it be better to place the extensions before the skins? Otherwise do any extensions require skin variables to be defined first?
[09:54:28] <ryzendar>	 It's a minor issue
[10:29:54] <Naleksuh>	 Reedy : Why is it only on Meta
[10:29:56] <Naleksuh>	 Its not on all wikis
[12:42:03] <Reedy>	 Naleksuh: That's how it's always been
[13:19:26] <Tuju>	 Error: 42501 ERROR: permission denied for relation transcode            any idea where those permissions are defined?
[13:52:50] <Vulpix>	 Tuju: looks like a postgresql error: https://stackoverflow.com/questions/18193487/42501-insufficient-privilege-error-while-querying-in-postgresql
[13:53:13] <Tuju>	 Vulpix: it was table owner issue
[16:15:41] <Krinkle>	 2003, when interpolating request variables into raw sql passed to a global function was the norm :D https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/+/036ff960cefa2e05749b4ecc34043f2a2543dafe%5E%21/
[16:41:33] <ashley>	 what could possibly go wrong ;^)
[16:42:53] <RhinosF1>	 Amir1: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/773855
[16:43:14] <RhinosF1>	 Per my ping like a week ago
[16:43:24] <Amir1>	 RhinosF1: again, I mentioned it before, I don't think it's needed for 1.38
[16:43:54] <Amir1>	 when there is no code to read new, this will just create duplicate unusable data
[16:43:54] <RhinosF1>	 Amir1: everything else related is in
[16:44:15] <RhinosF1>	 it kinda doesn't make sense to have half a patch
[16:44:23] <RhinosF1>	 Because write_both landed
[16:44:23] <Amir1>	 it's not a half a patch
[16:44:39] <Amir1>	 write both is useless for a third party wiki without read new
[16:45:00] <Amir1>	 it's a stream of work
[16:45:15] <RhinosF1>	 But migrations could take months anyway
[16:45:47] <RhinosF1>	 It'll probably take until 1.39 for me to manage to get it ran
[16:46:09] <RhinosF1>	 by which time read_new will be there
[16:46:56] <Amir1>	 I understand but your case is not the general case
[16:47:32] <Amir1>	 and it can be there for 1.39, you can backport it to your local installation if you really want to 
[16:47:56] * RhinosF1 will probably end up running it once he has time and has seen it work on 1 WMF wiki
[20:50:02] <Bongo-Cat>	 When I run  php maintenance/sql.php --wikidb centralauth extensions/CentralAuth/central-auth.sql on my wiki directory, it gives this: https://dpaste.org/PP9c
[20:52:03] <Bongo-Cat>	 while the other wiki works
[21:06:48] <RhinosF1>	 Bongo-Cat: you only have 1 CA table
[21:07:01] <RhinosF1>	 You don't need to run for each wiki in a farm
[21:07:15] <Bongo-Cat>	 oh
[21:07:21] <Bongo-Cat>	 ok thanks
[21:09:48] <RhinosF1>	 Just make sure to set $wgCentralAuthDB
[21:09:55] <RhinosF1>	 If that's the right name
[21:10:16] <RhinosF1>	 It might be s/DB/Database
[21:10:56] <Bongo-Cat>	 I'm pretty sure the former is correct
[21:15:36] <hannes_>	 i am trying to upgrade a 1.29 to 1.37. it is using sqlite as db. "php update.php" gave me several "index ... already exists" errors which i fixed manually by dropping the indexes. but now it complains about "Error 19: UNIQUE constraint failed: module_deps_tmp.md_module, module_deps_tmp.md_skin" 
[21:15:51] <hannes_>	 is there some special db updating stuff i should run before the update.php?
[21:21:20] <zabe>	 I don't think it is the correct strategy to remove indexes manually. Can you tell me one of the indexes that you removed manually?
[21:21:40] <Bongo-Cat>	 I did not get the global group of Steward, how do I assign it to myself?
[21:22:14] <zabe>	 Please keep in mind that update.php does not take care of the old version. So it may be that the indexes already existed and the update only checked that.
[21:22:23] <ashley>	 sounds more like that you're just encountering edge cases because nobody really tested this kinda stuff ever before :) (which I'm guessing is because most devs use MySQL/MariaDB; PGSQL is a minority; SQLite even more so, though the CI system uses it, but that's just for an initial install, obviously)
[21:23:05] <Bongo-Cat>	 ive ran php migrateStewards.php multiple times
[21:23:57] <zabe>	 Bongo-Cat, does there exist a global steward group? You need to manually insert it into the db first, see https://www.mediawiki.org/wiki/Extension:CentralAuth/Walkthrough#Step_3._Create_database_centralauth_(and_configure).
[21:24:30] <Bongo-Cat>	 I believe I have, but ill check
[21:24:54] <Bongo-Cat>	 Duplicate entry 'steward-globalgrouppermissions' for key 'PRIMARY'
[21:25:44] <Bongo-Cat>	 It exists, I can see it but I'm not assigned it
[21:26:02] <Bongo-Cat>	 Populating global groups table with stewards...
[21:26:02] <Bongo-Cat>	 Fetched 1 from local database... Checking for attached ones
[21:26:02] <Bongo-Cat>	 Fetched 1 SULed stewards... Adding them in group
[21:26:10] <hannes_>	 zabe: cl_sortkey, cl_timestamp, tl_namespace, pl_namespace https://pastebin.com/raw/VFhCcMD7
[21:26:41] <hannes_>	 https://www.mediawiki.org/wiki/Manual:SQLite  says SQLite support for MediaWiki is of production quality as of MediaWiki 1.17. ;)
[21:30:32] <RhinosF1>	 hannes_: the index already exists does not mean drop them
[21:31:22] <RhinosF1>	 That's not an error
[21:31:46] <RhinosF1>	 It's just telling you that there's no need to make the change because it's been done before
[21:31:49] <hannes_>	 update.php "crashed" with a traceback from those
[21:32:03] <hannes_>	 Wikimedia\Rdbms\Database->getQueryException()
[21:32:10] <Bongo-Cat>	 new problem: im not attached to the wikis
[21:32:10] <RhinosF1>	 What exactly did the Traceback say?
[21:32:12] <hannes_>	 i did not include that in the pastebin
[21:32:24] <Bongo-Cat>	 it would be a good idea to include it
[21:33:29] <hannes_>	 same https://pastebin.com/raw/06sVFKpq for each of them
[21:33:57] <hannes_>	 i did not see why they were relevant as they basically seem to say "we read a sql query file and got an error, crash"
[21:35:54] <Guest38>	 Hello, i'm creating an extension and i want PHP to create a new page. Is there a quick class that does this?
[21:36:04] <zabe>	 Bongo-Cat, use Special:MergeAccount
[21:36:16] <Bongo-Cat>	 Alright thanks
[21:36:46] <Bongo-Cat>	 [200b74a18a28b75c22236c91] 2022-03-26 21:36:39: Fatal exception of type "Exception"
[21:37:10] <Bongo-Cat>	 Unable to merge
[21:38:05] <RhinosF1>	 hannes_: do you have backups?
[21:38:14] <hannes_>	 sure
[21:38:20] <RhinosF1>	 That's also missing the actual error
[21:38:52] <Bongo-Cat>	 Are you talking about mine or hannes_?
[21:39:02] <RhinosF1>	 hannes_: id suggest rolling back before the upgrade failed and then stopping when update.php fails. Share the full output if it does again.
[21:39:21] <RhinosF1>	 Bongo-Cat: hannes_, you're missing the Traceback
[21:39:44] <zabe>	 @errors
[21:39:54] <zabe>	 hmm
[21:40:15] <Bongo-Cat>	 im new to hosting mw so i dont know how to view the tracebacks
[21:41:01] <hannes_>	 RhinosF1: this is "php update.php" after the error, i am back at the shell at that point: https://pastebin.com/raw/GzdbNs0a
[21:41:25] <zabe>	 !errors
[21:41:25] <wm-bot>	 To see PHP errors, add this to the very top of LocalSettings.php: error_reporting(E_ALL); ini_set("display_errors", 1); Fatal PHP errors usually go to Apache's error log - also check the error_log setting in php.ini (or use phpinfo). For more details in wiki error reports, set $wgShowExceptionDetails = true; $wgShowSQLErrors = true; For full debug output, set $wgDebugLogFile to some path you like.
[21:41:26] <hannes_>	 to me that is a traceback? if it isn't and there might be more info available, please shout
[21:42:26] <RhinosF1>	 hannes_: that included what I needed
[21:42:32] <RhinosF1>	 That index is supposed to exist
[21:42:45] <RhinosF1>	 I guess the SQLite updater is broken
[21:42:59] <RhinosF1>	 Because if they already exist, it should just skip creating them
[21:45:05] <Bongo-Cat>	 Here it is https://www.irccloud.com/pastebin/kiZPkMh3/Stupid%20error
[21:45:58] <RhinosF1>	 Bongo-Cat: I assume it should be metawiki? Did you type meta in or is that from config somewhere?
[21:46:34] <Bongo-Cat>	 is it the database name?
[21:46:52] <RhinosF1>	 Bongo-Cat: wikiid is normally the DB name yes
[21:46:57] <Bongo-Cat>	 ack
[21:47:05] <Bongo-Cat>	 perhaps thats why
[21:47:43] <Bongo-Cat>	 ugh thats why
[21:47:54] <Bongo-Cat>	 i didnt type the db name in the db section :p
[21:48:13] <Bongo-Cat>	 wait
[21:48:39] <Bongo-Cat>	 it has a suffix 🤦‍♂️
[21:48:49] <hannes_>	 is there an easy way to migrate a wiki from sqlite to postgres
[21:50:02] <RhinosF1>	 hannes_: no idea, is your wiki currently in a broken state?
[21:50:27] * RhinosF1 suggests using your backup to go back to a good state before moving off SQLite
[21:50:30] <hannes_>	 absolutely, visiting it says " Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?"
[21:50:33] <hannes_>	 yes of course...
[21:50:46] <RhinosF1>	 I would go back to last good state if you can
[21:52:01] <RhinosF1>	 https://pgloader.readthedocs.io/en/latest/ref/sqlite.html might help migrating
[21:52:10] <RhinosF1>	 I'm not sure if mediawiki has specific tools
[21:54:43] <Bongo-Cat>	 Welp new error https://www.irccloud.com/pastebin/vLFosVFQ/welp
[21:55:48] <RhinosF1>	 Bongo-Cat: do you have a wiki with the id beans
[21:56:11] <Bongo-Cat>	 i dont know what a wiki id is
[21:56:14] <Bongo-Cat>	 so maybe?
[21:57:43] <zabe>	 the database names of you wikis
[21:57:59] <RhinosF1>	 the database name 99.9999% of the time
[21:58:10] <Bongo-Cat>	 yes then
[21:58:32] <Bongo-Cat>	 https://usercontent.irccloud-cdn.com/file/80HI0U6U/image.png
[21:58:37] <Bongo-Cat>	 this is my sql
[21:59:31] <zabe>	 did you set wgServer, wgScriptPath, etc. in both LocalSettings like at https://www.mediawiki.org/wiki/Extension:CentralAuth/Walkthrough#Code
[21:59:39] <Bongo-Cat>	 i believe so
[21:59:43] <Bongo-Cat>	 let me check
[22:00:45] <Bongo-Cat>	 yes
[22:02:09] <Bongo-Cat>	 this is what i have https://www.irccloud.com/pastebin/JSfAt2UZ/
[22:04:29] <RhinosF1>	 Bongo-Cat: why have you added the wiki suffix in $wgLocalDatabases
[22:04:39] <RhinosF1>	 When it's not used
[22:04:59] <Bongo-Cat>	 i thought it was needed :p
[22:06:35] <RhinosF1>	 Not if you don't use it
[22:07:51] <Bongo-Cat>	 https://www.irccloud.com/pastebin/vdsIucvm/even%20when%20i%20dont%20it%20gives%20me%20this
[22:07:59] <Bongo-Cat>	 even when I dont it gives me this
[22:10:59] <zabe>	 $wgLocalDatabases needs to be array( 'meta', 'beans' ), without the suffixes
[22:11:19] <zabe>	 ah, that was already written, sorry
[22:11:46] <zabe>	 in wgArticlePath meta instead of metawiki
[22:11:53] <Bongo-Cat>	 alright
[22:12:53] <Bongo-Cat>	 okay
[22:15:59] <Bongo-Cat>	 this https://www.irccloud.com/pastebin/aJRvZKyF/
[22:18:14] <ryzendar>	 Regarding configuring multiple languages (e.g. 140+ countries/languages) following https://mediawiki.org/wiki/Manual:Wiki_family, and creating 140+ databases to handle each different language site, do all of the Module:*s and Template:*s need to be duplicated in each database also? Or can they be referenced/cited from the main database?
[22:18:29] <zabe>	 Bongo-Cat, Is the /beanswiki in wgScriptPath intended?
[22:18:48] <Bongo-Cat>	 if its supposed to be where the file is located, then yes
[22:22:31] <zabe>	 just to be sure. You now have $wgLocalDatabases = array( 'meta', 'beans');    $wgConf->wikis = $wgLocalDatabases;    $wgConf->suffixes = array( '' );    like this in both LocalSettings?
[22:25:25] <zabe>	 also please remove the $wgConf->suffixes = $wgLocalDatabases; line
[22:28:39] <zabe>	 (I am not sure if it is correct, but my local setup works without having it)
[22:34:55] <Bongo-Cat>	 ok
[23:34:32] <Bongo-Cat>	 zabe: sorry for late response doesnt work though
[23:36:16] <Bongo-Cat>	 still gives the same error