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

XF 1.2 Warning Points after import from vB 3.6

Discussion in 'Installation, Upgrade, and Import Support' started by dieg0, Sep 4, 2013.

  1. dieg0

    dieg0 Active Member

    Hello,

    After moving my board to xF there's (at least) one user with millions of warning points. The problem is that if I set an auto bann after X points are reached that user will get banned. I have been looking around in the admin panel and I can't find a way to fix this.
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    If you navigate to the user's profile in the front end, you should be able to see all his warnings and remove unnecessary ones.
     
  3. dieg0

    dieg0 Active Member

    From there I can only remove the warnings the user got after we moved to Xenforo.
     
  4. Mike

    Mike XenForo Developer Staff Member

    The only way to edit someone's warning points--if they're not showing up in XF--is to edit the database directly. It's the warning_points column in xf_user.
     
  5. dieg0

    dieg0 Active Member

    Hello Mike, I rather not mess up my forum by trying this myself :eek:. Is there any chance you can share the mysql query that would achieve that? The user has 4.294.967.294 warning points all of them from vB 3.6 and his user ID is 25643.
     
    Last edited: Sep 4, 2013
  6. Mike

    Mike XenForo Developer Staff Member

    Code:
    UPDATE xf_user SET warning_points = 0 WHERE user_id = 25643;
    Note that you need to change the "0" to the correct number of points.
     
  7. dieg0

    dieg0 Active Member

    It worked ;)

    One more thing. Lets say my user has 100 warning points from vB and 1 from xF. I just set his w. p. to 0 but he still has that Warnings(1) tab in his profile page with all the details related to the one he got once me moved to xF. Is there any way I can fix this? Maybe rebuilding caches would do the trick? I want a clean slate for every user.
     
  8. Jeremy

    Jeremy XenForo Moderator Staff Member

    Truncate the warnings table.
     
  9. dieg0

    dieg0 Active Member

    Hi Jeremy,

    Code:
     xf_warning                          |
    | xf_warning_action                    |
    | xf_warning_action_trigger            |
    | xf_warning_definition
    The first one?
     
  10. Mike

    Mike XenForo Developer Staff Member

    Correct.
     

Share This Page