Users reputation reached its MAX - 2147483647

[tgralex]

On my forum, many users reputation has reached its MAX - 2147483647 points and not increasing anymore... In order to reduce reputation and make it workable again, I have tried to make more restrictive rules on the page vBulletin Options->User Reputation Options, then tried to recalculate reputations using Maintenance->Update Counters->Rebuild User Reputation. But for some reason reputation still stays at the same level...

What am I doing wrong and what to do?

Thanks!

BTW, I liked new 3.7 version and blog feature a lot - Good job!!!

[tgralex]

Should it be run a SQL query on tables?

[Steve Machol]

That is the maximum allowed for that field. That's one food reason not to be playing with the reputation settings to create ultra-high values like this.

I don't know how to fix this except to change the field directly in the database.

[tgralex]

That is the maximum allowed for that field. That's one food reason not to be playing with the reputation settings to create ultra-high values like this.

I don't know how to fix this except to change the field directly in the database.

Agree, it was a little loose rules... But anyway it needs to be recalculated according to the new rules... So, you are saying the only way is to run direct query on tables? What "Rebuild User Reputation" is for anyway?

[Steve Machol]

Good question. I don't know if that really does what you think it does. I'll ask.

[peterska2]

Rebuild User Reputation removes any reputation manually given to users via the AdminCP > Edit User. It also recalculates the reputation power of users when the reputation power options have been changed.

In terms of resolving your issue where your users have reached the maximum possible reputation, you would need to run queries directly on the database to reduce their reputation to a more suitable amount.

[tgralex]

Rebuild User Reputation removes any reputation manually given to users via the AdminCP > Edit User. It also recalculates the reputation power of users when the reputation power options have been changed.

In terms of resolving your issue where your users have reached the maximum possible reputation, you would need to run queries directly on the database to reduce their reputation to a more suitable amount.

So it changes reputation power, but not reputation itself. It something already Than I will reduce reputation by dividing by 10..0

Thank you!

[tgralex]

Rebuild User Reputation removes any reputation manually given to users via the AdminCP > Edit User. It also recalculates the reputation power of users when the reputation power options have been changed.

In terms of resolving your issue where your users have reached the maximum possible reputation, you would need to run queries directly on the database to reduce their reputation to a more suitable amount.

Running query like this

update VBB_reputation
set reputation = Round(Reputation/100)

and then Rebuild user reputation - fixes the problem...