Name already in use [HELP]

danilokdn · 09/25/2011, 06:20

can someone help me fix this error [name already in use].

2011-09-24 23:28:06 PS_DBAGENT__system log start (DBAgent01)

2011-09-24 23:28:25 connect game, Name=

2011-09-24 23:28:25 connect game, Name=

2011-09-24 23:28:27 connect game, Name=

2011-09-24 23:29:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-09-24 23:29:24 ::CreateCharacter 0 lolxD retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Shaiya',1,'lolxD', 0,0,3,0,0,2,0,1, 1,0,0, 14,12,9,8,15,7, 352,110,257, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-09-24 23:29:24 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:34:49 VerifyReConnect : The Connection has been lost, SQLHDBC=2df2c8

2011-09-24 23:34:50 SDatabasePool::Reconnect:: success...

2011-09-24 23:34:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-09-24 23:34:50 ::CreateCharacter 0 iamafail retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Shaiya',1,'iamafail', 0,0,3,4,0,2,0,1, 1,0,0, 14,12,9,8,15,7, 352,110,257, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-09-24 23:34:50 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:35:34 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:35:35 SDatabasePool::Reconnect:: success...

2011-09-24 23:36:06 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-09-24 23:36:06 ::CreateCharacter 0 damnifail retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Shaiya',1,'damnifail', 0,0,3,0,0,2,0,1, 1,0,0, 14,12,9,8,15,7, 352,110,257, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-09-24 23:36:06 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:37:45 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:37:45 SDatabasePool::Reconnect:: success...

2011-09-24 23:38:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-09-24 23:38:27 ::CreateCharacter 0 lolololololol retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'test',2,'lolololololol', 0,0,2,3,0,2,0,1, 1,0,0, 14,12,9,8,15,7, 270,90,207, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-09-24 23:38:27 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:38:27 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:38:27 SDatabasePool::Reconnect:: success...

2011-09-24 23:41:10 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-09-24 23:41:10 ::CreateCharacter 0 lolololololol retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'test',2,'lolololololol', 0,0,2,3,0,2,0,1, 1,0,0, 14,12,9,8,15,7, 270,90,207, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-09-24 23:41:10 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:42:48 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:42:48 SDatabasePool::Reconnect:: success...

2011-09-24 23:43: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-09-24 23:43:15 ::CreateCharacter 0 SunFire retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'heyaxd',14,'SunFire', 0,1,3,0,0,0,3,1, 1,0,0, 11,14,10,7,13,10, 312,165,272, 1,0, 0,0, 1678.920044,38.919998,1776.910034, 0,200,0,0,0)}

2011-09-24 23:43:15 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:43:21 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:43:21 SDatabasePool::Reconnect:: success...

2011-09-24 23:43:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-09-24 23:43:21 ::CreateCharacter 0 lolololololol retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Foxy',16,'lolololololol', 0,0,2,3,3,2,0,1, 1,0,0, 14,12,9,8,15,7, 270,90,207, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-09-24 23:43:21 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:44:15 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:44:15 SDatabasePool::Reconnect:: success...

2011-09-24 23:44: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-09-24 23:44:15 ::CreateCharacter 0 SunFire retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'heyaxd',14,'SunFire', 0,1,3,0,0,0,3,1, 1,0,0, 11,14,10,7,13,10, 312,165,272, 1,0, 0,0, 1678.920044,38.919998,1776.910034, 0,200,0,0,0)}

2011-09-24 23:44:15 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:47:05 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:47:05 SDatabasePool::Reconnect:: success...

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

2011-09-24 23:47:05 ::CreateCharacter 0 asas retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'heyaxd',14,'asas', 0,1,3,0,0,0,3,1, 1,0,0, 11,14,10,7,13,10, 312,165,272, 1,0, 0,0, 1678.920044,38.919998,1776.910034, 0,200,0,0,0)}

2011-09-24 23:47:05 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-09-24 23:48:28 VerifyReConnect : The Connection has been lost, SQLHDBC=1d36c00

2011-09-24 23:48:28 SDatabasePool::Reconnect:: success...

2011-09-24 23:52:25 LoadCharacterList failed 0 qerr=0, EXEC usp_Read_Chars_R 1, 13

2011-09-24 23:53:10 LoadCharacterList failed 0 qerr=0, EXEC usp_Read_Chars_R 1, 13

[Admin]Snuggle · 09/25/2011, 06:49

wrong section.

Da Boss · 09/25/2011, 15:38

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

Execute that, credits to arutema