XF 1.5 Resetting message count after migrating from SMF

[Ahmed Jadoon]

I migrated from SMF. I wanted to import just members' accounts and was not interested to import any forum postings. Well, I did so but the forum is still showing message counts freecointalk.org
I need exact same thing as https://xenforo.com/community/threads/reset-message-count-to-zero-for-all-users.12795/
But I don't understand what to do with "UPDATE xf_user SET message_count = 0" . Can someone explain step by step what I need to do? I have a cPanel hosting and access to phpmyadmin.

 

[wp_arun]

Go to your phpmyadmin & execute this query..

UPDATE xf_user SET message_count = 0

 

[Ahmed Jadoon]

Go to your phpmyadmin & execute this query..

UPDATE xf_user SET message_count = 0

#1064 - you have an error in SQL syntax; check the manual that corresponds to your MariaDB version for the right syntax to use near '* UPDATE xf_user SET message_count = 0) LIMIT 0, 30' at line 3

 

[Jake Bunce]

#1064 - you have an error in SQL syntax; check the manual that corresponds to your MariaDB version for the right syntax to use near '* UPDATE xf_user SET message_count = 0) LIMIT 0, 30' at line 3

I see an asterisk at the beginning. Make sure you run just the provided query, nothing more.