Problem with temporal seals and scrolls

[minhai]

Hello


I got this problem. When i buy Seal form in game shop, i recive them in box and after i use them, Its says"Item has been used" but nothing apear on the tops of the screen, and neither has diferenc in the Exp for example. This happening only with seals and scrolls. The rest of the items i can use without problem.

Im Using Seaon 8 Z team files.

Im geting this error:

[22:46:22] [CashShop] [Guid:1] UpdatePoint info [930/1000/305]
[22:46:22] [CashShop][BUY REQUEST] - SUCCESS [1](OriginalSM) Category: 34, PackageID: 2505, ProductID: 0, wCoin_c: 930, wCoin_p:1000, wCoin_g:305
[22:46:25] WZ_PeriodItemInsert 1, 'OriginalSM', 7242, 69, 14, 0, 0, '2015-2-16 22:46'
[22:46:25] SQLSTATE:22007, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
[22:46:25] SQLSTATE:01000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Se terminó la instrucción.

I add the se4al from sql and its work. but from cash shop not.
Also tryed to replace the seals i but still the same error.

for what i understand from this msg i have to fix datatime value . How do i do that?

Config of the fails such as ip and ports are corect

What i have to do to fix that ?

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_PeriodItemInsert] Script Date: 02/17/2015 16:36:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[WZ_PeriodItemInsert]
@memb_guid int,
@CharName varchar(10),
@ItemCode int,
@ItemOption int,
@ItemEffect1 int,
@ItemEffect2 int,
@ItemUseTime int,
@DateTime varchar(30)
AS
BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON

IF EXISTS ( SELECT memb_guid FROM T_PeriodItem_Data WITH (READUNCOMMITTED)
WHERE memb__char = @CharName AND (ItemCode = @ItemCode OR ItemOption = @ItemOption) )
BEGIN
UPDATE T_PeriodItem_Data SET
ItemCode = @ItemCode, ItemOption = @ItemOption,
ItemEffect1 = @ItemEffect1, ItemEffect2 = @ItemEffect2,
UsedTime = 0,LeftTime = @ItemUseTime,ExpireDate = @DateTime
WHERE ItemOption = @ItemOption AND memb__char = @CharName
SELECT 1 AS QueryResult
END
ELSE
BEGIN
INSERT INTO T_PeriodItem_Data (memb_guid,memb__char,ItemCode,ItemOption,ItemEffect1,ItemEffect2,UsedTime,LeftTime,ExpireDate) VALUES
(@memb_guid,@CharName,@ItemCode,@ItemOption,@ItemEffect1,@ItemEffect2,0,@ItemUseTime,@DateTime)
SELECT 0 AS QueryResult
END

IF(@@Error <> 0 )
BEGIN
ROLLBACK TRANSACTION
END
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
END
/****** Object: StoredProcedure [dbo].[WZ_PeriodItemSelect] Script Date: 08/21/2008 19:09:12 ******/

Tnx in advence

[MentaL]

[minhai]

Problem slovet.

@dateTime varchar(30) changed to @dateTime date

[Dope Boy One]

Please next time use prefix [Help] on your topic
View the Rules of each section you post please,

[Help] fixed

Regards Dope.