|
You last visited: Today at 13:44
Advertisement
Rollback after using Rune
Discussion on Rollback after using Rune within the Shaiya Private Server forum part of the Shaiya category.
09/22/2012, 02:41
|
#1
|
elite*gold: 0 
Join Date: May 2012
Posts: 18
Received Thanks: 21
|
Rollback after using Rune
Hello,
I have a problem as I mentioned it in my topic.
Everything is working great till I use any rune appearing on the screen when used.Such as 30 day continuous Rune,Prevent of Item Drop Rune , Eternal Endurance Rune,Red Phoenix Charm and Warehouse Recall Rune.
When I use any of these runes ,everything seems to be normal till I go back to character screen.If I try to go back to character screen ,I disconnect from the server and see the notification saying "connection with servre has been disconnected ERROR 0"
When I relog in the game I found the rune unused in my bag and datas are rolled back to the time before I use the rune.
I will be appreaciated if anybody can tell me how to fix it.
Regards.
|
![[ADM]KEFARET is offline](images/elitepvpers/statusicon/user_offline.gif)
|
|
|
09/22/2012, 06:19
|
#2
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
|
Have you checked on your logs for what is shown at the time the "roll-back" happens? If not, that would be the best way to go to start
|
|
|
|
|
09/22/2012, 10:04
|
#3
|
elite*gold: 0
Join Date: Aug 2012
Posts: 69
Received Thanks: 19
|
Siz İlk önce Item.sdata 'yı Düzenleyin ve Server Dosyalarınızı Tekrar Yaratın. Sorununuz Girelecektir.
|
|
|
|
|
09/23/2012, 20:47
|
#4
|
elite*gold: 0
Join Date: Aug 2012
Posts: 12
Received Thanks: 9
|
[SORRY FOR TURKISH LANGUAGE]
Merhaba Kefaret;
Bir aralar aynı problem bendede vardı sebebi ise MSSQL Serverden kaynaklanması kurulumda bazı dosyaları eksik yüklediği için bendede çıkıyordu aynı problem veya Dipnot arkadaşımızın dediği gibi item.sdatayı tekrardan yapın eğer yine aynı problem çıkıyor ise muhtemelen MSSQL Serverden kaynaklıdır.
|
|
|
|
|
09/24/2012, 05:05
|
#5
|
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 21
|
Thanks for your advices but none of them worked for me.These are logs.If you figure out the problem ,I am all ear.
PS_DBAGENT__system.log__20120924_054430.log
Code:
2012-09-24 05:44:30 PS_DBAGENT__system log start (DBAgent01)
2012-09-24 05:44:31 connect game, Name=
2012-09-24 05:44:31 connect game, Name=
2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)
2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}
2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)
2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=15,RCS=0, RB=322,RBS=1, SC=18,SCS=0, SB=2902,SBS=9
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=4,SCS=0, SB=2068,SBS=6
2012-09-24 05:49:53 disconnect game, Name=Game01
2012-09-24 05:49:53 disconnect game, Name=Game01
2012-09-24 05:49:53 save market... wait plz...
2012-09-24 05:49:53 save all... wait plz... enter /uc
2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP
2012-09-24 05:49:53 PS_DBAGENT__system log end (DBAgent01)
2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAME__system.log__20120924_054430.log
Code:
2012-09-24 05:44:30 PS_GAME__system log start (Game01) [KR]
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/sorp1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/croco1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/croco2
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Troll1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Spink1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/GoldenPig
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Sorp3
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/SorpNamed1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/SorpNamed2
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Sorp2
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrocoNamed1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrocoNamed2
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrocoNamed3
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/OrcNamed1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/OrcNamed2
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/OrcNamed3
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/TrollNamed1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Deinos
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Parridalis
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Alcarian
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/ZinAlcaria
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Belizabeth
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Kirhiross
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/CrypticOne
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Haruhion
2012-09-24 05:44:30 Loaded Behavior In Factory : data/ai/Freezing
2012-09-24 05:44:31 connect mgr 796
2012-09-24 05:44:31 connect dbagent 804
2012-09-24 05:44:31 connect dbagent2 816
2012-09-24 05:44:31 connect gamelog 848
2012-09-24 05:44:32 Market End -----------------------
2012-09-24 05:44:32 Load Shaiya.SData 5
2012-09-24 05:46:57 error exp over usern=KEFARET,charn=defs, level=70,exp=-1294967296,exppn=71851
2012-09-24 05:48:43 discon client: (104, 64) T=000:01:00:000, RC=10,RCS=0, RB=94,RBS=0, SC=74,SCS=0, SB=1754,SBS=14
2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP
2012-09-24 05:49:53 Call save all waiting...
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=3,RCS=0, RB=110,RBS=0, SC=10,SCS=0, SB=659,SBS=2
2012-09-24 05:49:53 discon mgr ((3,64, 110,659)
2012-09-24 05:49:53 mgr Connection Lost INFO : T=000:05:00:000, RC=3,RCS=0, RB=110,RBS=0, SC=10,SCS=0, SB=659,SBS=2
2012-09-24 05:49:53 mgr server disconnection
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=4,RCS=0, RB=2068,RBS=6, SC=2,SCS=0, SB=41,SBS=0
2012-09-24 05:49:53 discon dbagent2 ((3,64, 2068,41)
2012-09-24 05:49:53 dbagent2 Connection Lost INFO : T=000:05:00:000, RC=4,RCS=0, RB=2068,RBS=6, SC=2,SCS=0, SB=41,SBS=0
2012-09-24 05:49:53 db agent2 server disconnected...
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=7,SCS=0, SB=572,SBS=1
2012-09-24 05:49:53 discon gamelog ((3,64, 4,572)
2012-09-24 05:49:53 gamelog Connection Lost INFO : T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=7,SCS=0, SB=572,SBS=1
2012-09-24 05:49:53 game log server disconnection
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=4,SCS=0, SB=130,SBS=0
2012-09-24 05:49:53 discon userlog ((3,64, 4,130)
2012-09-24 05:49:53 userlog Connection Lost INFO : T=000:05:00:000, RC=1,RCS=0, RB=4,RBS=0, SC=4,SCS=0, SB=130,SBS=0
2012-09-24 05:49:53 userlog log server disconnection
2012-09-24 05:49:53 server shutdown Connection INFO : T=000:05:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=1,CReq=1,CCnt=1,DCCnt=1, CTimeT=000:01:00:000,CTimeAvg=000:01:00:000, RBT=94,RBS=0,RBSC=0,SBT=1754,SBS=5,SBSC=14
2012-09-24 05:49:53 Save Shaiya.SData 5
2012-09-24 05:49:53 PS_GAME__system log end (Game01)
2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAMELOG__system.log__20120924_054430.log
Code:
2012-09-24 05:44:30 PS_GAMELOG__system log start (GameLog01)
2012-09-24 05:44:31 connect game
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=7,RCS=0, RB=572,RBS=1, SC=1,SCS=0, SB=4,SBS=0
2012-09-24 05:49:53 disconnect game
2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP
2012-09-24 05:49:53 PS_GAMELOG__system log end (GameLog01)
2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown
|
|
|
|
|
09/24/2012, 17:08
|
#6
|
elite*gold: 50
Join Date: Sep 2011
Posts: 408
Received Thanks: 1,262
|
Quote:
Originally Posted by [ADM]KEFARET
Thanks for your advices but none of them worked for me.These are logs.If you figure out the problem ,I am all ear.
PS_DBAGENT__system.log__20120924_054430.log
Code:
2012-09-24 05:44:30 PS_DBAGENT__system log start (DBAgent01)
2012-09-24 05:44:31 connect game, Name=
2012-09-24 05:44:31 connect game, Name=
2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)
2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}
2012-09-24 05:48:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)
2012-09-24 05:48:42 ::SaveCharacter 32076 defs ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(32076,286,3,2591972)}
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)
2012-09-24 05:49:53 1 1 SAgent::Disconnect: (4, 64)
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=15,RCS=0, RB=322,RBS=1, SC=18,SCS=0, SB=2902,SBS=9
2012-09-24 05:49:53 1 1 T=000:05:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=4,SCS=0, SB=2068,SBS=6
2012-09-24 05:49:53 disconnect game, Name=Game01
2012-09-24 05:49:53 disconnect game, Name=Game01
2012-09-24 05:49:53 save market... wait plz...
2012-09-24 05:49:53 save all... wait plz... enter /uc
2012-09-24 05:49:53 3 1 SERVICE_CONTROL_STOP
2012-09-24 05:49:53 PS_DBAGENT__system log end (DBAgent01)
2012-09-24 05:49:53 3 1 SService::ServiceCtrlDispatcher(): service shutdown
|
Maybe Here?  Check your Usp_Save_Char_ApplySkill_Add_E2 and try to execute it, then check errors and fix them.
|
|
|
|
|
09/24/2012, 19:15
|
#7
|
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 21
|
usp_Save_Char_ApplySkill_Add_E2
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2] Script Date: 09/24/2012 19:45:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]
@CharID int,
@SkillID smallint,
@SkillLevel tinyint,
@LeftResetTime int
AS
SET NOCOUNT ON
INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES(@CharID,@Skillid,@SkillLevel,@LeftResetTime)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
SET NOCOUNT OFF
When executed :
Code:
Msg 137, Level 15, State 2, Procedure usp_Save_Char_ApplySkill_Add_E2, Line 17
Must declare the scalar variable "@Skillid".
|
|
|
|
|
09/24/2012, 19:19
|
#8
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
|
It is telling you that you don't have declared @Skillid correctly
|
|
|
|
|
09/24/2012, 19:41
|
#9
|
elite*gold: 50
Join Date: Sep 2011
Posts: 408
Received Thanks: 1,262
|
Write DECLARE @Skillid smallint after SET NOCOUNT ON and i think your problem will be fixed o,o
|
|
|
|
|
09/24/2012, 22:45
|
#10
|
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 21
|
After I wrote DECLARE @Skillid smallint after SET NOCOUNT ON the quiry was executed successfully.
And when I tried to use any of the runes ,this time I got that error :
Code:
2012-09-24 21:27:45 PS_DBAGENT__system log start (DBAgent01)
2012-09-24 21:27:47 connect game, Name=
2012-09-24 21:27:47 connect game, Name=
2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID', table 'PS_GameData.dbo.CharApplySkills'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
2012-09-24 21:48:02 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}
2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID', table 'PS_GameData.dbo.CharApplySkills'; column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
2012-09-24 21:48:02 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}
2012-09-24 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)
2012-09-24 21:53:29 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}
2012-09-24 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)
2012-09-24 21:53:29 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}
2012-09-24 21:57:45 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)
2012-09-24 21:57:45 VerifyReConnect : The Connection has been lost, SQLHDBC=712d18
2012-09-24 21:57:46 SDatabasePool::Reconnect:: success...
2012-09-24 21:59:39 1 1 SAgent::Disconnect: (4, 64)
2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=35,RCS=0, RB=742,RBS=0, SC=39,SCS=0, SB=2987,SBS=1
2012-09-24 21:59:39 disconnect game, Name=Game01
2012-09-24 21:59:39 1 1 SAgent::Disconnect: (4, 64)
2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=7,RCS=0, RB=61,RBS=0, SC=9,SCS=0, SB=2088,SBS=1
2012-09-24 21:59:39 disconnect game, Name=Game01
2012-09-24 21:59:39 save market... wait plz...
2012-09-24 21:59:39 save all... wait plz... enter /uc
2012-09-24 21:59:39 3 1 SERVICE_CONTROL_STOP
2012-09-24 21:59:39 PS_DBAGENT__system log end (DBAgent01)
2012-09-24 21:59:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Code:
2012-09-24 21:27:45 PS_GAME__system log start (Game01) [KR]
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/sorp1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/croco1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/croco2
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Troll1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Spink1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/GoldenPig
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Sorp3
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/SorpNamed1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/SorpNamed2
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Sorp2
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrocoNamed1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrocoNamed2
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrocoNamed3
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/OrcNamed1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/OrcNamed2
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/OrcNamed3
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/TrollNamed1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Deinos
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Parridalis
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Alcarian
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/ZinAlcaria
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Belizabeth
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Kirhiross
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/CrypticOne
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Haruhion
2012-09-24 21:27:45 Loaded Behavior In Factory : data/ai/Freezing
2012-09-24 21:27:47 connect mgr 792
2012-09-24 21:27:47 connect dbagent 800
2012-09-24 21:27:47 connect dbagent2 812
2012-09-24 21:27:47 connect gamelog 844
2012-09-24 21:27:47 Market End -----------------------
2012-09-24 21:27:48 Load Shaiya.SData 0
2012-09-24 21:48:02 discon client: (104, 64) T=000:03:00:000, RC=14,RCS=0, RB=109,RBS=0, SC=101,SCS=0, SB=1945,SBS=8
2012-09-24 21:53:29 discon client: (104, 64) T=000:01:00:000, RC=10,RCS=0, RB=76,RBS=1, SC=81,SCS=1, SB=1622,SBS=21
2012-09-24 21:59:39 3 1 SERVICE_CONTROL_STOP
2012-09-24 21:59:39 Call save all waiting...
2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=39,RCS=0, RB=2987,RBS=1, SC=35,SCS=0, SB=742,SBS=0
2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=9,RCS=0, RB=231,RBS=0, SC=21,SCS=0, SB=1257,SBS=0
2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=9,RCS=0, RB=2088,RBS=1, SC=7,SCS=0, SB=61,SBS=0
2012-09-24 21:59:39 discon dbagent ((3,64, 2987,742)
2012-09-24 21:59:39 discon dbagent2 ((3,64, 2088,61)
2012-09-24 21:59:39 discon mgr ((3,64, 231,1257)
2012-09-24 21:59:39 dbagent2 Connection Lost INFO : T=000:31:00:000, RC=9,RCS=0, RB=2088,RBS=1, SC=7,SCS=0, SB=61,SBS=0
2012-09-24 21:59:39 mgr Connection Lost INFO : T=000:31:00:000, RC=9,RCS=0, RB=231,RBS=0, SC=21,SCS=0, SB=1257,SBS=0
2012-09-24 21:59:39 db agent2 server disconnected...
2012-09-24 21:59:39 mgr server disconnection
2012-09-24 21:59:39 dbagent Connection Lost INFO : T=000:31:00:000, RC=39,RCS=0, RB=2987,RBS=1, SC=35,SCS=0, SB=742,SBS=0
2012-09-24 21:59:39 db agent server disconnected...
2012-09-24 21:59:39 call disconnectAll...
2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=21,SCS=0, SB=1699,SBS=0
2012-09-24 21:59:39 discon gamelog ((3,64, 24,1699)
2012-09-24 21:59:39 gamelog Connection Lost INFO : T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=21,SCS=0, SB=1699,SBS=0
2012-09-24 21:59:39 game log server disconnection
2012-09-24 21:59:39 1 1 SAgent::Disconnect: (3, 64)
2012-09-24 21:59:39 1 1 T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=10,SCS=0, SB=171,SBS=0
2012-09-24 21:59:39 discon userlog ((3,64, 24,171)
2012-09-24 21:59:39 userlog Connection Lost INFO : T=000:31:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=10,SCS=0, SB=171,SBS=0
2012-09-24 21:59:39 userlog log server disconnection
2012-09-24 21:59:39 server shutdown Connection INFO : T=000:31:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=2,CReq=2,CCnt=2,DCCnt=2, CTimeT=000:05:00:000,CTimeAvg=000:02:00:000, RBT=185,RBS=0,RBSC=0,SBT=3567,SBS=1,SBSC=11
2012-09-24 21:59:39 Save Shaiya.SData 1
2012-09-24 21:59:39 PS_GAME__system log end (Game01)
2012-09-24 21:59:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
And I right clicked on CharApplySkills , clicked on Design and set Identity Specification as Yes from CharID Column Properties
Then Tried again ,this time I got this error:
Code:
2012-09-24 21:59:55 PS_DBAGENT__system log start (DBAgent01)
2012-09-24 21:59:56 connect game, Name=
2012-09-24 21:59:56 connect game, Name=
2012-09-24 22:21:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)
2012-09-24 22:21:47 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}
2012-09-24 22:21:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)
2012-09-24 22:21:47 ::SaveCharacter 1 KEFARET ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(1,242,1,3583)}
|
|
|
|
|
09/25/2012, 00:26
|
#11
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
|
If you see here it is telling you:
Code:
2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID',
table 'PS_GameData.dbo.CharApplySkills';
column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
Basically you need to check what is going on there because your database is adding a NULL under SkillID, when SkillID can't be set at NULL
|
|
|
|
|
09/25/2012, 00:36
|
#12
|
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 21
|
Quote:
Originally Posted by JohnHeatz
If you see here it is telling you:
Code:
2012-09-24 21:48:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SkillID',
table 'PS_GameData.dbo.CharApplySkills';
column does not allow nulls. INSERT fails., SQL STATE: 23000, NATIVE ERROR: 515 (0x203)
Basically you need to check what is going on there because your database is adding a NULL under SkillID, when SkillID can't be set at NULL |
As I explained in my previous post that I fixed that error by setting auto increment but could not fix when IDENTITY_INSERT is set to OFF error. So I want to learn how to let IDENTITY_INSERT to set to ON from OFF setting.
I could not find a way to turn IDENTITY INSERT setting ON and this error accured just after I set auto increment.Before this setting I got "Can not insert NULL into x column." so I set all columns as Allow NULL.
Code:
USE [PS_GameData]
GO
/****** Object: Table [dbo].[CharApplySkills] Script Date: 09/25/2012 04:36:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CharApplySkills](
[RowID] [int] NULL,
[CharID] [int] NULL,
[SkillID] [smallint] NULL,
[SkillLevel] [tinyint] NULL,
[LeftResetTime] [int] NULL
) ON [PRIMARY]
I did not get error.It did not roll back.But when I use a rune or a noss ,it disappears after relog.When I checked CharApplySkills Table I found SkillID column as NULL
While I received
Code:
2012-09-25 03:39:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'CharApplySkills' when IDENTITY_INSERT is set to OFF., SQL STATE: 23000, NATIVE ERROR: 544 (0x220)
error ,CharApplySkills table was set like below.
Code:
USE [PS_GameData]
GO
/****** Object: Table [dbo].[CharApplySkills] Script Date: 09/25/2012 03:17:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CharApplySkills](
[RowID] [int] NOT NULL,
[CharID] [int] IDENTITY(1,1) NOT NULL,
[SkillID] [smallint] NOT NULL,
[SkillLevel] [tinyint] NOT NULL,
[LeftResetTime] [int] NOT NULL,
CONSTRAINT [PK_CharApplySkills_1] PRIMARY KEY CLUSTERED
(
[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
I changed all OFF settings to ON like this :
Code:
[CharID] ASC
)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = ON, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Still it did not work.
If I allow to insert NULL value to the columns ,I do not get error but at that time runes and nosses are not permanent.They remain till relog then disapppear.
I am stuck 
|
|
|
|
|
09/26/2012, 05:36
|
#13
|
elite*gold: 0
Join Date: Jan 2011
Posts: 238
Received Thanks: 901
|
From what i can see you are trying to enter information into the DB that the game doesn't understand.
If SkillID is set to NULL then it doesn't know what skill to re-apply when you relog onto the character. Basically you are trying to tell it to add SkillID NULL so that means NO SkillID.
If it is from a Rune or Noss then they have a Specific SkillID that must be listed in the CharApplySkills DB in order for it to Re-Apply them upon logging in.
Is this from Custom Buffs or Noss items? If so then re-check your information you added into the sdata and DB for them because all ApplySkills have a unique SkillID that is listed in the Skills DB like 30 Day Conti is SkillID 286 and The Knockout Noss is SkillID 215...
|
|
|
|
|
09/26/2012, 10:21
|
#14
|
elite*gold: 0
Join Date: Sep 2010
Posts: 520
Received Thanks: 1,289
|
Quote:
Originally Posted by [ADM]KEFARET
usp_Save_Char_ApplySkill_Add_E2
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2] Script Date: 09/24/2012 19:45:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]
@CharID int,
[COLOR="red"]@SkillID smallint[/COLOR],
@SkillLevel tinyint,
@LeftResetTime int
AS
SET NOCOUNT ON
INSERT INTO CharApplySkills(CharID,[COLOR="red"]Skillid[/COLOR],SkillLevel,LeftResetTime) VALUES(@CharID,[COLOR="red"]@Skillid[/COLOR],@SkillLevel,@LeftResetTime)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
SET NOCOUNT OFF
When executed :
Code:
Msg 137, Level 15, State 2, Procedure usp_Save_Char_ApplySkill_Add_E2, Line 17
Must declare the scalar variable "[COLOR="Red"]@Skillid[/COLOR]".
|
Go to your database that contains "CharApplySkills", verify the column is "Skillid" and not "SkillID".
In your SP, you have "@Skillid", but it's not declared anywhere. However you also have "@SkillID" declared as a parameter. Seems like a typo to me, change "@Skillid" to "@SkillID" to match the parameter variable.
|
|
|
|
|
09/26/2012, 23:21
|
#15
|
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 21
|
I am formating test VDS and will try what you both told after the server is ready.
RebeccaBlack has caught a very good point.I think that will solve my problem.Hope so.
Thanks to all for your time and assistance.
EDIT: Great! It worked. I changed all @Skillid as @SkillID and cleared DECLARE @SkillID smallint lines both from usp_Save_Char_ApplySkill_Add_E and usp_Save_Char_ApplySkill_Add_E2. Then Executed the procedure.
It cost my half and a month to figure out and fix that problem.In the meanwhile I learnt much by searching a solution.I am much more familiar to the scripts and logs now.
"Every cloud has a silver lining" It is a very right proverb.
I do thank all of you very very very much and many times. Especially RebeccaBlack.
|
|
|
|
 |
Similar Threads
|
WTS: NA LoL Acct, 56 Champs, 5 Rune pages. Top Elo 1572, many rune sets.
07/04/2012 - League of Legends Trading - 0 Replies
I am wanting to sell one of my LvL 30 accts that I dont play much anymore besides when I goof off with friends. It currently has 56 champs, 5 rune pages, a few skins. Top elo of 1572, Current elo of 1312. I've spent a bit of money on it. It currently has 175RP and 3602 IP. The summoner name is 2Good2BeTru.
Im looking for no less then $50 US Dollars made through PayPal. The account is in good standing with 0 bans/warnings. I will not release the information to the account until the payment...
|
Selling lvl 30 NA account, 36 champs, 4 rune pages, 4 T3 rune sets, and skins!
03/02/2012 - League of Legends Trading - 1 Replies
this account has all the things you could want in any league of legends account, skins, champions, runes, rune pages! i have personally also spent over $120 on riot points for this account
some of the benefits include:
36 champions:
akali
alistar
amumu
annie
ashe
casseopeia
|
EU WEST ACCOUNT - 53 SKINS - 11 Rune Page with Rune Set - NOT OWNED 11 CHAMP
01/30/2012 - League of Legends Trading - 8 Replies
Hello Elitepvpers ;)
I'm selling League of Legends Europe-West Account with Rare Skins,Many Skins,Champions,Runes...
I have 53 Skins include Rare-Limited Skins.
I don't have only 11 Champions.
I have 5, Tier 3 Mark Sets.6 Seals Tier 3 Sets,6 Glyphs Tier 3 Sets,7 Quintessince Sets.
Everysets have 9 runes. 9x5 + 9x6 + 9x6 + 9x7 Runes with 11 Rune Pages.
|
Bug with Defence rune/escape rune etc..?
10/02/2010 - RF Online - 0 Replies
someone know??? can explain? tips ??
possible or not??
=)
|
Rollback
09/22/2007 - Conquer Online 2 - 11 Replies
Quoted at this Site
As compensation to players that lost experience during this rollback we will be offering double experience this weekend. <-------this is the best part
Update:
|
All times are GMT +1. The time now is 13:44.
|
|
![[ADM]KEFARET's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar4449596_1.gif){kind=avatar}
