XF 2.1 Active warning points out of sync

[Don Daniello]

One of our users is banned because warnings points > 3 but the list of warnings shows only 1 active point. What happened? How to re-sync that?
I've tried adding a warning point and removing it, and that did nothing to the overall count (properly added and subtracted the point I temporarily gave).

 

[beerForo]

Not sure how it happened (different software in 2014?) but try giving -2.
Call it Points Adjustment or whatever. I think it will work.

 

[Don Daniello]

try giving -2.

That's not really possible, must be >0 value.

 

[beerForo]

See below:

 

[beerForo]

I migrated from vB 3.8 and I looked, I have the same issue.

1/1 points and it expired in 2010. Perhaps this should be posted in importer bugs. Let's find the fix.

 

[djbaxter]

I had the same issue on one migrated forum. Work-around for me was zeroing all the warning points in the database via an SQL query.

 

[beerForo]

Been too long for that option now. Have current ones.

 

[beerForo]

Would you post the query? I'll probably have to do that. Thanks

 

[djbaxter]

Been too long for that option now. Have current ones.

So did I. I basically gave members amnesty for recent points in order to get rid of the problem of having people banned because XF was adding old vB expired points to new XF points. Zeroing them let everyone start afresh and got rid of that headache for the forum.

It was a while ago now but I believe I used this or something similar:

XF 2.1 - SQL help to delete warning points prior to a specified date

On a vBulletin to XF conversion (where some of the vB tables may have been corrupted), a residual issue is that there are old unexpired vBulletin warning points left over. As a result, if some members get a 1-point warning via XF, it puts them over the threshold and temporarily bans them. I...

xenforo.com

update xf_user
set warning_points = COALESCE(
   (select sum(xf_warning.points) from xf_warning where xf_warning.user_id = xf_user.user_id and is_expired = 0)
, 0);

 

[beerForo]

You can run the user rebuild and fix them in 2.1.8.

Fixed - Expired warning points show as active coming from vB 3.8

As stated, also for reference. https://xenforo.com/community/threads/active-warning-points-out-of-sync.175931/ PS. Could you provide a fix, perhaps a new task that can be run? Thanks!

xenforo.com