How to Fix

[Bron*]

 Spoiler

d:\server\source\_database\dbmanagerlog.cpp, 1116: uspLoggingTrade @pFlag=2, @deID=1595413989, @ndex='01', @Player='0000003', @mIndex='25246', @mSerialNum=-115972037, @mCnt=1, @lityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=0

 Spoiler

query:uspLoggingTrade @pFlag=2, @deID=1595413570, @ndex='01', @Player='0000003', @mIndex='25260', @mSerialNum=-1072098025, @mCnt=1, @lityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=0
SQLSTATE:23000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_tblTradeItemLog'. Cannot insert duplicate key in object 'dbo.tblTradeItemLog'. The duplicate key value is (1595413570, 01, 0000003, 25260, -1072098025).

 Spoiler

query:LOG_ITEM_STR @im_szName='IGN1' @rindex='01',@im_GetszName='IGN2',@idwWorldID=1,@im _dwGold=0,@im_nRemainGold=0,@iItem_UniqueNo=-1302817064,@iItem_Name='25245',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_coun t=1 @te='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResi st=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im _dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSiz e=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@ iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0,@in PetKind=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,@iadw ItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemI d9=0 @PiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@i adwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 11.0]Invalid cursor state

 Spoiler

query:LOG_GAMEMASTER_STR @im_idPlayer='0000003' @rindex='01',@iszWords='/say "IGN" Hi Sir'
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 11.0]Invalid cursor state

 Spoiler

2020/ 7/22 20:37:11
RemoveUser(): *pUser->m_pKey is '
2020/ 7/22 22:51:24
^OnGetPlayerList(), username1
2020/ 7/22 22:51:24
OnFail(): ERROR_FLYFF_ACCOUNT, username1
2020/ 7/22 22:51:24
RemoveUser(): Illegal

 Spoiler

RemoveUser(): *pUser->m_pKey is '

[xTwiLightx]

Errors 1 and 2 occur when a player tries to trade two stacks of the same item (same unique-id) in one trade.

Fix: Make the PK_tblTradeItemLog non-unique
- That is not possible by definition, because Primary Keys are explicitly unique. Create a non-unique clustered index as a replacement instead.

Errors 3 and 4 are follow-up errors because of the first/second one happened.

Errors 5 and 6 are happening when a socket receives messages with no/invalid content - most likely empty messages. There is no real fix yet besides removing the call which prints out the message.