Problema...

[VipBo$$]

Salut din nou samperisti-lor.

Sa incep din nou cu problmele mele? =))

Eu zic ca da.

Deci de curand mi-am achizitionat un host si dupa ce am incarcat tot ce trebuie pe el imi da asta in server_log.txt:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[21:19:17]
[21:19:17] Server Plugins
[21:19:17] --------------
[21:19:17]  Loading plugin: crashdetect.so
[21:19:17]   CrashDetect v4.15.1 is OK.
[21:19:17]   Loaded.
[21:19:17]  Loading plugin: sscanf.so
[21:19:17]

[21:19:17]  ===============================

[21:19:17]       sscanf plugin loaded.     

[21:19:17]          Version:  2.8.2        

[21:19:17]    (c) 2012 Alex "Y_Less" Cole  

[21:19:17]  ===============================

[21:19:17]   Loaded.
[21:19:17]  Loading plugin: streamer.so
[21:19:17]

** Streamer Plugin v2.7.7 by Incognito loaded **

[21:19:17]   Loaded.
[21:19:17]  Loading plugin: mysql.so
[21:19:17]  >> plugin.mysql: R34 successfully loaded.
[21:19:17]   Loaded.
[21:19:17]  Loading plugin: nativechecker.so
[21:19:17]   Loaded.
[21:19:17]  Loaded 5 plugins.

[21:19:17]
[21:19:17] Filterscripts
[21:19:17] ---------------
[21:19:17]   Loaded 0 filterscripts.
[21:19:18]  
[21:19:18]  
[21:19:18]  
[21:19:18]  =======================================
[21:19:18]  |                                     |
[21:19:18]  |        YSI version 3.09.0684        |
[21:19:18]  |        By Alex "Y_Less" Cole        |
[21:19:18]  |                                     |
[21:19:18]  =======================================
[21:19:18]  
[21:19:18] [MySQL Houses]: 0
[21:19:18] [MySQL Vehicles]: 0 server vehicles loaded.
[21:19:18] [MySQL Clans]: 0 clans loaded.
[21:19:18] [MySQL Bussines]: 0
[21:19:18] [MySQL Turfs]: 0
[21:19:18] [MySQL Factions]: 0
[21:19:18] [MySQL Trainings]: 0
[21:19:18] [MySQL Jobs]: 0 loaded...
[21:19:18] [MySQL Furniture]: 0 objects loaded.
[21:19:18] [MySQL SafeZone]: 0 loaded...
[21:19:18] Number of vehicle models: 95
[21:19:18] ====================================================================
[21:19:18] Error ID: 2006, Eroare: MySQL server has gone away
[21:19:18] Callback: LoadDSVeh
[21:19:18] gQuery: SELECT * FROM `dsveh`
[21:19:18] ====================================================================
[21:19:18] ====================================================================
[21:19:18] Error ID: 2006, Eroare: MySQL server has gone away
[21:19:18] Callback: PreLoadCars
[21:19:18] gQuery: SELECT MAX(ID) FROM `cars`
[21:19:18] ====================================================================

 

 

In gamemode este asta:

 

function LoadDSVeh()
{
    dsvehs = cache_num_rows();
    for(new i = 1; i <= dsvehs; i++)
    {
        new j = i - 1;
        DSModels[dID]                 = cache_get_field_content_int(j, "ID");
        DSModels[dModel]             = cache_get_field_content_int(j, "Model");
        DSModels[dPrice]             = cache_get_field_content_int(j, "Price");
        DSModels[dDoors]             = cache_get_field_content_int(j, "Doors");
        DSModels[dType]              = cache_get_field_content_int(j, "Type");
        DSModels[dPremium]             = cache_get_field_content_int(j, "Premium");
        DSModels[dMaxSpeed]          = cache_get_field_content_int(j, "MaxSpeed");
        DSModels[dGold]          = cache_get_field_content_int(j, "Gold");
    }
    printf("[MYSQL DShip Vehicles]: %d", dsvehs);
}

 

Si...

 

function LoadSystems()
{
    new query[256];
    mysql_format(SQL, query, sizeof(query), "SELECT * FROM `dsveh`");
    mysql_tquery(SQL, query, "LoadDSVeh", "");

    mysql_format(SQL, query, sizeof(query), "SELECT MAX(ID) FROM `cars`");
    mysql_tquery(SQL, query, "PreLoadCars", "");
}

Multumesc multa, bafta!

 

Edited September 11, 2017 by AlexBo$$

[Alin69]

Nu ma prea pricep eu la dinastea dar cred ca e ceva cu my_sql-ul,ai incercat sa dai un mic research pe google cu ce eroare ai primit? ( Error ID: 2006, Eroare: MySQL server has gone away ) incerca sa cauti.

[VipBo$$]

Acum 58 minute, Alin69 a spus:

Nu ma prea pricep eu la dinastea dar cred ca e ceva cu my_sql-ul,ai incercat sa dai un mic research pe google cu ce eroare ai primit? ( Error ID: 2006, Eroare: MySQL server has gone away ) incerca sa cauti.

Am rezolvat de mult asta, oricum ms de parere.

[Alin69]

Acum 6 ore, VipBo$$ a spus:

Am rezolvat de mult asta, oricum ms de parere.

Acum vad data....infine..ce a fost pana la urma?

[VipBo$$]

Acum 8 minute, Alin69 a spus:

Acum vad data....infine..ce a fost pana la urma?

Era problema de la baza de date, daca ai si tu problema asta.

[Alin69]

Acum 2 ore, VipBo$$ a spus:

Era problema de la baza de date, daca ai si tu problema asta.

Nu am,dar ma intrebam si eu in caz ca o sa dau si eu peste problema aia.

[VipBo$$]

Acum 2 minute, Alin69 a spus:

Nu am,dar ma intrebam si eu in caz ca o sa dau si eu peste problema aia.

Ok.