MYSQL error: 1604

[gergo150]

Hi all!

I need help:

  
WARNING: @...:110: dbFree failed; (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 'lock, upg1, upg2, upg3, upg4, upg5, upg6, upg7, upg8, upg9, upg10, upg11, upg12' at line 1 
  

Why is it?

function beszallaskor(player) 
        konnekt = dbConnect("mysql", "dbname=meetlife;host=127.0.0.1;port=3306;", "", "") 
         
        outputChatBox(getVehicleType(getPedOccupiedVehicle(player))) 
         
end 
  
function carsave(player) 
    vehicle = getPedOccupiedVehicle(player) 
    if(vehicle) then 
        local x, y, z = getElementPosition(vehicle) 
        local col1, col2, col3, col4 = getVehicleColor(vehicle) 
        if(isVehicleLocked(vehicle)) then 
            lock = 1 
        else 
            lock = 0 
        end 
         
        --alap 
        upgrades0 = 0 
        upgrades1 = 0 
        upgrades2 = 0 
        upgrades3 = 0 
        upgrades4 = 0 
        upgrades5 = 0 
        upgrades6 = 0 
        upgrades7 = 0 
        upgrades8 = 0 
        upgrades9 = 0 
        upgrades10 = 0 
        upgrades11 = 0 
        upgrades12 = 0 
        upgrades13 = 0 
        upgrades14 = 0 
        upgrades15 = 0 
        upgrades16 = 0 
         
        --számok beiratása, 4 karakter hosszúságúak. Bővebben: [url=https://wiki.multitheftauto.com/wiki/Vehicle_Upgrades]https://wiki.multitheftauto.com/wiki/Vehicle_Upgrades[/url] 
        if(getVehicleUpgradeOnSlot(vehicle, 0)) then 
            upgrades0 = getVehicleUpgradeOnSlot(vehicle, 0) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 1)) then 
            upgrades1 = getVehicleUpgradeOnSlot(vehicle, 1) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 2)) then 
            upgrades2 = getVehicleUpgradeOnSlot(vehicle, 2) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 3)) then 
            upgrades3 = getVehicleUpgradeOnSlot(vehicle, 3) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 4)) then 
            upgrades4 = getVehicleUpgradeOnSlot(vehicle, 4) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 5)) then 
            upgrades5 = getVehicleUpgradeOnSlot(vehicle, 5) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 6)) then 
            upgrades6 = getVehicleUpgradeOnSlot(vehicle, 6) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 7)) then 
            upgrades7 = getVehicleUpgradeOnSlot(vehicle, 7) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, -- s8) -->) then 
            upgrades8 = getVehicleUpgradeOnSlot(vehicle, -- s8) -->
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 9)) then 
            upgrades9 = getVehicleUpgradeOnSlot(vehicle, 9) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 10)) then 
            upgrades10 = getVehicleUpgradeOnSlot(vehicle, 10) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 11)) then 
            upgrades11 = getVehicleUpgradeOnSlot(vehicle, 11) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 12)) then 
            upgrades12 = getVehicleUpgradeOnSlot(vehicle, 12) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 13)) then 
            upgrades13 = getVehicleUpgradeOnSlot(vehicle, 13) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 14)) then 
            upgrades14 = getVehicleUpgradeOnSlot(vehicle, 14) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 15)) then 
            upgrades15 = getVehicleUpgradeOnSlot(vehicle, 15) 
        end 
        if(getVehicleUpgradeOnSlot(vehicle, 16)) then 
            upgrades16 = getVehicleUpgradeOnSlot(vehicle, 16) 
        end 
         
        local carhealth = getElementHealth(vehicle) 
        local engineState = 1 
        if(getVehicleEngineState(vehicle)) then 
            engineState = 1 
        else 
            engineState = 0 
        end 
        local id = getElementModel(vehicle) 
        local vehicleID = id 
         
        local szov = "INSERT INTO cars (user, posX, posY, posZ, Door1, Door2, Door3, Door4, Door5, Door6, Light, LightState1, LightState2, LightState3, LightState4, Engine, Color1, Color2, Color3, Color4, lock, upg1, upg2, upg3, upg4, upg5, upg6, upg7, upg8, upg9, upg10, upg11, upg12, upg13, upg14, upg15, upg16, upg17, Health, ModelID) VALUES ('"..getPlayerName(player).."', '"..x.."', '"..y.."', '"..z.."', "..getVehicleDoorState(vehicle, 0)..", "..getVehicleDoorState(vehicle, 1)..", "..getVehicleDoorState(vehicle, 2)..", "..getVehicleDoorState(vehicle, 3)..", "..getVehicleDoorState(vehicle, 4)..", "..getVehicleDoorState(vehicle, 5)..", "..getVehicleOverrideLights(vehicle)..", "..getVehicleLightState(vehicle, 0)..", "..getVehicleLightState(vehicle, 1)..", "..getVehicleLightState(vehicle, 2)..", "..getVehicleLightState(vehicle, 3)..", "..engineState..", "..col1..", "..col2..", "..col3..", "..col4..", "..lock..", "..upgrades0..", "..upgrades1..", "..upgrades2..", "..upgrades3..", "..upgrades4..", "..upgrades5..", "..upgrades6..", "..upgrades7..", "..upgrades8..", "..upgrades9..", "..upgrades10..", "..upgrades11..", "..upgrades12..", "..upgrades13..", "..upgrades14..", "..upgrades15..", "..upgrades16..", '"..carhealth.."', "..vehicleID..");" 
         
        local er = fileOpen("car.txt") 
         
        fileWrite(er, szov, "\n") 
        fileClose(er) 
         
        konnekt = dbConnect("mysql", "dbname=meetlife;host=127.0.0.1;port=3306;", "", "") 
        query = dbQuery(konnekt, szov) 
        er = dbFree(query) 
         
        if(er) then 
        outputChatBox("Autó lespawnolási helye megváltoztatva!", source) 
        else 
        outputChatBox("Hiba történt! Próbáld újra!", source) 
        end 
    else 
        outputChatBox("A lekötéshez gépjárműben kell lenned!", source) 
    end 
end 
  
addCommandHandler("carpos", carsave) 
  
addEventHandler("onVehicleEnter", getRootElement(), beszallaskor) 

[tosfera]

Can I ask, what is the semicolon doing there?

, "..vehicleID..");" 
 

Also, why are you adding single qoutes on int's at the x, y, z axes? Also, since it's crying about your naming about 'lock'. Try to rename the local lock to 'lockStatus', Cause a field in your table is also called lock. he might be crying about it That's all I could find in a quick scan.

[gergo150]

Shit, bad name -> database = Lock, Lua = lock

Thank you!!!!!!!!

[tosfera]

No problem.