SA-MP Forums Archive
[Mysql] Unknown column 'ACNR' - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [Mysql] Unknown column 'ACNR' (/showthread.php?tid=449675)



[Mysql] Unknown column 'ACNR' - Admigo - 09.07.2013

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


Re: [Mysql] Unknown column 'ACNR' - Calabresi - 09.07.2013

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.


AW: [Mysql] Unknown column 'ACNR' - roym899 - 09.07.2013

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

// just like calabresi said.


Re: [Mysql] Unknown column 'ACNR' - Admigo - 09.07.2013

Quote:
Originally Posted by Calabresi
View Post
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.