点券数据库报错问题！ - 联机问答

瑞瑞瑞瑞阿

本帖最后由瑞瑞瑞瑞阿于 2020-3-1 18:32 编辑

已解决

playerpoints 点券插件
数据库链接失败，如何解决？
下面是报错以及数据库配置

[18:07:02] [Server thread/ERROR]: [PlayerPoints] Could not create setter statement.
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (table playerpoints has no column named nickname)
at org.sqlite.core.DB.newSQLException(DB.java:909) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.DB.newSQLException(DB.java:921) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.DB.throwex(DB.java:886) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.NativeDB.prepare_utf8(Native Method) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.NativeDB.prepare(NativeDB.java:127) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.DB.prepare(DB.java:227) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:41) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:48) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:263) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:235) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at lib.PatPeter.SQLibrary.Database.prepare(Database.java:291) ~[SQLibrary-7.1.jar:?]
at org.black_ixx.playerpoints.storage.models.SQLiteStorage.setPoints(SQLiteStorage.java:81) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.storage.StorageHandler.setPoints(StorageHandler.java:44) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.PlayerPointsAPI.give(PlayerPointsAPI.java:45) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.commands.GiveCommand.execute(GiveCommand.java:68) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.services.CommandHandler.onCommand(CommandHandler.java:130) [PlayerPoints-RcVersionV1.1.jar:?]
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:651) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PlayerConnection.handleCommand(PlayerConnection.java:1392) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PlayerConnection.a(PlayerConnection.java:1227) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:45) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:1) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PlayerConnectionUtils$1.run(SourceFile:13) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_121]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_121]
at net.minecraft.server.v1_12_R1.SystemUtils.a(SourceFile:46) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:748) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:406) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:679) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:577) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_121]
[18:07:53] [Server thread/INFO]: Shmily_ke issued server command: /p give Shmily_ke 1
[18:07:53] [Server thread/ERROR]: [PlayerPoints] Could not create setter statement.
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (table playerpoints has no column named nickname)
at org.sqlite.core.DB.newSQLException(DB.java:909) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.DB.newSQLException(DB.java:921) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.DB.throwex(DB.java:886) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.NativeDB.prepare_utf8(Native Method) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.NativeDB.prepare(NativeDB.java:127) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.DB.prepare(DB.java:227) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:41) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:48) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:263) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:235) ~[Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at lib.PatPeter.SQLibrary.Database.prepare(Database.java:291) ~[SQLibrary-7.1.jar:?]
at org.black_ixx.playerpoints.storage.models.SQLiteStorage.setPoints(SQLiteStorage.java:81) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.storage.StorageHandler.setPoints(StorageHandler.java:44) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.PlayerPointsAPI.give(PlayerPointsAPI.java:45) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.commands.GiveCommand.execute(GiveCommand.java:68) [PlayerPoints-RcVersionV1.1.jar:?]
at org.black_ixx.playerpoints.services.CommandHandler.onCommand(CommandHandler.java:130) [PlayerPoints-RcVersionV1.1.jar:?]
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:651) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PlayerConnection.handleCommand(PlayerConnection.java:1392) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PlayerConnection.a(PlayerConnection.java:1227) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:45) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PacketPlayInChat.a(PacketPlayInChat.java:1) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.PlayerConnectionUtils$1.run(SourceFile:13) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_121]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_121]
at net.minecraft.server.v1_12_R1.SystemUtils.a(SourceFile:46) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:748) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:406) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:679) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:577) [Spigot-1.12.2.jar:git-Spigot-7754231-94b0980]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_121]

复制代码

思念化作海

截图下你的点券插件配置呢

瑞瑞瑞瑞阿

折叠发表于 2020-3-1 18:11
截图下你的点券插件配置呢

稍等，我更新在帖子里！

思念化作海

storage改为mysql
数据库和表名都没错呀...

瑞瑞瑞瑞阿

折叠发表于 2020-3-1 18:11
截图下你的点券插件配置呢

好了

EmptyLava

是在你建库之后才出错还是本来有这个数据库，突然出错?

石田将也i

是不是没转码转码试试

瑞瑞瑞瑞阿

EmptyLava 发表于 2020-3-1 18:21
是在你建库之后才出错还是本来有这个数据库，突然出错?

建库之后

起源战争

storage:SQLIte改成mysql就好了