help ples

04/25/2012 16:39 ssagar#1
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
04/26/2012 21:59 sewn62#2
Hello/Hi

I have the same problem as you.

Ps: To sadden I am not English / Translator
04/26/2012 22:15 Xijezu#3
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.
04/26/2012 22:23 sewn62#4
Is how to change the value?
By the DB or in file?
04/26/2012 22:27 Xijezu#5
Quote:
Originally Posted by Xijezu View Post
Next time use search.
^this.
04/26/2012 22:28 sewn62#6
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 ?