[AlexuTzVs]

Those are the 3 issues that i have right now and i don't know if is the server or the database

pawn Код:

Log("04:01:01","CMySQLQuery::Execute[]",1,"(error #2013) Lost connection to MySQL server during query (Query: \"UPDATE `factions` SET `Bank`='0' WHERE `ID`='0'\")",1);

pawn Код:

for(new i = 0; i < MAX_PLAYERS; i++)
                    {
                        if(IsPlayerConnected(i))
                        {
                            if((IsACop(i) && CrimInRange(50.0, playerid,i) && OnDuty[i] == 1)|| (IsACop(i) && killerid == i))
                            {
                                if(OnDuty[i] != 1) return 1;
                                GetPlayerName(killerid, lastname, sizeof(lastname));
                                GetPlayerName(playerid, streap, sizeof(streap));
                                count++;
                                GameTextForPlayer(i, "Running Suspect killed!", 5000, 1);
                                format(string, sizeof(string), "Ai primit {C3C3C3}$%d bonus {2641FE}pentru prinderea suspectului {C3C3C3}%s.", totalprice, streap);
                                SendClientMessage(i, COLOR_DBLUE, string);
                                ConsumingMoney[i] = 1;
                                GivePlayerCash(i, price);
                                Update(i, pCashx);
                                new idfac = PlayerInfo[i][pMember];
                                DynamicFactions[idfac][fBank] += totalprice;
                                mysql_format(SQL,str23,sizeof(str23),"UPDATE `factions` SET `Bank`='%d' WHERE `ID`='%d'", DynamicFactions[idfac][fBank], idfac);
                                mysql_tquery(SQL,str23,"","");
                                PlayerPlaySound(i, 1058, 0.0, 0.0, 0.0);
                                format(string, sizeof(string),"***[SUSPECT] {FFFFFF}%s {33CCFF}killed suspect {FFFFFF}%s {33CCFF}having Wanted {FFFFFF}%d{33CCFF}, over***",lastname,streap,PlayerInfo[playerid][pWantedLevel]);
                                copkill = 1;
                            }
                        }
                    }

2nd

pawn Код:

Log("23:40:19","CMySQLQuery::Execute[]",1,"(error #2013) Lost connection to MySQL server during query (Query: \"INSERT INTO iplogs (`ip`,`playerid`) VALUES ('MYIPHERE','8')\")",1);

pawn Код:

public LogIP(string[],psql)
{
    new query[500];
    mysql_format(SQL,query,500,"INSERT INTO iplogs (`ip`,`playerid`) VALUES ('%s','%d')",string,psql);
    mysql_tquery(SQL,query,"","");
    return 1;
}

3rd

pawn Код:

Query: \"UPDATE `users` SET `CarLic`='1',`FlyLic`='1',`BoatLic`='1',`GunLic`='1',`CarLicT`='33',`FlyLicT`='55',`BoatLicT`='84',`GunLicT`='55',`Rob`='20',`Jailed`='0',`HitT`='0',`Muted`='0',`MuteTime`='0' WHERE `name`='Alex'\")",1);
Log("23:40:19","CMySQLQuery::Execute[]",1,"(error #2013) Lost connection to MySQL server during query (

Does anyone has any idea?

pawn Код:

forward OnPlayerDateUpdateX2(playerid);
public OnPlayerDateUpdateX2(playerid)
{
    if(IsPlayerConnected(playerid))
    {
        new var[556];
        {
            mysql_format(SQL,var,sizeof(var),"UPDATE `users` SET `CarLic`='%d',`FlyLic`='%d',`BoatLic`='%d',`GunLic`='%d',`CarLicT`='%d',`FlyLicT`='%d',`BoatLicT`='%d',`GunLicT`='%d',`Rob`='%d',`Jailed`='%d',`HitT`='%d',`Muted`='%d',`MuteTime`='%d' WHERE `name`='%s'",
            PlayerInfo[playerid][pCarLic],
            PlayerInfo[playerid][pFlyLic],
            PlayerInfo[playerid][pBoatLic],
            PlayerInfo[playerid][pGunLic],
            PlayerInfo[playerid][pCarLicT],
            PlayerInfo[playerid][pFlyLicT],
            PlayerInfo[playerid][pBoatLicT],
            PlayerInfo[playerid][pGunLicT],
            PlayerInfo[playerid][pRob],
            PlayerInfo[playerid][pJailed],
            PlayerInfo[playerid][pHitT],
            PlayerInfo[playerid][pMuted],
            PlayerInfo[playerid][pMuteTime],
            PlayerInfo[playerid][pNormalName]);
            mysql_function_query(SQL,var,false,"","");
        }
    }
    return 1;
}

[AlexuTzVs]

Up ? Can someone tell me if is Database issue or Server issue?

[oMa37]

Use %e instead of %s while using mysql_format.

[Ultraz]

I have some solutions to you , it may help you :

1- Update all your plugins & includes

2- Try using %e instead of %s

________________________________________________
+Rep if i Helped you.

[AlexuTzVs]

I solved some issues i think by setting the net_read_timeout to 500 but i still get these errors

pawn Код:

[16:57:14] Error ID: 2013, Error: Lost connection to MySQL server during query
[16:57:14] Callback: 
[16:57:14] gQuery: INSERT INTO log_admin (`log`) VALUES ('AdmWarning: Admin Alex Teleported to Mountain.')

pawn Код:

new query[500];
    mysql_format(SQL,query,500,"INSERT INTO log_admin (`log`) VALUES ('%e')",string);
    mysql_tquery(SQL,query,"","");
    return 1;

pawn Код:

[16:52:31] Error ID: 2013, Error: Lost connection to MySQL server during query
[16:52:31] Callback: 
[16:52:31] gQuery: UPDATE users SET `Tutorial`='1',`Bank`='100',`Money`='250' WHERE `name`='Alex'
[16:52:31] ====================================================================

pawn Код:

else if(TutTime[i] == 101)
                {
                    TutTime[i] = 0; PlayerInfo[i][pTut] = 1;
                    gOoc[i] = 0; gNews[i] = 0; gFam[i] = 0;
                    TogglePlayerControllable(i, 1);
                    SetCameraBehindPlayer(i);
                    TogglePlayerSpectating(i, 0);
                    SetPlayerSpawn(i);
                    PlayerInfo[i][pAccount] = 100;
                    ResetPlayerCash(i);
                    GivePlayerCash(i,250);
                    SetPlayerInterior(i,0);
                    SetPlayerVirtualWorld(i,0);
                    TogglePlayerControllable(i,true);
                    new str1[256];
                    mysql_format(SQL,str1,256,"UPDATE users SET `Tutorial`='1',`Bank`='100',`Money`='250' WHERE `name`='%e'",PlayerInfo[i][pNormalName]);
                    mysql_tquery(SQL,str1,"","");
                }
            }