LOG_ITEM_STR

Ecrypter · 10/29/2014, 18:00

hi epvpers how to fix this error

PHP Code:


			
query:LOG_ITEM_STR @im_szName='iPwnY',@iserverindex='01',@im_GetszName='N0VAS',@idwWorldID=1,@im_dwGold=135000,@im_nRemainGold=135000,@iItem_UniqueNo=-2023805421,@iItem_Name='26460',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=5120,@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

thanks in advance

12gamer34 · 10/29/2014, 19:16

I think:
You need to Change the log01 DataSourceName to LOGGING_01_DBF, not LOG_01_DBF.

xTwiLightx · 10/29/2014, 20:01

Quote:

Originally Posted by Ecrypter

hi epvpers how to fix this error

PHP Code:

query:LOG_ITEM_STR @im_szName='iPwnY',@iserverindex='01',@im_GetszName='N0VAS',@idwWorldID=1,@im_dwGold=135000,@im_nRemainGold=135000,@iItem_UniqueNo=-2023805421,@iItem_Name='26460',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=5120,@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

thanks in advance

Could you post more CQuery-LogFile errors? I think the real problem should be found before that.
I think that it should be something with uspLoggingTrade @iFlag=2.

Quote:

Originally Posted by 12gamer34

I think:
You need to Change the log01 DataSourceName to LOGGING_01_DBF, not LOG_01_DBF.

Und wenn die LOG_01_DBF genau das selbe enthält die die LOGGING_01_DBF? Nein.

Ecrypter · 10/30/2014, 11:36

here

PHP Code:


			
014/10/30    00:11:28
query:uspLoggingTrade @pFlag=2, @pTradeID=1414653119, @pserverindex='01', @pidPlayer='0000034', @pItemIndex='26645', @pItemSerialNum=1870887728, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1215954410219110144
SQLSTATE:23000 error:[Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'PK_tblTradeItemLog'. Cannot insert duplicate key in object 'dbo.tblTradeItemLog'.
2014/10/30    00:11:28
query:uspLoggingTrade @pFlag=2, @pTradeID=1414653119, @pserverindex='01', @pidPlayer='0000034', @pItemIndex='26645', @pItemSerialNum=1870887728, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1215954410219110144
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/10/30    00:11:28
query:LOG_ITEM_STR @im_szName='vllMaroonllv',@iserverindex='01',@im_GetszName='WeAreYoung',@idwWorldID=1,@im_dwGold=799999993,@im_nRemainGold=799999993,@iItem_UniqueNo=1304304066,@iItem_Name='23574',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@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