[Skinnz]

hello, i have error : (6148 -- 6271) : fatal error 102: table overflow: "staging buffer"

PHP код:

    new requete[300];
    mysql_format(mysql, requete, sizeof(requete), "UPDATE `comptes` SET `admin` = %d,\
    'sexe' = %d,\
    'age' = %d,\
    'register' = %d,\
    'tuto' = %d,\
    'ip' = %e,\
    'skin' = %d,\
    'faction' = %d,\
    'rank' = %d,\
    'jobpv' = %d,\
    'rankjob' = %d,\
    'inte' = %d,\
    'vw' = %d,\
    'argent' = %d,\
    'banque' = %d,\
    'bancaire' = %d,\
    'bancairesec' = %d,\
    'hacker' = %d,\
    'astuces' = %d,\
    'nbrveh' = %d,\
    'spec' = %d,\
    'bannis' = %d,\
    'jail' = %d,\
    'jailtime' = %d,\
    'level' = %d,\
    'mort' = %d,\
    'crash' = %d,\
    'menotte' = %d,\
    'cagoule' = %d,\
    'nbrmaison' = %d,\
    'nbrmaisonloc' = %d,\
    'nbrbat' = %d,\
    'nbrbiz' = %d,\
    'lastint' = %d,\
    'numtel' = %d,\
    'calling' = %d,\
    'payday' = %d,\
    'timeduty' = %d,\
    'timedutyjob' = %d,\
    'timedutyjobpv' = %d,\
    'coke' = %d,\
    'cokec' = %d,\
    'morphine' = %d,\
    'morphinec' = %d,\
    'weed' = %d,\
    'weedc' = %d,\
    'shit' = %d,\
    'shitc' = %d,\
    'graineweed' = %d,\
    'graineweedc' = %d,\
    'dependance' = %d,\
    'dependancetype' = %d,\
    'dependancetime' = %d,\
    'job' = %d,\
    'exp' = %d,\
    'maxexp' = %d,\
    'forces' = %d,\
    'forcetime' = %d,\
    'drogueforce' = %d,\
    'drogueforcetime' = %d,\
    'dette' = %d,\
    'permisv' = %d,\
    'permisc' = %d,\
    'permisa' = %d,\
    'timerweed = %d,\
    'gps' = %d,\
    'c4' = %d,\
    'jerrican' = %d,\
    'litrejerrican' = %d,\
    'radio' = %d,\
    'freqradio' = %d,\
    'boombox' = %d,\
    'averto' = %d,\
    'matos' = %d,\
    'vproprio1' = %d,\
     'vproprio2' = %d,\
    'vproprio3' = %d,\
    'locationveh' = %d,\
    'vloc' = %d,\
    'vproprio4' = %d,\
    'vproprio5' = %d,\
    'vpreter' = %d,\
    'vip' = %d,\
    'viplvl' = %d,\
    'arme1' = %d,\
    'arme2' = %d,\
    'arme3' = %d,\
    'arme4' = %d,\
    'arme5' = %d,\
    'arme6' = %d,\
    'arme7' = %d,\
    'arme8' = %d,\
    'arme9' = %d,\
    'ammo1' = %d,\
    'ammo2' = %d,\
    'ammo3' = %d,\
    'ammo4' = %d,\
    'ammo5' = %d,\
    'ammo6' = %d,\
    'ammo7' = %d,\
    'ammo8' = %d,\
    'ammo9' = %d,\
    'pos_x' = %f,\
    'pos_y' = %f,\
    'pos_z' = %f,\
    'vie' = %f,\
    'armure' = %f,\
    'corde' = %d,\
    'casque' = %d,\
    'tel' = %d,\
    'eobj' = %d,\
    'c_name1' = %e,\
    'c_name2' = %e,\
    'c_name3' = %e,\
    'c_name4' = %e,\
    'c_name5' = %e,\
    'c_name6' = %e,\
    'c_name7' = %e,\
    'c_name8' = %e,\
    'c_name9' = %e,\
    'c_name10' = %e,\
    'c_name11' = %e,\
    'c_name12' = %e,\
    'c_name13' = %e,\
    'c_name14' = %e,\
    'c_name15' = %e,\
    'c_name16' = %e,\
    'c_name17' = %e,\
    'c_name18' = %e,\
    'c_name19' = %e,\
    'c_name20' = %e,\
    'c_num1' = %d,\
    'c_num2' = %d,\
    'c_num3' = %d,\
    'c_num4' = %d,\
    'c_num5' = %d,\
    'c_num6' = %d,\
    'c_num7' = %d,\
    'c_num8' = %d,\
    'c_num9' = %d,\
    'c_num10' = %d,\
    'c_num11' = %d,\
    'c_num12' = %d,\
    'c_num13' = %d,\
    'c_num14' = %d,\
    'c_num15' = %d,\
    'c_num16' = %d,\
    'c_num17' = %d,\
    'c_num18' = %d,\
    'c_num19' = %d,\
    'c_num20' = %d,\
    'pindex0' = %d,\
    'pindex1' = %d,\
    'pindex2' = %d,\
    'pindex3' = %d,\
    'pindex4' = %d,\
    'pindex5' = %d,\
    'pmodelid0' = %d,\
    'pmodelid1' = %d,\
    'pmodelid2' = %d,\
    'pmodelid3' = %d,\
    'pmodelid4' = %d,\
    'pmodelid5' = %d,\
    'pboneid0' = %d,\
    'pboneid1' = %d,\
    'pboneid2' = %d,\
    'pboneid3' = %d,\
    'pboneid4' = %d,\
    'pboneid5' = %d,\
    'pfoffsetx0' = %f,\
    'pfoffsetx1' = %f,\
    'pfoffsetx2' = %f,\
    'pfoffsetx3' = %f,\
    'pfoffsetx4' = %f,\
    'pfoffsetx5' = %f,\
    'pfoffsety0' = %f,\
    'pfoffsety1' = %f,\
    'pfoffsety2' = %f,\
    'pfoffsety3' = %f,\
    'pfoffsety4' = %f,\
    'pfoffsety5' = %f,\
    'pfoffsetz0' = %f,\
    'pfoffsetz1' = %f,\
    'pfoffsetz2' = %f,\
    'pfoffsetz3' = %f,\
    'pfoffsetz4' = %f,\
    'pfoffsetz5' = %f,\
    'pfrotx0' = %f,\
    'pfrotx1' = %f,\
    'pfrotx2' = %f,\
    'pfrotx3' = %f,\
    'pfrotx4' = %f,\
    'pfrotx5' = %f,\
    'pfroty0' = %f,\
    'pfroty1' = %f,\
    'pfroty2' = %f,\
    'pfroty3' = %f,\
    'pfroty4' = %f,\
    'pfroty5' = %f,\
    'pfrotz0' = %f,\
    'pfrotz1' = %f,\
    'pfrotz2' = %f,\
    'pfrotz3' = %f,\
    'pfrotz4' = %f,\
    'pfrotz5' = %f,\
    'pfscalex0' = %f,\
    'pfscalex1' = %f,\
    'pfscalex2' = %f,\
    'pfscalex3' = %f,\
    'pfscalex4' = %f,\
    'pfscalex5' = %f,\
    'pfscaley0' = %f,\
    'pfscaley1' = %f,\
    'pfscaley2' = %f,\
    'pfscaley3' = %f,\
    'pfscaley4' = %f,\
    'pfscaley5' = %f,\
    'pfscalez0' = %f,\
    'pfscalez1' = %f,\
    'pfscalez2' = %f,\
    'pfscalez3' = %f,\
    'pfscalez4' = %f,\
    'pfscalez5' = %f\
    WHERE `ID` = %d",
    pinfo[playerid][Admin],
    pinfo[playerid][Sexe],
    pinfo[playerid][Age],
    pinfo[playerid][Register],
    pinfo[playerid][Tuto],
    pinfo[playerid][IP],
    pinfo[playerid][Skin],
    pinfo[playerid][Faction],
    pinfo[playerid][Rank],
    pinfo[playerid][JobPv],
    pinfo[playerid][RankJob],
    pinfo[playerid][Int],
    pinfo[playerid][Vw],
    pinfo[playerid][Argent],
    pinfo[playerid][Banque],
    pinfo[playerid][Bancaire],
    pinfo[playerid][BancaireSec],
    pinfo[playerid][Hacker],
    pinfo[playerid][Astuces],
    pinfo[playerid][Id],
    pinfo[playerid][Spec],
    pinfo[playerid][Bannis],
    pinfo[playerid][Jail],
    pinfo[playerid][JailTime],
    pinfo[playerid][Level],
    pinfo[playerid][Mort],
    pinfo[playerid][Crash],
    pinfo[playerid][Menotte],
    pinfo[playerid][Cagoule],
    pinfo[playerid][NbrMaison],
    pinfo[playerid][NbrMaisonLoc],
    pinfo[playerid][NbrBat],
    pinfo[playerid][NbrBiz],
    pinfo[playerid][LastInt],
    pinfo[playerid][NumTel],
    pinfo[playerid][Calling],
    pinfo[playerid][Payday],
    pinfo[playerid][TimeDuty],
    pinfo[playerid][TimeDutyJob],
    pinfo[playerid][TimeDutyJobPv],
    pinfo[playerid][Coke],
    pinfo[playerid][Cokec],
    pinfo[playerid][Morphine],
    pinfo[playerid][Morphinec],
    pinfo[playerid][Weed],
    pinfo[playerid][Weedc],
    pinfo[playerid][Shit],
    pinfo[playerid][Shitc],
    pinfo[playerid][GraineWeed],
    pinfo[playerid][GraineWeedc],
    pinfo[playerid][Dependance],
    pinfo[playerid][DependanceType],
    pinfo[playerid][DependanceTime],
    pinfo[playerid][Job],
    pinfo[playerid][Exp],
    pinfo[playerid][MaxExp],
    pinfo[playerid][Force],
    pinfo[playerid][ForceTime],
    pinfo[playerid][DrogueForce],
    pinfo[playerid][DrogueForceTime],
    pinfo[playerid][Dette],
    pinfo[playerid][Permisv],
    pinfo[playerid][Permisc],
    pinfo[playerid][Permisa],
    pinfo[playerid][TimerWeed],
    pinfo[playerid][Gps],
    pinfo[playerid][C4],
    pinfo[playerid][Jerrican],
    pinfo[playerid][LitreJerrican],
    pinfo[playerid][Radio],
    pinfo[playerid][FreqRadio],
    pinfo[playerid][Boombox],
    pinfo[playerid][Averto],
    pinfo[playerid][Matos],
    pinfo[playerid][vProprio1],
    pinfo[playerid][vProprio2],
    pinfo[playerid][vProprio3],
    pinfo[playerid][LocationVeh],
    pinfo[playerid][vLoc],
    pinfo[playerid][vProprio4],
    pinfo[playerid][vProprio5],
    pinfo[playerid][vPreter],
    pinfo[playerid][Vip],
    pinfo[playerid][VipLvl],
    pinfo[playerid][Arme1],
    pinfo[playerid][Arme2],
    pinfo[playerid][Arme3],
    pinfo[playerid][Arme4],
    pinfo[playerid][Arme5],
    pinfo[playerid][Arme6],
    pinfo[playerid][Arme7],
    pinfo[playerid][Arme8],
    pinfo[playerid][Arme9],
    pinfo[playerid][Ammo1],
    pinfo[playerid][Ammo2],
    pinfo[playerid][Ammo3],
    pinfo[playerid][Ammo4],
    pinfo[playerid][Ammo5],
    pinfo[playerid][Ammo6],
    pinfo[playerid][Ammo7],
    pinfo[playerid][Ammo8],
    pinfo[playerid][Ammo9],
    pinfo[playerid][Pos_X],
    pinfo[playerid][Pos_Y],
    pinfo[playerid][Pos_Z],
    pinfo[playerid][Vie],
    pinfo[playerid][Armure],
    pinfo[playerid][Corde],
    pinfo[playerid][Casque],
    pinfo[playerid][Tel],
    pinfo[playerid][eObj],
    pinfo[playerid][c_Name1],
    pinfo[playerid][c_Name2],
    pinfo[playerid][c_Name3],
    pinfo[playerid][c_Name4],
    pinfo[playerid][c_Name5],
    pinfo[playerid][c_Name6],
    pinfo[playerid][c_Name7],
    pinfo[playerid][c_Name8],
    pinfo[playerid][c_Name9],
    pinfo[playerid][c_Name10],
    pinfo[playerid][c_Name11],
    pinfo[playerid][c_Name12],
    pinfo[playerid][c_Name13],
    pinfo[playerid][c_Name14],
    pinfo[playerid][c_Name15],
    pinfo[playerid][c_Name16],
    pinfo[playerid][c_Name17],
    pinfo[playerid][c_Name18],
    pinfo[playerid][c_Name19],
    pinfo[playerid][c_Name20],
    pinfo[playerid][c_Num1],
    pinfo[playerid][c_Num2],
    pinfo[playerid][c_Num3],
    pinfo[playerid][c_Num4],
    pinfo[playerid][c_Num5],
    pinfo[playerid][c_Num6],
    pinfo[playerid][c_Num7],
    pinfo[playerid][c_Num8],
    pinfo[playerid][c_Num9],
    pinfo[playerid][c_Num10],
    pinfo[playerid][c_Num11],
    pinfo[playerid][c_Num12],
    pinfo[playerid][c_Num13],
    pinfo[playerid][c_Num14],
    pinfo[playerid][c_Num15],
    pinfo[playerid][c_Num16],
    pinfo[playerid][c_Num17],
    pinfo[playerid][c_Num18],
    pinfo[playerid][c_Num19],
    pinfo[playerid][c_Num20],
    pinfo[playerid][pindex0],
    pinfo[playerid][pindex1],
    pinfo[playerid][pindex2],
    pinfo[playerid][pindex3],
    pinfo[playerid][pindex4],
    pinfo[playerid][pindex5],
    pinfo[playerid][pmodelid0],
    pinfo[playerid][pmodelid1],
    pinfo[playerid][pmodelid2],
    pinfo[playerid][pmodelid3],
    pinfo[playerid][pmodelid4],
    pinfo[playerid][pmodelid5],
    pinfo[playerid][pboneid0],
    pinfo[playerid][pboneid1],
    pinfo[playerid][pboneid2],
    pinfo[playerid][pboneid3],
    pinfo[playerid][pboneid4],
    pinfo[playerid][pboneid5],
    pinfo[playerid][pfOffsetX0],
    pinfo[playerid][pfOffsetX1],
    pinfo[playerid][pfOffsetX2],
    pinfo[playerid][pfOffsetX3],
    pinfo[playerid][pfOffsetX4],
    pinfo[playerid][pfOffsetX5],
    pinfo[playerid][pfOffsetY0],
    pinfo[playerid][pfOffsetY1],
    pinfo[playerid][pfOffsetY2],
    pinfo[playerid][pfOffsetY3],
    pinfo[playerid][pfOffsetY4],
    pinfo[playerid][pfOffsetY5],
    pinfo[playerid][pfOffsetZ0],
    pinfo[playerid][pfOffsetZ1],
    pinfo[playerid][pfOffsetZ2],
    pinfo[playerid][pfOffsetZ3],
    pinfo[playerid][pfOffsetZ4],
    pinfo[playerid][pfOffsetZ5],
    pinfo[playerid][pfRotX0],
    pinfo[playerid][pfRotX1],
    pinfo[playerid][pfRotX2],
    pinfo[playerid][pfRotX3],
    pinfo[playerid][pfRotX4],
    pinfo[playerid][pfRotX5],
    pinfo[playerid][pfRotY0],
    pinfo[playerid][pfRotY1],
    pinfo[playerid][pfRotY2],
    pinfo[playerid][pfRotY3],
    pinfo[playerid][pfRotY4],
    pinfo[playerid][pfRotY5],
    pinfo[playerid][pfRotZ0],
    pinfo[playerid][pfRotZ1],
    pinfo[playerid][pfRotZ2],
    pinfo[playerid][pfRotZ3],
    pinfo[playerid][pfRotZ4],
    pinfo[playerid][pfRotZ5],
    pinfo[playerid][pfScaleX0],
    pinfo[playerid][pfScaleX1],
    pinfo[playerid][pfScaleX2],
    pinfo[playerid][pfScaleX3],
    pinfo[playerid][pfScaleX4],
    pinfo[playerid][pfScaleX5],
    pinfo[playerid][pfScaleY0],
    pinfo[playerid][pfScaleY1],
    pinfo[playerid][pfScaleY2],
    pinfo[playerid][pfScaleY3],
    pinfo[playerid][pfScaleY4],
    pinfo[playerid][pfScaleY5],
    pinfo[playerid][pfScaleZ0],
    pinfo[playerid][pfScaleZ1],
    pinfo[playerid][pfScaleZ2],
    pinfo[playerid][pfScaleZ3],
    pinfo[playerid][pfScaleZ4],
    pinfo[playerid][pfScaleZ5],
    pinfo[playerid][ID]);
    mysql_tquery(mysql, requete, "", ""); 


6148 : WHERE `ID` = %d",
6271 : pinfo[playerid][c_Name12],
can you help me ?

[Misiur]

Quote:

new requete[300];

Your query is way longer than that. Increase your string size accordingly

[Skinnz]

PHP код:

 new requete[226]; 


Same problem

[Stinged]

He said increase it, but you decreased it..?

[Skinnz]

I understood the opposite

PHP код:

new requete[5048]; 


same problem

[Shinja]

I counted characters in your requete, its 4980, and guess it with many floats, names and alot more, it may reach 6000

[Skinnz]

PHP код:

new requete[4980]; 


PHP код:

new requete[6000]; 


PHP код:

new requete[20000]; 


Same problem.. How to do?

[BR3TT]

Have you tried breaking it down? Unless it's because you have it all spaced out, I don't think I've ever seen a query so long.

[Skinnz]

How does it breaking it down?
How to do it ?

[Shinja]

Try to break it then, it's too long i believe i've seen such cases sloved by breaking