[10:34:50] Hi, I need help. I don't know what happened, but current revisions aren't being displayed anymore. Example: https://futureworlds.eu/wiki/Manos_Mathioudakis [10:35:03] If I go to history, and click on the latest change, I can see it. [10:35:49] How I can get rid of that error that's displayed when you open some page? It doesn't happen with every single page, but there are few cases (about 10-20, I don't know). [10:36:52] I also tried to delete it and recreate it, but deleting doesn't work either. [10:37:04] Here is the error: https://pastebin.com/7kKKPK2R [10:37:58] So first of I'd suggest trying to identify what went wrong. Can you look in the database, and check what the page_latest field is set to for that page, is it actually the latest revision? [10:37:59] the last revision in the history, https://futureworlds.eu/wiki/index.php?title=Manos_Mathioudakis&oldid=11556, links to a “newer revision” as if there was one [10:38:10] * Lucas_WMDE was also going to guess page_latest [10:38:48] I'd also look at actor and comment_id field of the revision in question, to see if it is a referential integrity issue causing the revision in question to not be selected due to an inner join [10:41:45] Sometimes botched actor migration updates give errors like this, if the rev_actor field is 0 [10:43:08] I'll try to take a look and let you know. [10:43:12] What are the possible fixes? [10:43:27] ideally fixed by running cleanupUsersWithNoID.php, but that script doesn't wory on newer mediawiki so you kind of have to run it before upgrading to too new a version [10:44:25] Otherwise its kind of messy, where you have to basically reassign edits to a different user by messing with the rev_actor field in the database [10:46:13] Yeah, api says latest revision is 20822, so there is probably something wrong with that revision [10:47:39] And when I go to Special:Diff/20822 it's showing an error that it's not found at to check the deletion log. The deletion log links to deletion logs for Main page. [10:48:49] does a revision with id 20822 exists on the revision table? [10:50:17] You'll have to manually check referential integrity on your database. The api doesn't find anything about that revision neither, but it may fail when doing joins to other tables that are missing the data [10:55:16] I don't have direct access, so I have to connect each time via Anydesk to wiki's owner laptop. [10:55:31] I'm going to do that now, so I'll let you know what I find. [11:10:43] Vulpix: It exists, rev_actor is 0. [11:10:54] rev_comment_id is 0. [11:11:02] rev_id 20822, rev_page 131. [11:11:15] rev_parent_id is 11556. [11:12:39] the rev_actor and rev_comment_id being 0 are both very problematic [11:12:40] I did "SELECT * FROM `revision` WHERE `rev_actor` = 0" and there are 74 revisions with rev_comment_id 0 and rev_actor_0. [11:13:40] Should I change those rev_actor = 0 to some number? [11:13:54] I'm not sure what version is too late, but try running cleanupUsersWithNoId.php followed by migrateActors.php to see if that helps [11:14:18] There is only revision_comment_temp table. [11:14:57] The comment_id thing might not be a big deal if the version you have is still using revision_comment_temp table [11:15:11] * bawolff can't remember which version the db changes were made [11:15:20] missing actor and missing comment will be problematic. The wiki is on 1.39, the migration should have happened already. Maybe there was an error in a previous upgrade but the upgrade continued... [11:15:41] Skipping revision, fields rev_user and/or rev_user_text do not exist [11:16:13] does revision_actor_temp still exist? [11:18:40] Nope. I just changed rev_actor from 0 to 2 for revision 20822 and https://futureworlds.eu/wiki/Manos_Mathioudakis doesn't show an error for the current revision. [11:19:20] Saving works as well. [11:20:24] ah. You'll probably have to do that for all revisions with an actor_id of 0 (unless you have a pre-upgrade backup) [11:20:33] I'm thinking that way as well. [11:20:45] I'm going to replace all rev_actor 0 with 2, guy is fine with that. [11:24:55] Okay, pages are visible now again. Thank you for your help! [11:28:40] Gotta go now, see you. :) [15:41:30] how do i set Regex block to work across multiple wikis ( get the blocks to be effective on multiple wikis ) using it on the wiki its only effecting the local wiki and not all of them