cant create new characters [not fixed]

ive deleted all my databases except for Account,
and restored empty ones (the same ones i use all the time)

when i try to create a character it says that name is already in use, please choose another.

there are no characters in the database.

any suggestions?

Try this:

Code:

---

USE [World00_Character]
GO
/****** Object:  StoredProcedure [dbo].[p_Char_Create]    Script Date: 05/04/2011 22:09:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[p_Char_Create]
/*
Character Create
2004.6 By CJC
 input:
  All Args
 output:
  nCharNo = 1~? ??? ??? ??(??? = 0 )
          =  0 ?? ?? ??
          = -1 ?? ??? ??? ??? ??.
          = -2 ?? ?? ?? ??
          = -3 ?? ?? ?? ??
*/
@nUserNo int,                        -- 1        1 ~ ?
@nCreateWorld tinyint,        -- 2        0 ~ ?
@nAdminLevel tinyint,        -- 3        0=USER, 1~?=GM Level 1~?
@nSlotNo tinyint,                -- 4        0 ~ 5
@sID nvarchar(40),                -- 5 
@nRace tinyint,                        -- 6        0 = Human, 1 = Elf, 2 = Dark elf
@nClass tinyint,                -- 7        1 = Fighter,4 = Cleric, 7 = Archer, 10 = Mage
@nGender tinyint,                -- 8        0 = Male, 1 = Female
@nHairType tinyint,                -- 9        0 ~ ?
@nHairColor tinyint,        -- 10        0 ~ ?
@nFaceShape tinyint,        -- 11        0 ~ ?
@nCharNo int OUTPUT    -- 12
AS
SET NOCOUNT ON
-- ???? ?? ??
SET @nCharNo = 0
-- ????? ????? ??? ??? ??
IF EXISTS (SELECT sID FROM tCharacter(NOLOCK) WHERE sID = @sID)
    BEGIN
    RETURN
    END
    ELSE
BEGIN TRAN
INSERT tCharacter (  nUserNo,  nSlotNo,  sID,  nCreateWorld,  nAdminLevel )
VALUES            ( @nUserNo, @nSlotNo, @sID, @nCreateWorld, @nAdminLevel )
IF @@ERROR <> 0
BEGIN
        ROLLBACK TRAN
        RETURN
END
SET @nCharNo = @@IDENTITY
-- ?? ?? ??
INSERT tCharacterShape (  nCharNo,  nRace,  nClass,  nGender,  nHairType,  nHairColor,  nFaceShape )
VALUES                ( @nCharNo, @nRace, @nClass, @nGender, @nHairType, @nHairColor, @nFaceShape )
IF @@ERROR <> 0
BEGIN
        ROLLBACK TRAN
        SET @nCharNo = -2
        RETURN
END
-- ?? ?? ??
INSERT tCharacterOptions (  nCharNo )
VALUES                  ( @nCharNo )
IF @@ERROR <> 0
BEGIN
        ROLLBACK TRAN
        SET @nCharNo = -3
        RETURN
END
-- ?? ?? ??
COMMIT TRAN
-- end

---

Not sure if it's the right one, just something I found. It's worth a try though.

nope didnt help.
Ive also completely reinstalled windows, and still am unable to create characters.
and i have used 2 different database backups.

ive tried 2 different sets of server files (one ive been using for over a month)

ive tried removing all the databases and restoring from clean ones

ive removed windows and reinstalled.

i can connect/login, and get to character select screen on the client, i just cant make any characters.

i have executed that create script and it hasnt helped.

one tipp... take a look on your shns i got this problem for few days i sync my server and client files hairinfo, face that should help you if not sent me a pm and ill help you its not the db