search

taylorkelly / BigBrother

GNU General Public License v3.0
29 stars 20 forks source link

BigBrother error on rollback? #73

Open Sirenic opened 13 years ago

Sirenic commented 13 years ago

I get this large error upon doing /rollback [user] blah blah. What is it, and what do I do to fix the error? Is it serious? Is it just a bug that has to be fixed with a newer version of BB? Thanks!

29.04 10:11:37 [Server] INFO at net.minecraft.server.ThreadServerApplication.run(SourceFile:394) 29.04 10:11:37 [Server] INFO at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285) 29.04 10:11:37 [Server] INFO at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370) 29.04 10:11:37 [Server] INFO at net.minecraft.server.NetworkListenThread.a(SourceFile:100) 29.04 10:11:37 [Server] INFO at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74) 29.04 10:11:37 [Server] INFO at net.minecraft.server.NetworkManager.a(NetworkManager.java:195) 29.04 10:11:37 [Server] INFO at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32) 29.04 10:11:37 [Server] INFO at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:632) 29.04 10:11:37 [Server] INFO at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:638) 29.04 10:11:37 [Server] INFO at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:675) 29.04 10:11:37 [Server] INFO at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255) 29.04 10:11:37 [Server] INFO at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85) 29.04 10:11:37 [Server] INFO at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35) 29.04 10:11:37 [Server] INFO at me.taylorkelly.bigbrother.BBCommand.onCommand(BBCommand.java:40) 29.04 10:11:37 [Server] INFO at me.taylorkelly.bigbrother.commands.UndoCommand.onCommand(UndoCommand.java:28) 29.04 10:11:37 [Server] INFO at me.taylorkelly.bigbrother.rollback.Rollback.undo(Rollback.java:130) 29.04 10:11:37 [Server] INFO at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243) 29.04 10:11:37 [Server] INFO at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:71) 29.04 10:11:37 [Server] INFO at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100) 29.04 10:11:37 [Server] INFO at org.h2.engine.Session.prepareCommand(Session.java:374) 29.04 10:11:37 [Server] INFO at org.h2.engine.Session.prepareLocal(Session.java:426) 29.04 10:11:37 [Server] INFO at org.h2.command.Parser.prepareCommand(Parser.java:214) 29.04 10:11:37 [Server] INFO at org.h2.command.Parser.prepare(Parser.java:201) 29.04 10:11:37 [Server] INFO at org.h2.command.Parser.parse(Parser.java:247) 29.04 10:11:37 [Server] INFO at org.h2.command.Parser.parse(Parser.java:275) 29.04 10:11:37 [Server] INFO at org.h2.command.Parser.parsePrepared(Parser.java:423) 29.04 10:11:37 [Server] INFO at org.h2.command.Parser.parseUpdate(Parser.java:658) 29.04 10:11:37 [Server] INFO at org.h2.command.Parser.read(Parser.java:2737) 29.04 10:11:37 [Server] INFO at org.h2.message.DbException.getSyntaxError(DbException.java:192) 29.04 10:11:37 [Server] INFO at org.h2.message.DbException.get(DbException.java:167) 29.04 10:11:37 [Server] INFO at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) 29.04 10:11:37 [Server] INFO UPDATE bbdata AS bbdata, bbusers AS usr SET rbacked = false WHERE bbdata.player = usr.id AND action IN('0','1','4','12','2','13','15','16','17','19','20') AND player IN ('2') AND rbacked = true; [42001-153] 29.04 10:11:37 [Server] INFO org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "UPDATE BBDATA AS BBDATA,[*] BBUSERS AS USR SET RBACKED = FALSE WHERE BBDATA.PLAYER = USR.ID AND ACTION IN('0','1','4','12','2','13','15','16','17','19','20') AND PLAYER IN ('2') AND RBACKED = TRUE; "; expected "SET"; SQL statement: 29.04 10:11:37 [Server] SEVERE [BBROTHER] Rollback undo SQL Exception