SA-MP Forums Archive
MySQL Errors - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Errors (/showthread.php?tid=641511)


MySQL Errors - JasonRiggs - 16.09.2017

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?

Re: MySQL Errors - Kane - 16.09.2017

Spaces. Use them.

Re: MySQL Errors - Dayrion - 17.09.2017

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.

Re: MySQL Errors - JasonRiggs - 17.09.2017

Thanks, repped you both.