(28505 -- 28631) : fatal error 102: table overflow: "staging buffer"

(28505 -- 28631) : fatal error 102: table overflow: "staging buffer" - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: (28505 -- 28631) : fatal error 102: table overflow: "staging buffer" (/showthread.php?tid=458725)

(28505 -- 28631) : fatal error 102: table overflow: "staging buffer" - Marc_Johnson - 18.08.2013

PHP код:



public OnPlayerDataSave(playerid)

{

    if(IsPlayerConnected(playerid))

    {

        if(gPlayerLogged[playerid])

        {

             new query[300], pname[24];

            GetPlayerName(playerid, pname, 24);

            format(query, sizeof(query), "UPDATE playerinfo SET Password=%s, Level=%d, Interior=%d, VirWorld=%d, Admin=%d, Jetpack=%d, Scripter=%d, Helper=%d, PAntidolorifica=%d, PAntidroga=%d, PRigenerazione=%d, DonateRank=%d, Registerd=%d, Sex=%d, City=%d, InvWeapon=%d, InvAmmo='%s', Age=%d, Exp=%d, Cash=%d, Cents=%d, Bank=%d, Skin=%d, Droga=%d, Assicuraz=%d, UsoMaschera=%d, Orologio=%d, \

            Zaino=%d, Corde=%d, LottoNr=%d, Walkietalkie=%d, Benda=%d, TrafficoCell=%d, Sigarette=%d, RequestingBackup=%d, Accendino=%d, Maschera=%d, Dado=%d, Tomtom=%d, Calcolatrice=%d, Materiali=%d, Job=%d, PlayingHours=%d, AllowedPayday=%d, PayCheck=%d, Faction=%d, Clan=%d, HeadQuarter=%d, Rank=%d, HouseKey=%d, BizKey=%d, SpawnPoint=%d, Banned=%d, Warnings=%d, Arresti=%d, LicenzaA=%d, \

            Pcarkey=%d, Pcarkey2=%d, Pcarkey3=%d, Pcarkey4=%d, Pcarkey5=%d, Pcarkey6=%d, Pcarkey7=%d, Pcarkey8=%d, Pcarkey9=%d, Pcarkey10=%d, ChiavePrestata=%d, LicenzaB=%d, LicenzaC=%d, LicenzaD=%d, LicenzaVolo=%d, LicenzaNautica=%d, LicenzaArmi=%d, PhoneNumber=%d, PhoneC=%d, PagineGialle=%d, ListNumber=%d, Donatore=%d, Jailed=%d, JailTime=%d, Products=%d, CrashX=%f, CrashY=%f, CrashZ=%f, \

            CrashInt=%d, CrashW=%d, Crashed=%d, Casco=%d, Vip=%d, Occhiali=%d, Cappello=%d, Dinamite=%d, Bomba=%d, Punti=%d, Mp3=%d, Parcheggio=%d, Spacciatore=%d, MaterialiDroga=%d, Bloccato=%d, Vita=%d, Armour=%d, Laser=%d, Weapon1=%d, Weapon1a=%d, Weapon2=%d, Weapon2a=%d, Weapon3=%d, Weapon3a=%d, Weapon4=%d, Weapon4a=%d, Weapon5=%d, Weapon5a=%d, Weapon6=%d, Weapon6a=%d, Weapon7=%d, Weapon7a=%d, \

            Weapon8=%d, Weapon8a=%d, Weapon9=%d, Weapon9a=%d, Weapon10=%d, Weapon10a=%d, Weapon11=%d, Weapon11a=%d, Weapon12=%d, Weapon12a=%d, Garage=%d, Lavorato1=%d, Lavorato2=%d, Lavorato3=%d, Stilelotta=%d, FedinaPenale=%d, LivelloRicercato=%d  WHERE utente='%s'",

            PlayerInfo[playerid][pKey],

            PlayerInfo[playerid][pLevel],

            PlayerInfo[playerid][pInt],

            PlayerInfo[playerid][pVirWorld],

            PlayerInfo[playerid][pAdmin],

            PlayerInfo[playerid][pJetpack],

            PlayerInfo[playerid][pScripter],

            PlayerInfo[playerid][pHelper],

            PlayerInfo[playerid][pPAntidolorifica],

            PlayerInfo[playerid][pPAntidroga],

            PlayerInfo[playerid][pPRigenerazione],

            PlayerInfo[playerid][pDonateRank],

            PlayerInfo[playerid][pRegistered],

            PlayerInfo[playerid][pSex],

            PlayerInfo[playerid][pCity],

              PlayerInfo[playerid][pInvWeapon],

            PlayerInfo[playerid][pInvAmmo],

            PlayerInfo[playerid][pAge],

            PlayerInfo[playerid][pExp],

            PlayerInfo[playerid][pCash],

            PlayerInfo[playerid][pCents],

            PlayerInfo[playerid][pBank],

            PlayerInfo[playerid][pSkin],

            PlayerInfo[playerid][pDroga],

            PlayerInfo[playerid][pAssicuraz],

            PlayerInfo[playerid][pUsoMaschera],

            PlayerInfo[playerid][pOrologio],

            PlayerInfo[playerid][pZaino],

            PlayerInfo[playerid][pCorde],

            PlayerInfo[playerid][pLottoNr],

            PlayerInfo[playerid][pWalkietalkie],

            PlayerInfo[playerid][pBenda],

            PlayerInfo[playerid][pTrafficoCell],

            PlayerInfo[playerid][pSigarette],

            PlayerInfo[playerid][pRequestingBackup],

            PlayerInfo[playerid][pAccendino],

            PlayerInfo[playerid][pMaschera],

            PlayerInfo[playerid][pDado],

            PlayerInfo[playerid][pTomtom],

            PlayerInfo[playerid][pCalcolatrice],

            PlayerInfo[playerid][pMateriali],

            PlayerInfo[playerid][pJob],

            PlayerInfo[playerid][pPlayingHours],

            PlayerInfo[playerid][pAllowedPayday],

            PlayerInfo[playerid][pPayCheck],

            PlayerInfo[playerid][pFaction],

            PlayerInfo[playerid][pClan],

            PlayerInfo[playerid][pHeadQuarter],

            PlayerInfo[playerid][pRank],

            PlayerInfo[playerid][pHouseKey],

            PlayerInfo[playerid][pBizKey],

            PlayerInfo[playerid][pSpawnPoint],

            PlayerInfo[playerid][pBanned],

            PlayerInfo[playerid][pWarnings],

            PlayerInfo[playerid][pArresti],

            PlayerInfo[playerid][pLicenzaA],

            PlayerInfo[playerid][pPcarkey],

            PlayerInfo[playerid][pPcarkey2],

            PlayerInfo[playerid][pPcarkey3],

            PlayerInfo[playerid][pPcarkey4],

            PlayerInfo[playerid][pPcarkey5],

            PlayerInfo[playerid][pPcarkey6],

            PlayerInfo[playerid][pPcarkey7],

            PlayerInfo[playerid][pPcarkey8],

            PlayerInfo[playerid][pPcarkey9],

            PlayerInfo[playerid][pPcarkey10],

            PlayerInfo[playerid][ChiavePrestata],

            PlayerInfo[playerid][pLicenzaB],

            PlayerInfo[playerid][pLicenzaC],

            PlayerInfo[playerid][pLicenzaD],

            PlayerInfo[playerid][pLicenzaVolo],

            PlayerInfo[playerid][pLicenzaNautica],

            PlayerInfo[playerid][pLicenzaArmi],

            PlayerInfo[playerid][pPhoneNumber],

            PlayerInfo[playerid][pPhoneC],

            PlayerInfo[playerid][pPagineGialle],

            PlayerInfo[playerid][pListNumber],

            PlayerInfo[playerid][pDonatore],

            PlayerInfo[playerid][pJailed],

            PlayerInfo[playerid][pJailTime],

            PlayerInfo[playerid][pProducts],

            PlayerInfo[playerid][pCrashX],

            PlayerInfo[playerid][pCrashY],

            PlayerInfo[playerid][pCrashZ],

            PlayerInfo[playerid][pCrashInt],

            PlayerInfo[playerid][pCrashW],

            PlayerInfo[playerid][pCrashed],

            PlayerInfo[playerid][pCasco],

            PlayerInfo[playerid][pVip],

            PlayerInfo[playerid][pOcchiali],

            PlayerInfo[playerid][pCappello],

            PlayerInfo[playerid][pDinamite],

            PlayerInfo[playerid][pBomba],

            PlayerInfo[playerid][pPunti],

            PlayerInfo[playerid][pMp3],

            PlayerInfo[playerid][pParcheggio],

            PlayerInfo[playerid][pSpacciatore],

            PlayerInfo[playerid][pMaterialiDroga],

            PlayerInfo[playerid][pBloccato],

            PlayerInfo[playerid][pVita],

            PlayerInfo[playerid][pArmour],

            PlayerInfo[playerid][pLaser],

            PlayerInfo[playerid][pWeapon1],

            PlayerInfo[playerid][pWeapon1a],

            PlayerInfo[playerid][pWeapon2],

            PlayerInfo[playerid][pWeapon2a],

            PlayerInfo[playerid][pWeapon3],

            PlayerInfo[playerid][pWeapon3a],

            PlayerInfo[playerid][pWeapon4],

            PlayerInfo[playerid][pWeapon4a],

            PlayerInfo[playerid][pWeapon5],

            PlayerInfo[playerid][pWeapon5a],

            PlayerInfo[playerid][pWeapon6],

            PlayerInfo[playerid][pWeapon6a],

            PlayerInfo[playerid][pWeapon7],

            PlayerInfo[playerid][pWeapon7a],

            PlayerInfo[playerid][pWeapon8],

            PlayerInfo[playerid][pWeapon8a],

            PlayerInfo[playerid][pWeapon9],

            PlayerInfo[playerid][pWeapon9a],

            PlayerInfo[playerid][pWeapon10],

            PlayerInfo[playerid][pWeapon10a],

            PlayerInfo[playerid][pWeapon11],

            PlayerInfo[playerid][pWeapon11a],

            PlayerInfo[playerid][pWeapon12],

            PlayerInfo[playerid][pWeapon12a],

            PlayerInfo[playerid][pGarage],

            PlayerInfo[playerid][pLavorato1],

            PlayerInfo[playerid][pLavorato2],

            PlayerInfo[playerid][pLavorato3],

            PlayerInfo[playerid][pStilelotta],

            PlayerInfo[playerid][pFedinaPenale],

            PlayerInfo[playerid][pLivelloRicercato],

            pname);

            mysql_query(query);

        }


    }

    return 1;

}

Error:

PHP код:



(28505 -- 28631) : fatal error 102: table overflow: "staging buffer"

Re: (28505 -- 28631) : fatal error 102: table overflow: "staging buffer" - Ash. - 18.08.2013

I've never seen that error in my life, but my assumptions point me to the fact that format call is massive! Try shortening it and making it in to two format calls.

Re: (28505 -- 28631) : fatal error 102: table overflow: "staging buffer" - Marc_Johnson - 18.08.2013

Hmmm... okay

Re: (28505 -- 28631) : fatal error 102: table overflow: "staging buffer" - Misiur - 18.08.2013

Your query is _way_ over 300 cells (query format string only, without parameters is like 1.8k cells long), you not only achieved heap underflow, but some other error as well. Your table structure needs to be reorganized (search on this forum for related tables).

Re: (28505 -- 28631) : fatal error 102: table overflow: "staging buffer" - Vince - 18.08.2013

Read my tutorial on database normalization. If you need to add numbers to field names then you're doing it wrong.