MySQL Errors
#1

Quote:

[22:48:30] > OnQueryError:
[22:48:30] * Error: 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 'ChatStyle=0, HudCol=0,SecHol=0,Bonus=0 WHERE Name='Hugh_Mungus'' at line 1 (1064)
[22:48:30] * Callback:
[22:48:30] * Query: UPDATE accounts SET Admin=0, Helper=0, Reg=0, Jailed=0, Jailtime=0, helpme=0, ConnectTime=0, Level=0 ChatStyle=0, HudCol=0,SecHol=0,Bonus=0 WHERE Name='Hugh_Mungus'
[22:48:30] -----------------------------------------

This fucks much things up, Any solution?
Reply
#2

Spaces. Use them.
Reply
#3

Missing a comma:
Код:
UPDATE accounts SET Admin=0, Helper=0, Reg=0, Jailed=0, Jailtime=0, helpme=0, ConnectTime=0, Level=0, ChatStyle=0, HudCol=0,SecHol=0,Bonus=0 WHERE Name='Hugh_Mungus
And yes, use space.
Reply
#4

Thanks, repped you both.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)