[HELP Request]name already in use

12/10/2012 16:01 oldjayy#1
Hello there epvp members.I have got a little problem.Yesterday i executed the commands of Hoax to my SQL and they had no problem,were working and so,BUT when I try to make a character gives me the next error -name already in use.Some of you will say there are scripts to fix and USE search button,Did it many times,but there was no fix.
My logs aren't showing anything too.Hope someone can help me.
Thanks in advance.
12/10/2012 17:00 nephren#2
[Only registered and activated users can see links. Click Here To Register...]

please use the search function, next time.
12/10/2012 17:08 Philipp_#3
Quote:
Originally Posted by oldjayy View Post
Some of you will say there are scripts to fix and USE search button,Did it many times,but there was no fix.
I can't believe that you tried to use the search engine, because the fix you are talking about is easy to find. Here's the tutorial how to use the search engine on elitepvpers:

First, navigate to the search engine
[Only registered and activated users can see links. Click Here To Register...]

Then type in what you are looking for and click "SEARCH"
[Only registered and activated users can see links. Click Here To Register...]

Now you have to click on the first result and you are done!

If you still don't find it »[Only registered and activated users can see links. Click Here To Register...]«
12/10/2012 17:17 nephren#4
Use English Only on SQL - Languages - do not use any other languages.
Sometimes this error happens because different SQL language.
12/10/2012 17:18 Murik13#5
Script work 100%
12/10/2012 17:21 Philipp_#6
Did you restart your server after running this script? Any errors occurred while running the script?
12/10/2012 17:47 nephren#7
please try this:

Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Create_Char_R2]    Script Date: 12/10/2012 17:47:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R    스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER  Proc [dbo].[usp_Create_Char_R2]

@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,

@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,


/* 여기까지 인자값 주어져야 함 */

/* SP 내부 참조용 변수 */

@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int

SET @CharName = LTRIM(RTRIM(@CharName))
SET @SkillPoint = 5
SET @Ret = 0


BEGIN TRANSACTION

INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow, 
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint, 
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money], 
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)

VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow, 
@Hair, @Face, @Size, @Job, @Sex, @Level, @StatPoint, @SkillPoint, 
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money, 
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)

IF( @@ERROR=0 )
BEGIN
	COMMIT TRANSACTION
END
ELSE
BEGIN
	ROLLBACK TRANSACTION
	RETURN -1
END

SET @CharID = IDENT_CURRENT('Chars')


RETURN @CharID

SET NOCOUNT OFF
And this:

Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Create_Char_R]    Script Date: 12/10/2012 17:47:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R    스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER  Proc [dbo].[usp_Create_Char_R]

@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,

@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,


/* 여기까지 인자값 주어져야 함 */

/* SP 내부 참조용 변수 */

@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int

SET @CharName = LTRIM(RTRIM(@CharName))
SET @SkillPoint = 5
SET @Ret = 0



SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

IF(@NameCnt <> 0)
BEGIN
	RETURN -2
END
ELSE
BEGIN
	IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
	BEGIN
		RETURN -2
	END

	BEGIN TRANSACTION

	INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow, 
	Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint, 
	[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money], 
	PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)

	VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow, 
	@Hair, @Face, @Size, @Job, @Sex, @Level, @StatPoint, @SkillPoint, 
	@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money, 
	@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)

	IF( @@ERROR=0 )
	BEGIN
		COMMIT TRANSACTION
	END
	ELSE
	BEGIN
		ROLLBACK TRANSACTION
		RETURN -1
	END

	SET @CharID = IDENT_CURRENT('Chars')
END

RETURN @CharID

SET NOCOUNT OFF
12/10/2012 18:20 nephren#8
2012-12-10 19:02:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'usp_Create_Char_R' expects parameter '@GM', which was not supplied., SQL STATE: 42000, NATIVE ERROR: 201 (0xC9)

you didn't run that query successfully, there is no var called @GM.

Please do the following steps:

Open SQL-Manager, Go to: PS_GameData > Expand it > Stored Procedures > Expand it
Search for:
usp_Create_Char_R and modify it with my Codes.
Search for:
usp_Create_Char_E2 and modify it with my Codes.

Execute it. And make sure that you restart your SQL-Services AND your Shaiya-Server,
12/10/2012 18:57 oldjayy#9
STILL no effect.Logs aren't showing anything.
12/10/2012 19:00 nephren#10
In this case you should think about a new Database and maybe new server-files.

If you have the server public, you can BackUP all Characters and Items by using SQLScripter or Export/Import which is already included.

guess you're already use "English-Language" on SQL eh?
If not: please do this first.
12/11/2012 16:15 oldjayy#11
Okay.Reinstalled the SQL(English ofc).Everything is good,but unfortunately 95% of the new commands aren' working.
12/11/2012 16:20 Truth1010#12
What "new commands" would these be?
Try be a little more specific so we can help you easier :)
12/11/2012 16:45 Truth1010#13
I have never used that release before, so I don't have much knowledge of it, but just taking a quick look through.. Are you sure your using the right type of character/account.

Status 16 seems to be the main key to it. Also Admin 1 is used a few times.

are you typing the commands in correctly how it states, and are you re-logging after you use a command, like it also states?

Found this at the bottom of the post, checked it ?

Quote:
1. Did you set Adminlevel to 255 on your Account in your PS_UserData.dbo.Users_Master?
2. Does your Chatlog work?
3. Check permissions for the script. Is it allowed to change Values in other Databases?
4. Can you find the command that you used in your Chatlog?