CypherX/xAuth — Issue #21: SQL query failure
Author: Keetveter
Created: 2011-12-13 18:33:32+00:00
State: open

This is the error I receive with Bukkit 1.0.1-R1 when players are in the server:
2011-12-13 19:09:07 [SEVERE] [xAuth] SQL query failure [write] (INSERT INTO `strike_bans` VALUES (?, ?, ?))
org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement:
INSERT INTO `strike_bans` VALUES (?, ?, ?) [21002-159]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.message.DbException.get(DbException.java:135)
at org.h2.command.dml.Insert.prepare(Insert.java:226)
at org.h2.command.Parser.prepareCommand(Parser.java:218)
at org.h2.engine.Session.prepareLocal(Session.java:415)
at org.h2.engine.Session.prepareCommand(Session.java:364)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1119)
at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:71)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)
at com.cypherx.xauth.database.Database.queryWrite(Database.java:85)
at com.cypherx.xauth.database.DbUtil.insertStrike(DbUtil.java:145)
at com.cypherx.xauth.commands.LoginCommand.onCommand(LoginCommand.java:52)
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:165)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:378)
at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:180)
at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:93)
at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:550)
at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:527)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)