TFS 1.X+ Player_item INSERT INTO VALUES ERROR

[cryptomeepo]

Some players are suffering a rollback and I can't manage to reproduce the bug.

I did notice it is happening when they get too much items, from parcel or trades.

Does anyone knows how to fix it?

Datapack: Nostalrius.

player_items


player_depotitems

 

[Mjmackan]

count is set to smallint, meaning when reaching above the smallint range it will return in a crash.
Try changing it to a normal

int

 

[cryptomeepo]

I'll try. Bad thing is I cant reproduce it. I'll keep tracking console. I edit it to INT (10) is that ok or it should be 5?

 

[Evil Puncker]

I'll try. Bad thing is I cant reproduce it. I'll keep tracking console. I edit it to INT (10) is that ok or it should be 5?

this number is not used anymore:

MySQL :: WL#13127: Deprecate integer display width and ZEROFILL option

dev.mysql.com

 

[cryptomeepo]

Thanks! Lets see if INT itself is enough to fix it.

 

[Mjmackan]

I'll try. Bad thing is I cant reproduce it. I'll keep tracking console. I edit it to INT (10) is that ok or it should be 5?

Try moving around thousands of backpacks inside backpacks with golden coins or something, usually does it.
There are higher values than int aswell and well a lot of other changes that could be provided but it should be enough.