mysql query error
#1

Hey again. I've done another script since my last post, therefore, I'm posting a new topic.


Something is up with this query:

pawn Код:
mysql_format(szCurrent, query, sizeof(query), "INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX` ,`PosY`, `PosZ`) VALUES ('%e', '%s', '%s', 0, 0, 0, 0.0, 0.0, 0.0)", Name[playerid], Player[playerid][Password], IP[playerid]);
as the log states:
Код:
[19:01:44] [ERROR] CMySQLQuery::Execute[OnAccountRegister] - (error #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 '' at line 1
EDIT: nvm, still persisting (same error)
Reply


Messages In This Thread
mysql query error - by sammp - 28.06.2014, 17:39
Re : mysql query error - by Chipardeur - 28.06.2014, 18:00
Re: mysql query error - by sammp - 28.06.2014, 18:07
Re: mysql query error - by Konstantinos - 28.06.2014, 18:12
Re: mysql query error - by Diverse - 28.06.2014, 18:16
Re: mysql query error - by sammp - 28.06.2014, 18:38
Re: mysql query error - by Faisal_khan - 28.06.2014, 18:56
Re: mysql query error - by Konstantinos - 28.06.2014, 18:57
Re: mysql query error - by sammp - 28.06.2014, 19:16
Re: mysql query error - by sammp - 28.06.2014, 19:20

Forum Jump:


Users browsing this thread: 2 Guest(s)