Error ID: 1064, You have an error in your SQL syntax;
#1

Код:
format(query, sizeof(query),"INSERT INTO `vehicles` (`CarID`,`Model`,`Color1`,`Color2`,`Price`,`Owner`,`vPosX`,`vPosY`,`vPosZ`,`vPosA`,`Plate`,`PaintJ`,`Locked`,`Carcode`,`OreC`,`KM`,`Towed`,`Weapon1`,");
	  	format(query, sizeof(query),"%s`Weapon2`,`Weapon3`,`Weapon4`,`Weapon5`,`Weapon6`,`Ammo1`,`Ammo2`,`Ammo3`,`Ammo4`,`Ammo5`,`Ammo6`,`FirstAid`,`Variabila`,`Component0`,`Component1`,`Component2`,`Component3`,`Component4`,`Component5`,`Component6`,`Component7`,`Component8`,`Component9`,`Component10`,`Component11`,`Component12`,`Component13`)", query);
		format(query, sizeof(query),"%s VALUES ('%d','%d','%d','%d','%d','%s','%f','%f','%f','%f','%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",
		query,
		Total_Veh_Created,
		ivModel,
		ivColors[0],
		ivColors[1],
		ivPrice,
		vInfo[Total_Veh_Created][vOwner],
		Pos[0],
		Pos[1],
		Pos[2],
		Pos[3],
		vInfo[Total_Veh_Created][vPlate],
		vInfo[Total_Veh_Created][vPaintJ],
		vInfo[Total_Veh_Created][vLocked],
		vInfo[Total_Veh_Created][vCarCode],
		vInfo[Total_Veh_Created][vOre],
		vInfo[Total_Veh_Created][vVodo],
		vInfo[Total_Veh_Created][vTowed],
		vInfo[Total_Veh_Created][trWeapon1],
	    vInfo[Total_Veh_Created][trWeapon2],
	    vInfo[Total_Veh_Created][trWeapon3],
		vInfo[Total_Veh_Created][trWeapon4],
		vInfo[Total_Veh_Created][trWeapon5],
		vInfo[Total_Veh_Created][trWeapon6],
		vInfo[Total_Veh_Created][trAmmo1],
		vInfo[Total_Veh_Created][trAmmo2],
		vInfo[Total_Veh_Created][trAmmo3],
	    vInfo[Total_Veh_Created][trAmmo4],
	    vInfo[Total_Veh_Created][trAmmo5],
		vInfo[Total_Veh_Created][trAmmo6],
	    vInfo[Total_Veh_Created][tMedkit],
	    vInfo[Total_Veh_Created][vVariabila],
	    vInfo[Total_Veh_Created][vComponent0],
	    vInfo[Total_Veh_Created][vComponent1],
	    vInfo[Total_Veh_Created][vComponent2],
	    vInfo[Total_Veh_Created][vComponent3],
	    vInfo[Total_Veh_Created][vComponent4],
	    vInfo[Total_Veh_Created][vComponent5],
	    vInfo[Total_Veh_Created][vComponent6],
	    vInfo[Total_Veh_Created][vComponent7],
	    vInfo[Total_Veh_Created][vComponent8],
	    vInfo[Total_Veh_Created][vComponent9],
	    vInfo[Total_Veh_Created][vComponent10],
	    vInfo[Total_Veh_Created][vComponent11],
	    vInfo[Total_Veh_Created][vComponent12],
	    vInfo[Total_Veh_Created][vComponent13]);
		mysql_query(query);
Error

CMySQLHandler::Query(INSERT INTO `vehicles` (`CarID`,`Model`,`Color1`,`Color2`,`Price`,`Owner` ,`vPosX`,`vPosY`,`vPosZ`,`vPosA`,`Plate`,`PaintJ`, `Locked`,`Carcode`,`OreC`,`KM`,`Towed`,`Weapon1`,` Weapon2`,`Weapon3`,`Weapon4`,`Weapon5`,`Weapon6`,` Ammo1`,`Ammo2`,`Ammo3`,`Ammo4`,`Ammo5`,`Ammo6`,`Fi rstAid`,`Variabila`,`Component0`,`Component1`,`Com ponent2`,`Component3`,`Component4`,`Component5`,`C omponent6`,`Component7`,`Component8`,`Component9`, `Component10`,`Component11`,`Component12`,`Compone nt13`) VALUES ('5','400','2','2','12','Unbought','1386.406005','-1620.778320','17.023591','274.569885','Numar','6', '0','488','0','0','0') - 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 '' at line 1)


I check and wverything looks ok :\
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 7 Guest(s)