Mysql Error

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • 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;
    }

  • Leere mal den MySQL Log (lösche ihn) und starte dann deinen Server neu.
    Dann poste was alles in dem MySQL Log steht.


    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fimodel")
    [19:59:16] [ERROR] cache_get_field_content_int - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ficolor1")
    [19:59:16] [ERROR] cache_get_field_content_int - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ficolor2")
    [19:59:16] [ERROR] cache_get_field_content_int - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosX")
    [19:59:16] [ERROR] cache_get_field_content_float - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosY")
    [19:59:16] [ERROR] cache_get_field_content_float - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosZ")
    [19:59:16] [ERROR] cache_get_field_content_float - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosA")
    [19:59:16] [ERROR] cache_get_field_content_float - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fimodel")
    [19:59:16] [ERROR] cache_get_field_content_int - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ficolor1")
    [19:59:16] [ERROR] cache_get_field_content_int - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("ficolor2")
    [19:59:16] [ERROR] cache_get_field_content_int - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosX")
    [19:59:16] [ERROR] cache_get_field_content_float - invalid datatype
    [19:59:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("fiPosY")
    [19:59:16] [ERROR] cache_get_field_content_float - invalid datatype
    Jeffry:

  • Ist das alles was da drin steht?
    Füge gegebenenfalls bei OnGameModeInit das ein:
    mysql_log(LOG_ALL);


    Dann poste erneut was im MySQL Log steht.
    Möglicherweise hast du keine existierende Verbindung, oder die Tabelle heißt tatsächlich nicht so.

  • mysql_log(LOG_ALL);