[Mysql] Unknown column 'ACNR'
#2

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.
Reply


Messages In This Thread
[Mysql] Unknown column 'ACNR' - by Admigo - 09.07.2013, 20:08
Re: [Mysql] Unknown column 'ACNR' - by Calabresi - 09.07.2013, 20:11
AW: [Mysql] Unknown column 'ACNR' - by roym899 - 09.07.2013, 20:13
Re: [Mysql] Unknown column 'ACNR' - by Admigo - 09.07.2013, 20:17

Forum Jump:


Users browsing this thread: 2 Guest(s)