MYSQL Error. - 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 Error. (/showthread.php?tid=338026)
+- 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 Error. (/showthread.php?tid=338026)
MYSQL Error. - Ernestas_ - 28.04.2012
[08:24:58] CMySQLHandler::Query(UPDATE `profiliai` SET `skin` = '98', `Security` = '0', `Money` = '0', `Gender` = '18', `score` = '0', WHERE ( `id` = '18' )) - 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 'WHERE ( `id` = '18' )' at line 1)
LINE:
Код:
format( Query, 606, "UPDATE `profiliai` SET `skin` = '%i', `Security` = '%i', `Money` = '%i', `Gender` = '%i', `score` = '%i', WHERE ( `id` = '%i' )", GetPlayerSkin(playerid), pInfo[ playerid ][ security ], AC_GetPlayerMoney( playerid ), pInfo[ playerid ], GetPlayerScore(playerid), idx );
FIXED