25.02.2010, 22:39
Hi,
Does anyone know how to make the connection persistent? because the plugin drops the connection after some time and it isn't reconnecting automatically. It didn't happened to me with the other plugins.
and as I've told before:
Does this happens to anyone or just me?
Thank you.
Mike.
Does anyone know how to make the connection persistent? because the plugin drops the connection after some time and it isn't reconnecting automatically. It didn't happened to me with the other plugins.
Код:
[01:23:16] CMySQLHandler::Query(UPDATE players SET MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=1,Mission=0,Warnings=0,Adjustable=1,FactionSpawn=1 WHERE id=405,resultID) - Threaded query with id 5 started. (Extra ID: -1) [01:23:16] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006) [01:23:16] CMySQLHandler::ProcessQueryThread(UPDATE players SET PlayerLevel=3,Banned=0,WantedLevel=0,AdminLevel=1339,HelperLevel=1338,DonateRank=0,UpgradePoints=0,ConnectedTime=50,Registered=1,Sex=1,Age=23,Logged=0,CK=0,Muted=0,Disabled=0,Respect=50,Money=92190 WHERE id=405, Resultid: 5) - An error has occured in your query. (MySQL server has gone away)) [01:23:16] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006) [01:23:16] CMySQLHandler::ProcessQueryThread(UPDATE players SET Bank=50668,Crimes=0,Kills=0,Deaths=3,pillsTime=0,Arrested=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=16,Paycheck=5172,HeadValue=0,Jailed=0,JailTime=0,Materials=0,Drugs=0 WHERE id=405, Resultid: 5) - An error has occured in your query. (MySQL server has gone away)) [01:23:16] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006) [01:23:16] CMySQLHandler::ProcessQueryThread(UPDATE players SET Leader=0,Member=0,FMember=255,Rank=0,Chara=264,ContractTime=25,DetSkill=0,SexSkill=0,BoxSkill=0,LawSkill=0,MechSkill=0,JackSkill=0,CarSkill=0,NewsSkill=0,DrugsSkill=0,CookSkill=0,FishSkill=0 WHERE id=405, Resultid: 5) - An error has occured in your query. (MySQL server has gone away)) [01:23:16] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006) [01:23:16] CMySQLHandler::ProcessQueryThread(UPDATE players SET pSHealth='25.000000',Team=3,Model=203,PhoneNr=6633,House=255,Bizz=255,CarLic=1,FlyLic=1,BoatLic=1,FishLic=0,GunLic=0,CarTime=0,PayDay=6,PayDayHad=0,Wins=0,Loses=0,AlcoholPerk=0,DrugPerk=0 WHERE id=405, Resultid: 5) - An error has occured in your query. (MySQL server has gone away)) [01:23:16] CMySQLHandler::Ping() - An error has occured (MySQL server has gone away, Error ID: 2006) [01:23:16] CMySQLHandler::ProcessQueryThread(UPDATE players SET MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=1,Mission=0,Warnings=0,Adjustable=1,FactionSpawn=1 WHERE id=405, Resultid: 5) - An error has occured in your query. (MySQL server has gone away))
Quote:
Originally Posted by Sma_X
Hi, as far as I've seen there's a problem with mysql_free_result();
If you use it twice, it crashes the server. |
Thank you.
Mike.