[HELP] Name in use !

this_is_love · 02/11/2011, 22:15

hey guys,

I'm having trouble creating a new character .. When I enter the character name "This name is in use" error.

Logs;PS_DBAGENT__system.log

Quote:

2011-02-01 15:13:54 PS_DBAGENT__system log start (DBAgent01)

2011-02-01 15:14:14 connect game, Name=

2011-02-01 15:14:14 1 1 SAgent:isconnect: (4, 64)

2011-02-01 15:14:14 1 1 T=000:00:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=2,SCS=0, SB=2060,SBS=0

2011-02-01 15:14:14 disconnect game, Name=Game254

2011-02-01 15:14:15 connect game, Name=

2011-02-01 15:14:15 connect game, Name=

2011-02-01 15:15:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:30 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:30 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:32 VerifyReConnect : The Connection has been lost, SQLHDBC=6b2db0

2011-02-01 15:15:32 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:33 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:33 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:35 VerifyReConnect : The Connection has been lost, SQLHDBC=6c4208

2011-02-01 15:15:37 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:37 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:37 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:42 VerifyReConnect : The Connection has been lost, SQLHDBC=6c4208

2011-02-01 15:15:42 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:42 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:42 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:45 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:15:45 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:45 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:45 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:47 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:15:47 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:47 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:47 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:55 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:15:55 SDatabasePool::Reconnect:: success...

2011-02-01 15:16:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:16:15 ::CreateCharacter 0 ceemcmeedsa retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'ceemcmeedsa', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:16:15 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:16:18 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:16:18 SDatabasePool::Reconnect:: success...

2011-02-01 15:16:31 3 1 SERVICE_CONTROL_STOP

2011-02-01 15:16:42 1 1 SAgent:isconnect: (4, 64)

2011-02-01 15:16:42 1 1 T=000:02:00:000, RC=47,RCS=0, RB=2720,RBS=18, SC=81,SCS=0, SB=28479,SBS=193

2011-02-01 15:16:42 disconnect game, Name=Game01

2011-02-01 15:16:42 1 1 SAgent:isconnect: (4, 64)

2011-02-01 15:16:42 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=29,SCS=0, SB=47363,SBS=322

2011-02-01 15:16:42 disconnect game, Name=Game01

2011-02-01 15:16:42 save market... wait plz...

2011-02-01 15:16:42 save all... wait plz... enter /uc

2011-02-01 15:16:43 PS_DBAGENT__system log end (DBAgent01)

2011-02-01 15:16:43 3 1 SService::ServiceCtrlDispatcher(): service shutdown

And Sql Screen !

How do I resolve this problem. Waiting for your help.

Thanks

Aberdien · 02/11/2011, 23:22

Hmm.. I do know that in your .ini files the ServerName is not suppose to end in "01" looks like yours might :s

For the error in sql, seems you might have some corrupt files. What files are you using? This only happened to me once and I ended up just starting over on my server from square one.

eQuiNoX. · 02/12/2011, 00:08

I had the problem two weeks ago too. Try this Code: DBCC DBReIndex ('PS_GameData.dbo.Chars')

Bаne · 02/12/2011, 00:24

There have been a huge list of guides on this...use the search enging.

this_is_love · 02/12/2011, 00:40

Quote:

Originally Posted by [GM]Bane

There have been a huge list of guides on this...use the search enging.

I did search but could not find the information useful. Can you help?

this_is_love · 02/12/2011, 00:44

Quote:

Originally Posted by eQuiNoX.

I had the problem two weeks ago too. Try this Code: DBCC DBReIndex ('PS_GameData.dbo.Chars')

How do I do?

Aberdien · 02/12/2011, 03:47

Check this forum out will help with just about anything.

also check this one out for character name in use.

zargon05 · 02/12/2011, 06:32

Quote:

2011-02-01 15:15:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

That's your error and I can also see a solution there.

this_is_love · 02/12/2011, 12:38

Quote:

Originally Posted by Aberdien

Check this forum out will help with just about anything.

also check this one out for character name in use.

I did the display but the problem continues. So I've been looking for another solution.

this_is_love · 02/12/2011, 18:25

pls help me !

zargon05 · 02/13/2011, 05:21

try this

topazee · 02/18/2011, 05:38

1. Open Sql server management
2. New query
3. Copy and paste this code

Quote:

USE [PS_GameData]
GO
drop procedure [dbo].[usp_Save_Char_Item_Add_E]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/

CREATE Proc usp_Save_Char_Item_Add_E

@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@MaketimeZ varchar(50),
@Maketype char(1)

AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)
--SET NOCOUNT ON

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

--SET NOCOUNT OFF

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

4. click on the "parse" then "Execute "and finally you save