brunyman/MPDB

Data too long for column

Opened this issue · 0 comments

I am having problems with saving some data between servers and I get the following error in console when it happens. I think it's because I use plugins like mmoitems that add a lot of lore to the armors.

Error:
[15:29:33 WARN]: [MysqlPlayerDataBridge] Error: Data truncation: Data too long for column 'armor' at row 1
[15:29:33 WARN]: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'armor' at row 1
[15:29:33 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
[15:29:33 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:555)
[15:29:33 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:339)
[15:29:33 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
[15:29:33 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
[15:29:33 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
[15:29:33 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
[15:29:33 WARN]: at MysqlPlayerDataBridge-v4.7.0.jar//net.craftersland.data.bridge.storage.handlers.InventoryStorageHandler.setData(InventoryStorageHandler.java:379)
[15:29:33 WARN]: at MysqlPlayerDataBridge-v4.7.0.jar//net.craftersland.data.bridge.events.handlers.InventoryDataHandler.onDataSaveFunction(InventoryDataHandler.java:215)
[15:29:33 WARN]: at MysqlPlayerDataBridge-v4.7.0.jar//net.craftersland.data.bridge.events.PlayerDisconnect$1$1.run(PlayerDisconnect.java:73)
[15:29:33 WARN]: at org.bukkit.craftbukkit.v1_19_R1.scheduler.CraftTask.run(CraftTask.java:101)
[15:29:33 WARN]: at org.bukkit.craftbukkit.v1_19_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57)
[15:29:33 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[15:29:33 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
[15:29:33 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
[15:29:33 WARN]: at java.base/java.lang.Thread.run(Thread.java:833)

Version: Paper 1.19.2
MysqlPlayerDataBridge-v4.7.0.jar