[BUG] Long named items not logged

[Shepelzz]

Is there an existing issue for this?

• I have searched the existing issues

Type of bug

Error in console

Environment

- Server Version: 1.20.1
- Shop Version: 1.9.1.2

Server startup log

not needed

Shop config files

not needed

Error log (if applicable)

https://gist.github.com/Shepelzz/59dc65643b21d420342c9d0a07300283

Bug description

You need to increase size of mysql 'item' column because there are items more than char(32) length.
TIDE_ARMOR_TRIM_SMITHING_TEMPLATE for example.

Steps to reproduce

• configure mysql logging
• create shop selling TIDE_ARMOR_TRIM_SMITHING_TEMPLATE
• buy item

Expected behaviour

• transaction was saved to mysql

Actual behaviour

• transaction was not saved to mysql
• error in console

Other information

No response

[OstlerDev]

This is fixed in the new version 1.10.0 that will be coming out in the next couple weeks (hopefully). I have changed the column to remove the character limit, and it will now log the entire item data (in base64) to include all enchantments and custom NBT data!