help ples

ssagar · 04/25/2012, 16:39

Welcome my friends, I have a problem please help
DB COM ERROR(Thread:0, HRESULT:80040E07, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_update_character) : Error converting data type bigint to int.

UP pls help

sewn62 · 04/26/2012, 21:59

Hello/Hi

I have the same problem as you.

Ps: To sadden I am not English / Translator

Xijezu · 04/26/2012, 22:15

dbo.smp_update_character has defined a parameter as int, but the GS is sending the value for this parameter which is out of range.
You have to change it to BigInt.

Next time use search.

sewn62 · 04/26/2012, 22:23

Is how to change the value?
By the DB or in file?

Xijezu · 04/26/2012, 22:27

Quote:

Originally Posted by Xijezu

Next time use search.

^this.

sewn62 · 04/26/2012, 22:28

Sorry

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 ?