Importers for large forums

fefrei · October 24, 2017, 1:34pm

Looking though the code…

lib/tasks/import.rake

4623b46b0


      
               AND NOT COALESCE(p.hidden, 't')
               AND p.post_type = 1
               AND t.deleted_at IS NULL
               AND COALESCE(t.visible, 't')
               AND t.archetype <> 'private_message'
               AND p.user_id > 0
          GROUP BY p.user_id
          )
          UPDATE user_stats
             SET post_count = X.posts
               , posts_read_count = X.posts
               , time_read = X.posts * 5
               , topic_count = X.topics
               , topics_entered = X.topics
               , first_post_created_at = X.min_created_at
               , days_visited = X.days
               , topic_reply_count = X.topic_replies
            FROM X
           WHERE user_stats.user_id = X.user_id
             AND (post_count <> X.posts
               OR posts_read_count <> X.posts

…it looks like this will nuke the read stats

Am I overlooking something?

Topic		Replies	Views
Migrate a phpBB3 forum to Discourse Migrating to Discourse how-to	464	100355	September 4, 2025
Migrate a Vanilla forum to Discourse Sysadmins how-to	44	16349	January 30, 2023
Migrate a XenForo forum to Discourse Sysadmins how-to	90	21024	February 25, 2025
Migrating vBulletin 5 database - Import script errors Migration vbulletin5	46	2565	March 8, 2023
[Paid] Need a Vanilla 2 Import tool Marketplace	66	11224	March 3, 2015

Importers for large forums

Related topics