• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Resetting message count after migrating from SMF

#1
#3
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

XenForo moderator
Staff member
#4
#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.