XF 1.1 Messages count after import...

[nando99]

We decided to just keep the members and not import the forums/content. I know I know, SEO etc... But that's what they wanted to do. Import from VB4 went fine, I've been setting up the forum and I just realized our message counts are all messed up. I guess it's using our post count from VB... How would I get it to show the correct actual number of messages we have? I tried rebuilding the user cache and forum cache and that didn't work

Any help is appreciated.

 

[Slavik]

This query should help:

UPDATE xf_user AS user
SET message_count = (
    SELECT COUNT(*)
    FROM xf_post AS post
    LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)
    WHERE post.user_id = user.user_id
    AND post.message_state = 'visible' AND thread.discussion_state = 'visible'
    GROUP BY post.user_id
);

 

[nando99]

AWESOME! thanks

 

[nando99]

1 more thing, trophies will need to be updated the same way... can you confirm the query syntax.... thanks in advance!

 

[Jake Bunce]

1 more thing, trophies will need to be updated the same way... can you confirm the query syntax.... thanks in advance!

http://xenforo.com/community/threads/recalculate-trophy-points.30800/#post-351948

 

[nando99]

http://xenforo.com/community/threads/recalculate-trophy-points.30800/#post-351948

thanks!