[HELP] Name in use !

02/11/2011 22:15 this_is_love#1
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::Disconnect: (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::Disconnect: (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::Disconnect: (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 !

[Only registered and activated users can see links. Click Here To Register...]

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

Thanks
02/11/2011 23:22 Aberdien#2
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.
02/12/2011 00:08 eQuiNoX.#3
I had the problem two weeks ago too. Try this Code: DBCC DBReIndex ('PS_GameData.dbo.Chars')
02/12/2011 00:24 Bаne#4
There have been a huge list of guides on this...use the search enging.
02/12/2011 00:40 this_is_love#5
Quote:
Originally Posted by [GM]Bane View Post
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?
02/12/2011 00:44 this_is_love#6
Quote:
Originally Posted by eQuiNoX. View Post
I had the problem two weeks ago too. Try this Code: DBCC DBReIndex ('PS_GameData.dbo.Chars')
How do I do?
02/12/2011 03:47 Aberdien#7
[Only registered and activated users can see links. Click Here To Register...]

Check this forum out will help with just about anything.

also check this one out for character name in use.

[Only registered and activated users can see links. Click Here To Register...]
02/12/2011 06:32 zargon05#8
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.
02/12/2011 12:38 this_is_love#9
Quote:
Originally Posted by Aberdien View Post
[Only registered and activated users can see links. Click Here To Register...]

Check this forum out will help with just about anything.

also check this one out for character name in use.

[Only registered and activated users can see links. Click Here To Register...]
I did the display but the problem continues. So I've been looking for another solution.
02/12/2011 18:25 this_is_love#10
pls help me !
02/13/2011 05:21 zargon05#11
[Only registered and activated users can see links. Click Here To Register...]
try this
02/18/2011 05:38 topazee#12
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