Mysql problem

[Sasu]

Hi! This is a part of my script:

dbQuery ( connection , "CREATE TABLE IF NOT EXISTS Vehicles (VehicleID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, VehicleAccount TEXT, VehicleModel INT, VehicleFuel INT, VehicleHealth INT, VehicleCost INT, VehicleR INT, VehicleG INT, VehicleB INT, VehicleX INT, VehicleY INT, VehicleZ INT, VehicleRX INT, VehicleRY INT, VehicleRZ INT)" ) 
--(...) 
local qh = dbQuery ( connection , "INSERT INTO Vehicles (VehicleAccount, VehicleModel, VehicleFuel, VehicleHealth, VehicleCost, VehicleR, VehicleG, VehicleB, VehicleX, VehicleY, VehicleZ, VehicleRX, VehicleRY, VehicleRZ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", accName, id, 1000, 1000, cost, r, g, b, x, y, z, rx, ry, rz) 
local _,_,vehicleID = dbPoll( qh, -1 ) 
  

And when the INSERT query trigger debugscript 3 says "dbPoll failed; Column count doesn't match value count at row 1" and the INSERT don't work.

Thank you

[WASSIm.]

(?,?,?,?,?,?,?,?,?,?,?,?,?) you have here 13 count but you have 14 column

[Sasu]

(?,?,?,?,?,?,?,?,?,?,?,?,?) you have here 13 count but you have 14 column

Works, thank you.