aboutsummaryrefslogtreecommitdiff
path: root/db/migrations
diff options
context:
space:
mode:
authorJan-Hendrik Willms <tleilax+github@gmail.com>2024-04-30 14:48:50 +0200
committerJan-Hendrik Willms <tleilax+github@gmail.com>2024-04-30 15:13:43 +0200
commite36a783be7c066350ee7fa021fe648ff147edd2d (patch)
tree25ffcb81f2028b7bcbcc17f395933bb518202584 /db/migrations
parentb2f3bad52dd6dec973bef54d2f10986015848702 (diff)
don't delete global thread or automatically generated threads, re #4097
Diffstat (limited to 'db/migrations')
-rw-r--r--db/migrations/5.1.56_cleanup_blubber.php2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/migrations/5.1.56_cleanup_blubber.php b/db/migrations/5.1.56_cleanup_blubber.php
index 86348bc..b870d78 100644
--- a/db/migrations/5.1.56_cleanup_blubber.php
+++ b/db/migrations/5.1.56_cleanup_blubber.php
@@ -16,6 +16,8 @@ return new class extends Migration
LEFT JOIN `object_user_visits` AS ouv
ON (bt.`thread_id` = ouv.`object_id`)
WHERE bt.`external_contact` = 0
+ AND bt.`thread_id` != 'global'
+ AND bt.`user_id` != ''
AND bt.`user_id` NOT IN (
SELECT `user_id` FROM `auth_user_md5`
)";