Guten Tag,
ich habe seit Tagen mitbekommen, dass bei mir ein Mysql Error gibt.
Ich hoffe einer kann mir helfen bei mein Problem.
Mysql Error:
[17:24:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fimodel")
[17:24:49] [ERROR] cache_get_field_content_int - invalid datatype
[17:24:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ficolor1")
[17:24:49] [ERROR] cache_get_field_content_int - invalid datatype
[17:24:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ficolor2")
[17:24:49] [ERROR] cache_get_field_content_int - invalid datatype
[17:24:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosX")
[17:24:49] [ERROR] cache_get_field_content_float - invalid datatype
[17:24:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosY")
[17:24:49] [ERROR] cache_get_field_content_float - invalid datatype
[17:24:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosZ")
[17:24:49] [ERROR] cache_get_field_content_float - invalid datatype
[17:24:49] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosA")
[17:24:49] [ERROR] cache_get_field_content_float - invalid datatype
Hier die Stelle:
stock LoadFirmaCars(frakid)
{
	new query[256];
	format(query, sizeof(query), "SELECT * FROM ficars WHERE fiid='%i' AND fabgeschleppt='0'", frakid);
	mysql_function_query(dbhandle,query,true,"OnLoadFirmaCars","i",frakid);
	return 1;
}
public OnLoadFirmaCars(frakid)
{
    new num_fields,num_rows;
	cache_get_data(num_rows,num_fields,dbhandle);
	if(!num_rows)return 1;
	for(new i=0; i<num_rows; i++)
	{
	    new temp_modelid, temp_color1, temp_color2, Float:temp_saveX, Float:temp_saveY, Float:temp_saveZ, Float:temp_saveA;
	    temp_modelid = cache_get_field_content_int(i,"fimodel",dbhandle);
		temp_color1 = cache_get_field_content_int(i,"ficolor1",dbhandle);
		temp_color2 = cache_get_field_content_int(i,"ficolor2",dbhandle);
		temp_saveX = cache_get_field_content_float(i,"fiPosX",dbhandle);
		temp_saveY = cache_get_field_content_float(i,"fiPosY",dbhandle);
		temp_saveZ = cache_get_field_content_float(i,"fiPosZ",dbhandle);
		temp_saveA = cache_get_field_content_float(i,"fiPosA",dbhandle);
		new vID = CreateVehicle(temp_modelid, temp_saveX, temp_saveY, temp_saveZ, temp_saveA, temp_color1, temp_color2, -1);
		fivInfo[vID][fimodel] = temp_modelid;
		fivInfo[vID][ficolor1] = temp_color1;
		fivInfo[vID][ficolor2] = temp_color2;
		fivInfo[vID][fiPosX] = temp_saveX;
		fivInfo[vID][fiPosY] = temp_saveY;
		fivInfo[vID][fiPosZ] = temp_saveZ;
		fivInfo[vID][fiPosA] = temp_saveA;
		fivInfo[vID][db_id] = cache_get_field_content_int(i,"id",dbhandle);
		fivInfo[vID][fiid] = cache_get_field_content_int(i,"fiid",dbhandle);
		vInfo[vID][vehicleTank] = cache_get_field_content_int(i,"fivehicleTank",dbhandle);
		vInfo[vID][vdamage] = cache_get_field_content_float(i,"fivdamage",dbhandle);
		vInfo[vID][fiveh] = 1;
		GetVehicleParamsEx(vID,engine,lights,alarm,doors,bonnet,boot,objective);
		SetVehicleParamsEx(vID,VEHICLE_PARAMS_OFF,lights,alarm,1,bonnet,boot,objective);
	    new string[128];
	    format(string, sizeof(string), ""cBlue"%s [%i]", fiInfo[frakid][fishort], fivInfo[vID][db_id]);
	    SetVehicleNumberPlate(vID, string);
	}
	return 1;
}
		
		
		
	
