XF 2.1 Active warning points out of sync

Don Daniello

Don Daniello

Member
Licensed customer
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).
1580777879779.webp
 
Sort by date Sort by votes
Not sure how it happened (different software in 2014?) but try giving -2.
Call it Points Adjustment or whatever. I think it will work.
 
Last edited:
Upvote 0 Downvote
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. :)
 
Upvote 0 Downvote
beerForo said:
Been too long for that option now. Have current ones.
Click to expand...
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:

xenforo.com

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 xenforo.com

SQL: 
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);
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top Bottom