- Joined
- Mar 3, 2013
- Messages
- 268
- Reaction score
- 25
please help me!
error log..
other error:
first open normal open
2º normal items open
3º no update item no view item
4º relogin server view item
Help Fix Please
error log..
dbo.sp[09/13/17 06:08:37] MMatchDBMgr::ExceptionHandlerErrSQL( {CALL spChangeGambleItemToRewardSpendableItem (1944, 36836, 1003103, 203, 405005, 0)} ), ErrCode( -1 )ErrMsg - El nombre de columna 'RentHourPeriod' no es válido.El nombre de columna 'ItemCnt' no es válido.State:S0022,Native:207,Origin:[Microsoft][SQL Server Native Client 11.0][SQL Server]
USE [GUNZARMYDBAren]GO/****** Object: StoredProcedure [dbo].[spChangeGambleItemToRewardItem] Script Date: 13/09/2017 17:35:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROC [dbo].[spChangeGambleItemToRewardItem] -- CREATE PROC dbo.spChangeGambleItemToRewardItem @CID INT , @CIID INT , @GIID INT , @GRIID INT , @RewardItemID INTAS BEGIN SET NOCOUNT ON; DECLARE @RentHourPeriod INT DECLARE @GambleItemCount INT; ----------------------------------------------------------------------------- SELECT @RentHourPeriod = ISNULL(RentHourPeriod, 0) FROM GambleRewardItem gri(NOLOCK) WHERE GRIID = @GRIID AND GIID = @GIID AND (ItemIDMale = @RewardItemID OR ItemIDFemale = @RewardItemID) IF (0 = @@ROWCOUNT) BEGIN SELECT -1 AS 'Ret' RETURN END SELECT @GambleItemCount = ISNULL(Cnt, 1) FROM CharacterItem(NOLOCK) WHERE CIID = @CIID; ----------------------------------------------------------------------------- DECLARE @NowDate DATETIME; SET @NowDate = GETDATE(); ----------------------------------------------------------------------------- BEGIN TRAN ----------- ---------------------------------------------------------------------------------------- IF( @GambleItemCount > 1 ) BEGIN UPDATE CharacterItem SET Cnt = Cnt - 1 WHERE CID = @CID AND CIID = @CIID IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN ROLLBACK TRAN SELECT -2 AS 'Ret' RETURN END END ELSE BEGIN UPDATE CharacterItem SET CID = NULL WHERE CID = @CID AND CIID = @CIID IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN ROLLBACK TRAN SELECT -3 AS 'Ret' RETURN END END --------------------------------------------------------------------------------------- INSERT CharacterItem(CID, ItemID, RegDate, RentDate, RentHourPeriod, Cnt) VALUES (@CID, @RewardItemID, @NowDate, @NowDate, @RentHourPeriod, 1) DECLARE @OrderCIID INT; SET @OrderCIID = @@IDENTITY; IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -4 AS 'Ret' RETURN END INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count]) VALUES (202, @NowDate, @CID, @CIID, @GIID, 1); IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -5 AS 'Ret' RETURN END INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count]) VALUES (102, @NowDate, @CID, @OrderCIID, @RewardItemID, 1); IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -6 AS 'Ret' RETURN END INSERT INTO LogDB..GambleLog(CID, GIID, RewardItemID, RegDate) VALUES (@CID, @GIID, @RewardItemID, @NowDate); IF (0 <> @@ERROR) BEGIN ROLLBACK TRAN SELECT -7 AS 'Ret' RETURN END ---------------------------------------------------------------------------------------- COMMIT TRAN ----------- SELECT 0 AS 'Ret', @OrderCIID AS 'ORDERCIID'END
other error:
first open normal open
2º normal items open
3º no update item no view item
4º relogin server view item
Help Fix Please
Last edited: