From 98343a94ad77eb121d675043dbc0fd21345da2f4 Mon Sep 17 00:00:00 2001 From: Jan-Hendrik Willms Date: Thu, 26 Feb 2026 21:07:28 +0100 Subject: fix faulty migrations, fixes #6048 Closes #6048 Merge request studip/studip!4618 --- db/migrations/5.5.23_modernize_wiki.php | 15 +++++++++------ 1 file changed, 9 insertions(+), 6 deletions(-) diff --git a/db/migrations/5.5.23_modernize_wiki.php b/db/migrations/5.5.23_modernize_wiki.php index cfa3b89..4d5385b 100644 --- a/db/migrations/5.5.23_modernize_wiki.php +++ b/db/migrations/5.5.23_modernize_wiki.php @@ -176,8 +176,8 @@ final class ModernizeWiki extends Migration DBManager::get()->exec(" INSERT INTO `wiki_pages` (`range_id`, `name`, `content`, `parent_id`, `read_permission`, `write_permission`, `user_id`, `chdate`, `mkdate`) SELECT `superwiki_pages`.`seminar_id`, - CONVERT(`superwiki_pages`.`name` USING utf8mb4), - CONVERT(`superwiki_pages`.`content` USING utf8mb4), + `superwiki_pages`.`name`, + `superwiki_pages`.`content`, NULL, `superwiki_pages`.`read_permission`, `superwiki_pages`.`write_permission`, @@ -189,13 +189,16 @@ final class ModernizeWiki extends Migration DBManager::get()->exec(" INSERT INTO `wiki_versions` (`page_id`, `name`, `content`, `user_id`, `mkdate`) SELECT `wiki_pages`.`page_id`, - CONVERT(`superwiki_versions`.`name` USING utf8mb4), - CONVERT(`superwiki_versions`.`content` USING utf8mb4), + `superwiki_versions`.`name`, + `superwiki_versions`.`content`, `superwiki_versions`.`last_author`, `superwiki_versions`.`chdate` FROM `superwiki_versions` - INNER JOIN `superwiki_pages` ON (`superwiki_pages`.`page_id` = `superwiki_versions`.`page_id`) - INNER JOIN `wiki_pages` ON (`wiki_pages`.`range_id` = `superwiki_pages`.`seminar_id` AND `wiki_pages`.`name` = `superwiki_pages`.`name`) + JOIN `superwiki_pages` ON (`superwiki_pages`.`page_id` = `superwiki_versions`.`page_id`) + JOIN `wiki_pages` ON ( + `wiki_pages`.`range_id` = `superwiki_pages`.`seminar_id` + AND `wiki_pages`.`name` = CONVERT(`superwiki_pages`.`name` USING utf8mb4) + ) "); } DBManager::get()->exec(" -- cgit v1.0