变量刚开始会显示 然后有几个玩家进来就不显示了报错如下
Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications
[06:23:33] [Craft Scheduler Thread - 202/ERROR] [org.black_ixx.playerpoints.PlayerPoints]: [PlayerPoints] Could not create getter statement.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 553,674 milliseconds ago. The last packet sent successfully to the server was 553,674 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_251]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_251]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.8.0_251]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.8.0_251]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[Util.class:5.1.45]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[SQLError.class:5.1.45]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3746) ~[MysqlIO.class:5.1.45]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2509) ~[MysqlIO.class:5.1.45]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[MysqlIO.class:5.1.45]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) ~[ConnectionImpl.class:5.1.45]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[PreparedStatement.class:5.1.45]
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197) ~[PreparedStatement.class:5.1.45]
at lib.PatPeter.SQLibrary.Database.query(Database.java:261) ~[?:?]
at lib.PatPeter.SQLibrary.Database.query(Database.java:278) ~[?:?]
at org.black_ixx.playerpoints.storage.models.MySQLStorage.getPoints(MySQLStorage.java:87) ~[?:?]
at org.black_ixx.playerpoints.storage.StorageHandler.getPoints(StorageHandler.java:39) ~[?:?]
at org.black_ixx.playerpoints.PlayerPointsAPI.look(PlayerPointsAPI.java:102) ~[?:?]
at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.getPoints(PlayerPointsExpansion.java:73) ~[?:?]
at com.extendedclip.papi.expansion.playerpoints.PlayerPointsExpansion.onPlaceholderRequest(PlayerPointsExpansion.java:65) ~[?:?]
at me.clip.placeholderapi.PlaceholderHook.onRequest(PlaceholderHook.java:38) ~[?:?]
at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:237) ~[?:?]
at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:377) ~[?:?]
at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:41) ~[?:?]
at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:35) ~[?:?]
at \?.?.?.MiaoBoard.?ˊ.?(Replace.java:29) ~[?:?]
at \?.?.?.MiaoBoard.??.onBodyUpdate(SelfListener.java:37) ~[?:?]
at catserver.server.executor.asm.generated.GeneratedEventExecutor196.execute(Unknown Source) ~[?:?]
at org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:67) ~[EventExecutor$2.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[RegisteredListener.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:503) ~[SimplePluginManager.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:485) ~[SimplePluginManager.class:git-CatServer-1.12.2-ae86f3c]
at \?.?.?.MiaoBoard.??.?(SidebarBoard.java:43) ~[?:?]
at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:76) [CraftTask.class:git-CatServer-1.12.2-ae86f3c]
at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52) [CraftAsyncTask.class:git-CatServer-1.12.2-ae86f3c]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_251]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_251]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_251]
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:1.8.0_251]
at java.net.SocketOutputStream.socketWrite(Unknown Source) ~[?:1.8.0_251]
at java.net.SocketOutputStream.write(Unknown Source) ~[?:1.8.0_251]
at java.io.BufferedOutputStream.flushBuffer(Unknown Source) ~[?:1.8.0_251]
at java.io.BufferedOutputStream.flush(Unknown Source) ~[?:1.8.0_251]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3728) ~[MysqlIO.class:5.1.45]
... 30 more
|
变量是正确的 点卷也连了数据库 由于是1.12 所以不能更新版本 对接着充值插件 想问一下 这个如何解决？
关于这个问题，我洗不明白，来个高手回答一下
变量是函数变量？？
额，点券启用数据库要前置啊，下载前置了吗
Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications
初步判定是PlayerPoints数据库连接时开启了SSL连接，请找到PlayerPoints config下述内容
# If the database connection should use SSL
# You should enable this if your database supports SSL
# Default: false
use-ssl: true
use-ssl改为false
The last packet successfully received from the server was 553,674 milliseconds ago. The last packet sent successfully to the server was 553,674 milliseconds ago. is longer than the server configured value of 'wait_timeout'.
你的插件长时间没有和数据库进行通讯，导致数据库自动关闭了连接。
可以将数据库变量"wait_timeout"适当调高，以避免出现这个问题。