search

CatSeed / CatSeedLogin

MIT License
61 stars 18 forks source link

MySQL timestamp转换问题 #8

Closed Yang-qwq closed 3 years ago

Yang-qwq commented 3 years ago

作者，我在使用插件的时候遇到了一个问题 我使用的mysql版本为5.7.27 插件版本为1.3.4-SHANSHOT 以下是我的报错日志

[19:32:47 WARN]: [CatSeedLogin] 数据库错误,无法更新缓存!
[19:32:47 WARN]: java.sql.SQLDataException: Unsupported conversion from TIMESTAMP to java.lang.Long
[19:32:47 WARN]:  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:114)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1411)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.result.ResultSetImpl.getLong(ResultSetImpl.java:842)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.result.ResultSetImpl.getLong(ResultSetImpl.java:848)
[19:32:47 WARN]:  at cc.baka9.catseedlogin.database.SQL.get(SQL.java:77)
[19:32:47 WARN]:  at cc.baka9.catseedlogin.database.Cache.lambda$refresh$2(Cache.java:47)
[19:32:47 WARN]:  at org.bukkit.craftbukkit.v1_16_R3.scheduler.CraftTask.run(CraftTask.java:100)
[19:32:47 WARN]:  at org.bukkit.craftbukkit.v1_16_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:54)
[19:32:47 WARN]:  at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
[19:32:47 WARN]:  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[19:32:47 WARN]:  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[19:32:47 WARN]:  at java.lang.Thread.run(Unknown Source)
[19:32:47 WARN]: Caused by: com.mysql.cj.exceptions.DataConversionException: Unsupported conversion from TIMESTAMP to java.lang.Long
[19:32:47 WARN]:  at com.mysql.cj.result.DefaultValueFactory.unsupported(DefaultValueFactory.java:70)
[19:32:47 WARN]:  at com.mysql.cj.result.DefaultValueFactory.createFromTimestamp(DefaultValueFactory.java:82)
[19:32:47 WARN]:  at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeTimestamp(MysqlTextValueDecoder.java:85)
[19:32:47 WARN]:  at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:89)
[19:32:47 WARN]:  at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:243)
[19:32:47 WARN]:  at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91)
[19:32:47 WARN]:  at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1315)
[19:32:47 WARN]:  ... 10 more

如果这是个bug，希望作者可以尽快修复 如果不是，还请说下解决方法，麻烦了