How To Fix This

08/27/2014 16:53 Ecrypter#1
PHP Code:
uery:uspLoggingTrade @pFlag=2, @pTradeID=1409052769, @pserverindex='01', @pidPlayer='0000087', @pItemIndex='21040', @pItemSerialNum=-252860374, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1423756851920244480
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/26    04:33:09
query:uspLoggingTrade @pFlag=2, @pTradeID=1409052769, @pserverindex='01', @pidPlayer='0000087', @pItemIndex='21040', @pItemSerialNum=-252860374, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1423756851920244480
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/26    04:33:11
query:uspLoggingAcquireSkillPoint '01','0000117',0,0,11,930,930,0,11
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/26    04:33:30
query:uspLoggingTrade @pFlag=2, @pTradeID=1409052802, @pserverindex='01', @pidPlayer='0000115', @pItemIndex='21040', @pItemSerialNum=-252860374, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1423756851920244480
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/26    04:33:30
query:uspLoggingTrade @pFlag=2, @pTradeID=1409052802, @pserverindex='01', @pidPlayer='0000115', @pItemIndex='21040', @pItemSerialNum=-252860374, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1423756851920244480
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/26    04:33:35
query:LOG_STR 'L1',@im_idPlayer='0000117',@iserverindex='01',@im_nExp1=518168675295,@im_nLevel=200,@im_nJob=33,@im_nJobLv=1,@im_nFlightLv=1,@im_nStr=625,@im_nDex=15,@im_nInt=15,@im_nSta=15,@im_nRemainGP=137,@im_nRemainLP=0,@iState='E',@idwWorldID=0,@ikilled_m_szName='(null)',@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@iattackPower=165499997,@imax_HP=2772,@im_GetszName='(null)',@im_dwGold=0,@im_nRemainGold=0,@iItem_UniqueNo=0,@iItem_Name='',@iItem_durability=0,@iItem_count=0,@iItem_AddLv=0,@iStart_Time='(null)',@iTotalPlayTime=0,@iremoteIP='(null)',@iQuest_Index=0,@ikilled_m_idPlayer='0000000'
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/26    05:30:15
query:uspLoggingTrade @pFlag=2, @pTradeID=1409056194, @pserverindex='01', @pidPlayer='0000046', @pItemIndex='50234', @pItemSerialNum=770648146, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1387728949593252608
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/26    05:30:15
query:uspLoggingTrade @pFlag=2, @pTradeID=1409056194, @pserverindex='01', @pidPlayer='0000046', @pItemIndex='50234', @pItemSerialNum=770648146, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1387728949593252608
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/26    05:30:15
query:LOG_ITEM_STR @im_szName='GROUND',@iserverindex='01',@im_GetszName='Cally',@idwWorldID=2,@im_dwGold=2147483647,@im_nRemainGold=2147483647,@iItem_UniqueNo=1475996008,@iItem_Name='2036',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=1,@iState='R',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=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 Native Client]Invalid cursor state
2014/08/26    05:34:39
query:uspLoggingTrade @pFlag=2, @pTradeID=1409056456, @pserverindex='01', @pidPlayer='0000046', @pItemIndex='40297', @pItemSerialNum=-2110107871, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=1, @pResistAbilityOpt=20,@pRandomOpt=1423669785681993216
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/26    05:34:39
query:uspLoggingTrade @pFlag=2, @pTradeID=1409056456, @pserverindex='01', @pidPlayer='0000046', @pItemIndex='40297', @pItemSerialNum=-2110107871, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=1, @pResistAbilityOpt=20,@pRandomOpt=1423669785681993216
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/26    05:34:39
query:LOG_ITEM_STR @im_szName='Nami',@iserverindex='01',@im_GetszName='Panda',@idwWorldID=1,@im_dwGold=2147482647,@im_nRemainGold=2147482647,@iItem_UniqueNo=1399570626,@iItem_Name='26460',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=2147483647,@iItem_count=9999,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=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 Native Client]Invalid cursor state
2014/08/26    05:59:28
query:{call uspSavePocket( '01', '0000133', ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQLSTATE:40001 error:[Microsoft][SQL Native Client][SQL Server]Transaction (Process ID 240) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2014/08/26    06:09:54
q 
how to fix this error? my server is online., but i got this error.,

thanks im advance., hope you can help me
08/28/2014 12:36 Mognakor#2
Whats the type of 'pRandomOpt'? If it's not a string or 64bit variable it is most likely the cause for this.
08/30/2014 12:31 xTwiLightx#3
Change the type of tblTradeItemLog.m_nRandomOpt from int to bigint.
08/30/2014 18:45 Ecrypter#4
Quote:
Originally Posted by xTwiLightx View Post
Change the type of tblTradeItemLog.m_nRandomOpt from int to bigint.

how to change sir.,?

i change the int to big INT?
08/31/2014 15:17 Icetea#5
Use SQL Management studio to change the column type from int to bigint. Click save. Tell everyone you're working hard on it, and go to lunch. ;)

Quote:
Originally Posted by xTwiLightx View Post
Change the type of tblTradeItemLog.m_nRandomOpt from int to bigint.
Like TwaiLeit already said. Everything else should be self-explaining because SQL Management studio isn't realy hard to understand.. If you have further questions you could use next time google or certainly you can post in this thread again.

Regards,
Icetea'
08/31/2014 16:18 xTwiLightx#6
Quote:
Originally Posted by Icetea' View Post
Use SQL Management studio to change the column type from int to bigint. Click save.
Not with a filled table.