Lost connection to MySQL server during query -
AlexuTzVs - 19.09.2016
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;
}
Re: Lost connection to MySQL server during query -
AlexuTzVs - 19.09.2016
Up ? Can someone tell me if is Database issue or Server issue?
Re: Lost connection to MySQL server during query -
oMa37 - 19.09.2016
Use %e instead of %s while using mysql_format.
Re: Lost connection to MySQL server during query -
Ultraz - 19.09.2016
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.
Re: Lost connection to MySQL server during query -
AlexuTzVs - 21.09.2016
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,"","");
}
}