1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by Ahmed Jadoon, Oct 1, 2016.

  1. Ahmed Jadoon

    Ahmed Jadoon New Member

  2. socialteenz

    socialteenz New Member

    Go to your phpmyadmin & execute this query..

    UPDATE xf_user SET message_count = 0
  3. Ahmed Jadoon

    Ahmed Jadoon New Member

    #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
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

Share This Page