"Bad argument #1 to "pairs" (table expected, got boolean)"

[Marshell]

Hello, people! Forgive me if I did something bad/wrong, but, I am following tutorials to make scripts.

So.. as u read, in the title, I have this problem "Bad argument #1 to "pairs"(table expected, got boolean)" (line 28); and the other problem : dbPoll failed, near "FROM" : syntax error.(line 26)

function createVehicleForPlayer(player, command, model)
    local db = exports.db:getConnection()
    local x, y, z = getElementPosition(player)
 y = y + 5
 
 dbExec(db, "INSERT INTO vehicles(model, x, y, z) VALUES(?, ?, ?, ?)", model, x, y, z)
 
 local vehicleObject = createVehicle(model, x, y, z)
 
 dbQuery(function (queryHandle)
     local results = dbPoll(queryHandle, 0)
  local vehicles = results[1]
  
  
  setElementData(vehicleObject, "id", vehicle.id)
  
 
 
 
 end, db, "SELECT id FROM vehicles ORDER BY id DESC LIMIT 1")
end
addCommandHandler("veh", createVehicleForPlayer, false, false)

 

function loadAllVehicles(queryHandle)
    local results = dbPoll(queryHandle, 0)
 
 for index, vehicle in pairs(results) do
     local vehicleObject = createVehicle(vehicle.model, vehicle.x, vehicle.y, vehicle.z)
  
  setElementData(vehicleObject, "id", vehicle.id)
 end
end
 
 
addEventHandler("onResourceStart", resourceRoot, function()
    local db = exports.db:getConnection()
 
 dbQuery(loadAllVehicles, db, "SELECT + FROM vehicles")
end)
 
addEventHandler("onResourceStop", resourceRoot, function()
    local db = exports.db:getConnection()
    local vehicles = getElementsByType("vehicle")
 
 for index, vehicle in pairs(vehicles) do
     local id = getElementData(vehicle, "id")
  local x, y, z = getElementPosition(vehicle)
  
  dbExec(db, "UPDATE vehicles SET x=?, y=?, z=? WHERE id = ?", x, y, z, id)
 end
end)

 

 

 

Edited November 2, 2019 by Marshell

[Zango]

You need to do

SELECT * FROM vehicles

To select everything

[Marshell]

I also got this error : attempt to index global "vehicle" ( a nil value)

at this line :

setElementData(vehicleObject, "id", vehicle.id)

[Zango]

Change this

local vehicles = results[1]

local vehicle = results[1]

 

[Marshell]

Thank you very much !!

[Marshell]

I got another problem... " dbExec failed;  (1) near "x" : syntax error

 

 dbExec(db, "UPDATE vehicles SET x=?, y=?, z=? WHERE id = ?", x, y, z, id)         <<this is the line