Error in SQL syntax
#1

Hi, when I try to insert an account's information into the accounts table then I get this 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... <here comes the ip and lastlogin>
When I do that on localhost (Windows) then it works, but when I do it on frag.gs and that CentOS MySQL then it gives me that error. This is what I do in the script:
Код:
mysql_format(g_MySQL, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `Salt`, `Email`, `IP`, `LastLogin`) VALUES ('%s', '%s', '%s', '%s', '%s', '%s')", GetName(playerid), PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pSalt], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pIP], PlayerInfo[playerid][pLastLogin]);
mysql_tquery(g_MySQL, query, "OnQueryFinished", "dd", playerid, QUERY_CREATE_ACCOUNT);
Does it have to do something with frag or I'm doing something wrong?
Reply


Messages In This Thread
Error in SQL syntax - by GoldenLion - 22.12.2016, 20:41
Re: Error in SQL syntax - by Yaa - 22.12.2016, 20:48
Re: Error in SQL syntax - by GoldenLion - 22.12.2016, 20:51
Re: Error in SQL syntax - by Private200 - 23.12.2016, 00:21
Re: Error in SQL syntax - by X337 - 23.12.2016, 03:18
Re: Error in SQL syntax - by Sew_Sumi - 23.12.2016, 03:56
Re: Error in SQL syntax - by Vince - 23.12.2016, 09:28
Re: Error in SQL syntax - by BroZeus - 23.12.2016, 10:55
Re: Error in SQL syntax - by GoldenLion - 23.12.2016, 12:16
Re: Error in SQL syntax - by Konstantinos - 23.12.2016, 12:28

Forum Jump:


Users browsing this thread: 1 Guest(s)