|
You last visited: Today at 11:00
Advertisement
All Toon Names Don't Exist!
Discussion on All Toon Names Don't Exist! within the Shaiya Private Server forum part of the Shaiya category.
02/05/2013, 11:17
|
#1
|
elite*gold: 0 
Join Date: Jan 2013
Posts: 55
Received Thanks: 7
|
All Toon Names Don't Exist!
Hey..
Well the problem i am facing is when i go to pick a character name
an enter it , every single name i try enter does is already in use
How do i fix this problem...
Cheers 
|
|
|
|
02/05/2013, 12:08
|
#2
|
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,627
|
u fix that problem by simply using the search engine. How often do we need to tell u that?
 if the first quiery isnt working use the fix i posted on page 2
|
|
|
|
|
02/05/2013, 13:15
|
#3
|
elite*gold: 0
Join Date: Jan 2013
Posts: 55
Received Thanks: 7
|
Quote:
Originally Posted by TeddyBear94
u fix that problem by simply using the search engine. How often do we need to tell u that?
if the first quiery isnt working use the fix i posted on page 2 |
BTW i have read all that , The query's don't work ..
Yes i read it , but why release a query whats to fix ur own
problem an not explain it too others ? Can you explain a bit more about this fix an how to fix it
in a little bit more detail..
Cheers
|
|
|
|
|
02/05/2013, 17:07
|
#4
|
elite*gold: 5
Join Date: Mar 2012
Posts: 1,007
Received Thanks: 498
|
You tried this?
Quote:
Originally Posted by TeddyBear94
DBCC DBReIndex ('PS_GameData.dbo.Chars')
|
Just start a new Query in sql, past this and click on execute
|
|
|
|
|
02/05/2013, 17:25
|
#5
|
elite*gold: 0
Join Date: Jan 2013
Posts: 55
Received Thanks: 7
|
Quote:
Originally Posted by Sh1nra
You tried this?
Just start a new Query in sql, past this and click on execute
|
I have tried this Query already , for some reason that i cannot understand it
still persists too tell me the same thing..
|
|
|
|
|
02/05/2013, 22:01
|
#6
|
elite*gold: 576
Join Date: Mar 2011
Posts: 348
Received Thanks: 994
|
It might help if you show us your logs, but remember to put them in spoilers, please.
|
|
|
|
|
02/06/2013, 00:43
|
#7
|
elite*gold: 0
Join Date: Jan 2013
Posts: 55
Received Thanks: 7
|
This is the error log ..
Quote:
2013-02-05 16:20:51 PS_DBAGENT__system log start (DBAgent01)
2013-02-05 16:20:59 connect game, Name=
2013-02-05 16:20:59 connect game, Name=
2013-02-05 16:22:01 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)
2013-02-05 16:22:01 ::CreateCharacter 0 admin retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Comodo',1,'admin', 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)}
2013-02-05 16:22:01 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2013-02-05 16:22:07 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)
2013-02-05 16:22:07 ::CreateCharacter 0 fgfsdgdgwetr2 retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Comodo',1,'fgfsdgdgwetr2', 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)}
2013-02-05 16:22:07 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2013-02-05 16:22:11 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)
2013-02-05 16:22:11 ::CreateCharacter 0 fsd4 retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Comodo',1,'fsd4', 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)}
2013-02-05 16:22:11 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2013-02-05 16:22:17 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)
2013-02-05 16:22:17 ::CreateCharacter 0 212dewd2 retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'Comodo',1,'212dewd2', 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)}
2013-02-05 16:22:17 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2013-02-05 16:22:31 1 1 SAgent: isconnect: (4, 64)
2013-02-05 16:22:31 1 1 T=000:01:00:000, RC=11,RCS=0, RB=614,RBS=6, SC=11,SCS=0, SB=2245,SBS=24
2013-02-05 16:22:31 disconnect game, Name=Game01
2013-02-05 16:22:31 1 1 SAgent:isconnect: (4, 64)
2013-02-05 16:22:31 1 1 T=000:01:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=3,SCS=0, SB=2064,SBS=22
2013-02-05 16:22:31 disconnect game, Name=Game01
2013-02-05 16:22:31 save market... wait plz...
2013-02-05 16:22:31 save all... wait plz... enter /uc
2013-02-05 16:22:31 3 1 SERVICE_CONTROL_STOP
2013-02-05 16:22:31 PS_DBAGENT__system log end (DBAgent01)
2013-02-05 16:22:31 3 1 SService::ServiceCtrlDispatcher(): service shutdown
|
|
|
|
|
|
02/06/2013, 07:14
|
#8
|
elite*gold: 576
Join Date: Mar 2011
Posts: 348
Received Thanks: 994
|
The problem is not in the dbo.Chars table, as stated above, it is in the usp_Create_Char_R procedure. I bet you tried to edit it and made a mistake.. Run the following query to fix the problem - It will reset your procedure to default.
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 06.02.2013 07:11:37 ******/
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 @Ret = 0
SET @SkillPoint = 5
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
|
|
|
|
|
02/06/2013, 11:07
|
#9
|
elite*gold: 0
Join Date: Jan 2013
Posts: 55
Received Thanks: 7
|
Hmm a bit confused a ran that query successfully an restarted my server
an db an it still keeps telling me the same.
Maybe this might help u a bit better
Quote:
2013-02-06 09:57:51 PS_GAME__system log start (Game01) [KR]
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/sorp1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/croco1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/croco2
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Troll1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Spink1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/GoldenPig
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Sorp3
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/SorpNamed1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/SorpNamed2
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Sorp2
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/CrocoNamed1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/CrocoNamed2
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/CrocoNamed3
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/OrcNamed1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/OrcNamed2
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/OrcNamed3
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/TrollNamed1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Deinos
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Parridalis
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Alcarian
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/ZinAlcaria
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Belizabeth
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Kirhiross
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/CrypticOne
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Haruhion
2013-02-06 09:57:51 Loaded Behavior In Factory : data/ai/Freezing
2013-02-06 09:57:58 connect mgr 980
2013-02-06 09:57:58 connect dbagent 984
2013-02-06 09:57:58 connect dbagent2 988
2013-02-06 09:57:58 connect gamelog 1004
2013-02-06 09:57:59 Market End -----------------------
2013-02-06 09:58:00 cannot open .\Data\Lua\145.lua: No such file or directory
2013-02-06 09:58:00 cannot open .\Data\Lua\144.lua: No such file or directory
2013-02-06 09:58:00 Load Shaiya.SData 0
2013-02-06 09:58:13 <Console input> /nprotectoff
2013-02-06 09:58:13 <Console output> cmd NProtect off ok
2013-02-06 10:00:00 3 1 SERVICE_CONTROL_STOP
2013-02-06 10:00:01 Call save all waiting...
2013-02-06 10:00:01 1 1 SAgent:isconnect: (3, 64)
2013-02-06 10:00:01 1 1 T=000:02:00:000, RC=2,RCS=0, RB=106,RBS=0, SC=5,SCS=0, SB=117,SBS=0
2013-02-06 10:00:01 1 1 SAgent:isconnect: (3, 64)
2013-02-06 10:00:01 1 1 T=000:02:00:000, RC=9,RCS=0, RB=2227,RBS=18, SC=9,SCS=0, SB=414,SBS=3
2013-02-06 10:00:01 1 1 SAgent:isconnect: (3, 64)
2013-02-06 10:00:01 1 1 T=000:02:00:000, RC=3,RCS=0, RB=2064,RBS=16, SC=1,SCS=0, SB=37,SBS=0
2013-02-06 10:00:01 1 1 SAgent:isconnect: (3, 64)
2013-02-06 10:00:01 1 1 T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=1
2013-02-06 10:00:01 discon mgr ((3,64, 106,117)
2013-02-06 10:00:01 mgr Connection Lost INFO : T=000:02:00:000, RC=2,RCS=0, RB=106,RBS=0, SC=5,SCS=0, SB=117,SBS=0
2013-02-06 10:00:01 discon dbagent ((3,64, 2227,414)
2013-02-06 10:00:01 mgr server disconnection
2013-02-06 10:00:01 dbagent Connection Lost INFO : T=000:02:00:000, RC=9,RCS=0, RB=2227,RBS=18, SC=9,SCS=0, SB=414,SBS=3
2013-02-06 10:00:01 discon dbagent2 ((3,64, 2064,37)
2013-02-06 10:00:01 discon userlog ((3,64, 0,126)
2013-02-06 10:00:01 dbagent2 Connection Lost INFO : T=000:02:00:000, RC=3,RCS=0, RB=2064,RBS=16, SC=1,SCS=0, SB=37,SBS=0
2013-02-06 10:00:01 userlog Connection Lost INFO : T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=3,SCS=0, SB=126,SBS=1
2013-02-06 10:00:01 userlog log server disconnection
2013-02-06 10:00:01 1 1 SAgent:isconnect: (3, 64)
2013-02-06 10:00:01 1 1 T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0
2013-02-06 10:00:01 discon gamelog ((3,64, 0,37)
2013-02-06 10:00:01 gamelog Connection Lost INFO : T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0
2013-02-06 10:00:01 game log server disconnection
2013-02-06 10:00:01 db agent server disconnected...
2013-02-06 10:00:01 call disconnectAll...
2013-02-06 10:00:01 db agent2 server disconnected...
2013-02-06 10:00:01 server shutdown Connection INFO : T=000:02:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=1,CReq=1,CCnt=1,DCCnt=1, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=75,RBS=0,RBSC=1,SBT=92,SBS=0,SBSC=1
2013-02-06 10:00:01 Save Shaiya.SData 0
2013-02-06 10:00:01 PS_GAME__system log end (Game01)
2013-02-06 10:00:01 3 1 SService::ServiceCtrlDispatcher(): service shutdown
|
|
|
|
|
 |
Similar Threads
|
WTT OS Lailah Account 61 HM 52 UM 1-15 toon 20-30 toon
11/12/2012 - Shaiya Trading - 5 Replies
WTS Account on lailah(Doesnt really matter cause servers are gonna get merged soon anyways)
61 HM War - Token Toon
52 UM Battle Guard- Leveling toon
1-15 Toon and 20-30 Toon.
There is some gear so that you can farm but nothing TOO uber.
Looking for OPs ONLY.
|
hey WTT my 3 uber maxed toon in shiaya haven for OS shaiya 1 maxed toon orc or def
10/31/2012 - Shaiya Trading - 0 Replies
WTT for shaiya OS toons
pm me in skipe : biscuit455
|
WTB Shaiya US 20-30Uber Toon/1-15 Uber Toon
02/26/2012 - Shaiya Trading - 0 Replies
How Title Says:
Im Looking For Shaiya US 1-15/20-30 toon (preferably 20-30)
I Can Offer Shaiya Exile Uber Acc
P.S The 20-30Toon must be uber(UM,lvl30,Sonic,Enchants,Linked,eled,etc)
Contacting Me:
Pm Me / / / Add Me In Skype: mr.bubbledouble
Yahoo: [email protected]
FB: Tincau Mihai
|
[Names] All Server Names! Recommended Servers Are Marked!
02/15/2009 - CO2 Private Server - 36 Replies
Hey i saw Many server that are using the same names xD its funny so here is a list to help u out.
Later I Will Make A List With Avaible Names And I Will Put In The (Already In Use) Names What Server Is Dead And What Server Is Alive!
THE BLUE SERVERS ARE RECOMMENDED!
First 1-146 Names That Are In Use!
CoEmu
PorousCO
CoUnleashed
TCWNN
|
change color of item names or guild names?
05/07/2006 - Conquer Online 2 - 2 Replies
How can i change the color of the item names or guild names? -- they are both yellow and screw up my bot... so i cant be in a guild to us my bot and pick up items.
|
All times are GMT +2. The time now is 11:00.
|
|
