mysql error
#1

Since I'm not good at finding little detail errors, can anyone tell why do I keep getting this?
Quote:

[16:04:57] CMySQLHandler::Query(INSERT INTO `Accounts` (Username,Password,IP,Money,Score,Kills,Deaths,Ran k,Achievements,AdminLvl,milKills,swatKills,mapDeat hs) VALUES('Onfroi','hashed password) - An error has occured. (Error ID: 1064, 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 ''hashed password' at line 1)

I understand the error, but I can't find anything wrong with the syntax
pawn Код:
format(Query,sizeof(Query),"INSERT INTO `Accounts` (Username,Password,IP,Money,Score,Kills,Deaths,Rank,Achievements,AdminLvl,milKills,swatKills,mapDeaths) VALUES('%s','%s','%s','0','0','0','0','1','0','0','0','0','0')",pName(playerid),buffer,GetPlayerIP(playerid));
Thanks in advance.
Reply


Messages In This Thread
mysql error - by Onfroi - 21.12.2014, 21:23
Re: mysql error - by Ox1gEN - 21.12.2014, 22:33
Re: mysql error - by Onfroi - 21.12.2014, 23:04
Re: mysql error - by Ox1gEN - 21.12.2014, 23:08
Re: mysql error - by Onfroi - 22.12.2014, 18:00
Re: mysql error - by Ox1gEN - 22.12.2014, 18:12
Re: mysql error - by LiamM - 22.12.2014, 18:26
Re: mysql error - by Onfroi - 22.12.2014, 19:08

Forum Jump:


Users browsing this thread: 1 Guest(s)