mysql.log 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
  • halloo zusammen,
    habe folgende Errrors in meinem MYSQL.log und kann damit nichts anfangen



    Spoiler anzeigen
    [19:13:17] [WARNING] CMySQLConnection::Disconnect - no connection available
    [19:13:17] [WARNING] CMySQLConnection::Disconnect - no connection available
    [19:13:17] [WARNING] CMySQLConnection::Disconnect - no connection available
    [19:13:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    [19:13:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    [19:13:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    [19:13:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

  • eig ist es aktiviert


    //MYSQL


    #define db_host "localhost"
    #define db_user "ni191488_3_DB"
    #define db_pass "hZP99Rb0"
    #define db_db "ni191488_3_DB"



    die daten stimmen auch noch überein


    dbhandle = mysql_connect(db_host,db_user,db_db,db_pass);


    und dann halt mit mysql connect ^^

  • sooo die erros und warnings sind alle weg
    connecten kann ich auch


    nur ich habe noch diesen error im log


    [20:35:15] Script[gamemodes/Script1.amx]: Run time error 19: "File or function is not found"
    [20:35:15] Number of vehicle models: 0

    Einmal editiert, zuletzt von DevilMakeCry74 () aus folgendem Grund: kann doch connecten

  • Die Textdraws die beim Connecten geladen werden sollen

    Spoiler anzeigen
    //TEXTDRAWS
    //Loginregister
    Textdraw0 = TextDrawCreate(533.200012, 85.126663, "Hintergrundbox");
    TextDrawLetterSize(Textdraw0, 0.000000, 27.227039);
    TextDrawTextSize(Textdraw0, 116.400001, 0.000000);
    TextDrawAlignment(Textdraw0, 1);
    TextDrawColor(Textdraw0, 0);
    TextDrawUseBox(Textdraw0, true);
    TextDrawBoxColor(Textdraw0, 102);
    TextDrawSetShadow(Textdraw0, 0);
    TextDrawSetOutline(Textdraw0, 0);
    TextDrawFont(Textdraw0, 0);

    Spoiler anzeigen
    Textdraw1 = TextDrawCreate(235.200012, 97.066642, "Fun4Life Roleplay");
    TextDrawLetterSize(Textdraw1, 0.725998, 2.458666);
    TextDrawAlignment(Textdraw1, 1);
    TextDrawColor(Textdraw1, -1);
    TextDrawSetShadow(Textdraw1, 0);
    TextDrawSetOutline(Textdraw1, 0);
    TextDrawBackgroundColor(Textdraw1, 51);
    TextDrawFont(Textdraw1, 1);
    TextDrawSetProportional(Textdraw1, 1);

    Spoiler anzeigen
    Textdraw2 = TextDrawCreate(138.000000, 124.699996, "Trennlinie");
    TextDrawLetterSize(Textdraw2, 0.000000, -0.731481);
    TextDrawTextSize(Textdraw2, 511.599975, 0.000000);
    TextDrawAlignment(Textdraw2, 1);
    TextDrawColor(Textdraw2, 0);
    TextDrawUseBox(Textdraw2, true);
    TextDrawBoxColor(Textdraw2, 102);
    TextDrawSetShadow(Textdraw2, 0);
    TextDrawSetOutline(Textdraw2, 0);
    TextDrawFont(Textdraw2, 0);

    Spoiler anzeigen
    Textdraw3 = TextDrawCreate(148.799987, 148.586715, "Registrieren");
    TextDrawLetterSize(Textdraw3, 0.526000, 1.935999);
    TextDrawTextSize(Textdraw3, 250.000000, 23.000000);
    TextDrawAlignment(Textdraw3, 1);
    TextDrawColor(Textdraw3, -1);
    TextDrawSetShadow(Textdraw3, 0);
    TextDrawSetOutline(Textdraw3, 1);
    TextDrawBackgroundColor(Textdraw3, 51);
    TextDrawFont(Textdraw3, 1);
    TextDrawSetProportional(Textdraw3, 1);
    TextDrawSetSelectable(Textdraw3, true);
    Textdraw3_1 = TextDrawCreate(148.799987, 148.586715, "Einloggen");
    TextDrawLetterSize(Textdraw3_1, 0.526000, 1.935999);
    TextDrawTextSize(Textdraw3_1, 233.000000, 23.000000);
    TextDrawAlignment(Textdraw3_1, 1);
    TextDrawColor(Textdraw3_1, -1);
    TextDrawSetShadow(Textdraw3_1, 0);
    TextDrawSetOutline(Textdraw3_1, 1);
    TextDrawBackgroundColor(Textdraw3_1, 51);
    TextDrawFont(Textdraw3_1, 1);
    TextDrawSetProportional(Textdraw3_1, 1);
    TextDrawSetSelectable(Textdraw3_1, true);

    Spoiler anzeigen
    Textdraw4 = TextDrawCreate(147.200012, 197.120040, "Serverinfos");
    TextDrawLetterSize(Textdraw4, 0.517998, 1.936000);
    TextDrawTextSize(Textdraw4, 250.000000, 22.000000);
    TextDrawAlignment(Textdraw4, 1);
    TextDrawColor(Textdraw4, -1);
    TextDrawSetShadow(Textdraw4, 0);
    TextDrawSetOutline(Textdraw4, 1);
    TextDrawBackgroundColor(Textdraw4, 51);
    TextDrawFont(Textdraw4, 1);
    TextDrawSetProportional(Textdraw4, 1);
    TextDrawSetSelectable(Textdraw4, true);

    Spoiler anzeigen
    Textdraw5 = TextDrawCreate(144.000000, 245.653350, "Server verlassen");
    TextDrawLetterSize(Textdraw5, 0.513998, 1.935999);
    TextDrawTextSize(Textdraw5, 295.000000, 22.000000);
    TextDrawAlignment(Textdraw5, 1);
    TextDrawColor(Textdraw5, -1);
    TextDrawSetShadow(Textdraw5, 0);
    TextDrawSetOutline(Textdraw5, 1);
    TextDrawBackgroundColor(Textdraw5, 51);
    TextDrawFont(Textdraw5, 1);
    TextDrawSetProportional(Textdraw5, 1);
    TextDrawSetSelectable(Textdraw5, true);

    Spoiler anzeigen
    Textdraw6 = TextDrawCreate(514.799926, 304.646667, "Trennlinie2");
    TextDrawLetterSize(Textdraw6, 0.000000, -0.565554);
    TextDrawTextSize(Textdraw6, 128.399978, 0.000000);
    TextDrawAlignment(Textdraw6, 1);
    TextDrawColor(Textdraw6, 0);
    TextDrawUseBox(Textdraw6, true);
    TextDrawBoxColor(Textdraw6, 102);
    TextDrawSetShadow(Textdraw6, 0);
    TextDrawSetOutline(Textdraw6, 0);
    TextDrawFont(Textdraw6, 0);

    Spoiler anzeigen
    Textdraw7 = TextDrawCreate(137.600006, 309.866638, "TS: 212.227.88.250:9988");
    TextDrawLetterSize(Textdraw7, 0.405999, 1.674666);
    TextDrawAlignment(Textdraw7, 1);
    TextDrawColor(Textdraw7, -1);
    TextDrawSetShadow(Textdraw7, 0);
    TextDrawSetOutline(Textdraw7, 0);
    TextDrawBackgroundColor(Textdraw7, 51);
    TextDrawFont(Textdraw7, 1);
    TextDrawSetProportional(Textdraw7, 1);

    Spoiler anzeigen
    Textdraw8 = TextDrawCreate(318.399963, 309.866638, "Forum: www.jojosmcbox.de");
    TextDrawLetterSize(Textdraw8, 0.462799, 1.726933);
    TextDrawAlignment(Textdraw8, 1);
    TextDrawColor(Textdraw8, -1);
    TextDrawSetShadow(Textdraw8, 0);
    TextDrawSetOutline(Textdraw8, 1);
    TextDrawBackgroundColor(Textdraw8, 51);
    TextDrawFont(Textdraw8, 1);
    TextDrawSetProportional(Textdraw8, 1);


    //STATS
    Textdraw9 = TextDrawCreate(636.399963, 327.046691, "Hintergrundbox");
    TextDrawLetterSize(Textdraw9, 0.000000, 12.542590);
    TextDrawTextSize(Textdraw9, 492.399993, 0.000000);
    TextDrawAlignment(Textdraw9, 1);
    TextDrawColor(Textdraw9, 0);
    TextDrawUseBox(Textdraw9, true);
    TextDrawBoxColor(Textdraw9, 102);
    TextDrawSetShadow(Textdraw9, 0);
    TextDrawSetOutline(Textdraw9, 0);
    TextDrawFont(Textdraw9, 0);

    Spoiler anzeigen
    Textdraw10 = TextDrawCreate(564.799987, 327.040039, "Statistiken");
    TextDrawLetterSize(Textdraw10, 0.449999, 1.600000);
    TextDrawAlignment(Textdraw10, 2);
    TextDrawColor(Textdraw10, -1);
    TextDrawSetShadow(Textdraw10, 0);
    TextDrawSetOutline(Textdraw10, 1);
    TextDrawBackgroundColor(Textdraw10, 51);
    TextDrawFont(Textdraw10, 1);
    TextDrawSetProportional(Textdraw10, 1);

    Spoiler anzeigen
    Textdraw11 = TextDrawCreate(624.400024, 346.459991, "Trennlinie");
    TextDrawLetterSize(Textdraw11, 0.000000, -0.399630);
    TextDrawTextSize(Textdraw11, 503.600006, 0.000000);
    TextDrawAlignment(Textdraw11, 1);
    TextDrawColor(Textdraw11, 0);
    TextDrawUseBox(Textdraw11, true);
    TextDrawBoxColor(Textdraw11, 102);
    TextDrawSetShadow(Textdraw11, 0);
    TextDrawSetOutline(Textdraw11, 0);
    TextDrawFont(Textdraw11, 0);

    Spoiler anzeigen
    Textdraw12 = TextDrawCreate(625.199890, 423.366668, "Trennlinie2");
    TextDrawLetterSize(Textdraw12, 0.000000, -0.396666);
    TextDrawTextSize(Textdraw12, 504.400054, 0.000000);
    TextDrawAlignment(Textdraw12, 1);
    TextDrawColor(Textdraw12, 0);
    TextDrawUseBox(Textdraw12, true);
    TextDrawBoxColor(Textdraw12, 102);
    TextDrawSetShadow(Textdraw12, 0);
    TextDrawSetOutline(Textdraw12, 0);
    TextDrawFont(Textdraw12, 0);

    Spoiler anzeigen
    Textdraw13 = TextDrawCreate(535.199890, 404.693481, "/stats");
    TextDrawLetterSize(Textdraw13, 0.321999, 1.077332);
    TextDrawAlignment(Textdraw13, 1);
    TextDrawColor(Textdraw13, -1);
    TextDrawSetShadow(Textdraw13, 0);
    TextDrawSetOutline(Textdraw13, 1);
    TextDrawBackgroundColor(Textdraw13, 51);
    TextDrawFont(Textdraw13, 2);
    TextDrawSetProportional(Textdraw13, 1);

    for(new i = 0; i<MAX_PLAYERS; i++)
    {
    Textdraw14[i] = CreatePlayerTextDraw(i, 507.200012, 349.440032, "Geld: ERROR$");
    PlayerTextDrawLetterSize(i, Textdraw14[i], 0.449999, 1.600000);
    PlayerTextDrawAlignment(i, Textdraw14[i], 1);
    PlayerTextDrawColor(i, Textdraw14[i], -1);
    PlayerTextDrawSetShadow(i, Textdraw14[i], 0);
    PlayerTextDrawSetOutline(i, Textdraw14[i], 1);
    PlayerTextDrawBackgroundColor(i, Textdraw14[i], 51);
    PlayerTextDrawFont(i, Textdraw14[i], 1);
    PlayerTextDrawSetProportional(i, Textdraw14[i], 1);

    Spoiler anzeigen
    Textdraw15[i] = CreatePlayerTextDraw(i, 508.000000, 367.359954, "Level: ERROR");
    PlayerTextDrawLetterSize(i, Textdraw15[i], 0.449999, 1.600000);
    PlayerTextDrawAlignment(i, Textdraw15[i], 1);
    PlayerTextDrawColor(i, Textdraw15[i], -1);
    PlayerTextDrawSetShadow(i, Textdraw15[i], 0);
    PlayerTextDrawSetOutline(i, Textdraw15[i], 1);
    PlayerTextDrawBackgroundColor(i, Textdraw15[i], 51);
    PlayerTextDrawFont(i, Textdraw15[i], 1);
    PlayerTextDrawSetProportional(i, Textdraw15[i], 1);

    Spoiler anzeigen
    Textdraw16[i] = CreatePlayerTextDraw(i, 508.799926, 385.280090, "PayDay: ERROR");
    PlayerTextDrawLetterSize(i, Textdraw16[i], 0.449999, 1.600000);
    PlayerTextDrawAlignment(i, Textdraw16[i], 1);
    PlayerTextDrawColor(i, Textdraw16[i], -1);
    PlayerTextDrawSetShadow(i, Textdraw16[i], 0);
    PlayerTextDrawSetOutline(i, Textdraw16[i], 1);
    PlayerTextDrawBackgroundColor(i, Textdraw16[i], 51);
    PlayerTextDrawFont(i, Textdraw16[i], 1);
    PlayerTextDrawSetProportional(i, Textdraw16[i], 1);

    Spoiler anzeigen
    Textdraw17[i] = CreatePlayerTextDraw(i, 565.599975, 424.106597, "ERROR");
    PlayerTextDrawLetterSize(i, Textdraw17[i], 0.449999, 1.600000);
    PlayerTextDrawAlignment(i, Textdraw17[i], 2);
    PlayerTextDrawColor(i, Textdraw17[i], -1);
    PlayerTextDrawSetShadow(i, Textdraw17[i], 0);
    PlayerTextDrawSetOutline(i, Textdraw17[i], 1);
    PlayerTextDrawBackgroundColor(i, Textdraw17[i], 51);
    PlayerTextDrawFont(i, Textdraw17[i], 1);
    PlayerTextDrawSetProportional(i, Textdraw17[i], 1);
    }




    Spoiler anzeigen
    public OnPlayerConnect(playerid)
    {

    //Spielerfarbe setzen
    SetPlayerColor(playerid,COLOR_WHITE);
    GivePlayerMoney(playerid,5790);
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (10%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (20%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (30%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (40%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (50%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (60%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (70%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (80%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (90%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten werden geladen (100%)");
    SendClientMessage(playerid,CLGREEN,"Deine Spielerdaten wurden erfolgreich geladen!");

    Spoiler anzeigen
    //LOGIN/REGISTER
    new name[MAX_PLAYER_NAME],query[128];
    GetPlayerName(playerid,name,sizeof(name));
    format(query,sizeof(query),"SELECT id FROM user WHERE username='%s'",name);
    mysql_function_query(dbhandle,query,true,"OnUserCheck","i",playerid);
    SendClientMessage(playerid,0x37FF00FF,"Herzlich Willkommen auf 4RL!");
    SendClientMessageToAll(0x002DFFFF,"Ein Spieler ist dabei den Server zu betreten!");
    SendClientMessage(playerid,CLGREEN,"Herzlich Willkommen auf 4RL! Wir haben noch einen Parallelen Partnerserver!\n um die IP von dem Partner-Server herauszufinden nutze (( /Partner))!");
    return 1;
    }



    Und dann halt noch die Sachen die geladen werden

    Spoiler anzeigen
    public OnPasswordResponse(playerid)
    {
    new num_fields,num_rows;
    cache_get_data(num_rows,num_fields,dbhandle);
    if(num_rows==1)
    {
    //passwort richtig
    sInfo[playerid][eingeloggt] = 1;
    SendClientMessage(playerid,CLGREEN,"Du hast dich erfolgreich eingeloggt");
    sInfo[playerid][level] = cache_get_field_content_int(0,"level",dbhandle);
    SetPlayerScore(playerid,sInfo[playerid][level]);


    SetPlayerMoney(playerid,cache_get_field_content_int(0,"Money",dbhandle));

    sInfo[playerid][alevel] = cache_get_field_content_int(0,"alevel",dbhandle);
    sInfo[playerid][rang] = cache_get_field_content_int(0,"rang",dbhandle) ;
    sInfo[playerid][fraktion] = cache_get_field_content_int(0,"fraktion",dbhandle) ;
    sInfo[playerid][Payday] = cache_get_field_content_int(0,"Payday",dbhandle);
    sInfo[playerid][PaydayTime] = cache_get_field_content_int(0,"PaydayTime",dbhandle);
    sInfo[playerid][db_id] = cache_get_field_content_int(0,"id",dbhandle);
    sInfo[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",dbhandle);
    sInfo[playerid][rollerschein] = cache_get_field_content_int(0,"rollerschein",dbhandle);
    sInfo[playerid][autoschein] =cache_get_field_content_int(0,"autoschein",dbhandle);
    cache_get_field_content(0,"adname",sInfo[playerid][adname],dbhandle);
    printf("",sInfo[playerid][adname]);
    //auslesen aus der datenbank
    printf("Es wurden alle Daten geladen");
    loadPlayerCars(playerid);
    TextDrawHideForPlayer(playerid, Textdraw0);
    TextDrawHideForPlayer(playerid, Textdraw1);
    TextDrawHideForPlayer(playerid, Textdraw2);
    TextDrawHideForPlayer(playerid, Textdraw3);
    TextDrawHideForPlayer(playerid, Textdraw3_1);
    TextDrawHideForPlayer(playerid, Textdraw4);
    TextDrawHideForPlayer(playerid, Textdraw5);
    TextDrawHideForPlayer(playerid, Textdraw6);
    TextDrawHideForPlayer(playerid, Textdraw7);
    TextDrawHideForPlayer(playerid, Textdraw8);
    CancelSelectTextDraw(playerid);
    new query[128];
    mysql_escape_string(getPlayerName(playerid), getPlayerName(playerid));
    format(query, sizeof(query), "SELECT * FROM gebannt WHERE Name='%s'", getPlayerName(playerid));
    mysql_function_query(dbhandle, query, true, "BanCheck", "i", playerid);

    }
    else
    {
    //Passwort falsch
    SendClientMessage(playerid,RED,"Das eingegebene Passwort ist falsch!");
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gib bitte dein Passwort ein","Login","Abbruch");

    Spoiler anzeigen
    }
    return 1;
    }


    all diese sachen werden nicht aufgerufen

  • ja es ging vorher.
    ich habe verzweifelt versucht über das include foxBan das Timeban System einzubauen


    habe es auch bereits rausgenommen ohne erfolg (weils voll der müll ist)
    vlt kannst du dir ja die APP Teamviewer laden - ist auf jeden fall schonmal ne möglichkeit wie du schauen kannst und Skype gibst auch fürs IPAD :D