Item Mall error on EP5

04/17/2011 14:08 Mr.Shaiya#1

Hello all ,

My server is 5.3 and is public for friends , now i got a problem with the Item mall , i had never problems with it till yesterday. I checked My logs and it give 1 Error in PS_DBAGENT:

2011-04-17 13:50:12 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype VARCHAR naar DATETIME., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-04-17 13:50:12 SaveBuyPointItem 11 adminn qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,11,0,'Uber Boots','2011-04-17 13:50:12')}

(my item mall got only 1 item to buy , i did this for a test. The Item excist and the count is 1 in database)

The error says : error by convert from Varchar to Datetime.. How can i fix this ?

Thanks

Mr.Shaiya

07/24/2011 12:24 olyshop#2

your error is from sql, try to reinstall look on search how to instal correcly GL and sorry for my bad english, hope i helped you

07/24/2011 13:44 castor4878#3

Quote:

Originally Posted by Mr.Shaiya

2011-04-17 13:50:12 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Er is een fout opgetreden bij het converteren van het gegevenstype VARCHAR naar DATETIME., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-04-17 13:50:12 SaveBuyPointItem 11 adminn qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,11,0,'Uber Boots','2011-04-17 13:50:12')}

The error says : error by convert from Varchar to Datetime.. How can i fix this ?

what about changing the datetime for a varchar ?

your proc is defined as:

Code:

Proc [dbo].[usp_Save_User_BuyPointItems_NCash]
	@UserUID int,
	@CharID int,
	@UsePoint int,
	@ProductCode varchar(20),
	@UseDate datetime
as
	...

change this for:

Code:

Proc [dbo].[usp_Save_User_BuyPointItems_NCash]
	@UserUID int,
	@CharID int,
	@UsePoint int,
	@ProductCode varchar(20),
	@textDate varchar(30)
as

DECLARE @UseTime datetime
set @UseTime=convert(datetime, @textDate, 120)