How To Fix This

Ecrypter · 08/27/2014, 16:53

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

Mognakor · 08/28/2014, 12:36

Whats the type of 'pRandomOpt'? If it's not a string or 64bit variable it is most likely the cause for this.

xTwiLightx · 08/30/2014, 12:31

Change the type of tblTradeItemLog.m_nRandomOpt from int to bigint.

Ecrypter · 08/30/2014, 18:45

Quote:

Originally Posted by xTwiLightx

Change the type of tblTradeItemLog.m_nRandomOpt from int to bigint.

how to change sir.,?

i change the int to big INT?

Icetea · 08/31/2014, 15:17

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

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'

xTwiLightx · 08/31/2014, 16:18

Quote:

Originally Posted by Icetea'

Use SQL Management studio to change the column type from int to bigint. Click save.

Not with a filled table.