[Kebab-]

Hello,
I've been experiencing some server difficulties since I've updated my server to 0.3x from 0.3e. It appears as if my server crashes unexpectedly and without an error. By crashing, I mean shutting the console down without a notice. I'm unsure of the problem. Could anyone help me? I've updated sscanf and the streamer to the latest version and recompiled all my filterscripts which are in use and my gamemode.

I'd like to point out that I am hosting on a Windows VPS and the server uses MySQL for data storage (plugin with a_mysql.inc). I am using version R6 and well aware that I believe you don't need to update it.

Is there a possibility the server shuts itself down if it loses connection to the MySQL server?

Thanks so much for all your support,
Kebab-.

[MattyG]

Have you checked your server log?
Try changing your rcon password in your server.cfg.

[Kebab-]

I've checked the logs and no error was found and no rcon logins were made. The server doesn't crash on a specific command either.

[Hanger]

Add crashdetect plugin and do the same stuff you did when it crashed. Then post the log in here or sort it out yourself.

[Kebab-]

Logs from crash detect

Quote:

[02/04/2013 22:01:37] [debug] Server crashed while executing server.amx [02/04/2013 22:01:37] [debug] AMX backtrace: [02/04/2013 22:01:37] [debug] #0 native mysql_real_escape_string () [10006af0] from mysql.dll [02/04/2013 22:01:37] [debug] #1 001d97c4 in ?? () from server.amx [02/04/2013 22:01:37] [debug] #2 001d8d24 in ?? () from server.amx [02/04/2013 22:01:37] [debug] #3 00005620 in public Itter_OnPlayerDisconnect () from server.amx [02/04/2013 22:01:37] [debug] #4 native CallLocalFunction () [00471e90] from samp-server.exe [02/04/2013 22:01:37] [debug] #5 00001a00 in ?? () from server.amx [02/04/2013 22:01:37] [debug] #6 000012f8 in public OnPlayerDisconnect () from server.amx [02/04/2013 22:01:37] [debug] System backtrace: [02/04/2013 22:01:38] [debug] #0 785546f1 in vsnprintf_l () from C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a 1e18e3b_9.0.21022.8_x-ww_D08D0375\MSVCR90.dll [02/04/2013 22:01:38] [debug] #1 78554736 in vsnprintf () from C:\WINDOWS\WinSxS\x86_Microsoft.VC90.CRT_1fc8b3b9a 1e18e3b_9.0.21022.8_x-ww_D08D0375\MSVCR90.dll [02/04/2013 22:01:38] [debug] #2 10005b71 in ?? () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\mysql.dll [02/04/2013 22:01:38] [debug] #3 10005d7d in ?? () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\mysql.dll [02/04/2013 22:01:38] [debug] #4 10008bd8 in Unload () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\mysql.dll [02/04/2013 22:01:38] [debug] #5 10006bd6 in ?? () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\mysql.dll [02/04/2013 22:01:38] [debug] #6 004010b6 in ?? () from C:\Documents and Settings\Administrator\My Documents\Server\test\samp-server.exe [02/04/2013 22:01:38] [debug] #7 00f0340a in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #8 00f05aa6 in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #9 00efd621 in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #10 00f0345a in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #11 0047219e in ?? () from C:\Documents and Settings\Administrator\My Documents\Server\test\samp-server.exe [02/04/2013 22:01:38] [debug] #12 004010b6 in ?? () from C:\Documents and Settings\Administrator\My Documents\Server\test\samp-server.exe [02/04/2013 22:01:38] [debug] #13 00f0340a in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #14 00f05aa6 in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #15 00efd621 in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #16 00f0345a in Load () from C:\Documents and Settings\Administrator\My Documents\Server\test\plugins\crashdetect.dll [02/04/2013 22:01:38] [debug] #17 0046c8cb in ?? () from C:\Documents and Settings\Administrator\My Documents\Server\test\samp-server.exe

[Konstantinos]

The server probably crashed while executing mysql_real_escape_string. Can you show us the OnPlayerDisconnect callback?

[Kebab-]

Mysql_real_escape_string doesn't exist in the OnPlayerDisconnect callback. Id happly post the call back but I am currently working offline and only have internet access on my phone. May the problem be that it doesn't exist?

[Konstantinos]

It doesn't exist in the callback, but when you call something to check if a player is registered and then save his data, you may use it. If you don't find anything, then just PM me to help you.