[system39]

Hello all! I haven't been playing and interesting with SA:MP for very long time. Before I've closed my server I've saved this mod but it's not working anymore. There's tons of errors. I'll be very glad if anyone can help me. Regards...

"If anyone can help me, I'll be very happy. And If you guys solve this, I want to gift a Steam game to you guys."

Code:

C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(2553) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(2554) : error 017: undefined symbol "mysql_store_result"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(2555) : error 017: undefined symbol "mysql_num_rows"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(3091) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5791) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5792) : error 017: undefined symbol "mysql_store_result"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5793) : error 017: undefined symbol "mysql_num_rows"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5796) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5800) : error 017: undefined symbol "mysql_get_field"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5826) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5827) : error 017: undefined symbol "mysql_store_result"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5828) : error 017: undefined symbol "mysql_num_rows"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5831) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(5835) : error 017: undefined symbol "mysql_get_field"
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7022) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7047) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7072) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7098) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7123) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7148) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7173) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7199) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7225) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7250) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7276) : error 035: argument type mismatch (argument 1)
C:\Users\SAMAEL\Desktop\Deneme Roleplay\Son Umut\gamemodes\imrp.pwn(7302) : error 035: argument type mismatch (argument 1)

[antixgaming]

Maybe you are missing an include? Show us the code.

[system39]

Here's error 2553:

I know it's very hard to do but if you really want to help me I can send gamemode.pwn to you. I need this.

Code:

	new query[128];
	format(query, sizeof(query), "SELECT * FROM cpler WHERE yarisID = '%d' AND tip = '3' AND sira = '%d'",Yarista[playerid], CPSira[playerid]+2);
	mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {

[SymonClash]

Quote:

undefined symbol "mysql_...

You're probably using an incorrect/old MySQL version. Do you mind to say which?

About the rest of errors, show us the lines.

[system39]

SymonClash, thanks for you answer. Actually I don't know which MySQL version I use because the gamemod is about 2 years old. It's still 0.3z or something close to that. I'm trying to use different version and variations on the server files but result is same. I'm trying but I can not make work the server with old versions. Also, upgrading MySQL did not helped me. There's tons of errors before I mentioned. So, I'm sharing the gamemod with all files. It's Non-English gamemod but there's nothing about the errors of language. If anyone can help me, I'll be very happy. And If you guys solve this, I want to gift a Steam game to you guys.

My Regards.

[system39]

Any idea?

Code:

[00:00:11] [debug] Server crashed while executing imrp.amx
[00:00:11] [debug] AMX backtrace:
[00:00:11] [debug] #0 native mysql_fetch_field_row () in mysql.DLL
[00:00:11] [debug] #1 000aa244 in public OnQueryFinish (80354012, 8, -1, 1) in imrp.amx
[00:00:11] [debug] Native backtrace:
[00:00:11] [debug] #0 717db9f0 in ?? () in C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9415_none_508df7e2bcbccb90\MSVCR90.dll
[00:00:11] [debug] #1 10009abe in ?? () in plugins\mysql.DLL
[00:00:11] [debug] #2 100067e3 in ?? () in plugins\mysql.DLL
[00:00:11] [debug] #3 004010b6 in ?? () in samp-server.exe
[00:00:11] [debug] #4 7168dc92 in ?? () in plugins\crashdetect.DLL
[00:00:11] [debug] #5 71695318 in ?? () in plugins\crashdetect.DLL
[00:00:11] [debug] #6 716897cc in ?? () in plugins\crashdetect.DLL
[00:00:11] [debug] #7 7168dcf4 in ?? () in plugins\crashdetect.DLL
[00:00:11] [debug] #8 100086d7 in ?? () in plugins\mysql.DLL
[00:00:11] [debug] #9 00469a66 in ?? () in samp-server.exe
[00:00:11] [debug] #10 0048d4db in ?? () in samp-server.exe
[00:00:11] [debug] #11 0049b4a1 in ?? () in samp-server.exe
[00:00:11] [debug] #12 0049b4b1 in ?? () in samp-server.exe
[00:00:11] [debug] Registers:
[00:00:11] [debug] EAX: 0a84c048 EBX: 056ca3f8 ECX: 00000000 EDX: 02767190
[00:00:11] [debug] ESI: 0019fa80 EDI: 0298fd38 EBP: 0049b4a1 ESP: 0019fe98
[00:00:11] [debug] EIP: 0049b4b1 EFLAGS: 00010246
[00:00:11] [debug] Stack:
[00:00:11] [debug] ESP+00000000: 004ab4a0 0019ff70 004ab0e1 ffffffff
[00:00:11] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0
[00:00:11] [debug] ESP+00000040: 00000000 00000000 00000000 00000000
[00:00:11] [debug] ESP+00000060: 00000000 00000000 00000000 00000000
[00:00:11] [debug] ESP+00000080: 00000000 00000000 00000000 00000000
[00:00:11] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000
[00:00:11] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000
[00:00:11] [debug] ESP+000000e0: 004ba530 00000000 0019ff94 77888494
[00:00:11] [debug] ESP+00000100: 77de41c8 002e5000 f6f600f0 00000000
[00:00:11] [debug] ESP+00000120: 00000000 00000000 f6f600f0 0019ffa0
[00:00:11] [debug] ESP+00000140: 00000000 0019ffec 77de4198 ffffffff
[00:00:11] [debug] ESP+00000160: 002e5000 00000000 78746341 00000020
[00:00:11] [debug] ESP+00000180: 00000020 00000000 00000014 00000001
[00:00:11] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000
[00:00:11] [debug] ESP+000001c0: 00000044 000002e0 0000025c 00000000
[00:00:11] [debug] ESP+000001e0: 00000342 00000000 2d59495b 000008cc
[00:00:11] [debug] ESP+00000200: 32ceeacd 00000bfc 00000042 00000c40
[00:00:11] [debug] ESP+00000220: 0000005e 00000fd0 00000362 00000000
[00:00:11] [debug] ESP+00000240: 00000392 00000010 00000009 000000ec
[00:00:11] [debug] ESP+00000260: 00000001 00000002 00001758 000007a0
[00:00:11] [debug] ESP+00000280: 00000001 00000004 00002d84 00000314
[00:00:11] [debug] ESP+000002a0: 00000002 00000006 00003130 000000cc
[00:00:11] [debug] ESP+000002c0: 00000001 00000009 000032ec 00000028
[00:00:11] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001
[00:00:11] [debug] ESP+00000300: 00000001 000015a4 0000002c 0000005e
[00:00:11] [debug] ESP+00000320: 00000000 00000000 00000000 00000000
[00:00:11] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c
[00:00:11] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000
[00:00:11] [debug] ESP+00000380: 0000025c 00000001 f33271ba 000003c0
[00:00:11] [debug] ESP+000003a0: 2d59495b 00000750 00000032 00000784
[00:00:11] [debug] ESP+000003c0: 00000042 00000ac4 00000330 00000004
[00:00:11] [debug] ESP+000003e0: 00000362 00000005 b1280544 000011b8
[00:00:11] [debug] Loaded modules:
[00:00:11] [debug] 00400000 - 00519000 samp-server.exe
[00:00:11] [debug] 77d80000 - 77f10000 ntdll.dll
[00:00:11] [debug] 77870000 - 77950000 KERNEL32.DLL
[00:00:11] [debug] 71910000 - 71920000 aswhook.dll
[00:00:11] [debug] 74720000 - 74904000 KERNELBASE.dll
[00:00:11] [debug] 760d0000 - 7741a000 SHELL32.dll
[00:00:11] [debug] 74660000 - 7471f000 msvcrt.dll
[00:00:11] [debug] 77830000 - 77869000 cfgmgr32.dll
[00:00:11] [debug] 77710000 - 7782d000 ucrtbase.dll
[00:00:11] [debug] 74d70000 - 74df8000 shcore.dll
[00:00:11] [debug] 753c0000 - 75480000 RPCRT4.dll
[00:00:11] [debug] 74640000 - 74660000 SspiCli.dll
[00:00:11] [debug] 74630000 - 7463a000 CRYPTBASE.dll
[00:00:11] [debug] 75900000 - 75958000 bcryptPrimitives.dll
[00:00:11] [debug] 76060000 - 760a4000 sechost.dll
[00:00:11] [debug] 77980000 - 77bdc000 combase.dll
[00:00:11] [debug] 74e00000 - 753ba000 windows.storage.dll
[00:00:11] [debug] 75fe0000 - 76058000 advapi32.dll
[00:00:11] [debug] 75f80000 - 75fc5000 shlwapi.dll
[00:00:11] [debug] 77950000 - 77972000 GDI32.dll
[00:00:11] [debug] 74b10000 - 74c74000 gdi32full.dll
[00:00:11] [debug] 75510000 - 7558d000 msvcp_win.dll
[00:00:11] [debug] 75590000 - 7571d000 USER32.dll
[00:00:11] [debug] 759e0000 - 759f7000 win32u.dll
[00:00:11] [debug] 75720000 - 7572f000 kernel.appcore.dll
[00:00:11] [debug] 760b0000 - 760c8000 profapi.dll
[00:00:11] [debug] 75e30000 - 75e75000 powrprof.dll
[00:00:11] [debug] 77c80000 - 77c88000 FLTLIB.DLL
[00:00:11] [debug] 73ef0000 - 73ef8000 WSOCK32.dll
[00:00:11] [debug] 75970000 - 759d7000 WS2_32.dll
[00:00:11] [debug] 71950000 - 71974000 WINMM.dll
[00:00:11] [debug] 70810000 - 70833000 WINMMBASE.dll
[00:00:11] [debug] 74ce0000 - 74d06000 IMM32.DLL
[00:00:11] [debug] 10000000 - 10013000 mysql.DLL
[00:00:11] [debug] 717a0000 - 71843000 MSVCR90.dll
[00:00:11] [debug] 71710000 - 7179e000 MSVCP90.dll
[00:00:11] [debug] 02500000 - 0273e000 LIBMYSQL.dll
[00:00:11] [debug] 71e20000 - 71e31000 napinsp.dll
[00:00:11] [debug] 71e00000 - 71e16000 pnrpnsp.dll
[00:00:11] [debug] 71de0000 - 71df3000 NLAapi.dll
[00:00:11] [debug] 73970000 - 739c6000 mswsock.dll
[00:00:11] [debug] 732e0000 - 7336e000 DNSAPI.dll
[00:00:11] [debug] 74d60000 - 74d67000 NSI.dll
[00:00:11] [debug] 744e0000 - 74510000 IPHLPAPI.DLL
[00:00:11] [debug] 71dd0000 - 71ddc000 winrnr.dll
[00:00:11] [debug] 718f0000 - 71901000 wshbth.dll
[00:00:11] [debug] 732d0000 - 732d8000 rasadhlp.dll
[00:00:11] [debug] 716d0000 - 7170f000 streamer.DLL
[00:00:11] [debug] 53ad0000 - 53b39000 MSVCP100.dll
[00:00:11] [debug] 53a10000 - 53acf000 MSVCR100.dll
[00:00:11] [debug] 005c0000 - 005cc000 sscanf.DLL
[00:00:11] [debug] 71670000 - 716c1000 crashdetect.DLL
[00:00:11] [debug] 73280000 - 732cf000 fwpuclnt.dll
[00:00:11] [debug] 74510000 - 74529000 bcrypt.dll
[00:00:11] [debug] 73180000 - 731fc000 uxtheme.dll
[00:00:11] [debug] 74910000 - 74a0c000 ole32.dll
[00:00:11] [debug] 74360000 - 744e0000 PROPSYS.dll
[00:00:11] [debug] 77be0000 - 77c76000 OLEAUT32.dll
[00:00:11] [debug] 75480000 - 75503000 clbcatq.dll
[00:00:11] [debug] 5f520000 - 5f848000 OneCoreUAPCommonProxyStub.dll
[00:00:11] [debug] 718b0000 - 718ed000 edputil.dll
[00:00:11] [debug] 61ea0000 - 61f2b000 Windows.StateRepositoryPS.dll
[00:00:11] [debug] 73370000 - 7350d000 urlmon.dll
[00:00:11] [debug] 73540000 - 73768000 iertutil.dll
[00:00:11] [debug] 71890000 - 718aa000 CLDAPI.dll
[00:00:11] [debug] 6e640000 - 6e716000 WinTypes.dll

[SymonClash]

Open /pawno/include/a_mysql.inc, there you can find your MySQL version.

Also seems there is a problem on OnQueryFinish callback.

[raydx]

Looks like this version:

https://github.com/AndreT/samp-vorte...de/a_mysql.inc

Try to replace it with your a_mysql.inc

[solstice_]

You're using an old MySQL version.

Quote:

Originally Posted by SymonClash Open /pawno/include/a_mysql.inc, there you can find your MySQL version. Also seems there is a problem on OnQueryFinish callback.

Because OnQueryFinish was removed.
https://github.com/pBlueG/SA-MP-MySQL/issues/118

[Verc]

mysql_store_result only exists in R5-R7 version of MySQL plugin.