howto reset the reputation power

[lairnoc]

How can i reset the reputation power in 3.5.1?

[Steve Machol]

You can run these queries to reset the reputations (assuming no table prefixes):

DELETE FROM reputation;

UPDATE user SET reputation = 0, reputationlevelid = 0;

Then you need to run this counter:

Admin CP --> Import & Maintenance --> Update Counters --> Rebuild User Reputation

[lairnoc]

thnx

[abdicar]

i ran this command and now all the users have 0 in power and 0 in reputation... the rebuild user reputation is not working...

[Lats]

i ran this command and now all the users have 0 in power and 0 in reputation... the rebuild user reputation is not working...

That's exactly what the query does - what were you expecting?