[Admigo]

Hi,

I have made a vehicle system with mysql but when i save a vehicle i get error:

Code:

[22:08:49] 1054, Unknown column 'ACNR' in 'field list', OnQueryFinish, UPDATE `a_vehicles` SET `Created` = 2, `Model` = 602, `XPos` = -1649.86, `YPos` = 1218.89, `ZPos` = 7.01,`APos` = 224.33, `Color1` = 1, `Color2` = 1, `Interior` = 0, `VirtualWorld` = 0,`NumberPlate` = ACNR, `Value` = -615000, `Lock` = 0, `Alarm` = 0, `Paintjob` = 255,`Fuel` = 100.000000 WHERE `Owner` = 'Admigo', 1

pawn Code:

SaveVehicle(playerid,vehicleid)
{
    new query1[1000];
    format(query1, sizeof(query1), "UPDATE `"#MYSQL_ACCOUNT_TABLE5"` SET `Created` = %d, `Model` = %d, `XPos` = %.2f, `YPos` = %.2f, `ZPos` = %.2f,`APos` = %.2f, `Color1` = %d, \
    `Color2` = %d, `Interior` = %d, `VirtualWorld` = %d,`NumberPlate` = %s, `Value` = %d, `Lock` = %d, `Alarm` = %d, `Paintjob` = %d,`Fuel` = %f WHERE `Owner` = '%s'",
        VehicleCreated[vehicleid],
        VehicleModel[vehicleid],
        VehiclePos[vehicleid][0],
        VehiclePos[vehicleid][1],
        VehiclePos[vehicleid][2],
        VehiclePos[vehicleid][3],
        VehicleColor[vehicleid][0],
        VehicleColor[vehicleid][1],
        VehicleInterior[vehicleid],
        VehicleWorld[vehicleid],
        VehicleNumberPlate[vehicleid],
        VehicleValue[vehicleid],
        VehicleLock[vehicleid],
        VehicleAlarm[vehicleid],
        VehiclePaintjob[vehicleid],
        Fuel[vehicleid],
        GetPlayeridName(playerid));
    if(mysql_ping(gSQL))
    {
        mysql_query(query1, _THREAD_SAVE_VEHICLE, playerid, gSQL);//query
    }
}

How i can fix this?

Thanks Admigo

[Calabresi]

pawn Code:

format(query1, sizeof(query1), "UPDATE `"#MYSQL_ACCOUNT_TABLE5"` SET `Created` = %d, `Model` = %d, `XPos` = %.2f, `YPos` = %.2f, `ZPos` = %.2f,`APos` = %.2f, `Color1` = %d, \
    `Color2` = %d, `Interior` = %d, `VirtualWorld` = %d,`NumberPlate` = '%s', `Value` = %d, `Lock` = %d, `Alarm` = %d, `Paintjob` = %d,`Fuel` = %f WHERE `Owner` = '%s'",
        VehicleCreated[vehicleid],
        VehicleModel[vehicleid],
        VehiclePos[vehicleid][0],
        VehiclePos[vehicleid][1],
        VehiclePos[vehicleid][2],
        VehiclePos[vehicleid][3],
        VehicleColor[vehicleid][0],
        VehicleColor[vehicleid][1],
        VehicleInterior[vehicleid],
        VehicleWorld[vehicleid],
        VehicleNumberPlate[vehicleid],
        VehicleValue[vehicleid],
        VehicleLock[vehicleid],
        VehicleAlarm[vehicleid],
        VehiclePaintjob[vehicleid],
        Fuel[vehicleid],
        GetPlayeridName(playerid));

You forgot to close your string on NumberPlate with " ' ". It should be '%s', not %s.

[roym899]

Not 100% sure but maybe you should add ' ' around the %s after `NumberPlate`.
Like this:
`NumberPlate`= '%s'

// just like calabresi said.

[Admigo]

Quote:

Originally Posted by Calabresi pawn Code: format(query1, sizeof(query1), "UPDATE `"#MYSQL_ACCOUNT_TABLE5"` SET `Created` = %d, `Model` = %d, `XPos` = %.2f, `YPos` = %.2f, `ZPos` = %.2f,`APos` = %.2f, `Color1` = %d, \     `Color2` = %d, `Interior` = %d, `VirtualWorld` = %d,`NumberPlate` = '%s', `Value` = %d, `Lock` = %d, `Alarm` = %d, `Paintjob` = %d,`Fuel` = %f WHERE `Owner` = '%s'",         VehicleCreated[vehicleid],         VehicleModel[vehicleid],         VehiclePos[vehicleid][0],         VehiclePos[vehicleid][1],         VehiclePos[vehicleid][2],         VehiclePos[vehicleid][3],         VehicleColor[vehicleid][0],         VehicleColor[vehicleid][1],         VehicleInterior[vehicleid],         VehicleWorld[vehicleid],         VehicleNumberPlate[vehicleid],         VehicleValue[vehicleid],         VehicleLock[vehicleid],         VehicleAlarm[vehicleid],         VehiclePaintjob[vehicleid],         Fuel[vehicleid],         GetPlayeridName(playerid)); You forgot to close your string on NumberPlate with " ' ". It should be '%s', not %s.

Fail, i didnt noticed that it was needed. Have some Rep.