Log in

View Full Version : Help please?

Leon44
06-21-2008, 01:50 AM
Is there a way I can reset all users reputation in vb 3.6.8?
Dismounted
06-21-2008, 03:51 AM
UPDATE user
SET reputation = 0
reputationlevelid = 4
Leon44
06-21-2008, 04:56 PM
I cant do it, i get this error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reputationlevelid = 4' at line 3
Dismounted
06-22-2008, 07:05 AM
UPDATE user
SET reputation = 0,
reputationlevelid = 4