Bug Your Notifications: 4,294,967,316 After Deleting An Award

[Haltech]

Now this was completely bizarre. So, i ended up deleting an award yesterday from the system. As soon as i delete it, i ended up with "Your Notifications: 4,294,967,316"

so, how can i reset that to working? Thanks

 

[Fillip H.]

Some MySQL versions has issues with setting unsigned integers (numbers that cannot go in the negatives) to their maximum positive value when you do "0 - 1".

UPDATE user SET dbtech_vbactivity_medalmoderatecount = 0

Remember to add your table prefix

 

[Haltech]

Thanks db. Can you give me an example of what that would look like with the prefix in front? Thanks

 

[Fillip H.]

vb_user instead of just "user" if the contents of the tableprefix config.php variable is vb_

 

[Haltech]

LOL nevermind, i dont use prefixes. Thanks. that worked.