- 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
Attachments
You must be registered for see attachments list
Last edited: