1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Mysql errors
IndependentGaming
Gangsta
****
Posts: 674
Threads: 163
Joined: Oct 2012
Reputation: 0
#1

02.12.2014, 11:35
Hello, when i compile the server im getting 0 Warnings and Errors, but when i start the server and someone want to join it the server just go off and shows this in the logs:


Код:
#0 native mysql_real_escape_string () [10006af0] from mysql.dll
i tryed some mysql plugins but or it wont let me compile the gamemode or i get the same problem that the server is crashing.

callback loadplayer



Код:
stock AttemptPlayerLogin(playerid, passbuffer[]) {
	new
	    szQuery[225],
	    szPlayerName[MAX_PLAYER_NAME],
		szPlayerName2[MAX_PLAYER_NAME];

	GetPlayerName(playerid, szPlayerName, sizeof(szPlayerName));
	
	mysql_real_escape_string(szPlayerName, szPlayerName2, g_MySQLConnections[0]);

	format(szQuery, sizeof(szQuery), "SELECT * FROM players WHERE Username = '%s' AND Password = '%s'", szPlayerName2, passbuffer);
	mysql_query(szQuery, THREAD_LOGIN_ATTEMPT, playerid, g_MySQLConnections[0]);
	return 1;
}
Find
Reply
Steve Habbz
Big Clucker
***
Posts: 55
Threads: 10
Joined: Feb 2012
Reputation: 0
#2

02.12.2014, 11:52
What plugin do you use ?
Find
Reply
IndependentGaming
Gangsta
****
Posts: 674
Threads: 163
Joined: Oct 2012
Reputation: 0
#3

02.12.2014, 11:56
Mysql R5 i tryed R33 >> R39-2 not working at all
Find
Reply
Steve Habbz
Big Clucker
***
Posts: 55
Threads: 10
Joined: Feb 2012
Reputation: 0
#4

02.12.2014, 12:00
MYSQL R39-2
Download the new one and I tell you how to work it .
Find
Reply
Steve Habbz
Big Clucker
***
Posts: 55
Threads: 10
Joined: Feb 2012
Reputation: 0
#5

02.12.2014, 12:04
Can you give me the mysql log file ?
Find
Reply
IndependentGaming
Gangsta
****
Posts: 674
Threads: 163
Joined: Oct 2012
Reputation: 0
#6

02.12.2014, 12:09
Код:
[01/12/2014 12:45:06] [debug] Server crashed while executing Roleplay.amx
[01/12/2014 12:45:06] [debug] AMX backtrace:
[01/12/2014 12:45:06] [debug] #0 native mysql_real_escape_string () [10006af0] from mysql.dll
[01/12/2014 12:45:06] [debug] #1 001f920c in public Login () from Roleplay.amx
[01/12/2014 12:45:06] [debug] System backtrace:
[01/12/2014 12:45:06] [debug] #0 71dd4951 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_50916076bcb9a742\MSVCR90.dll
[01/12/2014 12:45:06] [debug] #1 71dd4996 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_50916076bcb9a742\MSVCR90.dll
[01/12/2014 12:45:06] [debug] #2 10005b71 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #3 10005d7d in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #4 10008bd8 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #5 10006bd6 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #6 004010b6 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #7 71a339e2 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #8 71a35e26 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #9 71a2bf3f in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #10 71a33a0e in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #11 0047f038 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #12 0048b51a in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #13 004877cb in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #14 00496281 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #15 00496291 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #16 ffc30000 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #17 e8042474 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #18 ffffffbf in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #19 c01bd8f7 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #20 4859d8f7 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #21 247c83c3 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #22 06740008 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #23 412d01c6 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #24 8b56d8f7 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #25 f7d233f1 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #26 83082474 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #27 057609fa in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #28 eb57c280 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #29 30c28003 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #30 85411188 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #31 c6e677c0 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #32 8a490001 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #33 88018a16 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #34 06884911 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #35 72f13b46 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #36 55c35ef2 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #37 7d83ec8b in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #38 458b0a10 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #39 850a7508 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #40 6a067dc0 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #41 eb0a6a01 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #42 ff006a05 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #43 4d8b1075 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #44 ff9fe80c in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #45 458bffff in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #46 5d59590c in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #47 244c8bc3 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #48 24448b08 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #49 ff006a04 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #50 e8102474 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #51 ffffff85 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #52 1024448b in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #53 e8c35959 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
There ya go and like i said i tryed R33>>> R39-2 they aren't working
Find
Reply
Steve Habbz
Big Clucker
***
Posts: 55
Threads: 10
Joined: Feb 2012
Reputation: 0
#7

02.12.2014, 12:12
Quote:
Originally Posted by hwakinsRP
Посмотреть сообщение
Код:
[01/12/2014 12:45:06] [debug] Server crashed while executing Roleplay.amx
[01/12/2014 12:45:06] [debug] AMX backtrace:
[01/12/2014 12:45:06] [debug] #0 native mysql_real_escape_string () [10006af0] from mysql.dll
[01/12/2014 12:45:06] [debug] #1 001f920c in public Login () from Roleplay.amx
[01/12/2014 12:45:06] [debug] System backtrace:
[01/12/2014 12:45:06] [debug] #0 71dd4951 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_50916076bcb9a742\MSVCR90.dll
[01/12/2014 12:45:06] [debug] #1 71dd4996 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_50916076bcb9a742\MSVCR90.dll
[01/12/2014 12:45:06] [debug] #2 10005b71 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #3 10005d7d in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #4 10008bd8 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #5 10006bd6 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\mysql.dll
[01/12/2014 12:45:06] [debug] #6 004010b6 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #7 71a339e2 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #8 71a35e26 in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #9 71a2bf3f in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #10 71a33a0e in ?? () from C:\Users\customer\Desktop\Roleplay\plugins\crashdetect.DLL
[01/12/2014 12:45:06] [debug] #11 0047f038 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #12 0048b51a in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #13 004877cb in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #14 00496281 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #15 00496291 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #16 ffc30000 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #17 e8042474 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #18 ffffffbf in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #19 c01bd8f7 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #20 4859d8f7 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #21 247c83c3 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #22 06740008 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #23 412d01c6 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #24 8b56d8f7 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #25 f7d233f1 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #26 83082474 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #27 057609fa in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #28 eb57c280 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #29 30c28003 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #30 85411188 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #31 c6e677c0 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #32 8a490001 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #33 88018a16 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #34 06884911 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #35 72f13b46 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #36 55c35ef2 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #37 7d83ec8b in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #38 458b0a10 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #39 850a7508 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #40 6a067dc0 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #41 eb0a6a01 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #42 ff006a05 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #43 4d8b1075 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #44 ff9fe80c in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #45 458bffff in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #46 5d59590c in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #47 244c8bc3 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #48 24448b08 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #49 ff006a04 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #50 e8102474 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #51 ffffff85 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #52 1024448b in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
[01/12/2014 12:45:06] [debug] #53 e8c35959 in ?? () from C:\Users\customer\Desktop\Roleplay\samp-server.exe
There ya go and like i said i tryed R33>>> R39-2 they aren't working
Hmm, I think it a bug on that version ._.
Find
Reply
IndependentGaming
Gangsta
****
Posts: 674
Threads: 163
Joined: Oct 2012
Reputation: 0
#8

02.12.2014, 12:22
What can i do with that i need help to fix it i already know its not qorking..
Find
Reply
Lordzy
High-roller
*****
Posts: 2,698
Threads: 37
Joined: Mar 2012
Reputation: 0
#9

02.12.2014, 12:42
Are you sure the mysql version used for compiling the script is equal to the plugin's version?
Find
Reply
IndependentGaming
Gangsta
****
Posts: 674
Threads: 163
Joined: Oct 2012
Reputation: 0
#10

02.12.2014, 12:46
Yes im getting 0 warnings and errors
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help