How to fix this database error?

09/17/2016 08:08 Ecrypter#1

CQuery-LogFile_20160916

Spoiler

error_20160916

Spoiler

or anyone can share the link on how to fix this error
thanks in advance

09/17/2016 14:27 Sedrika#2

This is a bug with the datatype of RandomOpt in tblTradeItemLog.

Execute this once to fix it:

Code:

USE [LOGGING_01_DBF]
GO

ALTER TABLE [tblTradeItemLog] DROP CONSTRAINT [DF_tblTradeItemLog_RandomOpt]
GO

ALTER TABLE [tblTradeItemLog]
ALTER COLUMN [RandomOpt] BIGINT NOT NULL
GO

ALTER TABLE [dbo].[tblTradeItemLog] ADD  CONSTRAINT [DF_tblTradeItemLog_RandomOpt]  DEFAULT ((0)) FOR [RandomOpt]
GO

05/01/2018 16:38 flyforall123#3

i got the same error too cause the trans not working .
can someone help me

Spoiler

05/04/2018 14:14 #vue#4

Quote:

Originally Posted by flyforall123

i got the same error too cause the trans not working .
can someone help me

Spoiler

query:uspLoggingTrade @pFlag=2, @[Only registered and activated users can see links. Click Here To Register...]deID=1525123814, @[Only registered and activated users can see links. Click Here To Register...]ndex='01', @pidPlayer='0000108', @[Only registered and activated users can see links. Click Here To Register...]mIndex='22448', @[Only registered and activated users can see links. Click Here To Register...]mSerialNum=421617161, @[Only registered and activated users can see links. Click Here To Register...]mCnt=1, @pAbilityOpt=0, @[Only registered and activated users can see links. Click Here To Register...]mResist=0, @[Only registered and activated users can see links. Click Here To Register...]stAbilityOpt=0 @[Only registered and activated users can see links. Click Here To Register...]mOpt=1353719344679130624
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @[Only registered and activated users can see links. Click Here To Register...]deID=1525123814, @[Only registered and activated users can see links. Click Here To Register...]ndex='01', @pidPlayer='0000108', @[Only registered and activated users can see links. Click Here To Register...]mIndex='22448', @[Only registered and activated users can see links. Click Here To Register...]mSerialNum=421617161, @[Only registered and activated users can see links. Click Here To Register...]mCnt=1, @pAbilityOpt=0, @[Only registered and activated users can see links. Click Here To Register...]mResist=0, @[Only registered and activated users can see links. Click Here To Register...]stAbilityOpt=0 @[Only registered and activated users can see links. Click Here To Register...]mOpt=1353719344679130624
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-506333170,@iItem_Name='22449',@iItem_durability=0, @im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count= 1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=0,@im_dwKeepTime=0,@im_nRandomOptItemId=20079797 7511761408,@inPiercedSize=0,@iadwItemId0=0,@iadwIt emId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4 =0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@i dwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D= 0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_ S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@ iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@i adwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@ iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @[Only registered and activated users can see links. Click Here To Register...]deID=1525123814, @[Only registered and activated users can see links. Click Here To Register...]ndex='01', @pidPlayer='0000108', @[Only registered and activated users can see links. Click Here To Register...]mIndex='22449', @[Only registered and activated users can see links. Click Here To Register...]mSerialNum=-506333170, @[Only registered and activated users can see links. Click Here To Register...]mCnt=1, @pAbilityOpt=0, @[Only registered and activated users can see links. Click Here To Register...]mResist=0, @[Only registered and activated users can see links. Click Here To Register...]stAbilityOpt=0 @[Only registered and activated users can see links. Click Here To Register...]mOpt=200797977511761408
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @[Only registered and activated users can see links. Click Here To Register...]deID=1525123814, @[Only registered and activated users can see links. Click Here To Register...]ndex='01', @pidPlayer='0000108', @[Only registered and activated users can see links. Click Here To Register...]mIndex='22449', @[Only registered and activated users can see links. Click Here To Register...]mSerialNum=-506333170, @[Only registered and activated users can see links. Click Here To Register...]mCnt=1, @pAbilityOpt=0, @[Only registered and activated users can see links. Click Here To Register...]mResist=0, @[Only registered and activated users can see links. Click Here To Register...]stAbilityOpt=0 @[Only registered and activated users can see links. Click Here To Register...]mOpt=200797977511761408
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-629865712,@iItem_Name='22447',@iItem_durability=0, @im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count= 1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=0,@im_dwKeepTime=0,@im_nRandomOptItemId=11905388 99836933632,@inPiercedSize=0,@iadwItemId0=0,@iadwI temId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId 4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@ idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D =0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL _S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0, @iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@ iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0, @iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @[Only registered and activated users can see links. Click Here To Register...]deID=1525123814, @[Only registered and activated users can see links. Click Here To Register...]ndex='01', @pidPlayer='0000108', @[Only registered and activated users can see links. Click Here To Register...]mIndex='22447', @[Only registered and activated users can see links. Click Here To Register...]mSerialNum=-629865712, @[Only registered and activated users can see links. Click Here To Register...]mCnt=1, @pAbilityOpt=0, @[Only registered and activated users can see links. Click Here To Register...]mResist=0, @[Only registered and activated users can see links. Click Here To Register...]stAbilityOpt=0 @[Only registered and activated users can see links. Click Here To Register...]mOpt=1190538899836933632
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @[Only registered and activated users can see links. Click Here To Register...]deID=1525123814, @[Only registered and activated users can see links. Click Here To Register...]ndex='01', @pidPlayer='0000108', @[Only registered and activated users can see links. Click Here To Register...]mIndex='22447', @[Only registered and activated users can see links. Click Here To Register...]mSerialNum=-629865712, @[Only registered and activated users can see links. Click Here To Register...]mCnt=1, @pAbilityOpt=0, @[Only registered and activated users can see links. Click Here To Register...]mResist=0, @[Only registered and activated users can see links. Click Here To Register...]stAbilityOpt=0 @[Only registered and activated users can see links. Click Here To Register...]mOpt=1190538899836933632
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-1392407597,@iItem_Name='22446',@iItem_durability=0 ,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count =1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_b ItemResist=0,@im_nResistAbilityOption=0,@im_bCharg ed=0,@im_dwKeepTime=0,@im_nRandomOptItemId=3866784 1150948864,@inPiercedSize=0,@iadwItemId0=0,@iadwIt emId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4 =0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@i dwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D= 0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_ S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@ iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@i adwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@ iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @[Only registered and activated users can see links. Click Here To Register...]deID=1525123814, @[Only registered and activated users can see links. Click Here To Register...]ndex='01', @pidPlayer='0000108', @[Only registered and activated users can see links. Click Here To Register...]mIndex='22446', @[Only registered and activated users can see links. Click Here To Register...]mSerialNum=-1392407597, @[Only registered and activated users can see links. Click Here To Register...]mCnt=1, @pAbilityOpt=0, @[Only registered and activated users can see links. Click Here To Register...]mResist=0, @[Only registered and activated users can see links. Click Here To Register...]stAbilityOpt=0 @[Only registered and activated users can see links. Click Here To Register...]mOpt=38667841150948864
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26

Change prandomOpt from int to bigint.