Bug In statistics we have a strange issue

[katoona]

In our statistiscs the winner of given dislikes is reported to have given 4294967294 number of dislikes, and in reallife he has given none.

Its a bug, and when chekcing the user table we find 0 in dbtech_thanks_disliked and 0 in dbtech_thanks_dislikes

Have you encountered this problem before?

How can I remove this?

 

[Fillip H.]

Some MySQL installations incorrectly handle doing "0 - 1". I've not been able to identify how it happens or why, so it's incredibly hard for me to fix it if at all possible.

The only way to clear it would be to recalculate the statistics in the AdminCP I believe.

 

[katoona]

When you say recalculate in Admincp - can you be more spesific?

Edit: found it!!

 

[Fillip H.]

Sorry, good you found it

For anyone else stumbling in here, I meant DBTech - Post Thanks -> Maintenance -> Recalculate and Rebuild Statistics