Problema pornire srv

1Shot · February 7, 2019

Salut. cand incerc pornesc server-ul se inchide si imi da niste erori pe care nu stiu cum sa le rezolv...

Am incercat sa schimb plugin-urile dar degeaba...

Acestea sunt erorile din server_log:

[16:01:02] [debug] Server crashed while executing GM.amx
[16:01:02] [debug] AMX backtrace:
[16:01:02] [debug] #0 native mysql_connect () [72f1e4d0] from mysql.DLL
[16:01:02] [debug] #1 000c0c08 in ?? () at C:\Users\Remus\Desktop\GM\gamemodes\GM.pwn:1524
[16:01:02] [debug] #2 0002f144 in public L_AFK_OnGM () at C:\Users\Remus\Desktop\GM\pawno\include\YSI\y_hooks/impl.inc:484
[16:01:02] [debug] #3 native CallLocalFunction () [004743b0] from samp-server.exe
[16:01:02] [debug] #4 0001bcc4 in public SSCANF_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\AutoAFK.inc:47
[16:01:02] [debug] #5 000153b0 in public Itter_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\sscanf2.inc:205
[16:01:02] [debug] #6 native CallLocalFunction () [004743b0] from samp-server.exe
[16:01:02] [debug] #7 000140e8 in public ScriptInit_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\YSI\y_iterate.inc:791
[16:01:02] [debug] #8 00012d08 in public PZone_OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\YSI\internal\..\y_scriptinit.inc:171
[16:01:02] [debug] #9 native CallLocalFunction () [004743b0] from samp-server.exe
[16:01:02] [debug] #10 00006ce8 in public OnGameModeInit () at C:\Users\Remus\Desktop\GM\pawno\include\playerzone.inc:429

multumesc.

Banditul · February 7, 2019

Arata linia 1524 din GM.pwn sau aia e linia cu mysql_connect?

1Shot · February 7, 2019

Dap, este fix linia SQL = mysql_connect("localhost", "root", "baza", "");

SherKan · February 7, 2019

verifica daca versiunea de la plugin e aceeasi cu cea de la include,

1Shot · February 7, 2019

Da, sunt aceleasi tocmai ce le-am downloadat (toate cele 5 plugin-uri) ultimele versiuni , si le-am pus si in plugins si in pawno/include si am si compilat gm-ul...

SherKan · February 7, 2019

ce versiune de mysql folosesti?

Banditul · February 7, 2019

Daca e mysql r40+

SQL = mysql_connect("localhost", "root", "", "baza");

1Shot · February 7, 2019

R41-4

SherKan · February 7, 2019

eu am r41-4 si folosesc

SQL	= mysql_connect_file();

nu e nevoie sa compilez mereu cand modific numele/parola la baza de date sau hostul

SherKan · February 7, 2019

log-core.dll si libmariadb.dll trebuie puse in folderul principal in caz ca nu le-ai pus

1Shot · February 7, 2019

Defapt am gresit eu, aveam o versiune mai veche, am pus acum ultima versiune si imi apar erori cand compilez.........

C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(6998) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(6999) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7000) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7001) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7002) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7003) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7017) : warning 213: tag mismatch
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7019) : warning 202: number of arguments does not match definition
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7020) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7021) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7022) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7023) : error 017: undefined symbol "cache_get_field_content"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(7024) : error 017: undefined symbol "cache_get_field_content"

Edited February 7, 2019 by 1Shot

SherKan · February 7, 2019

uita-te la functiile din mysql pe wiki eu folosesc asta + cele asemanatoare

cache_get_value_int
cache_get_value_float
...

1Shot · February 7, 2019

9 minutes ago, Banditul said:
Daca e mysql r40+
SQL = mysql_connect("localhost", "root", "", "baza");

daca pun r41 imi da multe erori...

iar mysql acesta pe care il am acum nu stiu exact ce versiune este...cum pot vedea?

1Shot · February 7, 2019

Just now, SherKan said:
uita-te la functiile din mysql pe wiki eu folosesc asta + cele asemanatoare
cache_get_value_int
cache_get_value_float
...

nu ma pricep prea bine la mysql...mai bine las versiunea asta de mysql care este pusa...dar nu stiu exact ce versiune e

1Shot · February 7, 2019

12 minutes ago, Banditul said:
Daca e mysql r40+
SQL = mysql_connect("localhost", "root", "", "baza");
Daca pun asa cum ai spus, se deschide server-ul, dar imi apare:

[16:27:21] Server vehicles: 0
[16:27:21] Safezones: 0
[16:27:21] Houses: 0
[16:27:21] Clans: 0
[16:27:21] Clan zones: 0
[16:27:21] Bussines: 0
[16:27:21] Turfs: 0
[16:27:21] Factions: 0
[16:27:21] Jobs: 0
[16:27:21] Furnitures: 0
[16:27:21] Stuff Loaded
[16:27:21] Safes: 0
[16:27:21] Apartaments: 0
[16:27:23] Accesory loaded: 0

De ce apar toate 0 ? ...

SherKan · February 7, 2019

pune loadjobs() sau cum ai sa vad ce ar trebui modificat

1Shot · February 7, 2019

Aparea 0 pt. ca nu era bine cum am scris la mysql_connect...

Am mysql 39.4 sau ceva de genu... Nu inteleg de ce apar acele erori in serverlog si imi da crash...

SherKan · February 7, 2019

pune r41-4 eu ala folosesc si fara mysql_connect, eu am mysql_connect_file, documenteaza-te de pe wiki cum se foloseste

1Shot · February 7, 2019

trebuie sa stau sa redenumesc o gramade de functii daca bag r41...si nu am nici o garantie ca dupa aceea va merge...

1Shot · February 7, 2019

@Banditul Ma poti ajuta? Cu ce trebuie sa redenumesc aceste functii care au fost scoate in r40 ... ?

C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(1687) : error 017: undefined symbol "mysql_store_result"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(1688) : error 017: undefined symbol "mysql_num_rows"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(1690) : error 017: undefined symbol "mysql_free_result"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(15815) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(16343) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(16343) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Remus\Desktop\GM\gamemodes\OneShot.pwn(31315) : error 017: undefined symbol "mysql_get_field"

cum naiba rezolv eu astea...? cu ce sa le redenumesc...

Edited February 7, 2019 by 1Shot

SherKan · February 7, 2019

mysql_num_rows = cache_num_row

mysql_free_result ar fi cache_delete

celelalte nu stiu exact, eu parca le-am sters tot ce era legat de mysql_free, mysq_fect.. etc si am pus pe cache

Banditul · February 7, 2019

@1Shot arata functia respectiva sa iti fac un model

Avand in vedere functiile asa zice r34

1Shot · February 7, 2019

@Banditul Apare mysql R39.3 loaded...

Sunt vreo 7 functii care imi spune ca sunt "undefined":

Acestea sunt functiile undefined: mysql_store_result, mysql_num_rows, mysql_fetch_row, mysql_free_result, mysql_get_field, mysql_fetch_field_row, mysql_retrieve_row.

Cam astea ar fi scripturile:

	// Login
	format(szString,sizeof(szString),"SELECT * FROM users WHERE `name`='%s'",GetName(playerid));
	mysql_query(SQL,szString);
	mysql_store_result();
	if(mysql_num_rows()) PlayerAccount[playerid] = 1;
	else PlayerAccount[playerid] = 0;
	mysql_free_result();

	login[playerid] = SetTimerEx("LoginTimer", 30000, false,"d", playerid);
	CheckClassIP(playerid);

	mysql_query(SQL,str1);
	mysql_store_result();
	mysql_fetch_row(strid);
	intid = strval(strid);
	mysql_free_result();
	intid++;

			if(PlayerAccount[playerid] != 0) {
				new laston[64], field[128];
				format(field,128,"SELECT `lastOn`  FROM users WHERE `name`='%s'",GetName(playerid));
				mysql_query(SQL,field);
				mysql_store_result();
				if(mysql_retrieve_row()) mysql_fetch_field_row(laston, "lastOn");
				mysql_free_result();
				format(string, sizeof(string), "Bine ai revenit, %s!\nTasteaza in casuta de mai jos parola contului tau.\n\nUltima logare: {FFFFFF}%s",GetName(playerid),laston);
				ShowPlayerDialog(playerid, DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"Logare", string,"Logare","Quit");

		mysql_get_field("ID", result);				BizzInfo[i][bID] = strval(result);
        mysql_get_field("Owned", result);			BizzInfo[i][bOwned] = strval(result);
        mysql_get_field("Owner", result);			strmid(BizzInfo[i][bOwner], result, 0, 32, 32);
        mysql_get_field("Message", result);			strmid(BizzInfo[i][bMessage], result, 0, 100, 100);
   	    mysql_get_field("EntranceX", result);		BizzInfo[i][bEntranceX] = floatstr(result);

Edited February 7, 2019 by 1Shot

Banditul · February 7, 2019

mysql_format(SQL, szString,sizeof(szString),"SELECT `ID` FROM users WHERE `name`= '%e'",GetName(playerid)); //Nue e nevoie sa selectezi tot daca oricum nu folosesti nimic
new Cache:result =  mysql_query(SQL,szString);
new rows;
cache_get_row_count(rows);
if(rows) PlayerAccount[playerid] = 1;
else PlayerAccount[playerid] = 0;
cache_delete(result);

new Cache:result = mysql_query(SQL,str1);
cache_get_value_int(0, "field selectat folosind query de select", intid);
cache_delete(result);
intid++;


if(PlayerAccount[playerid] != 0) {
    new laston[64], field[128];
    mysql_format(SQL, field,128,"SELECT `lastOn` FROM users WHERE `name`='%e'",GetName(playerid));
    new Cache:result = mysql_query(SQL,field), rows;
    cache_get_row_count(rows);
    if(rows) cache_get_value(0, laston, "lastOn");
    cache_delete(result);
    format(string, sizeof(string), "Bine ai revenit, %s!\nTasteaza in casuta de mai jos parola contului tau.\n\nUltima logare: {FFFFFF}%s",GetName(playerid),laston);
    ShowPlayerDialog(playerid, DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"Logare", string,"Logare","Quit");

//Aici imi lipsete contextul
for(new row = 0, rows = cache_num_rows(); row < rows; row++)

cache_get_value_int(row, "ID", BizzInfo[i][bID]);			
cache_get_value_int(row, "Owned", BizzInfo[i][bOwned]);			
cache_get_value(row, "Owner", BizzInfo[i][bOwner], MAX_PLAYER_NAME);			
cache_get_value(row, "Message", BizzInfo[i][bMessage], 200);// marimea bMessage in lco de 200			
cache_get_value_float(row, "EntranceX", BizzInfo[i][bEntranceX]);

1Shot · February 7, 2019

@Banditulmda, nu cred ca o sa fiu in stare sa modific toate liniile ca in modelul tau... sunt 7 erori diferite...dar se repeta...sunt vreo 30 de linii de erori...

totusi daca l-as lasa asa cum e pe r39.3 ... nu am cum sa il fac sa mearga?... de ce naiba imi da crash...

Banditul · February 7, 2019

Da stiu, e mult de munca sa convertesti tot sistemul pe r40+ dar uneori merita.

Incearca sa folosesti mysql r34 sau r39-6 si vezi daca iti mai da crash. E destul de ciudat faptul ca da crash la mysql_connect

Sign In

Problema pornire srv

Question

Link to comment

Share on other sites

33 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Similar Content

Recently Browsing 0 members

Important Information