Muska-Ami / CatSero

一个基于MiraiMC的QQ群功能&MC功能插件
https://blog.ovome.icu
GNU Affero General Public License v3.0
29 stars 3 forks source link

81号问题再次出现 #119

Closed wanyanjiabin closed 1 year ago

wanyanjiabin commented 1 year ago

问题描述

2.3.3版本再次出现81号问题

复现方法

服务端版本

Paper-1.19.2

CatSero 版本

2.3.3

服务端日志

[02:23:54 WARN]: [CatSero] [Catch] 捕获到一个错误
[02:23:54 WARN]: [CatSero] [Catch] 错误类型: org.sqlite.SQLiteException
[02:23:54 WARN]: [CatSero] [Catch] 捕获消息: [SQLITE_ERROR] SQL error or missing database (no such table: RECORDS)
[02:23:54 WARN]: [CatSero] [Catch] 详细信息:      - org.sqlite.core.DB.newSQLException(DB.java:1030)
     - org.sqlite.core.DB.newSQLException(DB.java:1042)
     - org.sqlite.core.DB.throwex(DB.java:1007)
     - org.sqlite.core.NativeDB.prepare_utf8(Native Method)
     - org.sqlite.core.NativeDB.prepare(NativeDB.java:137)
     - org.sqlite.core.DB.prepare(DB.java:257)
     - org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:66)
     - [QQ机器人]CatSero-2.3.3.jar//com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110)
     - [QQ机器人]CatSero-2.3.3.jar//com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
     - [QQ机器人]CatSero-2.3.3.jar//moe.xmcn.catsero.utils.WhiteListDatabase.getCode(WhiteListDatabase.java:289)
     - [QQ机器人]CatSero-2.3.3.jar//moe.xmcn.catsero.listeners.qwhitelist.RefuseNoWhiteList.onPlayerPreLogin(RefuseNoWhiteList.kt:56)
     - com.destroystokyo.paper.event.executor.asm.generated.GeneratedEventExecutor267.execute(Unknown Source)
     - org.bukkit.plugin.EventExecutor$2.execute(EventExecutor.java:77)
     - co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:76)
     - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70)
     - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:670)
     - net.minecraft.server.network.LoginListener$LoginHandler.fireEvents(LoginListener.java:431)
     - net.minecraft.server.network.LoginListener$1.run(LoginListener.java:310)
     - java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
     - java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
     - java.base/java.lang.Thread.run(Thread.java:833)

[02:23:54 WARN]: [CatSero] [Catch] 如您认为这不是配置错误、网络原因导致的问题,请前往此处报告:
[02:23:54 WARN]: [CatSero] [Catch] https://github.com/XiaMoHuaHuo-CN/CatSero/issues

额外说明

No response

wanyanjiabin commented 1 year ago

https://github.com/XiaMoHuaHuo-CN/CatSero/issues/81

Muska-Ami commented 1 year ago

请确保数据库文件有效,并确保白名单开启,如两项均尝试,请尝试备份whitelist.db,并删除原来的数据库文件手动迁移

怪了 怎么会未找到表格

具体原因有空我再去排查

wanyanjiabin commented 1 year ago

没有启用自带的白名单,因为我用了第三方的白名单插件,白名单处于false关闭状态,上次我看你是修改了src/main/java/moe/xmcn/catsero/uses/listeners/qWhitelist/RefuseNoWhiteList.kt文件,然后就不报错了,这次我看你新增了很多内容,所以不能确定是哪个文件,等你有空修复吧,目前只是报错,不影响功能

Muska-Ami commented 1 year ago

👌

Muska-Ami commented 1 year ago

开发版已修复 image