[01:13:13] upgrading RationalWiki [01:13:29] I'm thinking about putting this channel in the read-only message so that I can give updates [01:15:07] it has been in read-only mode for almost 2 hours [01:17:40] ok done [01:18:13] current status is that 80 user rows were deleted in 2007-2008, leaving rev_user/rev_user_text fields that don't link to user [01:18:25] this confuses actor migration and needs to be cleaned up [01:24:57] I think I can do it with insert select [01:26:30] What's wrong with BlueSpice https://www.irccloud.com/pastebin/6aMgOpPb/bluespice [01:32:46] that error is saying that the Chameleon skip is not compatible with the version of MW you are using [01:32:51] s/skip/skin/ [01:34:47] see the skin page for support details https://www.mediawiki.org/wiki/Skin:Chameleon [02:03:06] migrateActors was erroring out on a user called "Å–Ä›Éâ€vÄ›" [02:03:43] not sure at what stage it got mojibaked or if their actual name starts with A-tilde ellipsis [02:05:22] fixed that manually, next problem is 135 rows in the logging table with non-zero log_user and log_user_text='' [02:10:05] 94 of the rows have an associated user row, the rest there is no user row [02:37:05] update logging join user on log_user=user_id set log_user_text=user_name where log_user_text=''; [02:39:59] update logging set log_user_text = concat('Deleted user ',log_user) where log_user_text=''; [02:52:18] when is the rationalwiki update gonna be finished [02:59:30] eh [02:59:33] before I go to sleep [03:00:38] I mostly need to go back in time to 2007 and tell whoever decided to provide a feature to delete user rows to not do that [03:01:33] I mean, people did ask me how to do that at the time, or asked in public forums, and the answer was always a horrified "don't do that" [03:01:59] I see [03:02:31] don't push yourself too hard and don't sacrifice too much sleep [03:02:45] it's 1pm now so I'm not in danger just yet ;) [03:03:02] started at 9:30am [03:03:06] oh ok lol [03:03:38] RW is usually pretty quiet at this time of the day [03:04:00] true [03:05:30] I mostly need to go back in time to 2007 and tell whoever decided to provide a feature to delete user rows to not do that <-- using E:UserMerge or something custom? [03:06:47] I don't know, but revision, archive and logging rows contain references to nonexistent user IDs so whatever it was did not properly deal with contributions [03:07:52] welp :/ [03:08:18] today UserMerge correctly handles that by merging stuff into a dummy user rather than outright deleting things, no idea what it was like in 2007 [03:10:21] currently migrateActors.php is having a nice quiet run, it's 28% of the way through the logging table [03:11:11] has been going 12 minutes so probably has another 30 to go [03:12:43] so that's a better estimate for Guest41_they-the -- half an hour for this bit, then we'll see [03:13:00] oh that's quick [03:13:06] good to know [03:13:38] if worst comes to worst I can just switch out of read-only mode and leave it on MW 1.27 [03:13:51] I'm doing the upgrade on a replica database server [03:14:27] ooh [03:15:28] that's fine. you can switch it out and come back to it later if it doesn't work out. [03:45:31] migrateActor.php done, restarting update.php now [04:03:43] errored out at patch-ipblocks-rename-ipb_address.sql but there are not many updates left now [04:13:00] we're into the extension updates now [04:22:30] exception due to max_allowed_packet exceeded, quadrupled it and retrying [04:29:59] urgh Echo trying to update a table with 2M rows in batches of 500 but each query takes 40s due to a bad query plan [04:30:24] ctrl-C, will have to figure that out [04:45:13] skipped it for now, and that concludes update.php for rationalwiki, now doing ru.rationalwiki [04:50:25] good thing we only have two languages. [04:54:48] both human time and computer time for ru should be shorter [04:55:18] yep, already done [04:55:53] nice [04:56:28] ok, time to switch the source trees and see what happens [05:00:40] switched back, best to figure out that 403 error while the site's not down [05:04:36] well that seems to be working now [05:05:27] the images still seem to be bugging out [05:06:00] oh well, we can fix that later [05:06:51] anyways, thank you for your hard work [05:07:05] go take a well deserved rest my hero [10:48:47] Hi [10:49:04] Is it possible to have wildcard search by default [10:49:22] I mean so visitors don't have to search for foo* [13:26:13] hmm that could be useful indeed