reputation reset?

[Wayne Luke]

As I have said, the problem you are having has nothing to do with the amount of reputation a user has. Resetting the Reputation will not solve the database error. The database error is caused by a configuration on your server. I cannot recreate it using either MySQL or MariaDB on my local server.

[delicjous]

The problem of rebuild reputation is that the system takes the "base reputation value" you entered at the Maintanence and add the value the user have right now. So you never get the value you want/ need. If you run the query (which also works for vB5 tables ;-)) you could rebuild the reputation with a "base reputation value" of 10 and it should be a "normal" value again.
But like Mark B. wrote... backup your DB first!

And don't forge to replace the table-prefix.

And you better use this statement:

update reputation
set reputation = Round(Reputation/100)
where reputation > 100

Otherwise it will turn every reputation < 100 to 0