1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support

Threaded Mode
Localhost server shutting down
Affan
Huge Clucker
****
Posts: 390
Threads: 65
Joined: Dec 2012
Reputation: 0
#1

07.08.2014, 17:13
( Последний раз редактировалось Affan; 08.08.2014 в 03:16. )
So I have been working on a filterscript, and I haven't tested it out yet. After finishing the main systems, I decided to test it out and the samp-server.exe keeps shutting down after a while. Any help?

Код:
SA-MP Server: 0.3z



Exception At Address: 0x100090A0 Module: (mysql.DLL)



Registers:

EAX: 0x0196E158	EBX: 0x027B12B0	ECX: 0x00000000	EDX: 0x01966540

ESI: 0x01620638	EDI: 0x01620638	EBP: 0x0012FD80	ESP: 0x0012FB00

EFLAGS: 0x00010202



Stack:

+0000: 0x0196E158   0x0000000A   0x13AB5B78   0x0012FBDC

+0010: 0x7771E115   0x0196E138   0x0196E148   0x0196EFF0

+0020: 0x00000000   0x000003F8   0x00000400   0x01FCA82A

+0030: 0x01FCA828   0x00078000   0x00000000   0x0000000F

+0040: 0x000000C2   0x0012FB00   0x7772942B   0x01C549D0

+0050: 0x00000042   0x00000000   0x0000000F   0x000000C2

+0060: 0x00002500   0x01C52498   0x000004A7   0x01C50290

+0070: 0x00000000   0x0000000F   0x00002528   0x00000200

+0080: 0x000000C3   0x000000C2   0x00002528   0x00000000

+0090: 0x0000000F   0x00000000   0x00000000   0x01FCA830

+00A0: 0x01F101F8   0x01297F30   0x00000000   0x0000000F

+00B0: 0x0000007B   0x00000000   0x00000000   0x00000000

+00C0: 0x01F10200   0x00000000   0x0000000F   0x01298328

+00D0: 0x00000000   0x00000000   0x00000029   0x01FCAC18

+00E0: 0x00000000   0x0000000F   0x01FCA830   0x00000000

+00F0: 0x0000007D   0x77752FE7   0x75706F94   0x00000000

+0100: 0x0000000F   0x01290000   0x00050000   0x00000001

+0110: 0x0129F580   0x0000000D   0x00000000   0x0000000F

+0120: 0x00020029   0x00000000   0x00000006   0x00000001

+0130: 0x00000000   0x00000000   0x0000000F   0x004F1404



--------------------------



Loaded Modules:

samp-server.exe	A: 0x00400000 - 0x004F5000	(C:\Users\user\Desktop\Project Innovative\samp-server.exe)

ntdll.dll	A: 0x77700000 - 0x7783C000	(C:\Windows\SYSTEM32\ntdll.dll)

kernel32.dll	A: 0x760F0000 - 0x761C4000	(C:\Windows\system32\kernel32.dll)

KERNELBASE.dll	A: 0x75A10000 - 0x75A5B000	(C:\Windows\system32\KERNELBASE.dll)

SHELL32.dll	A: 0x76790000 - 0x773DA000	(C:\Windows\system32\SHELL32.dll)

msvcrt.dll	A: 0x75F40000 - 0x75FEC000	(C:\Windows\system32\msvcrt.dll)

SHLWAPI.dll	A: 0x75E50000 - 0x75EA7000	(C:\Windows\system32\SHLWAPI.dll)

GDI32.dll	A: 0x75AA0000 - 0x75AEE000	(C:\Windows\system32\GDI32.dll)

USER32.dll	A: 0x75CF0000 - 0x75DB9000	(C:\Windows\system32\USER32.dll)

LPK.dll	A: 0x773E0000 - 0x773EA000	(C:\Windows\system32\LPK.dll)

USP10.dll	A: 0x76020000 - 0x760BD000	(C:\Windows\system32\USP10.dll)

WSOCK32.dll	A: 0x6B4A0000 - 0x6B4A7000	(C:\Windows\system32\WSOCK32.dll)

WS2_32.dll	A: 0x761E0000 - 0x76215000	(C:\Windows\system32\WS2_32.dll)

RPCRT4.dll	A: 0x775B0000 - 0x77652000	(C:\Windows\system32\RPCRT4.dll)

NSI.dll	A: 0x765C0000 - 0x765C6000	(C:\Windows\system32\NSI.dll)

WINMM.dll	A: 0x73C40000 - 0x73C72000	(C:\Windows\system32\WINMM.dll)

IMM32.DLL	A: 0x760D0000 - 0x760EF000	(C:\Windows\system32\IMM32.DLL)

MSCTF.dll	A: 0x76220000 - 0x762EC000	(C:\Windows\system32\MSCTF.dll)

mysql.DLL	A: 0x10000000 - 0x10015000	(C:\Users\user\Desktop\Project Innovative\plugins\mysql.DLL)
Fixed it, by using

pawn Код:
mysql_tquery(chandle, query, "", "d", playerid);
to

pawn Код:
mysql_tquery(chandle, query);
Find
Reply
iAnonymous
Gangsta
*****
Posts: 757
Threads: 36
Joined: Jun 2013
Reputation: 0
#2

07.08.2014, 17:18
Server_log.txt please
Find
Reply
Affan
Huge Clucker
****
Posts: 390
Threads: 65
Joined: Dec 2012
Reputation: 0
#3

07.08.2014, 17:21
Код:
SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[22:11:29] 
[22:11:29] Server Plugins
[22:11:29] --------------
[22:11:29]  Loading plugin: mysql
[22:11:29] 

  > MySQL plugin R7 successfully loaded.

[22:11:29]   Loaded.
[22:11:29]  Loading plugin: sscanf
[22:11:29] 

[22:11:29]  ===============================

[22:11:29]       sscanf plugin loaded.     

[22:11:30]          Version:  2.8.1        

[22:11:30]    © 2012 Alex "******" Cole  

[22:11:30]  ===============================

[22:11:30]   Loaded.
[22:11:30]  Loading plugin: streamer
[22:11:30] 

*** Streamer Plugin v2.7.2 by Incognito loaded ***

[22:11:30]   Loaded.
[22:11:30]  Loading plugin: Whirlpool
[22:11:30]  
[22:11:30]  ==================
[22:11:30]  
[22:11:30]   Whirlpool loaded
[22:11:30]  
[22:11:30]  ==================
[22:11:30]  
[22:11:30]   Loaded.
[22:11:30]  Loading plugin: nativechecker
[22:11:30]   Loaded.
[22:11:30]  Loaded 5 plugins.

[22:11:30] 
[22:11:30] Filterscripts
[22:11:30] ---------------
[22:11:30]   Loading filterscript 'admin.amx'...
[22:11:30]  
[22:11:30]  
[22:11:30]  
[22:11:30]  ======================================= 
[22:11:30]  |                                     | 
[22:11:30]  |        YSI version 3.09.0684        | 
[22:11:30]  |        By Alex "******" Cole        | 
[22:11:30]  |                                     | 
[22:11:30]  ======================================= 
[22:11:30]  
[22:11:30] 
--------------------------------------
[22:11:30]  Admin System by Affan - Loaded
[22:11:30] --------------------------------------

[22:11:30]   Loaded 1 filterscripts.

[22:11:30] 
---------------------------------------
[22:11:30] Running Grand Larceny - by the SA-MP team

[22:11:30] ---------------------------------------

[22:11:30] Number of vehicle models: 0
[22:11:31]  
[22:11:31]  ========================================== 
[22:11:31]  |                                        | 
[22:11:31]  |  A new version (v<html>
  ) of YSI is  | 
[22:11:31]  |            available from:             | 
[22:11:31]  |                                        | 
[22:11:31]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
[22:11:31]  |                                        | 
[22:11:31]  ========================================== 
[22:11:31]
Find
Reply
1FreeHost
Banned
Posts: 265
Threads: 17
Joined: Jan 2014
#4

07.08.2014, 18:34
Have you downloaded and added crash detect?
And see what it says.
Find
Reply
Affan
Huge Clucker
****
Posts: 390
Threads: 65
Joined: Dec 2012
Reputation: 0
#5

08.08.2014, 01:56
( Последний раз редактировалось Affan; 08.08.2014 в 03:00. )
Quote:
Originally Posted by 1FreeHost
Посмотреть сообщение
Have you downloaded and added crash detect?
And see what it says.
Код:
[07:53:54] [debug] Server crashed while executing admin.amx
[07:53:54] [debug] AMX backtrace:
[07:53:54] [debug] #0 native mysql_tquery () [67e0f180] from mysql.DLL
[07:53:54] [debug] #1 0000bc58 in public SaveStats () from admin.amx
[07:53:54] [debug] Native backtrace:
[07:53:54] [debug] #0 67df226a in ?? () from plugins\mysql.DLL
[07:53:54] [debug] #1 67e0f628 in ?? () from plugins\mysql.DLL
[07:53:54] [debug] #2 004010b6 in ?? () from samp-server.exe
[07:53:54] [debug] #3 6720543a in ?? () from plugins\crashdetect.DLL
[07:53:54] [debug] #4 6720728f in ?? () from plugins\crashdetect.DLL
[07:53:54] [debug] #5 671f9d54 in ?? () from plugins\crashdetect.DLL
[07:53:54] [debug] #6 6720548a in ?? () from plugins\crashdetect.DLL
[07:53:54] [debug] #7 0047f038 in ?? () from samp-server.exe
[07:53:54] [debug] #8 0048b51a in ?? () from samp-server.exe
[07:53:54] [debug] #9 004877cb in ?? () from samp-server.exe
[07:53:54] [debug] #10 00496281 in ?? () from samp-server.exe
[07:53:54] [debug] #11 00496291 in ?? () from samp-server.exe
Edit;
Here is the savestats
pawn Код:
public SaveStats(playerid)
{
    new query[500], query2[200], Float:x, Float:y, Float:z, Float:a, pvw, pinterior, pskin, pscore, pmoney, year, month, day;
    GetPlayerFacingAngle(playerid, a);
    GetPlayerPos(playerid, x, y, z);
    pvw = GetPlayerVirtualWorld(playerid);
    pinterior = GetPlayerInterior(playerid);
    pskin = GetPlayerSkin(playerid);
    pscore = GetPlayerScore(playerid);
    pmoney = GetPlayerMoney(playerid);
    getdate(year, month, day);
    mysql_format(chandle, query, sizeof(query), "UPDATE `players` SET `Rank` = '%d', `VIP` = '%d', `Skin` = '%d', `Score` = '%d', `Money` = '%d', `xPos` = '%f', `yPos` = '%f', `zPos` = '%f', `aPos` = '%f', `vw` = '%d', `interior` = '%d', `LastOnlineDate` = '%d/%d/%d' WHERE `Username` = '%e'",
                                                        pInfo[playerid][rank], pInfo[playerid][vip], pskin, pscore, pmoney, x, y, z, a, pvw, pinterior, day, month, year, GetName(playerid));
    mysql_tquery(chandle, query, "", "d", playerid);
    if(pInfo[playerid][rank] > 1)
    {
        mysql_format(chandle, query2, sizeof(query2), "UPDATE `adminstats` SET `LastOnlineDate` = '%d/%d/%d' WHERE `Username` = '%e'", day, month, year, GetName(playerid));
        mysql_tquery(chandle, query, "", "d", playerid);
    }
    return 1;
}
Find
Reply
Affan
Huge Clucker
****
Posts: 390
Threads: 65
Joined: Dec 2012
Reputation: 0
#6

08.08.2014, 02:43
-delete- thought this was the edit >.>
Find
Reply
Blade_Cervetti
Huge Clucker
***
Posts: 208
Threads: 38
Joined: Sep 2009
Reputation: 0
#7

08.08.2014, 05:11
I seen something about mysql, did you make sure that everything is the latest update and then compile?
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support