I need a help for my error

[tangia1426]

How to fix this one sir/mom

 Spoiler

2013/05/16 07:47:06
query:uspLoggingTrade @pFlag=2, @pTradeID=1368715645, @pserverindex='01', @pidPlayer='0001741', @pItemIndex='50042', @pItemSerialNum=286355284, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=65555597869616742 4
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2013/05/16 07:47:06
query:uspLoggingTrade @pFlag=2, @pTradeID=1368715645, @pserverindex='01', @pidPlayer='0001741', @pItemIndex='50042', @pItemSerialNum=286355284, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=65555597869616742 4
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2013/05/16 07:47:06
query:LOG_ITEM_STR @im_szName='Ignacio',@iserverindex='01',@im_GetszN ame='GirLalu',@idwWorldID=1,@im_dwGold=1497381963, @im_nRemainGold=1497381963,@iItem_UniqueNo=2068486 656,@iItem_Name='50270',@iItem_durability=3600000, @im_nAbilityOption=0,@Im_GetdwGold=500000,@iItem_c ount=1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@ im_bItemResist=0,@im_nResistAbilityOption=0,@im_bC harged=1,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@ inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iad wItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDura bility=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,@iadwIte mId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadwItemId8= 0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0 =0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId 3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2013/05/16 08:17:24
query:uspLoggingTrade @pFlag=2, @pTradeID=1368717445, @pserverindex='01', @pidPlayer='0001741', @pItemIndex='21040', @pItemSerialNum=1933753700, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=5293413506560
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2013/05/16 08:17:24
query:uspLoggingTrade @pFlag=2, @pTradeID=1368717445, @pserverindex='01', @pidPlayer='0001741', @pItemIndex='21040', @pItemSerialNum=1933753700, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=5293413506560
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2013/05/16 08:17:24
query:LOG_ITEM_STR @im_szName='DreamS',@iserverindex='01',@im_GetszNa me='::AwakeCancel',@idwWorldID=1,@im_dwGold=109347 423,@im_nRemainGold=109347423,@iItem_UniqueNo=5417 3556,@iItem_Name='5791',@iItem_durability=4500000, @im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count= 1,@iState='r',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPie rcedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItem Id2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurabilit y=0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPet Energy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@i nPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5= 0,@iadwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@ia dwItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@i adwUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@ iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2013/05/16 08:53:31
query:uspLoggingTrade @pFlag=2, @pTradeID=1368719595, @pserverindex='01', @pidPlayer='0001975', @pItemIndex='21041', @pItemSerialNum=107732854, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=619166572032
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2013/05/16 08:53:31
query:uspLoggingTrade @pFlag=2, @pTradeID=1368719595, @pserverindex='01', @pidPlayer='0001975', @pItemIndex='21041', @pItemSerialNum=107732854, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=619166572032
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2013/05/16 08:53:31
query:LOG_ITEM_STR @im_szName='Abduction',@iserverindex='01',@im_Gets zName='S0UL',@idwWorldID=1,@im_dwGold=912122344,@i m_nRemainGold=912122344,@iItem_UniqueNo=-394927054,@iItem_Name='5605',@iItem_durability=657 0000,@im_nAbilityOption=0,@Im_GetdwGold=174742551, @iItem_count=1,@iState='T',@im_nSlot0=100,@im_nSlo t1=100,@im_bItemResist=0,@im_nResistAbilityOption= 0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptIt emId=72326770250820608,@inPiercedSize=10,@iadwItem Id0=26597,@iadwItemId1=26597,@iadwItemId2=26597,@i adwItemId3=26597,@iadwItemId4=26597,@iMaxDurabilit y=0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPet Energy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@i nPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5= 26597,@iadwItemId6=26597,@iadwItemId7=26597,@iadwI temId8=26597,@iadwItemId9=26597,@inUMPiercedSize=0 ,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2= 0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2013/05/16 08:53:31
query:uspLoggingTrade @pFlag=2, @pTradeID=1368719595, @pserverindex='01', @pidPlayer='0001975', @pItemIndex='5605', @pItemSerialNum=-394927054, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=72326770250820608
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2013/05/16 08:53:31
query:uspLoggingTrade @pFlag=2, @pTradeID=1368719595, @pserverindex='01', @pidPlayer='0001975', @pItemIndex='5605', @pItemSerialNum=-394927054, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=72326770250820608
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2013/05/16 08:53:31
query:LOG_USER_CNT_STR '01', 0, 27
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2013/05/16 09:41:36
query:uspLoggingTrade @pFlag=2, @pTradeID=1368722513, @pserverindex='01', @pidPlayer='0002447', @pItemIndex='5605', @pItemSerialNum=1325813488, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=19842247456745830 4
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2013/05/16 09:41:36
query:uspLoggingTrade @pFlag=2, @pTradeID=1368722513, @pserverindex='01', @pidPlayer='0002447', @pItemIndex='5605', @pItemSerialNum=1325813488, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=19842247456745830 4
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2013/05/16 09:41:36
query:LOG_ITEM_STR @im_szName='SharonRose',@iserverindex='01',@im_Get szName='SharonRose',@idwWorldID=1,@im_dwGold=61720 7385,@im_nRemainGold=617207385,@iItem_UniqueNo=-1850392905,@iItem_Name='10270',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_coun t=3,@iState='1',@im_nSlot0=0,@im_nSlot1=0,@im_bIte mResist=0,@im_nResistAbilityOption=0,@im_bCharged= 1,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPierc edSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId 2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurability= 0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEn ergy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inP etAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0, @iadwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadw ItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iad wUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@ia dwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state

[raventh1984]

Set the INT for pRandomOpt to bigint.

INT will allow up to 11 digits while bigINT will allow for more.

[tangia1426]

but how?

[raventh1984]

in your database.

go to LOGGING_01_DBF
Right click on tblTradeItemLog and click on design.
Take an look to RandomOpt and you will see what you need to change.

The rest is up to you.