Jump to content

Question

Posted

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 >((

4 answers to this question

Recommended Posts

  • 0
Posted
16 minutes ago, cristian9900 said:

Hostul samp este de la zero ping , iar hostul pentru baza de date este de la alta firma , asta sa fie de vina ?

Ai butonul de edit ;) Verifica inca de 2 ori datele de la host.

j3V8Znq.png

5IGyOAw.png

  • 0
Posted

Problema este de la baza de date, isi da timeout sau inchide conexiunea dintr-un motiv oarecare. Posibil sa fie de la host, scrie un ticket firmei de host si daca iti spun ca nu este problema de la ei atunci lasa un reply.

Gh38gEQ.gif

  • 0
Posted

Topic inactiv. T/C

**********************************

Servicii Scripting de calitate:

*********************************

Future Project: ExpertGame

*********************************

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.