[iBots]

I have made a system that insert this to a table,everything is ok but it doesnt insert it and shows this in mysql log:

pawn Код:

[01:50:31] [ERROR] CMySQLQuery::Execute[] - (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 '`Price`=0, `Locked`=0 WHERE `Item`=1' at line 1
[01:50:31] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[01:50:31] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:50:31] [ERROR] CMySQLQuery::Execute[] - (error #1136) Column count doesn't match value count at row 1
[01:50:31] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

in script:

pawn Код:

mysql_format(dbHandle, query, sizeof(query), "INSERT INTO `items` (`Item`, `Used`, `ItemN`, `ItemO`, `ItemOw`, `Itemone`, `Itemtwo`, `Itemthree`, `Itemfour`, `ItemI`, `ItemW`, `Itemix`, `Itemiy`, `Itemiz`, `Itemia`, `Itemii`, `Itemiw`, `Price`\
,`ItemLevel`, `ItemLock`) VALUES (%d, %d, '%e', %d, '%e', %f, %f, %f, %f, %d, %d, %f, %f, %f, %f, %d, %d, %d, %d, %d)", itemid, 1, "", 0, "", 0.000, 0.000, 0.000, 0.000, 0, 0,
0.000, 0.000, 0.000, 0.000, 0, 0, 0, 0);

[Jefff]

Missing one value at the end 0, 0, 0, 0