Character Select Black Screen

[shiroun]

Well heres the drift of things.

I made my own server (hurray!)
I have my own character and custom items (Hazah)
I have full quest (Hoot-rah)
I can't get past character select screen (gasp!)
^
|
Spamish so ill go to real point.

I get to character select, I select my character... and then the lobby is all black, nothing to touch, and no matter how much or where i click, nothing happens.

Anyone know the fix to this?

[MentaL]

[Bryan1]

Use a other runnable or read Quests & Answers

[MAXTRAXv3]

its spinsretcharr, where it says0,0,null put 0,null,null

[shiroun]

Maxtrax... you rock. I literally am so happy right now. But uhh.. wheres it say 0,0, null cuz i cant find it. Heres what mine is, can you copy+paste yours to the fix?
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,50000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
END

[MAXTRAXv3]

well that not right, this is tho

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,50000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null)
END