[HELP]New Char Problem

rea1 · 02/01/2011, 16:57

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

HTML Code:

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

error seems.

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

Thanks

Sinful858 · 02/01/2011, 19:14

There are a few posts on how to fix this, but I will give ya this link. Just scroll below the 3 videos and the script will be right there:

rea1 · 02/01/2011, 22:46

I made the display of the video. I entered the following code but the problem continues. Show if there is no other way.

HTML Code:

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

rea1 · 02/02/2011, 14:26

pls help me!