[Warm]

Hy everyone.
I have a problem with my hosted server. Server close sometimes and i have this errors from crashdetect ...

Код:

[15:13:32] [debug] Server crashed while executing GM.amx
[15:13:32] [debug] AMX backtrace:
[15:13:32] [debug] #0 0000565c in ?? () from GM.amx
[15:13:32] [debug] #1 00005a18 in ?? () from GM.amx
[15:13:32] [debug] #2 000164ec in public Streamer_OnPlayerConnect () from GM.amx
[15:13:32] [debug] #3 000014d0 in public OnPlayerConnect () from GM.amx
[15:13:32] [debug] System backtrace:
[15:13:32] [debug] #0 00e560f3 in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[15:13:32] [debug] #1 00e4db61 in _ZN11crashdetect20PrintSystemBacktraceEPv () from plugins/crashdetect.so
[15:13:32] [debug] #2 00e50405 in _ZN11crashdetect15SystemExceptionEPv () from plugins/crashdetect.so
[15:13:32] [debug] #3 00e55c42 in ?? () from plugins/crashdetect.so
[15:13:32] [debug] #4 0039d400 in ?? ()
[15:13:32] [debug] #5 0a0cbc3c in ?? () from *
а#S
[15:13:32] [debug] #6 0092999c in cli_advanced_command () from plugins/mysql.so
[15:13:32] [debug] #7 009079cd in mysql_ping () from plugins/mysql.so
[15:13:32] [debug] #8 00900282 in _ZN13CMySQLHandler4PingEv () from plugins/mysql.so
[15:13:32] [debug] #9 00e58267 in amx_Exec () from plugins/crashdetect.so
[15:13:32] [debug] #10 00e508b4 in _ZN11crashdetect9DoAmxExecEPii () from plugins/crashdetect.so
[15:13:32] [debug] #11 00e54203 in ?? () from plugins/crashdetect.so
[15:13:32] [debug] #12 080dc202 in ?? () from ./samp03svr
[15:13:32] [debug] #13 00e58267 in amx_Exec () from plugins/crashdetect.so
[15:13:32] [debug] #14 00e508b4 in _ZN11crashdetect9DoAmxExecEPii () from plugins/crashdetect.so
[15:13:32] [debug] #15 00e54203 in ?? () from plugins/crashdetect.so
[15:13:32] [debug] #16 080a3849 in ?? () from ./samp03svr
[15:13:32] [debug] #17 080cdadf in ?? () from ./samp03svr
[15:13:32] [debug] #18 080b2e82 in ?? () from ./samp03svr
[15:13:32] [debug] #19 08071ac8 in ?? () from ./samp03svr
[15:13:32] [debug] #20 08071bc2 in ?? () from ./samp03svr
[15:13:32] [debug] #21 0807ba20 in ?? () from ./samp03svr
[15:13:32] [debug] #22 080acbfd in ?? () from ./samp03svr
[15:13:32] [debug] #23 080acda2 in ?? () from ./samp03svr
[15:13:32] [debug] #24 080a81ae in ?? () from ./samp03svr
[15:13:32] [debug] #25 003b4d26 in __libc_start_main () from /lib/libc.so.6
[15:13:32] [debug] #26 0804b4a1 in ?? () from ./samp03svr

What cand i do ?

[CuervO]

If it's a MySQL Error, which version are you running? R37 has a fix included in the release notes which fixes random crashes caused by the SQL plugin.

[Warm]

I use R5 version. I downloaded the R7 version but i have some errors

Код:

C:\Documents and Settings\George\Desktop\pawno\include\streamer.inc(487) : warning 219: local variable "hitid" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4269) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4281) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4307) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4319) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4350) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4360) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4366) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4407) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4419) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4443) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4459) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4462) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4473) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4476) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4491) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4507) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4516) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4556) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4605) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4608) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4630) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4636) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4706) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4737) : warning 219: local variable "OToggleControl" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4817) : warning 204: symbol is assigned a value that is never used: "OToggleControl"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(6835) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(9622) : warning 219: local variable "veh" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(11329) : warning 219: local variable "carid" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21280) : warning 203: symbol is never used: "value"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21296) : warning 204: symbol is assigned a value that is never used: "PlayerSpeedDistance"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21969) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21980) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(45789) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(46457) : warning 219: local variable "string" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(59632) : error 035: argument type mismatch (argument 1)

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

can give me a download link for a better version ?

[CuervO]

It is always the best to have the latest versions of anything you use. People like me usually uses the last version and can only help with issues regarding the latest versions. Old versions are most likely no longer supported by anyone.

https://github.com/pBlueG/SA-MP-MySQL/releases
https://sampwiki.blast.hk/wiki/MySQL/R33

You will need to do a massive rewrital possibly by upgrading to R37.

[Warm]

I updated with last version but i have this errors ... and i don't know how to fix this errors is from latest version ...

Errors

Код:

C:\Documents and Settings\George\Desktop\pawno\include\streamer.inc(487) : warning 219: local variable "hitid" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4269) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4281) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4307) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4319) : error 017: undefined symbol "mysql_ping"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4350) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4360) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4366) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4407) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4419) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4443) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4459) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4462) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4473) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4476) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len")
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4491) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4507) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4516) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4556) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4605) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4608) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4630) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4636) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4706) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4737) : warning 219: local variable "OToggleControl" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(4817) : warning 204: symbol is assigned a value that is never used: "OToggleControl"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(6835) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(9622) : warning 219: local variable "veh" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(11329) : warning 219: local variable "carid" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21280) : warning 203: symbol is never used: "value"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21296) : warning 204: symbol is assigned a value that is never used: "PlayerSpeedDistance"
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21969) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(21980) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(45789) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(46457) : warning 219: local variable "string" shadows a variable at a preceding level
C:\Documents and Settings\George\Desktop\samp03\gamemodes\Godfather.pwn(59632) : error 035: argument type mismatch (argument 1)

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

From all of this i have the error

Код:

mysql_query(query);

[CuervO]

You did not even check the wiki, did you?

Here, let me do a lazy search for you:

Код:

mysql_query (conhandle, query[], bool:use_cache = true);

Those are the parameters needed for the mysql_query command.

[Warm]

You can give me an example how i use ? My MySQL system si old and I'm not a profi in MySQL.
(Sorry if is a stupid question, but ...)

[CuervO]

In all honestity I don't know how unthreaded queries work at mysql older versions. I only learned how to use threaded queries system by reading several tutorials:

This is an outdated guide on how to use cached data but only a few things were modified and it still works
https://sampforum.blast.hk/showthread.php?tid=337810

Another guide
https://sampforum.blast.hk/showthread.php?tid=129183

Another recent one
https://sampforum.blast.hk/showthread.php?tid=485633