[Nin9r]

My server is restarting sometime...


This is the server_log.txt when my server was restarted..

Code:

[13:57:02] [debug] Server crashed while executing gmi.amx
[13:57:02] [debug] AMX backtrace:
[13:57:02] [debug] #0 native mysql_query () from mysql_static.so
[13:57:02] [debug] #1 00197034 in public globalPlayerLoop2 () at D:\server\gamemodesgmi.pwn:28455
[13:57:02] [debug] Native backtrace:
[13:57:02] [debug] #0 f74a1e8b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[13:57:02] [debug] #1 f749abcf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[13:57:02] [debug] #2 f749bdbc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[13:57:02] [debug] #3 f749c226 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[13:57:02] [debug] #4 f74a1adc in ?? () from plugins/crashdetect.so
[13:57:02] [debug] #5 f778f410 in ?? ()
[13:57:02] [debug] #6 f75dda9f in ?? () from /lib32/libc.so.6
[13:57:02] [debug] #7 f6ee8254 in _ZN11CMySQLQuery11StoreResultEP8st_mysqlP12st_mysql_res () from plugins/mysql_static.so
[13:57:02] [debug] #8 f6ee8657 in _ZN11CMySQLQuery7ExecuteEP8st_mysql () from plugins/mysql_static.so
[13:57:02] [debug] #9 f6ef8693 in _ZN6Native11mysql_queryEP6tagAMXPi () from plugins/mysql_static.so
[13:57:02] [debug] #10 080950e4 in ?? () from samp03svr
[13:57:02] [debug] #11 f73fd0b5 in ?? () from plugins/streamer.so
[13:57:02] [debug] #12 f749d94b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so
[13:57:02] [debug] #13 f74a08f8 in ?? () from plugins/crashdetect.so
[13:57:02] [debug] #14 f74a4916 in amx_Exec () from plugins/crashdetect.so
[13:57:02] [debug] #15 f749cbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so
[13:57:02] [debug] #16 f74a0659 in ?? () from plugins/crashdetect.so
[13:57:02] [debug] #17 f73fd173 in ?? () from plugins/streamer.so
[13:57:02] [debug] #18 080ebc05 in ?? () from samp03svr
[13:57:02] [debug] #19 080af03c in ?? () from samp03svr
[13:57:02] [debug] #20 080aa13a in ?? () from samp03svr
[13:57:02] [debug] #21 f74dbbd6 in __libc_start_main () from /lib32/libc.so.6
[13:57:02] [debug] #22 0804b4e1 in ?? () from samp03svr

Any ideas?

Line 28455:

Code:

new Cache: result7 = mysql_query (handle, "SELECT * FROM `players` ORDER BY `players`.`playerID` ASC");

Entire code:

Code:

new text69[256];
	new text6969[256];
	new text68[256];
	new da;
	new Cache: result7 = mysql_query (handle, "SELECT * FROM `players` ORDER BY `players`.`playerID` ASC");
 	for ( new i, j = cache_get_row_count ( ); i != j; ++i )
	{
       	cache_get_field_content(i, "text", text69);
       	cache_get_field_content(i, "text2", text6969); da = strval(text6969);
       	if(!isnull(text69) && da >= 1)
		{
			format(szMessage, sizeof(szMessage), text69);
			SCMTA(COLOR_LIGHTRED, szMessage);

			format(text68, 256, "UPDATE players SET text2 = 0 WHERE playerID = %d",da);
			mysql_tquery(handle, text68);
		}
    }
	cache_delete(result7);