Crash server help please

03/25/2012 16:51 darckistyle#1
Hello, I have a problem, the server crash, I try to find the problem with other DEV, but with no success can you help me?


03/30/2012 14:57 q8wars#2
lol u will not found any one tell u what u do :)
04/23/2012 14:41 q8wars#3
!!
04/23/2012 17:48 |\| /\ /< `/ ()#4
try look in gamelog.txt
04/26/2012 22:57 sewn62#5
smp_insert_character:
Code:
@IN_DEFAULT_WEAPON_SID	BIGINT,
@IN_DEFAULT_WEAPON_CODE	INT,
@IN_DEFAULT_ARMOR_SID	BIGINT,
@IN_DEFAULT_ARMOR_CODE	INT,
@IN_DEFAULT_BAG_SID		BIGINT,
@IN_DEFAULT_BAG_CODE	INT
Game_Log.txt:
Code:
2012/04/25 22:51:15 DB COM ERROR(Thread:2, HRESULT:80040E07, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_update_character) : Error converting data type bigint to int.
2012/04/25 22:51:15 DB COM ERROR(Thread:3, HRESULT:80040E07, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_update_character) : Error converting data type bigint to int.
2012/04/25 23:09:14 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_OnStartUp(Hard-coded in DB_OnStartUp::readMaxFarmIndex) : Invalid object name 'Farm'.
2012/04/26 09:26:21 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 17:02:33 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 19:45:19 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 19:51:29 DB COM ERROR(Thread:3, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
2012/04/26 20:05:30 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 20:08:29 DB COM ERROR(Thread:1, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
2012/04/26 20:48:27 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 20:53:38 DB COM ERROR(Thread:1, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
I does not how include to change the value of BigInt ?
05/25/2012 23:24 Audric123#6
The problem is the gameguard on the client. Use a client no gameguard and there are not crash.
05/25/2012 23:46 Xijezu#7
Quote:
Originally Posted by Audric123 View Post
The problem is the gameguard on the client. Use a client no gameguard and there are not crash.
This is the dumbest comment I ever saw... :facepalm:

The client has nothing to do with a servercrash, especially not the Gameguard.

If it would, then I would go to retail and crash this the whole time.

Quote:
2012/04/26 20:53:38 DB COM ERROR(Thread:1, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
this should be help enough.
05/25/2012 23:51 c1ph3r#8
Please check if your authserver.opt console._password is set. If somebody connects to your authserver and post a command which isn't supported by the authserver your authserver will crash with the posted error! (Sorry don't know the real parameter name...but you have to set a console pw!)

Set an authserver.opt console._password and nobody can connect to your authserver via console...don't know if this would fix your error but this is one of the security lags in the 7.3 files....
05/26/2012 00:21 Audric123#9
Xijezu I know what I said -_-

Will take care of your server (If it is not hacked yet -- ')