caoli5288 / playersql Goto Github PK

View Code? Open in Web Editor NEW

62.0 62.0 33.0 657 KB

Synchronize data between servers.

Home Page: https://www.spigotmc.org/resources/playersql.552/

License: GNU General Public License v2.0

Java 100.00%

playersql's People

Contributors

Stargazers

Watchers

playersql's Issues

加载出现问题

服务器系统：CentOS 7.7.1908
服务端核心：PaperSpigot-1.12-1618
插件版本：b41
加载卡在 [PlayerSQL] 0kb 无限循环

[11:29:49 INFO]: [PlayerSQL] Loading PlayerSQL v2.10-dev
[11:29:49 INFO]: [PlayerSQL] Loading library MavenLibrary(repository=http://central.maven.org/maven2, group=org.lz4, artifact=lz4-java, version=1.5.0)
[11:29:50 INFO]: [PlayerSQL] 0kb
[11:29:51 INFO]: [PlayerSQL] 0kb
[11:29:52 INFO]: [PlayerSQL] 0kb

关于无限 Your data is locked, login later 的问题

在升级到最近的版本后，不少玩家表示会出现Your data is locked, login later的问题，即便数据同步成功了，也会无限出现Your data is locked, login later，从而无法进入游戏。
必须手动重启服务端才能临时解决该问题。
另外可否告知为何取消了Fix a player gets blocked forever after joining when its data…
是出于什么考虑呢？

fight Log out

Hello ,

I meet a duplication problem with the plugin " CombatTagPlus " I try to contact the developer who did not offer a solution, I hope you can help me ..

Byteflux/CombatTagPlus#63

I want to know if a similar plugin exists to block the fight Log out

Thank you anyway for your wonderful plugin and sorry for my pathetic English ^^

在BC端安装PlayerSQL导致1.13+客户端无法进入

如题
在BC端安装PlayerSQL导致1.13+客户端无法进入
[16:14:35] [Server thread/INFO]: Xu_wznln lost connection: Internal Exception: io.netty.handler.codec.DecoderException: net.minecraft.server.v1_13_R2.ResourceKeyInvalidException: Non [a-z0-9/._-] character in path of location: legacy:playersql@channel
请修复，谢谢！

Ebean-Error after installing VoxelSniper

Hey,

i have a problem after Installing Voxelsniper on our Server:

[22:46:46] [Server thread/INFO]: [PlayerSQL] Enabling PlayerSQL v2.8-SNAPSHOT
[22:46:47] [Server thread/INFO]: [PlayerSQL] Bukkit v1_12_R1
[22:46:47] [Server thread/INFO]: [PlayerSQL] Item util build-in
[22:46:47] [Server thread/INFO]: [PlayerSQL] ORM lib load okay!
[22:46:47] [Server thread/ERROR]: Error occurred while enabling PlayerSQL v2.8-SNAPSHOT (Is it up to date?)
java.lang.NoClassDefFoundError: com/avaje/ebean/config/dbplatform/SQLitePlatform
	at com.mengcraft.playersql.lib.simpleorm.EbeanManager.build(EbeanManager.java:39) ~[?:?]
	at com.mengcraft.playersql.lib.simpleorm.EbeanManager.getHandler(EbeanManager.java:25) ~[?:?]
	at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:42) ~[?:?]
	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264) ~[patched_1.12.2.jar:git-Paper-1384]
	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:316) [patched_1.12.2.jar:git-Paper-1384]
	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [patched_1.12.2.jar:git-Paper-1384]
	at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:395) [patched_1.12.2.jar:git-Paper-1384]
	at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:344) [patched_1.12.2.jar:git-Paper-1384]
	at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:442) [patched_1.12.2.jar:git-Paper-1384]
	at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:403) [patched_1.12.2.jar:git-Paper-1384]
	at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:341) [patched_1.12.2.jar:git-Paper-1384]
	at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:292) [patched_1.12.2.jar:git-Paper-1384]
	at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:616) [patched_1.12.2.jar:git-Paper-1384]
	at java.lang.Thread.run(Thread.java:844) [?:?]
Caused by: java.lang.ClassNotFoundException: com.avaje.ebean.config.dbplatform.SQLitePlatform
	at java.net.URLClassLoader.findClass(URLClassLoader.java:466) ~[?:?]
	at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:156) ~[patched_1.12.2.jar:git-Paper-1384]
	at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:104) ~[patched_1.12.2.jar:git-Paper-1384]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:563) ~[?:?]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:496) ~[?:?]
	... 14 more
[22:46:47] [Server thread/INFO]: [PlayerSQL] Disabling PlayerSQL v2.8-SNAPSHOT

What can i do here? I mean, this has worked before some time.
Thanks

Error while enabling plugin in Spigot 1.12

When loading the plugin in Spigot 1.12 I get the following exception:

[22:06:00] [Server thread/ERROR]: Error occurred while enabling PlayerSQL v2.4.2 (Is it up to date?)
java.lang.NoClassDefFoundError: com/avaje/ebean/config/dbplatform/DatabasePlatform
	at com.mengcraft.playersql.lib.simpleorm.EbeanManager.a(EbeanManager.java:48) ~[?:?]
	at com.mengcraft.playersql.lib.simpleorm.EbeanManager.getHandler(EbeanManager.java:23) ~[?:?]
	at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:30) ~[?:?]
	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264) ~[spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:402) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:377) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:327) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:421) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:382) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:337) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:272) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:544) [spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_111]
Caused by: java.lang.ClassNotFoundException: com.avaje.ebean.config.dbplatform.DatabasePlatform
	at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[?:1.8.0_111]
	at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:101) ~[spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:86) ~[spigot-1.12-2017-06-10.jar:git-Spigot-87496df-ed8c725]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:1.8.0_111]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:1.8.0_111]
	... 14 more

一些问题，希望可以修复

问题：

地图无法被同步。当在A服务器制作了地图以后，到B服务器，地图是空的
生命值同步导致玩家直接死亡。例如A、B、C服务器里面，只有B关闭了生命值同步功能，会导致进入服务器后直接死亡
有时候把物品放入箱子以后，去其他服务器再快速返回，背包里面会出现已经放入箱子的物品，导致可以刷物品。建议在一些敏感操作以后立刻保存/同步数据，或者可以增强一个BC/Redis的通讯功能，保证在其他服务器的同步操作晚于之前的保存操作。

我在用playersql遇到了一个很致命的问题

简单说:
A服务器是死亡掉落的,B服务器不掉落
玩家在A服务器快死的时候就立马跨服到B服务器
快死情况有: 着火/给追着打等等....
然后到了B服务器背包的物品全没了

然后我也是一个开发者
这个原因我也有猜想,因为BC跨服是先连接服务器,再断开连接
大概原因是玩家已经连接到B服务器了,但是A服务器还没退出就死了
我觉得这个问题需要BC插件应该才能解决吧。

compatible with combat log plugin

I'm using a anti combat log plugin, that clears the playerinv on quit (while in combat). The event has a HIGH priority. With PlayerSQL the inventory is stored before it gets cleared, even if I compile it with a LOW priority on the PlayerQuitEvent. How could I make it compatible? Thx

Combat PlayerQuitEvent:

@EventHandler(ignoreCancelled = true, priority = EventPriority.HIGH)
public void onQuit(PlayerQuitEvent e) {
    Player p = e.getPlayer();
    if (this.incombat.containsKey(p.getUniqueId())) {
        // broadcast...
        p.setHealth(0.0);
        p.setFoodLevel(0);
        p.getInventory().setHelmet(new ItemStack(Material.AIR));
        p.getInventory().setChestplate(new ItemStack(Material.AIR));
        p.getInventory().setLeggings(new ItemStack(Material.AIR));
        p.getInventory().setBoots(new ItemStack(Material.AIR));
        p.getInventory().clear();
        this.incombat.remove(p.getUniqueId());
    }
}

PlayerSQL Test:

@EventHandler(priority = LOWEST)
public void handle(PlayerQuitEvent event) {
    UUID uuid = event.getPlayer().getUniqueId();
    if (manager.isNotLocked(uuid)) {
        manager.cancelTask(uuid);
        User user = manager.getUserData(event.getPlayer(), true);
        main.runTaskAsynchronously(() -> {
            manager.saveUser(user, false);
        });
    } else {
        manager.unlockUser(uuid, false);
    }
}

Locked Players can't rejoin for a long time!

In some circumstances a player gets kicked because of locked data (column Online = 1). Often he can't rejoin for a long time (for example 15 or 20 minutes) or until the server get's a restart.

You could test it, if you set your player (must be offline) manually to online in the MySQL table (column Online = 1) and then try to join the server.

My current workaround with this issue is a custom plugin that sets the player online boolean to 0 if the player is kicked from the server (to the hub)

如果背包有潜影盒，可能不保存数据

在一个潜影盒内放很多东西，如果背包里面有很多这种放了很多东西的潜影盒。退出再进入，背包会是以前的状态，这个问题可以导致随便刷东西。先把贵重的东西放背包，退出再进来。然后放到箱子里，背包放满放了垃圾的潜影盒，退出再进游戏。背包里面就是以前的贵重物品了，可以无限翻倍刷，并且后台没有任何报错。

lib无法获取

老哥你ci好像被机房屏蔽了
playersql的lib都下载不下来
能不能直接把lib打个包放到其他地方下载.....
现在就是:
Caused by: java.io.FileNotFoundException: http://ci.mengcraft.com:8080/plugin/repository/everything/org/avaje/ebean/2.8.1/ebean-2.8.1.jar at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source) ~[?:1.8.0_221] at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) ~[?:1.8.0_221] at java.net.URL.openStream(Unknown Source) ~[?:1.8.0_221] at com.mengcraft.playersql.lib.simpleorm.lib.MavenLibrary.loadFile(MavenLibrary.java:114) ~[?:?]

浏览器访问上去就是机房的拦截页面

About decode

Hi i am using playersql on my website but when i try to decode with base64 it gives me something like that: ��id�minecraft:concrete��Count@��Damage , I used online decoders too. They aren't worked.
I can't see any numbers. please help me also thank you for creating this plugin.

Player's data unlocks after being 'sent' in a non-Bungee situation

When you execute /playersql send somebody target when no BungeeCord is connected, the player somebody's data will be unlocked and it can log on another server.

ERROR

[12:44:20 INFO]: [PlayerSQL] ORM lib load okay!
[12:44:20 WARN]: [SimpleORM] Loaded class com.zaxxer.hikari.HikariDataSource from lightEconomy v2.8.4 which is not a depend, softdepend or loadbefore of this plugin.
[12:44:20 ERROR]: [com.avaje.ebean.config.PropertyMapLoader] ebean.properties not found
[12:44:20 INFO]: [com.zaxxer.hikari.HikariDataSource] PlayerSQL@13220db5-6a2a-45f9-b606-c7372673b56b - Starting...
[12:44:21 ERROR]: [com.zaxxer.hikari.pool.HikariPool] PlayerSQL@13220db5-6a2a-45f9-b606-c7372673b56b - Exception during pool initialization.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) ~[patched_1.16.4.jar:git-Paper-294] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:768) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) ~[patched_1.16.4.jar:git-Paper-294]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_261]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_261]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) ~[patched_1.16.4.jar:git-Paper-294]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[?:?]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[?:?]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[?:?]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) ~[?:?]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) ~[?:?]
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) ~[?:?]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[?:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.checkDataSource(DefaultServerFactory.java:472) ~[ebean-2.8.1.jar:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:170) ~[ebean-2.8.1.jar:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:63) ~[ebean-2.8.1.jar:?]
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:78) ~[ebean-2.8.1.jar:?]
at com.mengcraft.simpleorm.EbeanHandler.initialize(EbeanHandler.java:272) ~[?:?]
at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:93) ~[?:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:263) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:380) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:483) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugin(CraftServer.java:501) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugins(CraftServer.java:415) ~[patched_1.16.4.jar:git-Paper-294]
at net.minecraft.server.v1_16_R3.MinecraftServer.loadWorld(MinecraftServer.java:468) ~[patched_1.16.4.jar:git-Paper-294]
at net.minecraft.server.v1_16_R3.DedicatedServer.init(DedicatedServer.java:239) ~[patched_1.16.4.jar:git-Paper-294]
at net.minecraft.server.v1_16_R3.MinecraftServer.w(MinecraftServer.java:940) ~[patched_1.16.4.jar:git-Paper-294] at net.minecraft.server.v1_16_R3.MinecraftServer.lambda$a$0(MinecraftServer.java:177) ~[patched_1.16.4.jar:git-Paper-294]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_261]
[12:44:21 ERROR]: Error occurred while enabling PlayerSQL v2.10-dev (Is it up to date?)
com.mengcraft.simpleorm.DatabaseException: javax.persistence.PersistenceException: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mengcraft.simpleorm.EbeanHandler.initialize(EbeanHandler.java:274) ~[?:?]
at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:93) ~[?:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:263) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:380) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:483) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugin(CraftServer.java:501) ~[patched_1.16.4.jar:git-Paper-294]
at org.bukkit.craftbukkit.v1_16_R3.CraftServer.enablePlugins(CraftServer.java:415) ~[patched_1.16.4.jar:git-Paper-294]
at net.minecraft.server.v1_16_R3.MinecraftServer.loadWorld(MinecraftServer.java:468) ~[patched_1.16.4.jar:git-Paper-294]
at net.minecraft.server.v1_16_R3.DedicatedServer.init(DedicatedServer.java:239) ~[patched_1.16.4.jar:git-Paper-294]
at net.minecraft.server.v1_16_R3.MinecraftServer.w(MinecraftServer.java:940) ~[patched_1.16.4.jar:git-Paper-294] at net.minecraft.server.v1_16_R3.MinecraftServer.lambda$a$0(MinecraftServer.java:177) ~[patched_1.16.4.jar:git-Paper-294]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_261]
Caused by: javax.persistence.PersistenceException: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.checkDataSource(DefaultServerFactory.java:482) ~[ebean-2.8.1.jar:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:170) ~[ebean-2.8.1.jar:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:63) ~[ebean-2.8.1.jar:?]
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:78) ~[ebean-2.8.1.jar:?]
at com.mengcraft.simpleorm.EbeanHandler.initialize(EbeanHandler.java:272) ~[?:?]
... 11 more
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) ~[patched_1.16.4.jar:git-Paper-294] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:768) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) ~[patched_1.16.4.jar:git-Paper-294]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_261]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_261]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_261]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) ~[patched_1.16.4.jar:git-Paper-294]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) ~[patched_1.16.4.jar:git-Paper-294]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[?:?]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[?:?]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[?:?]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) ~[?:?]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) ~[?:?]
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) ~[?:?]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[?:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.checkDataSource(DefaultServerFactory.java:472) ~[ebean-2.8.1.jar:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:170) ~[ebean-2.8.1.jar:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:63) ~[ebean-2.8.1.jar:?]
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:78) ~[ebean-2.8.1.jar:?]
at com.mengcraft.simpleorm.EbeanHandler.initialize(EbeanHandler.java:272) ~[?:?]
... 11 more

加载出错

Could not load 'plugins/[P][同步]Playersql.jar' in folder 'plugins'
org.bukkit.plugin.InvalidPluginException: java.lang.NoClassDefFoundError: com/mengcraft/simpleorm/lib/Library
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:133) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:327) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:248) [Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at org.bukkit.craftbukkit.v1_12_R1.CraftServer.loadPlugins(CraftServer.java:305) [Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:205) [Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:545) [Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
Caused by: java.lang.NoClassDefFoundError: com/mengcraft/simpleorm/lib/Library
at java.lang.Class.forName0(Native Method) ~[?:1.8.0_232]
at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_232]
at org.bukkit.plugin.java.PluginClassLoader.(PluginClassLoader.java:78) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:129) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
... 6 more
Caused by: java.lang.ClassNotFoundException: com.mengcraft.simpleorm.lib.Library
at java.net.URLClassLoader.findClass(URLClassLoader.java:382) ~[?:1.8.0_232]
at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:152) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:100) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[?:1.8.0_232]
at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[?:1.8.0_232]
at java.lang.Class.forName0(Native Method) ~[?:1.8.0_232]
at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_232]
at org.bukkit.plugin.java.PluginClassLoader.(PluginClassLoader.java:78) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:129) ~[Spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
... 6 more

更新到最新版本出现错误

问题一：升级新版本时出错
旧版本成功：
[12:24:22] [User Authenticator #1/INFO]: UUID of player Xu_wznln_2017 is 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e
[12:24:22] [Server thread/INFO]: [PlayerSQL] Lock user 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e done!
[12:24:22] [Server thread/INFO]: Xu_wznln_2017[/112.96.248.14:52631] logged in with entity id 311 at ([world]22497.74618032058, 60.0, -7735.293136029611)
[12:24:22] [Craft Scheduler Thread - 2/INFO]: [PlayerSQL] Load user Xu_wznln_2017 done.
[12:24:22] [Craft Scheduler Thread - 2/INFO]: [PlayerSQL] Update 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e lock to true okay
[12:24:22] [Server thread/INFO]: [PlayerSQL] Scheduling daily save task for user 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e.
新版本报错
[12:21:21] [User Authenticator #1/INFO]: UUID of player Xu_wznln_2017 is 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e
[12:21:22] [Server thread/INFO]: [PlayerSQL] Lock user 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e done!
[12:21:22] [Server thread/INFO]: Xu_wznln_2017[/112.96.248.14:65364] logged in with entity id 311 at ([world]22497.74618032058, 60.0, -7735.293136029611)
[12:21:22] [Craft Scheduler Thread - 0/INFO]: [PlayerSQL] Load user Xu_wznln_2017 done.
[12:21:22] [Craft Scheduler Thread - 0/INFO]: [PlayerSQL] Update 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e lock to true okay
[12:21:22] [Server thread/INFO]: Xu_wznln_2017 lost connection: Your game data loading error, please contact the operator
[12:21:22] [ForkJoinPool.commonPool-worker-25/INFO]: [PlayerSQL] Update 2a3b9874-d6b2-3a83-94e7-0db6a5b3e66e lock to false okay
[12:21:22] [Server thread/INFO]: Xu_wznln_2017 left the game
[12:21:22] [Server thread/ERROR]: [PlayerSQL] java.lang.IllegalArgumentException: Illegal base64 character d
java.lang.IllegalArgumentException: Illegal base64 character d
at java.util.Base64$Decoder.decode0(Base64.java:714) ~[?:1.8.0_201]
at java.util.Base64$Decoder.decode(Base64.java:526) ~[?:1.8.0_201]
at java.util.Base64$Decoder.decode(Base64.java:549) ~[?:1.8.0_201]
at com.mengcraft.playersql.DataSerializer.deserialize(DataSerializer.java:54) ~[?:?]
at com.mengcraft.playersql.UserManager.toStack(UserManager.java:259) ~[?:?]
at com.mengcraft.playersql.UserManager.pend(UserManager.java:188) ~[?:?]
at com.mengcraft.playersql.UserManager.pend(UserManager.java:171) ~[?:?]
at com.mengcraft.playersql.UserManager.lambda$addFetched$0(UserManager.java:40) ~[?:?]
at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftTask.run(CraftTask.java:84) ~[Survival-1paper1.13.jar:git-Paper-625]
at org.bukkit.craftbukkit.v1_13_R2.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:449) ~[Survival-1paper1.13.jar:git-Paper-625]
at net.minecraft.server.v1_13_R2.MinecraftServer.b(MinecraftServer.java:1010) ~[Survival-1paper1.13.jar:git-Paper-625]
at net.minecraft.server.v1_13_R2.DedicatedServer.b(DedicatedServer.java:439) ~[Survival-1paper1.13.jar:git-Paper-625]
at net.minecraft.server.v1_13_R2.MinecraftServer.a(MinecraftServer.java:940) ~[Survival-1paper1.13.jar:git-Paper-625]
at net.minecraft.server.v1_13_R2.MinecraftServer.run(MinecraftServer.java:837) ~[Survival-1paper1.13.jar:git-Paper-625]
at java.lang.Thread.run(Thread.java:748)

问题2：不管是用哪个版本，同样的数据，1.13和1.14玩家实际物品并不一致

关于后台疯狂报错

由于最新的版本导致玩家无法进入游戏，使用了倒数第二个构建版本
今天发现有不少玩家说自己无法进入游戏，提示data lock，于是查看后台，发现后台错误刷屏，多达100W行，类似这样：
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:08] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception
java.lang.NullPointerException
[05:16:09] [Server thread/WARN]: [PlayerSQL] Task #26 for PlayerSQL v1.10.3 generated an exception

2.9版本的一个报错

[20:49:13 WARN]: [PlayerSQL] Plugin PlayerSQL v2.9-SNAPSHOT generated an exception whilst handling plugin message java.io.UTFDataFormatException: encoded string too long: 70892 bytes at java.io.DataOutputStream.writeUTF(Unknown Source) ~[?:1.8.0_152] at java.io.DataOutputStream.writeUTF(Unknown Source) ~[?:1.8.0_152] at com.mengcraft.playersql.PlayerDataHelper.write(PlayerDataHelper.java:57) ~[playersql-2.9-SNAPSHOT.jar:?] at com.mengcraft.playersql.PlayerDataHelper.encode(PlayerDataHelper.java:24) ~[playersql-2.9-SNAPSHOT.jar:?] at com.mengcraft.playersql.EventExecutor.lambda$new$1(EventExecutor.java:63) ~[playersql-2.9-SNAPSHOT.jar:?] at com.mengcraft.playersql.BiRegistry.handle(BiRegistry.java:26) ~[playersql-2.9-SNAPSHOT.jar:?] at com.mengcraft.playersql.EventExecutor.onPluginMessageReceived(EventExecutor.java:143) ~[playersql-2.9-SNAPSHOT.jar:?] at org.bukkit.plugin.messaging.StandardMessenger.dispatchIncomingMessage(StandardMessenger.java:426) [spigot-1.12.2-R0.1-SNAPS HOT.jar:git-Spigot-eadd615-bea5a84] at net.minecraft.server.v1_12_R1.PlayerConnection.a(PlayerConnection.java:2576) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-ea dd615-bea5a84] at net.minecraft.server.v1_12_R1.PacketPlayInCustomPayload.a(SourceFile:58) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-eadd61 5-bea5a84] at net.minecraft.server.v1_12_R1.PacketPlayInCustomPayload.a(SourceFile:8) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-eadd615 -bea5a84] at net.minecraft.server.v1_12_R1.PlayerConnectionUtils$1.run(SourceFile:13) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-eadd61 5-bea5a84] at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_152] at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_152] at net.minecraft.server.v1_12_R1.SystemUtils.a(SourceFile:46) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-eadd615-bea5a84] at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:748) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-eadd6 15-bea5a84] at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:406) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-eadd6 15-bea5a84] at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:679) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-eadd6 15-bea5a84] at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:577) [spigot-1.12.2-R0.1-SNAPSHOT.jar:git-Spigot-ead d615-bea5a84] at java.lang.Thread.run(Unknown Source) [?:1.8.0_152]

Does it support CatServer?

https://github.com/Luohuayu/CatServer1.12.2

Possible NPE CheckLoadedTask.sync()

Hey, I think you missed the fact that plugin.getServer().getPlayer(poll.getKey()) can return null if a player is denied from joining by another plugin (e. g. PlayerJoinEvent). We had this case on our server. My quickfix was to just insert a null check but I think you should think about catching this earlier?

一个小问题

非常抱歉打扰你，梦梦大大
但是我发现你在mcbbs发布的修复服务端核心的资源链接全部挂掉了，你能修复一下或者给我提供一个其他的下载链接吗？我非常需要这几个核心文件。

All those exceptions...

玩家登陆时有时会报这个错，有一个玩家汇报说丢失了一大半的物品，只留下了几个，原因未明
这是该玩家在装了PlayerSQL后的第一次登陆，并且在登陆时立刻被杀死，复活时就没了大部分的背包和一半的盔甲，但是末影箱没有受影响
错误报告:
http://pastebin.com/Xd5Ja7Fu

java.lang.NoSuchMethodException: java.lang.Object.addURL(java.net.URL)

Hello,

thank you very much for the effort you put into this plugin.

We'd love to use PlayerSQL in the future, but we can't get it to work on our 1.13 server with Java 11. I'm not sure, what this error is related too, but with the latest build from Spigot I get this exception:

[15:32:05] [Server thread/INFO]: [PlayerSQL] Enabling PlayerSQL v2.8-SNAPSHOT*
[15:32:05] [Server thread/WARN]: [PlayerSQL] java.lang.IllegalAccessException: class com.mengcraft.playersql.lib.ItemUtil$NMS cannot access a member of class net.minecraft.server.v1_13_R2.ItemStack with modifiers "private"
[15:32:05] [Server thread/INFO]: [PlayerSQL] Bukkit v1_13_R2
[15:32:05] [Server thread/INFO]: [PlayerSQL] Item util protocollib
[15:32:05] [Server thread/ERROR]: Error occurred while enabling PlayerSQL v2.8-SNAPSHOT (Is it up to date?)
java.lang.NoSuchMethodException: java.lang.Object.addURL(java.net.URL)
at java.lang.Class.getDeclaredMethod(Class.java:2476) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getRef(RefHelper.java:41) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.lambda$getMethodRef$3(RefHelper.java:61) ~[?:?]
at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1705) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getMethodRef(RefHelper.java:61) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getRef(RefHelper.java:46) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.lambda$getMethodRef$3(RefHelper.java:61) ~[?:?]
at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1705) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getMethodRef(RefHelper.java:61) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getRef(RefHelper.java:46) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.lambda$getMethodRef$3(RefHelper.java:61) ~[?:?]
at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1705) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getMethodRef(RefHelper.java:61) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getRef(RefHelper.java:46) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.lambda$getMethodRef$3(RefHelper.java:61) ~[?:?]
at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1705) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getMethodRef(RefHelper.java:61) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getRef(RefHelper.java:46) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.lambda$getMethodRef$3(RefHelper.java:61) ~[?:?]
at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1705) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.getMethodRef(RefHelper.java:61) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.RefHelper.invoke(RefHelper.java:74) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.LibraryLoader.load(LibraryLoader.java:35) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.lib.LibraryLoader.load(LibraryLoader.java:31) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.ORM.loadExtLibrary(ORM.java:48) ~[?:?]
at com.mengcraft.playersql.lib.simpleorm.ORM.loadLibrary(ORM.java:42) ~[?:?]
at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:51) ~[?:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:254) ~[patched_1.13.2.jar:git-Paper-523]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:326) ~[patched_1.13.2.jar:git-Paper-523]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) ~[patched_1.13.2.jar:git-Paper-523]
at org.bukkit.craftbukkit.v1_13_R2.CraftServer.enablePlugin(CraftServer.java:443) ~[patched_1.13.2.jar:git-Paper-523]
at org.bukkit.craftbukkit.v1_13_R2.CraftServer.enablePlugins(CraftServer.java:357) ~[patched_1.13.2.jar:git-Paper-523]
at net.minecraft.server.v1_13_R2.MinecraftServer.l(MinecraftServer.java:608) ~[patched_1.13.2.jar:git-Paper-523]
at net.minecraft.server.v1_13_R2.MinecraftServer.a(MinecraftServer.java:570) ~[patched_1.13.2.jar:git-Paper-523]
at net.minecraft.server.v1_13_R2.MinecraftServer.a(MinecraftServer.java:431) ~[patched_1.13.2.jar:git-Paper-523]
at net.minecraft.server.v1_13_R2.DedicatedServer.init(DedicatedServer.java:316) ~[patched_1.13.2.jar:git-Paper-523]
at net.minecraft.server.v1_13_R2.MinecraftServer.run(MinecraftServer.java:786) ~[patched_1.13.2.jar:git-Paper-523]
at java.lang.Thread.run(Thread.java:834) [?:?]
[15:32:05] [Server thread/INFO]: [PlayerSQL] Disabling PlayerSQL v2.8-SNAPSHOT

1.13 builds.

Hey, i know that the plugin wont work on 1.13 but md_5 has released builds for the new api and on 1.13. recently i tried to load up the plugin on it and see whats going to happen and it throws this in the console:

[22:32:39 INFO]: [PlayerSQL] Enabling PlayerSQL v2.8-SNAPSHOT
[22:32:40 WARN]: [PlayerSQL] java.lang.IllegalAccessException: Class com.mengcraft.playersql.lib.ItemUtil$NMS can not access a member of class net.minecraft.server.v1_13_R1.ItemStack with modifiers "private"
[22:32:42 ERROR]: Error occurred while enabling PlayerSQL v2.8-SNAPSHOT (Is it up to date?)
java.lang.IllegalStateException: Hasn't compatible util! Update PlayerSQL or ProtocolLib
        at com.mengcraft.playersql.PluginMain.thr(PluginMain.java:148) ~[?:?]
        at com.mengcraft.playersql.lib.ItemUtilHandler.handle(ItemUtilHandler.java:38) ~[?:?]
        at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:48) ~[?:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264) ~[spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:339) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:403) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at org.bukkit.craftbukkit.v1_13_R1.CraftServer.enablePlugin(CraftServer.java:420) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at org.bukkit.craftbukkit.v1_13_R1.CraftServer.enablePlugins(CraftServer.java:334) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at net.minecraft.server.v1_13_R1.MinecraftServer.m(MinecraftServer.java:523) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at net.minecraft.server.v1_13_R1.MinecraftServer.g_(MinecraftServer.java:485) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at net.minecraft.server.v1_13_R1.MinecraftServer.a(MinecraftServer.java:384) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at net.minecraft.server.v1_13_R1.DedicatedServer.init(DedicatedServer.java:288) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at net.minecraft.server.v1_13_R1.MinecraftServer.run(MinecraftServer.java:647) [spigot-1.13-pre7.jar:git-Spigot-6505f06-b8ea9ec]
        at java.lang.Thread.run(Unknown Source) [?:1.8.0_161]

I'm making this issue to make you aware of this issue :)

PSQL v2.10加载时出现问题

[22:26:12 INFO]: [PlayerSQL] Load library lib\javax\persistence\persistence-api\persistence-api-1.0.jar done
[22:26:12 INFO]: [PlayerSQL] Load library lib\org\avaje\ebean\ebean-2.8.1.jar done
[22:26:12 INFO]: [PlayerSQL] ORM lib load okay!
[22:26:12 ERROR]: 启用 PlayerSQL v2.10-dev 时发生错误 (它是最新的吗？)
java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory
at com.zaxxer.hikari.HikariConfig.(HikariConfig.java:51) ~[HikariConfig.class:?]
at com.mengcraft.simpleorm.EbeanHandler.createSource(EbeanHandler.java:164) ~[?:?]
at com.mengcraft.simpleorm.EbeanHandler.initialize(EbeanHandler.java:201) ~[?:?]
at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:86) ~[?:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:177) ~[JavaPlugin.class:7464a42]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:327) [JavaPluginLoader.class:7464a42]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:399) [SimplePluginManager.class:7464a42]
at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:466) [CraftServer.class:7464a42]
at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:407) [CraftServer.class:7464a42]
at net.minecraft.server.MinecraftServer.func_71247_a(MinecraftServer.java:393) [MinecraftServer.class:?]
at net.minecraft.server.dedicated.DedicatedServer.func_71197_b(DedicatedServer.java:321) [nz.class:?]
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:599) [MinecraftServer.class:?]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_231]
Caused by: java.lang.ClassNotFoundException: org.slf4j.LoggerFactory
at net.minecraft.launchwrapper.LaunchClassLoader.findClass(LaunchClassLoader.java:110) ~[Mohist-7464a42-server.jar:7464a42]
at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:1.8.0_231]
at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:1.8.0_231]
... 13 more

使用Mohist服务端核心（类CAT高版本PF服务端）：
[]https://ci.codemc.io/job/Mohist-Community/job/Mohist-1.12.2/

Your data is locked

hi,
i set the delay to 60 ticks but again and again it kicks the player because data is locked.
We use a bungeecord and 2 server use playersql.

PlayerSQL v: 1.17.2
Spigot v: 1.8.8

An erro with plugin starting....

[15:56:55 ERROR]: Error registering MBean[Ebean:server=PlayerSQL2]
java.security.AccessControlException: access denied ("javax.management.MBeanTrus
tPermission" "register")
at java.security.AccessControlContext.checkPermission(Unknown Source) ~[
?:1.8.0_71]
at java.lang.SecurityManager.checkPermission(Unknown Source) ~[?:1.8.0_7
1]
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.checkMBeanTrust
Permission(Unknown Source) ~[?:1.8.0_71]
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(U
nknown Source) ~[?:1.8.0_71]
at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(Unknown Source)
~[?:1.8.0_71]
at com.avaje.ebeaninternal.server.core.DefaultServer.registerMBeans(Defa
ultServer.java:389) [DefaultServer.class:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer
(DefaultServerFactory.java:226) [DefaultServerFactory.class:?]
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer
(DefaultServerFactory.java:64) [DefaultServerFactory.class:?]
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:78)
[EbeanServerFactory.class:?]
at com.mengcraft.simpleorm.EbeanHandler.initialize(EbeanHandler.java:166
) [playersql-2.0-SNAPSHOT.jar:?]
at com.mengcraft.simpleorm.EbeanHandler.initialize(EbeanHandler.java:171
) [playersql-2.0-SNAPSHOT.jar:?]
at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:31) [play
ersql-2.0-SNAPSHOT.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [Ja
vaPlugin.class:1.7.10-1614.176]
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:368) [JavaPluginLoader.class:1.7.10-1614.176]
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:410) [SimplePluginManager.class:1.7.10-1614.176]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.jav
a:415) [CraftServer.class:1.7.10-1614.176]
at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.
java:349) [CraftServer.class:1.7.10-1614.176]
at net.minecraft.server.MinecraftServer.func_71243_i(MinecraftServer.jav
a:511) [MinecraftServer.class:?]
at net.minecraft.server.MinecraftServer.func_71222_d(MinecraftServer.jav
a:485) [MinecraftServer.class:?]
at net.minecraft.server.MinecraftServer.func_71247_a(MinecraftServer.jav
a:445) [MinecraftServer.class:?]
at net.minecraft.server.dedicated.DedicatedServer.func_71197_b(Dedicated
Server.java:336) [lt.class:?]
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:631) [M
inecraftServer.class:?]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_71]

Easy improvement to avoid the "Datal Locked Error"

I Would suggest to chnage its behavior to something different.

If a player joins the server, the plugin starts checking the date after n ticks.
if it is locked, wait for n ticks and try again.
And it will do so on until the data is available or if it has tried it for x seconds.
This will improve the Performance much, because on most mysql servers the data should already be written when the player arrives on the server.

It that possible?

spigot 1.13.2 只有潜影盒無法保存，其餘物品有正常保存

bungeecord + spigot 1.13.2

插件使用2.10-dev

Better data storage

PlayerSQL stores all players data in one column and don't compresses it.

Example from my PlayerSQL database:

[200.0,65,0,[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null],[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[["NIGHT_VISION",4367,0,false]],4]

In other hand oldest plugin InvertorySQL stores data in better way.

InvertorySQL database structure:

[table] inv_player
[column] id
[column] playeruuid

[table] inv_inventory
[column] id
[column] playerID
[column] content (serialized $ compresed)
[column] armor (serialized & compresed)
[column] server
[column] min_health
[column] max_health
[column] food

[table] inv_enderchest
[column] id
[column] playerID
[column] content (serialized $ compresed)
[column] server

Compression and serialization isn't the most important thing for me and others. But i will write PHP website for my server with equipment viewer module. Division of data in separate columns is very important for that purpose. By dividing data external program has smaller part of data to catch in queries and anyway mysql engine can faster organizes data.

Java 7 Compatibility

Could you compile it also with java 7?

Exception on server switch.

[00:08:14] [Craft Scheduler Thread - 2/WARN]: Exception in thread "Craft Scheduler Thread - 2"
[00:08:14] [Craft Scheduler Thread - 2/WARN]: org.apache.commons.lang.UnhandledException: Plugin PlayerSQL v2.0-SNAPSHOT generated an exception while executing task 1143
at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:56)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[Duplicate entry 'fdd7fc97-da7c-4e8e-9095-0199d57660fc' for key 'PRIMARY']
at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:116)
at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(DmlBeanPersister.java:76)
at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeInsertBean(DefaultPersistExecute.java:91)
at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:500)
at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:530)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(DefaultPersister.java:406)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveEnhanced(DefaultPersister.java:345)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:315)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultPersister.java:282)
at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1629)
at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1619)
at com.mengcraft.playersql.UserManager.saveUser(UserManager.java:104)
at com.mengcraft.playersql.EventExecutor.lambda$handle$0(EventExecutor.java:52)
at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
... 3 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'fdd7fc97-da7c-4e8e-9095-0199d57660fc' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeUpdate(ExtendedPreparedStatement.java:164)
at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:74)
at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:158)
at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
... 17 more

關於maxHealth

請問有考慮支援maxHealth嗎？
有些插件會改變玩家的最大血量
重新計算最大血量的時機一般在等級改變時
但此插件會使最大血量在玩加上線時重新設定到20
因此建議新增maxHealth的支援

README.md need to be update

关于后台无限报错的问题

在TimerCheckTask中的kick方法没有检查获取的用户是否为null，有极小的概率导致可能无限报错，并且使得TPS锐减直至蹦服。经过三天测试，发现修改后该问题得以解决。
修改后的方法代码：
private void kick(UUID uuid) {
Player p = server.getPlayer(uuid);
/*
* Possible offline here.
*/
if (p != null) {
if (p.isOnline()) {
p.kickPlayer(DataCompound.MESSAGE_KICK);
}
}
compond.state(uuid, null);
}

Return double items when player logout of the game

Problem

When player logout of the game, some plugin returns double amount of items to player.
Such as DuanzaoCMD, SpecialAttributes

Cause

I'm not sure whats causing this to happen, but plugins works perfectly well with out the plugin.

I guess it is the problem with the player lock... returning item after locking the player.
I will try it out later.

SQL Error

Hi,

we are getting some sql errors
" java.sql.BatchUpdateException: Data truncation: Data too long for column 'Data' at row 5"

Can we simply change the Data column from text to mediumtext or longtext?

能不能做3天内的表备份

如题，有一些情况下。会导致背包莫名其妙清空。或者还原物品。
但这样同样会同步到sql里。。
我想的是做个定时任务。按N小时备份表。保留N天内的表。这样。就可以在清空背包的情况下。恢复背包了。
还需要个恢复功能？
0.0就这样

Table prefixes

Can you add a way to configure custom prefixes for tables?

LONGTEXT still not enough space for inventory slot

Hey there,

there is still the issue with full (I mean very full) inventories. They won't be saved into the database, I guess the string will still be too long.
After the update to LONGTEXT it went better, but a player just tried to transport most of the following chest at the same time:
https://prnt.sc/kqkjzz

I would really love to see a way to improve this problem :)
Thanks in advance!

你好，请问哪个版本支持1.7.10？

谢谢

玩家经验值在换服后错误

复现：
版本 1.12.2
设置玩家经验值为7
使用附魔台1级附魔一个物品
此时玩家经验值为0
传送到其他服务器
经验值被设置为Integer.MAX_VALUE

"Can't call commit when autocommit=true"

[07:06:45 INFO]: kazu[/67.189.110.61:59620] logged in with entity id 302 at ([spawn]1042.5, 70.0, 689.5)
[07:06:45 WARN]: java.sql.SQLException: Can't call commit when autocommit=true
[07:06:45 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)
[07:06:45 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
[07:06:45 WARN]: at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1655)
[07:06:45 WARN]: at com.mengcraft.playersql.task.LoadPlayerTask.run(LoadPlayerTask.java:42)
[07:06:45 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[07:06:45 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[07:06:45 WARN]: at java.lang.Thread.run(Thread.java:745)

Issue with ViaVersion

Will thr exception under viaversion installed server. See https://www.spigotmc.org/threads/playersql.18056/page-44#post-1864688

java.lang.IllegalArgumentException: Invalid inventory size; expected 36 or less
at org.bukkit.craftbukkit.v1_8_R3.inventory.CraftInventory.setContents(CraftInventory.java:64) ~[spigot.jar:git-Spigot-db6de12-18fbb24]
at com.mengcraft.playersql.UserManager.pend(UserManager.java:158) ~[?:?]
at com.mengcraft.playersql.UserManager.pend(UserManager.java:148) ~[?:?]
at com.mengcraft.playersql.UserManager.lambda$addFetched$1(UserManager.java:46) ~[?:?]

大佬好，我最新出现了服务器启动时在playersql卡住的问题

复制一小段log
在[21:45:00] [Server thread/INFO]: SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]

这个地方卡住，然后会卡几分钟才能加载完成
以前不卡，后来因为玩家越多,启动时候渐渐变卡，而且有时候直接几秒完成，有时候要十几分钟。是因为玩家数据太多的问题嘛
[21:45:00] [Server thread/INFO]: [PlayerSQL] Enabling PlayerSQL v2.4.2 [21:45:00] [Server thread/INFO]: [PlayerSQL] Server version: v1_8_R3. [21:45:00] [Server thread/INFO]: [PlayerSQL] Build-in item util work well! [21:45:00] [Server thread/ERROR]: ebean.properties not found [21:45:00] [Server thread/INFO]: DataSourcePool [PlayerSQL] autoCommit[false] transIsolation[READ_COMMITTED] min[1] max[50] [21:45:00] [Server thread/INFO]: DatabasePlatform name:PlayerSQL platform:mysql [21:45:00] [Server thread/INFO]: SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader] [22:09:11] [Server thread/INFO]: Entities enhanced[0] subclassed[1] [22:09:11] [Server thread/INFO]: [PlayerSQL] Tables already exists!

Update from 1.08 to 1.17 errors

Hi, i have follwing errors which spams my console.
http://pastebin.com/aR9b9TcA
PaperSpigot 1.7.10, with ProtocolLib 3.6.0 Snapshot.

new item in 1.14.3 is not transfer

关于升级插件后背包丢失的问题

今天我把1.7.10的服务端升级到1.8.3，同时也将PlayerSQL插件升级到最新版本。在排除其他插件问题时发现升级PlayerSQL会导致背包数据读取失败（清空背包），再次登录后正常。
手动在Mysql把Data字段的内容替换成原来的内容，发现该问题可以复现。可能是NBT不兼容导致？请问有办法解决么？如果确实由序列化的NBT不兼容导致，可以增加转换数据的功能么？

报错内容：

21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: 21:36:49 WARN: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.mengcraft.playersql.util.ItemUtil.getItemStack(ItemUtil.java:92)
at com.mengcraft.playersql.task.CheckLoadedTask.arrayToStacks(CheckLoadedTask.java:96)
at com.mengcraft.playersql.task.CheckLoadedTask.sync(CheckLoadedTask.java:63)
at com.mengcraft.playersql.task.CheckLoadedTask.work(CheckLoadedTask.java:43)
at com.mengcraft.playersql.task.CheckLoadedTask.run(CheckLoadedTask.java:35)
at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftTask.run(CraftTask.java:71)
at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:720)
at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:368)
at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:651)
at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:554)
at java.lang.Thread.run(Thread.java:745)
WARN: Caused by: java.io.EOFException
at java.io.DataInputStream.readFully(DataInputStream.java:197)
at java.io.DataInputStream.readUTF(DataInputStream.java:609)
at java.io.DataInputStream.readUTF(DataInputStream.java:564)
at net.minecraft.server.v1_8_R2.NBTTagCompound.b(SourceFile:376)
at net.minecraft.server.v1_8_R2.NBTTagCompound.load(SourceFile:46)
... 16 more

21:36:49 WARN: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
21:36:49 WARN: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
21:36:49 WARN: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
21:36:49 WARN: at java.lang.reflect.Method.invoke(Method.java:483)
21:36:49 WARN: at com.mengcraft.playersql.util.ItemUtil.getItemStack(ItemUtil.java:92)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.arrayToStacks(CheckLoadedTask.java:96)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.sync(CheckLoadedTask.java:63)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.work(CheckLoadedTask.java:43)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.run(CheckLoadedTask.java:35)
21:36:49 WARN: at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftTask.run(CraftTask.java:71)
21:36:49 WARN: at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:720)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:368)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:651)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:554)
21:36:49 WARN: at java.lang.Thread.run(Thread.java:745)
21:36:49 WARN: Caused by: java.io.EOFException
21:36:49 WARN: at java.io.DataInputStream.readFully(DataInputStream.java:197)
21:36:49 WARN: at java.io.DataInputStream.readUTF(DataInputStream.java:609)
21:36:49 WARN: at java.io.DataInputStream.readUTF(DataInputStream.java:564)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.NBTTagCompound.b(SourceFile:376)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.NBTTagCompound.load(SourceFile:46)
21:36:49 WARN: ... 16 more

21:36:49 WARN: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
21:36:49 WARN: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
21:36:49 WARN: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
21:36:49 WARN: at java.lang.reflect.Method.invoke(Method.java:483)
21:36:49 WARN: at com.mengcraft.playersql.util.ItemUtil.getItemStack(ItemUtil.java:92)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.arrayToStacks(CheckLoadedTask.java:96)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.sync(CheckLoadedTask.java:67)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.work(CheckLoadedTask.java:43)
21:36:49 WARN: at com.mengcraft.playersql.task.CheckLoadedTask.run(CheckLoadedTask.java:35)
21:36:49 WARN: at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftTask.run(CraftTask.java:71)
21:36:49 WARN: at org.bukkit.craftbukkit.v1_8_R2.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:720)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:368)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:651)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:554)
21:36:49 WARN: at java.lang.Thread.run(Thread.java:745)
21:36:49 WARN: Caused by: java.io.EOFException
21:36:49 WARN: at java.io.DataInputStream.readFully(DataInputStream.java:197)
21:36:49 WARN: at java.io.DataInputStream.readUTF(DataInputStream.java:609)
21:36:49 WARN: at java.io.DataInputStream.readUTF(DataInputStream.java:564)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.NBTTagCompound.b(SourceFile:376)
21:36:49 WARN: at net.minecraft.server.v1_8_R2.NBTTagCompound.load(SourceFile:46)
21:36:49 WARN: ... 16 more

MysqlDataTruncation: Data truncation: Data too long for column 'inventory' at row 1

Some of the players have items with custom NBT tags in their inventory. Some of them are pretty complex. It looks like the String "version" of that inventory has exceeds the maximum length limit of the EBean Server. I'm not familiar with the Spigot EBean server utils, but I assume if you could change the column type to one that can hold more bytes?

caoli5288 / playersql Goto Github PK

playersql's People

Contributors

Stargazers

Watchers

Forkers

playersql's Issues

Problem

Cause

Recommend Projects

Recommend Topics

Recommend Org