MyBB importer exposes deleted posts

dandv · 2015 年10 月 2 日 02:23

After going through a thread with 400+ posts to see why the original thread had 415 posts while the imported one had 417, it appears that the importer doesn’t mark deleted posts in any way.

MyBB soft-deleted posts and they’re no longer visible even to Admins. After importing into Discourse, the deleted posts were visible to all users. This may pose a privacy problem if sensitive data had been exposed in the deleted posts.

sam · 2020 年1 月 10 日 04:35

我很确定多年后的今天情况依然如此：

github.com/discourse/discourse

script/import_scripts/mybb.rb

f1cd59996


      
          results = mysql_query("
            SELECT p.pid id,
                   p.tid topic_id,
                   t.fid category_id,
                   t.subject title,
                   t.firstpost first_post_id,
                   p.uid user_id,
                   p.message raw,
                   p.dateline post_time
              FROM #{TABLE_PREFIX}posts p,
                   #{TABLE_PREFIX}threads t
             WHERE p.tid = t.tid
          ORDER BY p.dateline
             LIMIT #{BATCH_SIZE}
            OFFSET #{offset};
          ")

欢迎提交拉取请求（PR），如果有人愿意修复这个导入脚本的话。

ruoxin · 2021 年7 月 12 日 07:39

这应该能解决该问题。

话题		回复	浏览量
Importing Deleted Posts Development	0	427	2020 年5 月 19 日
Mybb import skips importing posts Support	7	1325	2024 年6 月 8 日
Import phpBB - when are accounts deleted? Migration	3	53	2024 年9 月 16 日
MyBB import doesn't process on quoted posts PID and date Bug	9	3673	2022 年7 月 21 日
Members problem on importing Mybb to Discourse Migration mybb	25	3433	2017 年9 月 4 日

MyBB importer exposes deleted posts

相关话题