[DEVELOPMENT] 7.3 Gameserver + Current Databases + Debug Info

[demonlordace]

well i got it to fully boot up now i need to repopulate the databases with info


well i was able to get the GS to stay running so i decied to populate the databases with info from old dbs and after i did that it wouldnt boot the rite way so im stumped rite now as to what to do next honestly was kinda hoping id be able to use data from other dbs but guess **** out of luck

[coolmans]

Originally Posted by demonlordace

[dbo].[smp_read_guild_member_list]

Invalid object name "dbo.smp_read_guild_member_list".

help

[wisp66]

its telling u what u missing dbo.smp_read_guild_member_list but u also need to modify guild resource

[ismokedrow]

Originally Posted by demonlordace

well i got it to fully boot up now i need to repopulate the databases with info


well i was able to get the GS to stay running so i decied to populate the databases with info from old dbs and after i did that it wouldnt boot the rite way so im stumped rite now as to what to do next honestly was kinda hoping id be able to use data from other dbs but guess **** out of luck

Astounding mate, you kinda vanished off TS last night. Can't wait to keep going with you this morning, we were just running through errors last night ^_^

[Wing2000]

i´m very exciting about this Server... Hope you fix all errors as soon as possible... Great Work mates...

[Strange2010]

i wish i can help here
i have 32-bit
GL guys + I am working on inserting s0 pets along with the s5 ones

[ismokedrow]

Current Progress:

Thanks to help from DemonLordAce and his friends and a few friends of my own, we have gotten the GS to load completely and connect to the auth server. You can login but can not select or create a character yet. We are currently trying to reconfigure the smp's involved.

Current Error: (On Character Creation Attempt)

 Spoiler

2012/03/14 11:15:29 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_CreateCharacter(dbo.smp_insert_character) : Procedure or function smp_insert_character has too many arguments specified.

If you create a character entry in the database and try to login to 'Server Selection' this error is printed (Also SMP)

Current Error: (On Login to Character Select)

 Spoiler

2012/03/14 08:00:01 DB COM ERROR(Thread:3, HRESULT:800A0CC1, GUID:00000564-0000-0010-8000-00AA006D2EA4) : DB_CharacterList(dbo.smp_read_item_equip_info: @IN_ACCOUNT_ID: 1) : Item cannot be found in the collection corresponding to the requested name or ordinal.

If you are in need of the current working databases please contact myself or demonlordace.

[aka-manga]

Originally Posted by ismokedrow

Current Progress:

Thanks to help from DemonLordAce and his friends and a few friends of my own, we have gotten the GS to load completely and connect to the auth server. You can login but can not select or create a character yet. We are currently trying to reconfigure the smp's involved.

Current Error: (On Character Creation Attempt)

 Spoiler

2012/03/14 11:15:29 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_CreateCharacter(dbo.smp_insert_character) : Procedure or function smp_insert_character has too many arguments specified.

If you create a character entry in the database and try to login to 'Server Selection' this error is printed (Also SMP)

Current Error: (On Login to Character Select)

 Spoiler

2012/03/14 08:00:01 DB COM ERROR(Thread:3, HRESULT:800A0CC1, GUID:00000564-0000-0010-8000-00AA006D2EA4) : DB_CharacterList(dbo.smp_read_item_equip_info: @IN_ACCOUNT_ID: 1) : Item cannot be found in the collection corresponding to the requested name or ordinal.

If you are in need of the current working databases please contact myself or demonlordace.

this GS support x32

[demonlordace]

NO its 64x ONLY jesus how many times do u people need to be told this u need a 64x os to run the 7.3 GS if u dont have this then give up stick with ur 6.2

[Levelz]

Originally Posted by aka-manga

this GS support x32

its a server for *** sakes .... if your still running 32 bit you have no place making your own p-server .. upgrade your system or stop wasting there time.

[mlejnek2]

well id liek them if ya dont mind thats if they alow you in game i can start to work on ingame things ato help out thats about all im realy gona be good at right now with me being down sick atm

[demonlordace]

sorry cant even make it ingame atm we are currently trying to fix the smp's that allow you to even get ingame we have fixed char creation but ur unable to login rite now due to another smp error will be quite sum time be for this is even gonna be even remotely usable sorry guys we have made alot of progress but still much more work to be done and as its only me and smoke working on this gonna be atleast a few more days b4 can login would be faster if we had more people that know how to do this but any1 who knows how to help with this wont well minus the info that pyrok gave me to fix the guild member list smp

[ismokedrow]

The current task is to correct the dbo.smp_read_item_equip_info we have verified that the character creation process is now functioning, the next issue is between creating the character or logging in when an account that already has a character. The server will execute the a fore mentioned smp.

Current SMP:

 Spoiler

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_read_item_equip_info]    Script Date: 03/14/2012 13:43:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- end of smp_insert_character

-- smp_read_item_equip_info
CREATE PROCEDURE [dbo].[smp_read_item_equip_info]
@IN_ACCOUNT_ID INT
AS
SET NOCOUNT ON

SELECT wear_info, code, enhance, level, elemental_effect_type, elemental_effect_expire_time FROM dbo.Item WITH (NOLOCK) WHERE account_id = 0 AND owner_id = @IN_ACCOUNT_ID AND summon_id = 0 AND auction_id = 0 AND keeping_id = 0 AND wear_info > -1 AND wear_info < 22 ORDER BY update_time

RETURN @@ERROR

[mlejnek2]

ok cool also could this be due to the empty DB also so it has no items to read from just wondering is all tryign to help with what i can

and hey no complaints here i was a tester for ncarbon when they had there test server up they prob dont remember me much anymore but that cool no freating here, at least you all are trying to get it to be public again so we can get testers and maybe more to help out i can only do so much to help sorry my skills arnt great, but ill do what i can to help out

[ismokedrow]

We have populated the ItemResource and verified that it is loading it, we have also verified that during the character creation process 2 entries are created in the dbo.item

Current Error:

 Spoiler

2012/03/14 08:00:01 DB COM ERROR(Thread:3, HRESULT:800A0CC1, GUID:00000564-0000-0010-8000-00AA006D2EA4) : DB_CharacterList(dbo.smp_read_item_equip_info: @IN_ACCOUNT_ID: 1) : Item cannot be found in the collection corresponding to the requested name or ordinal.