Account wird nicht im MYSQL erstellt nachen Registrieren

RedDragon28080 · 12. Februar 2021

Hallo Liebes Breadfish Community

Nachen registrieren wird mein Account in die MYSQL nicht erstellt.

Da ich nicht so viel Ahnung von MYSQL habe und den Fehler nicht sehe bräuchte ich eure Hilfe.

Code

//Paddy
    if(dialogid == DIALOG_REG2)
    {
        if(response && strlen(inputtext) > 0)
        {
            
            new query[265], playername[MAX_PLAYER_NAME];
            GetPlayerName(playerid, playername, sizeof(playername));
            format(query, sizeof(query), "INSERT INTO `accounts` (name,passwort) VALUES ('%s','%s')", playername, MD5_Hash(inputtext));
            mysql_function_query(mysqlcon,query, false, "", "");
            gPlayerLogged[playerid] = 1;
            SaveMysqlPlayer(playerid);
            new name[MAX_PLAYER_NAME+1];
            GetPlayerName(playerid, name, sizeof(name));
            new ip[16];
               GetPlayerIp(playerid,ip,sizeof(ip));
              new tstring[320],cstring[320];
            format(tstring, sizeof(tstring), "SOM Reallife Login",(playerid));
            format(cstring,sizeof(cstring),"{FFFFFF}Willkommen auf {FF7700}SOM Reallife!\n\n{FF7700}_____________________________________\n\n{FF7700}-Dein Name: {FFFFFF}%s\n\n{FF7700}-Forum: {FFFFFF}google.de\n\n{FF7700}-IP: {FFFFFF}%s \n\n{FF7700}Account: {FFFFFF}Loge dich in dein Account ein\n\n{FF7700}_____________________________________",name, ip);
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, tstring, cstring, "Login", "Verlassen");
        }
        else
        {
            new name[MAX_PLAYER_NAME+1];
            GetPlayerName(playerid, name, sizeof(name));
               new tstring[320], cstring[320], ip[16];
               GetPlayerIp(playerid,ip,sizeof(ip));
            format(tstring, sizeof(tstring), "SOM Reallife Register");
            format(cstring,sizeof(cstring),"{FFFFFF}Willkommen auf {FF7700}SOM Reallife!\n\n{FF7700}_____________________________________\n\n{FF7700}-Dein Name: {FFFFFF}%s\n\n{FF7700}-Forum: {FFFFFF}google.de\n\n{FF7700}-IP: {FFFFFF}%s \n\n{FF7700}Account: {FFFFFF}Registriere deinen Account\n\n{FF7700}_____________________________________",name, ip);
            ShowPlayerDialog(playerid,DIALOG_REG2, DIALOG_STYLE_PASSWORD, tstring, cstring, "Register", "Verlassen");
        }
        if(response == 0)
        {
            KickEx(playerid);
        }
    }

Alles anzeigen

Code

public SaveMysqlPlayer(playerid)
{
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid)) //wir überprüfen ob der Spieler überhaupt noch Connected ist und ob er nicht ein NPC ist.
    {
        if(gPlayerLogged[playerid] == 1) //Und hier ob er noch eingeloggt ist.
        {
            new query[2048];
            SpielerInfo[playerid][pCash] = PlayerMoney[playerid];
            format(query, sizeof(query), "UPDATE `accounts` SET banned = '%d',admin = '%d',donater = '%d',upgradepoints = '%d',reg = '%d',sex = '%d',exp = '%d',level = '%d',hand = '%d',konto = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pGebannt],SpielerInfo[playerid][pAdmin],SpielerInfo[playerid][pDonateRank],SpielerInfo[playerid][gPupgrade],SpielerInfo[playerid][pReg],
                SpielerInfo[playerid][pSex],SpielerInfo[playerid][pExp],SpielerInfo[playerid][pAge],SpielerInfo[playerid][pCash],SpielerInfo[playerid][pAccount],SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET crimes = '%d',arrested = '%d',wanteddeaths = '%d',phonebook = '%d',lottonr = '%d',fishes = '%d',biggestfish = '%d',job = '%d',kills = '%d',deaths = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pCrimes],SpielerInfo[playerid][pArrested],SpielerInfo[playerid][pWantedDeaths],SpielerInfo[playerid][pPhoneBook],SpielerInfo[playerid][pLottoNr],
                SpielerInfo[playerid][pFishes],SpielerInfo[playerid][pBiggestFish],SpielerInfo[playerid][sJob],SpielerInfo[playerid][pKills],SpielerInfo[playerid][pDeaths], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET jobgehalt = '%d',headvalue = '%d',jailed = '%d',jailtime = '%d',mats = '%d',gras = '%d',lsd = '%d',kokain = '%d',helmid = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pJobGehalt],SpielerInfo[playerid][pHeadValue],SpielerInfo[playerid][pJailed],SpielerInfo[playerid][pJailTime],
                SpielerInfo[playerid][pMats],SpielerInfo[playerid][pGras],SpielerInfo[playerid][pLSD],SpielerInfo[playerid][pKokain],SpielerInfo[playerid][pHelmID], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET kmedizin = '%d',gmedizin = '%d',member = '%d',rank = '%d',charakter = '%d',contracttime = '%d',health = '%d',interior = '%d',local = '%d',team = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pKMedizin],SpielerInfo[playerid][pGMedizin],SpielerInfo[playerid][sMember],SpielerInfo[playerid][pRank],SpielerInfo[playerid][pChar],
                SpielerInfo[playerid][pContractTime],SpielerInfo[playerid][pHealth],SpielerInfo[playerid][pInt],SpielerInfo[playerid][pLocal],SpielerInfo[playerid][pTeam], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET pnumber = '%d',housekey = '%d',bizzkey = '%d',carlic = '%d',flylic = '%d',motolic = '%d',lkwlic = '%d',ALG = '%d',carinsurance = '%d',lifeinsurance = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pPnumber],SpielerInfo[playerid][pPhousekey],SpielerInfo[playerid][pPbiskey],SpielerInfo[playerid][pCarLic],SpielerInfo[playerid][pFlyLic],
                SpielerInfo[playerid][pMotoLic],SpielerInfo[playerid][pLKWLic],SpielerInfo[playerid][pARG],SpielerInfo[playerid][pCarInsurance],SpielerInfo[playerid][pLifeInsurance], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET boxmats = '%d',boxgras = '%d', boxlsd = '%d',boxkokain = '%d',boatlic = '%d',fishlic = '%d',gunlic = '%d',gun1 = '%d',gun2 = '%d',gun3 = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pBoxMats],SpielerInfo[playerid][pBoxGras],SpielerInfo[playerid][pBoxLSD],SpielerInfo[playerid][pBoxKokain],SpielerInfo[playerid][pBoatLic],
                SpielerInfo[playerid][pFishLic],SpielerInfo[playerid][pGunLic],SpielerInfo[playerid][pGun1],SpielerInfo[playerid][pGun2],SpielerInfo[playerid][pGun3], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET gun4 = '%d',gun5 = '%d',ammo1 = '%d',ammo2 = '%d',ammo3 = '%d',ammo4 = '%d',ammo5 = '%d',cartime = '%d',payday = '%d',paydayhad = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pGun4],SpielerInfo[playerid][pGun5],SpielerInfo[playerid][pAmmo1],SpielerInfo[playerid][pAmmo2],SpielerInfo[playerid][pAmmo3],
                SpielerInfo[playerid][pAmmo4],SpielerInfo[playerid][pAmmo5],SpielerInfo[playerid][pCarTime],SpielerInfo[playerid][pPayDay],SpielerInfo[playerid][pPayDayHad], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET cdplayer = '%d',wins = '%d',loses = '%d',alcoholperk = '%d',drugperk = '%d',miserperk = '%d',painperk = '%d',traderperk = '%d',detskill = '%d',sexskill = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pCDPlayer],SpielerInfo[playerid][pWins],SpielerInfo[playerid][pLoses],SpielerInfo[playerid][pAlcoholPerk],SpielerInfo[playerid][pDrugPerk],
                SpielerInfo[playerid][pMiserPerk],SpielerInfo[playerid][pPainPerk],SpielerInfo[playerid][pTraderPerk],SpielerInfo[playerid][pDetSkill],SpielerInfo[playerid][pSexSkill], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET boxskill = '%d',lawskill = '%d',mechskill = '%d',jackskill = '%d',carskill = '%d',newsskill = '%d',cockskill = '%d',fishskill = '%d',farmerskill = '%d',tut = '%d',warns = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pBoxSkill],SpielerInfo[playerid][pLawSkill],SpielerInfo[playerid][pMechSkill],SpielerInfo[playerid][pJackSkill],SpielerInfo[playerid][pCarSkill],SpielerInfo[playerid][pNewsSkill],
                SpielerInfo[playerid][pCookSkill],SpielerInfo[playerid][pFishSkill],SpielerInfo[playerid][pFarmerSkill],SpielerInfo[playerid][pTut],SpielerInfo[playerid][pWarns], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET fuel = '%d',married = '%d',marriedto = '%s',kampfstil = '%d',spawnchange = '%d',wanteds = '%d',sflic = '%d',lvlic = '%d',uhrid = '%d',ownperso = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pFuel],SpielerInfo[playerid][pMarried],SpielerInfo[playerid][pMarriedTo],SpielerInfo[playerid][pKampfstil],
                SpielerInfo[playerid][pSpawnChange],GetPlayerWantedLevel(playerid),SpielerInfo[playerid][pSFLic],SpielerInfo[playerid][pLVLic],SpielerInfo[playerid][pUhrID],SpielerInfo[playerid][pOwnPerso],SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET pinb = '%d',handyid = '%d',handyton = '%d',handyakku = '%d',zigid = '%d',zig = '%d',zigsucht = '%d',handygeld = '%d',handyver = '%d',GWD = '%.3f',playminutes = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pPinB],SpielerInfo[playerid][pHandyID],SpielerInfo[playerid][pHandyTon],SpielerInfo[playerid][pHandyAkku],SpielerInfo[playerid][pZigID],SpielerInfo[playerid][pZig],
                SpielerInfo[playerid][pZigSucht],SpielerInfo[playerid][pHandyGeld],SpielerInfo[playerid][pHandyVer],SpielerInfo[playerid][pGWD],SpielerInfo[playerid][pPlayMinutes], SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");

            format(query, sizeof(query), "UPDATE `accounts` SET gesamtminutes = '%d',pfandflaschen = '%d',coins = '%d', lastonline = '%d', frakinvited = '%d', online = '%d', Fraksperre = '%d', Sprache = '%d' WHERE `name` = '%s'",
                SpielerInfo[playerid][pGesamtMinutes],SpielerInfo[playerid][sPfandflaschen],SpielerInfo[playerid][pCoins],SpielerInfo[playerid][pLastOnline],SpielerInfo[playerid][pFrakInvited],SpielerInfo[playerid][pOnline],SpielerInfo[playerid][pFrakSperre],SpielerInfo[playerid][Name]);
            mysql_function_query(mysqlcon,query, false, "", "");
        /*    for(new i=0;i<5;i++){
                format(query,sizeof(query),"UPDATE `PhoneContact` SET `phName%d`= '%s', `phNumber%d` = '%d' WHERE `name` = '%s'",i,PhoneInfo[playerid][i][phName],i,PhoneInfo[playerid][i][phNumber],SpielerInfo[playerid][Name]);
                mysql_function_query(mysqlcon,query, false, "", "");
            }*/
            return 1;
        }
    }
    return 1;
}

Alles anzeigen

Code

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL,
  `name` varchar(28) DEFAULT NULL,
  `banned` tinyint(1) DEFAULT NULL,
  `passwort` varchar(100) DEFAULT NULL,
  `admin` int(4) DEFAULT NULL,
  `donater` int(12) DEFAULT NULL,
  `upgradepoints` int(4) DEFAULT NULL,
  `reg` tinyint(1) DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `exp` int(2) DEFAULT NULL,
  `level` int(3) NOT NULL,
  `hand` int(11) DEFAULT NULL,
  `konto` int(11) DEFAULT NULL,
  `crimes` int(4) DEFAULT NULL,
  `arrested` int(11) DEFAULT NULL,
  `wanteddeaths` int(11) DEFAULT NULL,
  `phonebook` int(11) DEFAULT NULL,
  `lottonr` int(11) DEFAULT NULL,
  `fishes` int(11) DEFAULT NULL,
  `biggestfish` int(11) DEFAULT NULL,
  `job` int(11) DEFAULT NULL,
  `kills` int(3) NOT NULL,
  `deaths` int(3) NOT NULL,
  `paycheck` int(11) DEFAULT NULL,
  `jobgehalt` int(11) DEFAULT NULL,
  `headvalue` int(11) DEFAULT NULL,
  `jailed` int(11) DEFAULT NULL,
  `jailtime` int(11) DEFAULT NULL,
  `mats` int(11) DEFAULT NULL,
  `gras` int(11) DEFAULT NULL,
  `lsd` int(11) NOT NULL,
  `kokain` int(11) NOT NULL,
  `helmid` int(6) NOT NULL,
  `kmedizin` int(4) NOT NULL,
  `gmedizin` int(4) NOT NULL,
  `member` int(11) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  `charakter` int(11) DEFAULT NULL,
  `contracttime` int(1) DEFAULT NULL,
  `interior` int(40) DEFAULT NULL,
  `local` int(11) DEFAULT NULL,
  `team` int(11) DEFAULT NULL,
  `pnumber` int(11) DEFAULT NULL,
  `housekey` int(11) DEFAULT NULL,
  `bizzkey` int(11) DEFAULT NULL,
  `gesamtminutes` int(11) DEFAULT NULL,
  `playminutes` int(11) DEFAULT NULL,
  `carlic` int(11) DEFAULT NULL,
  `flylic` int(11) DEFAULT NULL,
  `lkwlic` int(11) DEFAULT NULL,
  `motolic` int(11) DEFAULT NULL,
  `ALG` int(11) DEFAULT NULL,
  `carinsurance` int(11) DEFAULT NULL,
  `lifeinsurance` int(11) DEFAULT NULL,
  `boxmats` int(11) DEFAULT NULL,
  `boxgras` int(11) DEFAULT NULL,
  `boxlsd` int(6) NOT NULL,
  `boxkokain` int(6) NOT NULL,
  `boatlic` int(11) DEFAULT NULL,
  `gunlic` int(11) DEFAULT NULL,
  `fishlic` int(11) DEFAULT NULL,
  `gun1` int(11) DEFAULT NULL,
  `gun2` int(11) DEFAULT NULL,
  `gun3` int(11) DEFAULT NULL,
  `gun4` int(11) DEFAULT NULL,
  `gun5` int(11) DEFAULT NULL,
  `gun6` int(3) NOT NULL,
  `ammo1` int(11) DEFAULT NULL,
  `ammo2` int(11) DEFAULT NULL,
  `ammo3` int(11) DEFAULT NULL,
  `ammo4` int(11) DEFAULT NULL,
  `ammo5` int(11) DEFAULT NULL,
  `ammo6` int(6) NOT NULL,
  `cartime` int(11) DEFAULT NULL,
  `payday` int(11) DEFAULT NULL,
  `paydayhad` int(11) DEFAULT NULL,
  `cdplayer` int(11) DEFAULT NULL,
  `wins` int(11) DEFAULT NULL,
  `loses` int(11) DEFAULT NULL,
  `alcoholperk` int(11) DEFAULT NULL,
  `drugperk` int(11) DEFAULT NULL,
  `painperk` int(11) DEFAULT NULL,
  `miserperk` int(11) DEFAULT NULL,
  `traderperk` int(11) DEFAULT NULL,
  `detskill` int(6) NOT NULL DEFAULT 0,
  `sexskill` int(6) NOT NULL DEFAULT 0,
  `boxskill` int(6) NOT NULL DEFAULT 0,
  `lawskill` int(6) NOT NULL DEFAULT 0,
  `mechskill` int(6) NOT NULL DEFAULT 0,
  `jackskill` int(6) NOT NULL DEFAULT 0,
  `carskill` int(6) NOT NULL DEFAULT 0,
  `newsskill` int(6) NOT NULL DEFAULT 0,
  `drugsskill` int(6) NOT NULL DEFAULT 0,
  `cockskill` int(6) NOT NULL DEFAULT 0,
  `fishskill` int(6) NOT NULL DEFAULT 0,
  `farmerskill` int(6) NOT NULL DEFAULT 0,
  `tut` int(11) DEFAULT NULL,
  `warns` int(11) DEFAULT NULL,
  `online` int(11) DEFAULT NULL,
  `fuel` int(11) DEFAULT NULL,
  `gwd` float(2,2) DEFAULT NULL,
  `married` int(11) DEFAULT NULL,
  `marriedto` varchar(28) DEFAULT NULL,
  `kampfstil` int(11) DEFAULT NULL,
  `spawnchange` int(11) DEFAULT NULL,
  `wanteds` int(11) DEFAULT NULL,
  `sflic` int(11) DEFAULT NULL,
  `lvlic` int(11) DEFAULT NULL,
  `uhrid` int(11) DEFAULT NULL,
  `ownperso` int(11) DEFAULT NULL,
  `pinb` int(11) DEFAULT NULL,
  `handyid` int(11) DEFAULT NULL,
  `handyakku` int(11) DEFAULT NULL,
  `handyton` int(11) DEFAULT NULL,
  `handyver` int(11) DEFAULT NULL,
  `zigid` int(11) DEFAULT NULL,
  `zig` int(11) DEFAULT NULL,
  `zigsucht` int(11) DEFAULT NULL,
  `handygeld` int(11) DEFAULT NULL,
  `pfandflaschen` int(11) DEFAULT NULL,
  `eingeloggt` int(1) NOT NULL,
  `lastonline` varchar(28) NOT NULL,
  `frakinvited` varchar(28) CHARACTER SET utf8 NOT NULL,
  `coins` int(3) NOT NULL,
  `tottime` int(2) NOT NULL,
  `tban` varchar(12) CHARACTER SET utf8 NOT NULL,
  `geworbenvon` varchar(28) CHARACTER SET utf8 NOT NULL,
  `health` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT 'health',
  `DoneTicket` int(11) NOT NULL DEFAULT 0,
  `Mapper` int(2) NOT NULL DEFAULT 0,
  `email` text NOT NULL,
  `Fraksperre` int(11) NOT NULL DEFAULT 0,
  `Sprache` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Alles anzeigen

MFG

Whice · 12. Februar 2021

Die Insert Query sieht auf den ersten Blick richtig aus, ich kann dir aber trotzdem empfehlen immer zu escapen (INSERT INTO `accounts` (`name`, `passwort`) VALUES ('%s', '%s'))

Was sagt denn die mysql Log?

Kann es sein das es daran liegt, das manche Sachen auf NOT NULL eingetragen sind und du sie in deiner Query nicht angebist? (Bsp: email, frakinvited)

RedDragon28080 · 12. Februar 2021

so habe es getestet und wird immer noch nicht erstellt.

hier die mysql.log.

Code

[15:18:41] >> mysql_query_callback( Connection handle: 1 )
[15:18:41] >> mysql_query_callback( Connection handle: 1 )
[15:18:41] >> mysql_query_callback( Connection handle: 1 )
[15:18:41] >> mysql_query_callback( Connection handle: 1 )
[15:18:41] Passing query SELECT * FROM `carsystem` WHERE `CarOwner`='LadyKiller0608_0' | sii
[15:18:41] ProcessQueryThread(LoadMysqlCars) - Query was successful. (SELECT * FROM `carsystem` WHERE `CarOwner`='LadyKiller0608_0')
[15:18:41] ProcessQueryThread(LoadMysqlCars) - Data caching enabled.
[15:18:41] CMySQLHandler::StoreResult() - Result was stored.
[15:18:41] CMySQLHandler::FreeResult() - Result was successfully free'd.
[15:18:41] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:41] LoadMysqlCars(sii) - Threaded function called.
[15:18:41] >> cache_get_data( Connection handle: 1 )
[15:18:41] ProcessTick() - The cache has been cleared.
[15:18:41] Passing query SELECT * FROM `carsystem` WHERE `CarOwner`='LadyKiller0608_1' | sii
[15:18:41] ProcessQueryThread(LoadMysqlCars) - Query was successful. (SELECT * FROM `carsystem` WHERE `CarOwner`='LadyKiller0608_1')
[15:18:41] ProcessQueryThread(LoadMysqlCars) - Data caching enabled.
[15:18:41] CMySQLHandler::StoreResult() - Result was stored.
[15:18:41] CMySQLHandler::FreeResult() - Result was successfully free'd.
[15:18:41] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:41] LoadMysqlCars(sii) - Threaded function called.
[15:18:41] >> cache_get_data( Connection handle: 1 )
[15:18:41] ProcessTick() - The cache has been cleared.
[15:18:41] Passing query SELECT * FROM `carsystem` WHERE `CarOwner`='LadyKiller0608_2' | sii
[15:18:41] ProcessQueryThread(LoadMysqlCars) - Query was successful. (SELECT * FROM `carsystem` WHERE `CarOwner`='LadyKiller0608_2')
[15:18:41] ProcessQueryThread(LoadMysqlCars) - Data caching enabled.
[15:18:41] CMySQLHandler::StoreResult() - Result was stored.
[15:18:41] CMySQLHandler::FreeResult() - Result was successfully free'd.
[15:18:41] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:41] LoadMysqlCars(sii) - Threaded function called.
[15:18:41] >> cache_get_data( Connection handle: 1 )
[15:18:41] ProcessTick() - The cache has been cleared.
[15:18:41] Passing query SELECT `id` FROM `accounts` WHERE `name`='LadyKiller0608' | si
[15:18:41] ProcessQueryThread(CheckAcc) - Query was successful. (SELECT `id` FROM `accounts` WHERE `name`='LadyKiller0608')
[15:18:41] ProcessQueryThread(CheckAcc) - Data caching enabled.
[15:18:41] CMySQLHandler::StoreResult() - Result was stored.
[15:18:41] CMySQLHandler::FreeResult() - Result was successfully free'd.
[15:18:41] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:41] CheckAcc(si) - Threaded function called.
[15:18:41] >> cache_get_data( Connection handle: 1 )
[15:18:41] ProcessTick() - The cache has been cleared.
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] >> mysql_query_callback( Connection handle: 1 )
[15:18:59] Passing query INSERT INTO `accounts`(`name`,`passwort`) VALUES ('LadyKiller0608','8C0E59B2786AF6F9AF23CFD960C9FF74') | 
[15:18:59] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[15:18:59] OnQueryError() - Called.
[15:18:59] Passing query UPDATE `accounts` SET banned = '0',admin = '0',donater = '0',upgradepoints = '0',reg = '0',sex = '0',exp = '0',level = '0',hand = '0',konto = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET banned = '0',admin = '0',donater = '0',upgradepoints = '0',reg = '0',sex = '0',exp = '0',level = '0',hand = '0',konto = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET crimes = '0',arrested = '0',wanteddeaths = '0',phonebook = '0',lottonr = '0',fishes = '0',biggestfish = '0',job = '0',kills = '0',deaths = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET crimes = '0',arrested = '0',wanteddeaths = '0',phonebook = '0',lottonr = '0',fishes = '0',biggestfish = '0',job = '0',kills = '0',deaths = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET jobgehalt = '0',headvalue = '0',jailed = '0',jailtime = '0',mats = '0',gras = '0',lsd = '0',kokain = '0',helmid = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET jobgehalt = '0',headvalue = '0',jailed = '0',jailtime = '0',mats = '0',gras = '0',lsd = '0',kokain = '0',helmid = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET kmedizin = '0',gmedizin = '0',member = '0',rank = '0',charakter = '0',contracttime = '0',health = '0',interior = '15',local = '999',team = '3' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET kmedizin = '0',gmedizin = '0',member = '0',rank = '0',charakter = '0',contracttime = '0',health = '0',interior = '15',local = '999',team = '3' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET pnumber = '591779',housekey = '999',bizzkey = '999',carlic = '0',flylic = '0',motolic = '0',lkwlic = '0',ALG = '0',carinsurance = '0',lifeinsurance = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET pnumber = '591779',housekey = '999',bizzkey = '999',carlic = '0',flylic = '0',motolic = '0',lkwlic = '0',ALG = '0',carinsurance = '0',lifeinsurance = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET boxmats = '0',boxgras = '0', boxlsd = '0',boxkokain = '0',boatlic = '0',fishlic = '0',gunlic = '0',gun1 = '0',gun2 = '0',gun3 = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET boxmats = '0',boxgras = '0', boxlsd = '0',boxkokain = '0',boatlic = '0',fishlic = '0',gunlic = '0',gun1 = '0',gun2 = '0',gun3 = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET gun4 = '0',gun5 = '0',ammo1 = '0',ammo2 = '0',ammo3 = '0',ammo4 = '0',ammo5 = '0',cartime = '0',payday = '0',paydayhad = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET gun4 = '0',gun5 = '0',ammo1 = '0',ammo2 = '0',ammo3 = '0',ammo4 = '0',ammo5 = '0',cartime = '0',payday = '0',paydayhad = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET cdplayer = '0',wins = '0',loses = '0',alcoholperk = '0',drugperk = '0',miserperk = '0',painperk = '0',traderperk = '0',detskill = '0',sexskill = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET cdplayer = '0',wins = '0',loses = '0',alcoholperk = '0',drugperk = '0',miserperk = '0',painperk = '0',traderperk = '0',detskill = '0',sexskill = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET boxskill = '0',lawskill = '0',mechskill = '0',jackskill = '0',carskill = '0',newsskill = '0',cockskill = '0',fishskill = '0',farmerskill = '0',tut = '0',warns = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET boxskill = '0',lawskill = '0',mechskill = '0',jackskill = '0',carskill = '0',newsskill = '0',cockskill = '0',fishskill = '0',farmerskill = '0',tut = '0',warns = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET fuel = '0',married = '0',marriedto = 'Niemand',kampfstil = '0',spawnchange = '0',wanteds = '0',sflic = '0',lvlic = '0',uhrid = '0',ownperso = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET fuel = '0',married = '0',marriedto = 'Niemand',kampfstil = '0',spawnchange = '0',wanteds = '0',sflic = '0',lvlic = '0',uhrid = '0',ownperso = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET pinb = '0',handyid = '0',handyton = '0',handyakku = '0',zigid = '0',zig = '0',zigsucht = '0',handygeld = '0',handyver = '0',GWD = '0.000',playminutes = '0' WHERE `name` = 'LadyKiller0608' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET pinb = '0',handyid = '0',handyton = '0',handyakku = '0',zigid = '0',zig = '0',zigsucht = '0',handygeld = '0',handyver = '0',GWD = '0.000',playminutes = '0' WHERE `name` = 'LadyKiller0608')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:18:59] Passing query UPDATE `accounts` SET gesamtminutes = '0',pfandflaschen = '0',coins = '0', lastonline = '0', frakinvited = '0', online = '0', Fraksperre = '0', Sprache = '76' WHERE `name` = '' | 
[15:18:59] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET gesamtminutes = '0',pfandflaschen = '0',coins = '0', lastonline = '0', frakinvited = '0', online = '0', Fraksperre = '0', Sprache = '76' WHERE `name` = '')
[15:18:59] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:18:59] () - Threaded function called.
[15:19:04] >> mysql_query_callback( Connection handle: 1 )
[15:19:04] Passing query SELECT * FROM `accounts` WHERE `name` ='LadyKiller0608' AND `passwort`='8C0E59B2786AF6F9AF23CFD960C9FF74' LIMIT 0,1 | i
[15:19:04] ProcessQueryThread(LoadPlayer) - Query was successful. (SELECT * FROM `accounts` WHERE `name` ='LadyKiller0608' AND `passwort`='8C0E59B2786AF6F9AF23CFD960C9FF74' LIMIT 0,1)
[15:19:04] ProcessQueryThread(LoadPlayer) - Data caching enabled.
[15:19:04] CMySQLHandler::StoreResult() - Result was stored.
[15:19:04] CMySQLHandler::FreeResult() - Result was successfully free'd.
[15:19:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:04] LoadPlayer(i) - Threaded function called.
[15:19:04] >> cache_get_data( Connection handle: 1 )
[15:19:04] ProcessTick() - The cache has been cleared.
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] >> mysql_query_callback( Connection handle: 1 )
[15:19:11] Passing query UPDATE `accounts` SET banned = '0',admin = '0',donater = '0',upgradepoints = '0',reg = '0',sex = '0',exp = '0',level = '0',hand = '0',konto = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET banned = '0',admin = '0',donater = '0',upgradepoints = '0',reg = '0',sex = '0',exp = '0',level = '0',hand = '0',konto = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET crimes = '0',arrested = '0',wanteddeaths = '0',phonebook = '0',lottonr = '0',fishes = '0',biggestfish = '0',job = '0',kills = '0',deaths = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET crimes = '0',arrested = '0',wanteddeaths = '0',phonebook = '0',lottonr = '0',fishes = '0',biggestfish = '0',job = '0',kills = '0',deaths = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET jobgehalt = '0',headvalue = '0',jailed = '0',jailtime = '0',mats = '0',gras = '0',lsd = '0',kokain = '0',helmid = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET jobgehalt = '0',headvalue = '0',jailed = '0',jailtime = '0',mats = '0',gras = '0',lsd = '0',kokain = '0',helmid = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET kmedizin = '0',gmedizin = '0',member = '0',rank = '0',charakter = '0',contracttime = '0',health = '0',interior = '15',local = '999',team = '3' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET kmedizin = '0',gmedizin = '0',member = '0',rank = '0',charakter = '0',contracttime = '0',health = '0',interior = '15',local = '999',team = '3' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET pnumber = '591779',housekey = '999',bizzkey = '999',carlic = '0',flylic = '0',motolic = '0',lkwlic = '0',ALG = '0',carinsurance = '0',lifeinsurance = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET pnumber = '591779',housekey = '999',bizzkey = '999',carlic = '0',flylic = '0',motolic = '0',lkwlic = '0',ALG = '0',carinsurance = '0',lifeinsurance = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET boxmats = '0',boxgras = '0', boxlsd = '0',boxkokain = '0',boatlic = '0',fishlic = '0',gunlic = '0',gun1 = '0',gun2 = '0',gun3 = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET boxmats = '0',boxgras = '0', boxlsd = '0',boxkokain = '0',boatlic = '0',fishlic = '0',gunlic = '0',gun1 = '0',gun2 = '0',gun3 = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET gun4 = '0',gun5 = '0',ammo1 = '0',ammo2 = '0',ammo3 = '0',ammo4 = '0',ammo5 = '0',cartime = '0',payday = '0',paydayhad = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET gun4 = '0',gun5 = '0',ammo1 = '0',ammo2 = '0',ammo3 = '0',ammo4 = '0',ammo5 = '0',cartime = '0',payday = '0',paydayhad = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET cdplayer = '0',wins = '0',loses = '0',alcoholperk = '0',drugperk = '0',miserperk = '0',painperk = '0',traderperk = '0',detskill = '0',sexskill = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET cdplayer = '0',wins = '0',loses = '0',alcoholperk = '0',drugperk = '0',miserperk = '0',painperk = '0',traderperk = '0',detskill = '0',sexskill = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET boxskill = '0',lawskill = '0',mechskill = '0',jackskill = '0',carskill = '0',newsskill = '0',cockskill = '0',fishskill = '0',farmerskill = '0',tut = '0',warns = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET boxskill = '0',lawskill = '0',mechskill = '0',jackskill = '0',carskill = '0',newsskill = '0',cockskill = '0',fishskill = '0',farmerskill = '0',tut = '0',warns = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET fuel = '0',married = '0',marriedto = 'Niemand',kampfstil = '0',spawnchange = '0',wanteds = '0',sflic = '0',lvlic = '0',uhrid = '0',ownperso = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET fuel = '0',married = '0',marriedto = 'Niemand',kampfstil = '0',spawnchange = '0',wanteds = '0',sflic = '0',lvlic = '0',uhrid = '0',ownperso = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET pinb = '0',handyid = '0',handyton = '0',handyakku = '0',zigid = '0',zig = '0',zigsucht = '0',handygeld = '0',handyver = '0',GWD = '0.000',playminutes = '0' WHERE `name` = 'LadyKiller0608' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET pinb = '0',handyid = '0',handyton = '0',handyakku = '0',zigid = '0',zig = '0',zigsucht = '0',handygeld = '0',handyver = '0',GWD = '0.000',playminutes = '0' WHERE `name` = 'LadyKiller0608')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.
[15:19:11] Passing query UPDATE `accounts` SET gesamtminutes = '0',pfandflaschen = '0',coins = '0', lastonline = '0', frakinvited = '0', online = '0', Fraksperre = '0', Sprache = '76' WHERE `name` = '' | 
[15:19:11] ProcessQueryThread() - Query was successful. (UPDATE `accounts` SET gesamtminutes = '0',pfandflaschen = '0',coins = '0', lastonline = '0', frakinvited = '0', online = '0', Fraksperre = '0', Sprache = '76' WHERE `name` = '')
[15:19:11] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:19:11] () - Threaded function called.

Alles anzeigen

**Kasakow** · 12. Februar 2021

Würde bei Gelegenheit mal die Version updaten, R5 ist das glaube ich, ziemlich veraltet.

RedDragon28080 · 12. Februar 2021

Zitat von Kasakow

Würde bei Gelegenheit mal die Version updaten, R5 ist das glaube ich, ziemlich veraltet.

Habe versucht das abzudaten und jetzt kann der Server nicht mit MYSQL verbinden.

MYSQL.log ist leer

Code

[16:17:28] [debug] Run time error 19: "File or function is not found"
[16:17:28] [debug]  mysql_function_query
[16:17:28] [debug]  cache_get_data
[16:17:28] [debug]  cache_get_field_content
[16:17:28] [debug]  mysql_free_result
[16:17:28] [debug]  mysql_debug
[16:17:28] [debug]  mysql_ping
[16:17:28] [debug]  mysql_store_result
[16:17:28] [debug]  mysql_retrieve_row
[16:17:28] [debug]  mysql_num_rows
[16:17:28] [debug] Run time error 19: "File or function is not found"
[16:17:28] [debug]  mysql_function_query
[16:17:28] [debug]  cache_get_data
[16:17:28] [debug]  cache_get_field_content
[16:17:28] [debug]  mysql_free_result
[16:17:28] [debug]  mysql_debug
[16:17:28] [debug]  mysql_ping
[16:17:28] [debug]  mysql_store_result
[16:17:28] [debug]  mysql_retrieve_row
[16:17:28] [debug]  mysql_num_rows
[16:17:28] Script[gamemodes/SOM.amx]: Run time error 19: "File or function is not found"

Alles anzeigen

Maho · 12. Februar 2021

Du verwendest die falsche mysql version, versuch es mal mit der mysql_static.so

RedDragon28080 · 12. Februar 2021

Zitat von iTsMyHoe

Du verwendest die falsche mysql version, versuch es mal mit der mysql_static.so

hallo ich habe den mysql_static.so genommen und habe diese errors bekommen

und im mysql log steht nichts drine ist leer

Code

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[19:23:38] filterscripts = ""  (string)
[19:23:38] 
[19:23:38] Server Plugins
[19:23:38] --------------
[19:23:38]  Loading plugin: crashdetect.so
[19:23:38]   crashdetect v4.8.4 is OK.
[19:23:38]   Loaded.
[19:23:38]  Loading plugin: mysql_static.so
[19:23:38]  SA:MP MySQL Plugin v2.1.1 Loaded.
[19:23:38]   Loaded.
[19:23:38] [MySQL] Thread running. Threadsafe: Yes.
[19:23:38]  Loading plugin: sscanf.so
[19:23:38] 

[19:23:38]  ===============================

[19:23:38]       sscanf plugin loaded.     

[19:23:38]    (c) 2009 Alex "Y_Less" Cole

[19:23:38]  ===============================

[19:23:38]   Loaded.
[19:23:38]  Loading plugin: streamer.so
[19:23:38] 

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[19:23:38]   Loaded.
[19:23:38]  Loaded 4 plugins.

[19:23:38] 
[19:23:38] Filterscripts
[19:23:38] ---------------
[19:23:38]   Loaded 0 filterscripts.

[19:23:38] [debug] Run time error 19: "File or function is not found"
[19:23:38] [debug]  mysql_format
[19:23:38] [debug]  mysql_pquery
[19:23:38] [debug]  cache_get_row_count
[19:23:38] [debug]  cache_get_field_count
[19:23:38] [debug]  cache_get_value_name
[19:23:38] [debug]  cache_get_field_name
[19:23:38] [debug]  mysql_log
[19:23:38] Script[gamemodes/SOM.amx]: Run time error 19: "File or function is not found"
[19:23:38] Number of vehicle models: 0

Alles anzeigen

Maho · 12. Februar 2021

Nimm mal die Orginale mysql.so von SOM

Jeffry · 12. Februar 2021

Schaue unter /pawno/include/a_mysql.inc welche Version dort im Kommentar (ganz oben) genannt wird (R-xx).

RedDragon28080 · 12. Februar 2021

Zitat von iTsMyHoe

Nimm mal die Orginale mysql.so von SOM

Habe ich gemacht Server startet nun das wahr ja nicht mein Problem mein problem ist wenn ich auf registrieren klicke erstellt er mein account daten nicht im mysql das ist mein problem

mysql_log habe ich angepinnt da es zu groß ist

Zitat von Jeffry

Schaue unter /pawno/include/a_mysql.inc welche Version dort im Kommentar (ganz oben) genannt wird (R-xx).

Jeffry ist MySQL plugin R7

Jeffry · 12. Februar 2021

Zitat von RedDragon28080

Jeffry ist MySQL plugin R7

Und du lädst die 2.1.1 (siehe Server Log).

Die R7 findest du hier: Fehler mit libmysqlclient_r.so.16

RedDragon28080 · 12. Februar 2021

Zitat von Jeffry

Und du lädst die 2.1.1 (siehe Server Log).

Die R7 findest du hier: Fehler mit libmysqlclient_r.so.16

so habe jetzt errors im server log

im mysql.log steht nichts

Code

Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[20:29:47] filterscripts = ""  (string)
[20:29:47] 
[20:29:47] Server Plugins
[20:29:47] --------------
[20:29:47]  Loading plugin: crashdetect.so
[20:29:47]   crashdetect v4.8.4 is OK.
[20:29:47]   Loaded.
[20:29:47]  Loading plugin: mysql.so
[20:29:47]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[20:29:47]  Loading plugin: sscanf.so
[20:29:47] 

[20:29:47]  ===============================

[20:29:47]       sscanf plugin loaded.     

[20:29:47]    (c) 2009 Alex "Y_Less" Cole

[20:29:47]  ===============================

[20:29:47]   Loaded.
[20:29:47]  Loading plugin: streamer.so
[20:29:47] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[20:29:47]   Loaded.
[20:29:47]  Loaded 3 plugins.

[20:29:47] 
[20:29:47] Filterscripts
[20:29:47] ---------------
[20:29:47]   Loaded 0 filterscripts.

[20:29:47] [debug] Run time error 19: "File or function is not found"
[20:29:47] [debug]  mysql_function_query
[20:29:47] [debug]  cache_get_data
[20:29:47] [debug]  cache_get_field_content
[20:29:47] [debug]  mysql_free_result
[20:29:47] [debug]  mysql_debug
[20:29:47] [debug]  mysql_connect
[20:29:47] [debug]  mysql_ping
[20:29:47] [debug]  mysql_store_result
[20:29:47] [debug]  mysql_retrieve_row
[20:29:47] [debug]  mysql_num_rows
[20:29:47] Script[gamemodes/SOM.amx]: Run time error 19: "File or function is not found"
[20:29:47] Number of vehicle models: 0

Alles anzeigen

Jeffry · 12. Februar 2021

Zitat von RedDragon28080

Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

Dieser Fehler ist im Rest vom oben genannten Thread exakt beschrieben, und was zu tun ist.

Eigentlich wäre die mysql_static.so (R7) hier am besten, die habe ich aber leider nicht.

Zudem ist zu sagen, die R7 ist ohnehin so veraltet, die sollte nicht mehr verwendet werden.

RedDragon28080 · 12. Februar 2021

Zitat von Jeffry

Dieser Fehler ist im Rest vom oben genannten Thread exakt beschrieben, und was zu tun ist.

Eigentlich wäre die mysql_static.so (R7) hier am besten, die habe ich aber leider nicht.

Zudem ist zu sagen, die R7 ist ohnehin so veraltet, die sollte nicht mehr verwendet werden.

dann müsste ich alles umschreiben oder wie updaten ich die Version ?

Jeffry · 12. Februar 2021

Korrekt.

RedDragon28080 · 12. Februar 2021

Zitat von Jeffry

Dieser Fehler ist im Rest vom oben genannten Thread exakt beschrieben, und was zu tun ist.

Eigentlich wäre die mysql_static.so (R7) hier am besten, die habe ich aber leider nicht.

Zudem ist zu sagen, die R7 ist ohnehin so veraltet, die sollte nicht mehr verwendet werden.

ist die neuste version "R41-4"?

Jeffry · 12. Februar 2021

Ja.

[jTuT] MySQL R41-4 (Installation, XAMPP, Verwendung, Bedienung & Registrations-System)

RedDragon28080 · 12. Februar 2021

habe von das Script SOM Reallife Server eine neuste version gefunden und habe die R41-4 eingefügt und Compilet ging ohne errors jetzt habe ich das plugin auch eingefügt und server neu gestartet und der hängt bei "[21:48:28] [MySQL] Verbindungsaufbau..." fest und geht nicht weiter

Code

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[22:31:22] filterscripts = ""  (string)
[22:31:22] 
[22:31:22] Server Plugins
[22:31:22] --------------
[22:31:22]  Loading plugin: crashdetect.so
[22:31:22]   Failed (plugins/crashdetect.so: cannot open shared object file: No such file or directory)
[22:31:22]  Loading plugin: mysql.so
[22:31:22]  >> plugin.mysql: R41-4 successfully loaded.
[22:31:22]   Loaded.
[22:31:22]  Loading plugin: sscanf.so
[22:31:22] 

[22:31:22]  ===============================

[22:31:22]       sscanf plugin loaded.     

[22:31:22]    (c) 2009 Alex "Y_Less" Cole

[22:31:22]  ===============================

[22:31:22]   Loaded.
[22:31:22]  Loading plugin: streamer.so
[22:31:22] 

*** Streamer Plugin v2.8.2 by Incognito loaded ***

[22:31:22]   Loaded.
[22:31:22]  Loaded 3 plugins.

[22:31:22] 
[22:31:22] Filterscripts
[22:31:22] ---------------
[22:31:22]   Loaded 0 filterscripts.

[22:31:22] [MySQL] Verbindungsaufbau...

Alles anzeigen

Hat jemand Vieleicht ein Mysql_Static.so auf R41-4?

Account wird nicht im MYSQL erstellt nachen Registrieren

Beitrag von RedDragon28080 (12. Februar 2021)

Beitrag von RedDragon28080 (12. Februar 2021)