[dusk]

pawn Код:

[20:28:15] CMySQLHandler::Query(INSERT INTO `vehicles` (owner,model,Nr,x,y,z,r,Dauzta,LPlate,Locked,EngineHealth,PanelHealth,DoorHealth,LightsHealth,TiresHealth,Lock,Alarm,Insurance,Color1,Color2) VALUES ('Enrico_Mancini',560,0,-192.842575,959.667846,17.427457,0.000000,0,'OQR 917',0,0.000000,0,0,0,0,0,0,0,135,186)) - An error has occured. (Error ID: 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,Alarm,Insurance,Color1,Color2) VALUES ('Enrico_Mancini',560,0,-192.842575,9' at line 1)

Thats the error,and this is the command save function:

pawn Код:

stock SaveVehicles(playerid)
{
    new query[512],query2[256];
    format(query2,sizeof(query2),"SELECT * FROM vehicles WHERE owner = '%s'",Name);
    mysql_query(query2);
    mysql_store_result();
    if(mysql_num_rows()==1)
    {
        format(query,sizeof(query),"UPDATE `vehicles` SET owner = '%s', model = '%d',Nr = '%d', x = '%f', y = '%f', z = '%f', r = '%f', Dauzta = '%d', LPlate = '%s', Locked = '%d', EngineHealth = '%f', BodyHealth = '%d', Lock = '%d', Alarm = '%d', Insurance = '%d', Color1 = '%d', \
        Color2 = '%d' WHERE owner = '%s'",Name,VehicleInfo[playerid][model],VehicleInfo[playerid][Nr],
        VehicleInfo[playerid][pos][X],VehicleInfo[playerid][pos][Y],VehicleInfo[playerid][pos][Z],VehicleInfo[playerid][pos][R],
        VehicleInfo[playerid][Dauzta],VehicleInfo[LPlate],VehicleInfo[playerid][Locked],VehicleInfo[playerid][EngineHealth],
        VehicleInfo[playerid][BodyHealth][Panels],VehicleInfo[playerid][BodyHealth][Doors],VehicleInfo[playerid][BodyHealth][Lights],
        VehicleInfo[playerid][BodyHealth][Tires],VehicleInfo[playerid][Lock],VehicleInfo[playerid][Alarm],VehicleInfo[playerid][Insurance],
        VehicleInfo[playerid][Color1],VehicleInfo[playerid][Color2],Name);
        mysql_query(query);
    }
    else
    {
        format(query,sizeof(query),"INSERT INTO `vehicles` (owner,model,Nr,x,y,z,r,Dauzta,LPlate,Locked,EngineHealth,PanelHealth,DoorHealth,LightsHealth,TiresHealth,Lock,Alarm,Insurance,Color1,Color2) VALUES ('%s',%d,%d,%f,%f,%f,%f,%d,'%s',%d,%f,%d,%d,%d,%d,%d,%d,%d,%d,%d)", \
        Name,VehicleInfo[playerid][model],VehicleInfo[playerid][Nr],VehicleInfo[playerid][pos][X],VehicleInfo[playerid][pos][Y],
        VehicleInfo[playerid][pos][Z],VehicleInfo[playerid][pos][R],VehicleInfo[playerid][Dauzta],VehicleInfo[playerid][LPlate],
        VehicleInfo[playerid][Locked],VehicleInfo[playerid][EngineHealth],VehicleInfo[playerid][BodyHealth][Panels],VehicleInfo[playerid][BodyHealth][Doors],
        VehicleInfo[playerid][BodyHealth][Lights],VehicleInfo[playerid][BodyHealth][Tires],VehicleInfo[playerid][Lock],
        VehicleInfo[playerid][Alarm],VehicleInfo[playerid][Insurance],VehicleInfo[playerid][Color1],VehicleInfo[playerid][Color2]);
        mysql_query(query);
    }
    mysql_free_result();
}

[Brokenbreaken]

I think you must use mysql_free_result before next mysql_query.

[dusk]

That didn't change anything,thanks for trying tho

[dusk]

bump

[FUNExtreme]

Mysql errors are not samp specific and clearly explained all over the internet

[3ventic]

Are all the columns there in the table structure?

[dusk]

Yes they are

[Jstylezzz]

Count the amount of specifiers, and count the amount of values (I mean these Vehicleinfo[id][something] things).
Maybe you have one too many of one of those?

[dusk]

checked those as well