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.
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.
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".
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.
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...
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.
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.
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.
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:
![[ADM]KEFARET's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar4449596_1.gif){kind=avatar}
![[ADM]KEFARET is offline](images/elitepvpers/statusicon/user_offline.gif){kind=small}
Check your Usp_Save_Char_ApplySkill_Add_E2 and try to execute it, then check errors and fix them.
