Inventory Glitch

[ParzivalGG]

If somebody is buying custom weapon models, then it works for that particular period and afterwards when they join again their inventory is gone, and they've to buy it again.

[nuclearsilo583]

If you using mysql as database. Can you give me a screenshot at the time player buy an item in the store_plugins_log table. If you're using sqlite open the .qc3 file and give me the same table screenshot

[ParzivalGG]

There ya go!

[ParzivalGG]

[nuclearsilo583]

Could keep using it for a couple of day to see if this may happen again.

[nuclearsilo583]

Close due to inactive

[KillerRoi]

It is still not saving

[KillerRoi]

Everytime, players need to join and equip it again and again

[Oz-Lin]

Sorry for necroing. This happens when the previous playerskin was expired but not removed from store_equipment database table. Everytime when a player reports the store bug to me, I have to remove the loadout from the database manually.

L 08/23/2022 - 02:23:20: [store.smx] SQL error happened.
Query: INSERT INTO store_equipment (`player_id`, `type`, `unique_id`, `slot`) VALUES(438, "playerskin", "uid_model_megumin", 2)
Error: Duplicate entry '438-playerskin-2' for key 'PRIMARY'

[nuclearsilo583]

Can you give me screenshot me the store_equipment table structure.

[Oz-Lin]

Here you go.

[nuclearsilo583]

probaly you have done something to that table because the table doesn't contain any primary keys and unique key which make the data can't insert duplicate. This is how the structure from myside even with the fresh/ currently created table. You should backup the store_equipment table and drop it via mysql. And restart the server so it can create that table again with the most exact sync.

[Oz-Lin]

Thanks, hopefully the problem is solved after moving values from the old store_equipment to the new one.