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;
}