Jump to content
  • 0

Problema mysql error 2006


cristian9900

Question

Problema intalnita (descriere): creez o baza de date pe host , completez in gamemode totul corect , iar cand incerc sa intru pe server , nu ma lasa sa imi fac , cont  , adica nu apare sa ma inregistrez  , in consola apare eroor id 2006 mysql gone away....
Ero(area / rile) / warning-(ul / urile):  [ -- ] [ Gamemode is Starting ] [ -- ]


[MySQL] Using connection no. 2
[MYSQL]: Connection succesful!
[Clans Script]: 0 clans loaded.
[MySQL INFO]: 0 businesses loaded.
[MySQL INFO]: 0 entries loaded.
[MySQL INFO]: 0 pickups loaded.
[MySQL INFO]: 0 labels loaded.
[MySQL INFO]: 0 factions loaded.
[MySQL INFO]: 0 server vehicles loaded.
[MySQL - JOBS]: 0 loaded...


[ -- ] [ Gamemode STARTED ] [ -- ]


fixes.plugin: Could not find function TakeAd.
Number of vehicle models: 0
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: LoadHouses
gQuery: SELECT * FROM `houses`
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: LoadSafebox
gQuery: SELECT * FROM `safeboxs`
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: LoadTurfs
gQuery: SELECT * FROM `turfs`
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: LoadDSVeh
gQuery: SELECT * FROM `dsveh`
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: LoadGInfo
gQuery: SELECT * FROM `infos`
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: PreLoadCars
gQuery: SELECT MAX(ID) FROM `cars`
====================================================================
[connection] 94.176.155.51:26307 requests connection cookie.
[connection] incoming connection: 94.176.155.51:26307 id: 0
[join] NinGe has joined the server (0:94.176.155.51)
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: OnPlayerDataLoaded
gQuery: SELECT `Password`, `KeyReset` FROM `users` WHERE `username` = '' LIMIT 1
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: 
gQuery: UPDATE `infos` SET `recordnumber`='1' WHERE ID = 1
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: 
gQuery: UPDATE `infos` SET `recorddate`='04.08.2016 20:36' WHERE ID = 1
====================================================================
[part] NinGe has left the server (0:1)
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: 
gQuery: UPDATE `users` SET `Seconds`='0' WHERE `ID`='0' LIMIT 1
====================================================================
====================================================================
Error ID: 2006, MySQL server has gone away
Callback: 
gQuery: UPDATE `users` SET `online`='0' WHERE `ID`='0' LIMIT 1
Liniile de cod / sursa / script-ul(obligatoriu):

stock initiateConnections() {
    new
        File: fhConnectionInfo = fopen("MySQL.txt", io_read);

    new szQueryOutput[256];
    fread(fhConnectionInfo, szQueryOutput);
    fclose(fhConnectionInfo);

    sscanf(szQueryOutput, "p<|>e<i>", conType);
    
    printf("[MySQL] Using connection no. %d",conType);
    
    if(conType == 1) //localhost
        SQL = mysql_connect("localhost", "root", "gm_db", "");
    if(conType == 2) //remote server
        SQL = mysql_connect("am colpletat corect totul aici", "-", "-", "-");
    return true;
}


Imagini / Video (optional):
Ati incercat sa rezolvati singur?:Da, am incercat , am editat si fisierul mysql.text cu 2 , si tot nu merge >((

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.