Name already in use fix problem

[[Admin]Smile.jpg]

I am trying to fix the name already in use problem when trying to make a char, but the fix isn't working.

Here is the log:

2012-07-26 11:47:35 PS_DBAGENT__system log start (DBAgent01)

2012-07-26 11:47:36 UpdateGuildPointRankDB Result=-1

2012-07-26 11:47:50 connect game



2012-07-26 11:48:46 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'CharID', table 'PS_GameData.dbo.Chars'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)

2012-07-26 11:48:46 ::CreateCharacter 0 dfhr retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'admin',2084,'dfhr', 0,0,3,0,0,2,0,0, 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)}

2012-07-26 11:48:46 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

I tried both methods from John's topic, but the same error...

[Sh1nra]

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

credits to JohnHeatz.

If this don`t work, what database ep you have ?

[[Admin]Smile.jpg]

I already said I used it and it isn't working. I have EP5 DB.

[Sh1nra]

from shaiya xtreme ?
or where you got EP 5 DB ?

[[Admin]Smile.jpg]

From [Dev]AshArtanis.

[Follow001]

Smile All Working DataBase dear Sh1nra Give You Script.

Me Tested. Ep4, Ep5 Db.

[[Admin]Smile.jpg]

Still not working...

[dimaster10]

USE [PS_GameData]
GO

/****** Object: Index [IX_Chars_CharName] Script Date: 10/07/2011 17:15:26 ******/
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Chars]') AND name = N'IX_Chars_CharName')
DROP INDEX [IX_Chars_CharName] ON [dbo].[Chars] WITH ( ONLINE = OFF )
GO

USE [PS_GameData]
GO

/****** Object: Index [IX_Chars_CharName] Script Date: 10/07/2011 17:15:27 ******/
CREATE NONCLUSTERED INDEX [IX_Chars_CharName] ON [dbo].[Chars]
(
[CharName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

[[Admin]Smile.jpg]

Thank you everyone, but I found the fix. If anyone ever encounters this bad problem, just download the EP 5 db files from Bane's Index and only attach the PS_GameData(delete old one). It seems like my DB was corrupted, now it works.

[bb005836]

Originally Posted by dimaster10

USE [PS_GameData]
GO

/****** Object: Index [IX_Chars_CharName] Script Date: 10/07/2011 17:15:26 ******/
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Chars]') AND name = N'IX_Chars_CharName')
DROP INDEX [IX_Chars_CharName] ON [dbo].[Chars] WITH ( ONLINE = OFF )
GO

USE [PS_GameData]
GO

/****** Object: Index [IX_Chars_CharName] Script Date: 10/07/2011 17:15:27 ******/
CREATE NONCLUSTERED INDEX [IX_Chars_CharName] ON [dbo].[Chars]
(
[CharName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

It's work!!Thx big=))