Resolve "Wiki-Startseite-Umbau"

Closes #5946

Merge request studip/studip!4614

1 files changed, 22 insertions, 0 deletions

diff --git a/db/migrations/5.5.37_cleanup_wiki_startpage_parent.php b/db/migrations/5.5.37_cleanup_wiki_startpage_parent.php
new file mode 100644
index 0000000..74c188a
--- /dev/null
+++ b/db/migrations/5.5.37_cleanup_wiki_startpage_parent.php
@@ -0,0 +1,22 @@
+<?php
+/**
+ * @see https://gitlab.studip.de/studip/studip/-/issues/5946
+ */
+class CleanupWikiStartpageParent extends Migration
+{
+    public function up(): void
+    {
+        $query = "SELECT `range_id`, `value`
+                  FROM `config_values`
+                  WHERE `field` = 'WIKI_STARTPAGE_ID'";
+        $pages = DBManager::get()->fetchAll($query);
+
+        $query = "UPDATE `wiki_pages`
+                  SET `parent_id` = NULL
+                  WHERE `page_id` = ? AND `range_id` = ?";
+        $statement = DBManager::get()->prepare($query);
+        foreach ($pages as [$range_id, $page_id]) {
+            $statement->execute([$page_id, $range_id]);
+        }
+    }
+}