Column count doesn't match value count at row 1

Column count doesn't match value count at row 1 - 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: Column count doesn't match value count at row 1 (/showthread.php?tid=607284)

Column count doesn't match value count at row 1 - SetPlayerNameTag - 17.05.2016

I'm trying to make an active system, admin can handle it even this player is offline but I have a problem to insert

PHP код:



[20:52:24] > MYSQL:

[20:52:24] * ERROR: Column count doesn't match value count at row 1 (1136)

[20:52:24] * FROM: CAN NOT BE FOUND.

[20:52:24] * QUERY: INSERT INTO accounts (`Name`,`Pass`,`Cash`,`Bank`,`Model`,`Interior`,`World`,`Tut`,`Age`,`Sex`,`PosX`,`PosY`,`PosZ`,`Health`,`Armour`,`MaskID`,`PhoneNum`,`WepSerial`,`OfflineReg`,`LastPrim`,`LastSec`,`LastMelee`,`Materials`) VALUES ('Sakura_Testss','630D8DADBA39B0C7A0E3BF7A84219403B0B0AE19661FB25CE48E1DD751625FBF',500,0,26,0,0,0,14,1,1642.729,-2240.559,13.495,99.0,0.0,6192190,3467661,8336956,1,-1,-1,-1)

Код:

mysql_format(handlesql, query, sizeof(query), "INSERT INTO accounts (`Name`,`Pass`,`Cash`,`Bank`,`Model`,`Interior`,`World`,`Tut`,`Age`,`Sex`,`PosX`,`PosY`,`PosZ`,`Health`,`Armour`,`MaskID`,`PhoneNum`,`WepSerial`,`OfflineReg`,`LastPrim`,`LastSec`,`LastMelee`,`Materials`) VALUES ('%s','%s',%i,%i,%i,%i,%i,%i,%i,%i,%f,%f,%f,%f,%f,%d,%d,%d,%i,%d,%d,%d)",name,password,500,0,26,0,0,0,14,1,1642.7285,-2240.5591,13.4945,99.0,0.0,randmask,randphone,randserial,1,-1,-1,-1,0);
mysql_tquery(handlesql, query);
mysql_format(handlesql, query, sizeof(query), "DELETE FROM applications WHERE Name = '%s'", name);
mysql_tquery(handlesql, query);