[03:47:25] hello 0/ [03:48:11] I'm trying to post a comment in #mediawiki-visualeditor but it's not letting me. not sure what's wrong [03:49:09] I'm getting "Cannot send to nick/channel". Do I have to be invited there or something? [03:50:14] so... is no one here then? can anyone see my comments? [03:54:19] you might need to be registered to speak in there [03:56:46] how do I do that? [04:05:49] https://freenode.net/kb/answer/registration [04:06:17] thx! [11:28:50] Hello, I am stuck at trying to upgrade an old version (1.16.2) to 1.31.12. Is it the right place to ask for help? :) [11:30:04] yes [11:32:42] Great. So I retrieved a (postgresql) dump of the old version, nothing else. I install mediawiki using the debian package (debian 10), run though the install process and getting (at step Upgrade existing installation): https://paste.debian.net/1189003/ [11:32:55] not sure which is the most relevant error [11:33:44] Am I missing something I should do before starting the upgrade from the web interface? [11:34:04] the most relevant bit is "Error: 42P01 ERROR: relation "mwuser" does not exist" [11:34:34] is there a reason you're updating to 1.31 and not 1.35? [11:35:19] I just "apt install mediawiki" [11:35:29] to try how easy it would be to upgrade [11:35:59] ah, good point, buster doesn't have 1.35 [11:37:04] are there any chances to see the problem fixed on 1.35? [11:41:07] I'm not familiar with postgres and this bit seems to have differences from mysql, sorry [11:42:43] For some reason, the postgres schema uses foreign keys, while mysql doesn't [11:43:04] I'm confused how that error is saying that mwuser does not exist but the output above that says that it has some indexes present [12:03:17] I removed the REFERENCES part when creating the user_former_groups table and now get [12:03:39] Error: 42P01 ERROR:  relation "updatelog" does not exist [12:04:16] full output https://paste.debian.net/1189014/ [12:04:27] I don't see the .sql file where it's coming from [12:06:45] The table "updatelog" exists in the DB.. [15:38:29] For the record: I upgraded correctly to 1.31. I moved the DB to MariaDB (using the sql schema from 1.16) and used the "postgres to mysql" script found on the wiki [15:38:57] I had to remove some "not null" constraint in the schema however to bypass a couple of "cannot be null" errors [15:39:12] have a good weekend everyone [16:26:37] does MediaWiki 1.31.x work with mysql 8? [16:27:00] i'm considering upgrading mysql 5.7 to 8.. [16:27:24] it should... [16:27:38] thx. i have a staging instance so i guess i'll just test this there [16:27:55] https://www.mediawiki.org/wiki/Compatibility#Database [19:10:57] just FYI, buster-backports has MediaWiki 1.35 [19:38:17] I keep getting the "Sorry! We could not process your edit due to a loss of session data." error when attempting to save my pages. recently upgraded 1.35.1 install. i've already tried everything here multiple times: https://www.mediawiki.org/wiki/Manual:How_to_debug/Login_problems [19:38:25] any suggestions on how to debug? [19:39:31] no errors in the logs at all [20:13:39] aha fixed! for future reference, i was using sqlite backend. i enabled showdebug, debugtoolbar, etc as described in the debug page [20:14:18] saw these errors: [SQLBagOStuff] Error 11 from SqlBagOStuff::fetchBlobMulti, database disk image is malformed SELECT keyname,value,exptime FROM objectcache WHERE keyname = 'wikidb:messages:en' localhost [20:14:19] [SQLBagOStuff] DBError: Error 11: database disk image is malformed [20:14:56] turns out the wikicache.sqlite db was corrupted [20:15:41] was able to fix it with sqlite commands