fatal error 102: table overflow: "staging buffer"

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: fatal error 102: table overflow: "staging buffer" (/showthread.php?tid=419161)

fatal error 102: table overflow: "staging buffer" - PaulDinam - 27.02.2013

rp.pwn(3815 -- 3862) : fatal error 102: table overflow: "staging buffer"

pawn Code:

public OnAccountLoad(playerid)
{
    new temp[40];
    cache_get_row(0, 4, temp), PlayerInfo[playerid][pRegistered] = strval(temp),
    cache_get_row(0, 5, temp), PlayerInfo[playerid][pCash] = strval(temp),
    cache_get_row(0, 6, temp), PlayerInfo[playerid][pBank] = strval(temp),
    cache_get_row(0, 7, temp), PlayerInfo[playerid][pSkin] = strval(temp),
    cache_get_row(0, 8, temp), PlayerInfo[playerid][pSex] = strval(temp),
    cache_get_row(0, 9, temp), PlayerInfo[playerid][pAge] = strval(temp),
    cache_get_row(0, 10, PlayerInfo[playerid][pOrigin]),
    cache_get_row(0, 11, temp), PlayerInfo[playerid][pLevel] = strval(temp),
    cache_get_row(0, 12, temp), PlayerInfo[playerid][pExp] = strval(temp),
    cache_get_row(0, 13, temp), PlayerInfo[playerid][pHours] = strval(temp),
    cache_get_row(0, 14, temp), PlayerInfo[playerid][pAdmin] = strval(temp),
    cache_get_row(0, 15, temp), PlayerInfo[playerid][pHelper] = strval(temp),
    cache_get_row(0, 16, temp), PlayerInfo[playerid][pInt] = strval(temp),
    cache_get_row(0, 17, temp), PlayerInfo[playerid][pWorld] = strval(temp),
    cache_get_row(0, 18, temp), PlayerInfo[playerid][pJailed] = strval(temp),
    cache_get_row(0, 19, temp), PlayerInfo[playerid][pJailTime] = strval(temp),
    cache_get_row(0, 20, temp), PlayerInfo[playerid][pBanned] = strval(temp),
    cache_get_row(0, 21, temp), PlayerInfo[playerid][pWarns] = strval(temp),
    cache_get_row(0, 22, temp), PlayerInfo[playerid][pDonateRank] = strval(temp),
    cache_get_row(0, 23, temp), PlayerInfo[playerid][pCarLic] = strval(temp),
    cache_get_row(0, 24, temp), PlayerInfo[playerid][pWepLic] = strval(temp),
    cache_get_row(0, 25, temp), PlayerInfo[playerid][pFlyLic] = strval(temp),
    cache_get_row(0, 26, temp), PlayerInfo[playerid][pPosX] = floatstr(temp),
    cache_get_row(0, 27, temp), PlayerInfo[playerid][pPosY] = floatstr(temp),
    cache_get_row(0, 28, temp), PlayerInfo[playerid][pPosZ] = floatstr(temp),
    cache_get_row(0, 29, temp), PlayerInfo[playerid][pPosA] = floatstr(temp),
    cache_get_row(0, 30, temp), PlayerInfo[playerid][pDied] = strval(temp),
    cache_get_row(0, 31, temp), PlayerInfo[playerid][pFightStyle] = strval(temp),
    cache_get_row(0, 32, temp), PlayerInfo[playerid][pPen] = strval(temp),
    cache_get_row(0, 33, PlayerInfo[playerid][pNote1]),
    cache_get_row(0, 34, temp), PlayerInfo[playerid][pNote1s] = strval(temp),
    cache_get_row(0, 35, PlayerInfo[playerid][pNote2]),
    cache_get_row(0, 36, temp), PlayerInfo[playerid][pNote2s] = strval(temp),
    cache_get_row(0, 37, PlayerInfo[playerid][pNote3]),
    cache_get_row(0, 38, temp), PlayerInfo[playerid][pNote3s] = strval(temp),
    cache_get_row(0, 39, PlayerInfo[playerid][pAttributes]),
    cache_get_row(0, 40, temp), PlayerInfo[playerid][pPayCheckMade] = strval(temp),
    cache_get_row(0, 41, temp), PlayerInfo[playerid][pPayCheckMoney] = strval(temp),
    cache_get_row(0, 42, temp), PlayerInfo[playerid][pUpgrade] = strval(temp),
    cache_get_row(0, 43, temp), PlayerInfo[playerid][pPayDayTime] = strval(temp),
    cache_get_row(0, 44, temp), PlayerInfo[playerid][pSHealth] = floatstr(temp),
    cache_get_row(0, 45, temp), PlayerInfo[playerid][pCellPhone] = strval(temp),
    cache_get_row(0, 46, temp), PlayerInfo[playerid][pNumber] = strval(temp),
    cache_get_row(0, 47, temp), PlayerInfo[playerid][pSavings] = strval(temp),
    cache_get_row(0, 48, temp), PlayerInfo[playerid][pHouseKey] = strval(temp),
    cache_get_row(0, 49, temp), PlayerInfo[playerid][pMeleeWep] = strval(temp),
    cache_get_row(0, 50, temp), PlayerInfo[playerid][pWep1] = strval(temp),
    cache_get_row(0, 51, temp), PlayerInfo[playerid][pWep2] = strval(temp);
    return 1;
}

But when I remove the last line pWep2 it works...
how can I fix it?

Re : fatal error 102: table overflow: "staging buffer" - yusei - 27.02.2013

new temp[60];

Re: fatal error 102: table overflow: "staging buffer" - Vince - 27.02.2013

Quote:

“staging buffer”: the staging buffer holds the code generated for
an expression before it is passed to the peephole optimizer. The
staging buffer grows dynamically, so an overflow of the staging
buffer basically is an “out of memory” error.

Means you don't have enough RAM. But have you looked at the R15 version of the plugin on ****** Code? It has cache_get_row_int which will probably make this a whole lot easier.

https://code.******.com/p/sa-mp-mysq...downloads/list

Re: fatal error 102: table overflow: "staging buffer" - PaulDinam - 27.02.2013

When I use it everything is good, only the strings aren't good. like the origin and notes. it doesn't load them.

pawn Code:

public OnAccountLoad(playerid)
{
    new temp[40];
    PlayerInfo[playerid][pRegistered] = cache_get_row_int(0, 4);
    PlayerInfo[playerid][pCash] = cache_get_row_int(0, 5);
    PlayerInfo[playerid][pBank] = cache_get_row_int(0, 6);
    PlayerInfo[playerid][pSkin] = cache_get_row_int(0, 7);
    PlayerInfo[playerid][pSex] = cache_get_row_int(0, 8);
    PlayerInfo[playerid][pAge] = cache_get_row_int(0, 9);
    cache_get_row(0, 10, PlayerInfo[playerid][pOrigin]);
    PlayerInfo[playerid][pLevel] = cache_get_row_int(0, 11);
    PlayerInfo[playerid][pExp] = cache_get_row_int(0, 12);
    PlayerInfo[playerid][pHours] = cache_get_row_int(0, 13);
    PlayerInfo[playerid][pAdmin] = cache_get_row_int(0, 14);
    PlayerInfo[playerid][pHelper] = cache_get_row_int(0, 15);
    PlayerInfo[playerid][pInt] = cache_get_row_int(0, 16);
    PlayerInfo[playerid][pWorld] = cache_get_row_int(0, 17);
    PlayerInfo[playerid][pJailed] = cache_get_row_int(0, 18);
    PlayerInfo[playerid][pJailTime] = cache_get_row_int(0, 19);
    PlayerInfo[playerid][pBanned] = cache_get_row_int(0, 20);
    PlayerInfo[playerid][pWarns] = cache_get_row_int(0, 21);
    PlayerInfo[playerid][pDonateRank] = cache_get_row_int(0, 22);
    PlayerInfo[playerid][pCarLic] = cache_get_row_int(0, 23);
    PlayerInfo[playerid][pWepLic] = cache_get_row_int(0, 24);
    PlayerInfo[playerid][pFlyLic] = cache_get_row_int(0, 25);
    PlayerInfo[playerid][pPosX] = cache_get_row_float(0, 26);
    PlayerInfo[playerid][pPosY] = cache_get_row_float(0, 27);
    PlayerInfo[playerid][pPosZ] = cache_get_row_float(0, 28);
    PlayerInfo[playerid][pPosA] = cache_get_row_float(0, 29);
    PlayerInfo[playerid][pDied] = cache_get_row_int(0, 30);
    PlayerInfo[playerid][pFightStyle] = cache_get_row_int(0, 31);
    PlayerInfo[playerid][pPen] = cache_get_row_int(0, 32);
    cache_get_row(0, 33, PlayerInfo[playerid][pNote1]);
    PlayerInfo[playerid][pNote1s] = cache_get_row_int(0, 34);
    cache_get_row(0, 35, PlayerInfo[playerid][pNote2]);
    PlayerInfo[playerid][pNote2s] = cache_get_row_int(0, 36);
    cache_get_row(0, 37, PlayerInfo[playerid][pNote3]);
    PlayerInfo[playerid][pNote3s] = cache_get_row_int(0, 38);
    cache_get_row(0, 39, PlayerInfo[playerid][pAttributes]),
    PlayerInfo[playerid][pPayCheckMade] = cache_get_row_int(0, 40);
    PlayerInfo[playerid][pPayCheckMoney] = cache_get_row_int(0, 41);
    PlayerInfo[playerid][pUpgrade] = cache_get_row_int(0, 42);
    PlayerInfo[playerid][pPayDayTime] = cache_get_row_int(0, 43);
    PlayerInfo[playerid][pSHealth] = cache_get_row_float(0, 44);
    PlayerInfo[playerid][pCellPhone] = cache_get_row_int(0, 45);
    PlayerInfo[playerid][pNumber] = cache_get_row_int(0, 46);
    PlayerInfo[playerid][pSavings] = cache_get_row_int(0, 47);
    PlayerInfo[playerid][pHouseKey] = cache_get_row_int(0, 48);
    PlayerInfo[playerid][pMeleeWep] = cache_get_row_int(0, 49);
    PlayerInfo[playerid][pWep1] = cache_get_row_int(0, 50);
    PlayerInfo[playerid][pWep2] = cache_get_row_int(0, 51);
    PlayerInfo[playerid][pAmmo1] = cache_get_row_int(0, 52);
    PlayerInfo[playerid][pAmmo2] = cache_get_row_int(0, 53);
    return 1;
}

Re: fatal error 102: table overflow: "staging buffer" - PaulDinam - 27.02.2013

When I use, it doesn't work with the new plugin, but with the old it does.
cache_get_row(0, 10, PlayerInfo[playerid][pOrigin]);
So I have to use this...
cache_get_row(0, 10, temp); format(PlayerInfo[playerid][pOrigin], 128, "%s", temp);

Re: fatal error 102: table overflow: "staging buffer" - Misiur - 27.02.2013

I don't know if there is a way to get size of string within array of enumerated arrays.

pawn Code:

cache_get_row(0, 10, temp, dbhandle, 128);

This works if you don't care about further changes in code.
You can use this dirty thing if you want:

pawn Code:

new tmp[ENUM_OF_PlayerInfo];
cache_get_row(0, 10, temp, dbhandle, sizeof tmp[pOrigin]);

Not nice, but works (should).

Re: fatal error 102: table overflow: "staging buffer" - PaulDinam - 27.02.2013

cache_get_row(0, 10, temp, dbhandle, 12

;

This is what i'm going to use.