MYSQL Error.
#1

[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 );
And skin didn't save.

FIXED
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)