Inventory Database Error

[legionffxi]

Because I am getting horribly sick of seeing this please see the attached screenshots regarding an inventory error I am seeing on some servers including the one we are working on setting up.

Any ideas would be very helpful, the items eventually go into your inventory if you toss an item from your inventory, my inventory currently testing is 33/80 so Unless its r/ex it should drop in with no issues.

[kjLotus]

couldn't put it in the database because there's already an item in that slot

general outline: AddItem calls InsertItem which iterates over the container until it finds an empty slot, then puts the item in that slot and returns what slot it went in to
then, AddItem will write the values to the char_inventory table to save the item to the database, using the slot that InsertItem found. if either of those fail then the item is deleted and the adding is canceled.

at some point you have a disconnect between what the game server thinks your inventory is and what the database thinks your inventory is. how you arrived there I don't know, but possibilities include failing to load char_inventory on login, messed up database, some code that removes an item from the server's storage but not the database

[Cyprus]

I am seeing this on my server also. Sometimes I will see items drop while killing mobs solo & it will say that I obtained them...but when I look for them in my inventory, they aren't there. At some point later on, they show up in my inventory...could be after tossing items as stated above but to be honest, I didn't test to confirm that.

I have seen same situations as the screenshots above...any fix for this yet?

[kjLotus]

not until i know how to reproduce it reliably

[TeoTwawki]

I am seeing this on my server also. Sometimes I will see items drop while killing mobs solo & it will say that I obtained them...but when I look for them in my inventory, they aren't there. At some point later on, they show up in my inventory...could be after tossing items as stated above but to be honest, I didn't test to confirm that.

I have seen same situations as the screenshots above...any fix for this yet?

I get what I call the "sort bug" a lot. I hit sort and then things that really were there will show up.

not until i know how to reproduce it reliably

I've seen that db error message after crashes (caused by bad custom item reward script) and when adding items that don't exist yet by mistake to a chars inventory (seeing if we have X already by using @additem...Not such a good idea). Even though that resulted in no item on the char being added, the "slot" was somehow still in use. There was just garbage data in the table where that chars inventory was. Once deleted they went back to normal, and I just had to give the character a new pair of the taru RSE legs they lost in the process (that slot had been corrupted).

As for items not showing up when they are really there...Crank your test servers drop rates up in the conf and then walk into dyna with god mode and HULK SMASH half the zone in seconds. You'll see it happen a lot more then!

[uwill99]

This has been happening on my server ever since I load FFXI.AH.Broker/PriceGrabber. Is there a fix for it yet? For me it is only items that can be equipped that go into inventory - they appear after sorting inventory. Also - the only workaround I've found is to turn off auto sorting in game. Problem completely disappears after that.