[Score]

Hello, i am getting an error when i am registering ingame.

Here is the code:

PHP код:

[15:51:40] [ERROR] error #1064 while executing query "UPDATE `players` SET `SCORE` = 0, `CASH` = 0, `KILLS` = 0, `DEATHS` = 0, `BAN` = 0, `ADMIN` = 0, `SKIN` = 0, WHERE `ID` = 4 LIMIT 1": 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` = 4 LIMIT 1' at line 1
[15:51:40] [DEBUG] CConnection::GetError(this=0x4d3c020, connection=0x292ff0)
[15:51:40] [DEBUG] CCallback::Create(amx=0x27e12e0, name='OnQueryError', format='dsssd) 


PHP код:

ALTER TABLE `players` ADD `ID` INT(12) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`ID`); 


[DelK]

Remove this comma `SKIN` = 0,

[Score]

Quote:

Originally Posted by DelK Remove this comma `SKIN` = 0,

Thanks! I didn't even notice that

[Sithis]

Also, the LIMIT 1 statement in your UPDATE query will only limit the rowcount returned from the query. Therefore, I suggest removing it.