Jail error #150

  • Defect
  • Accepted
Assigned to _ForgeUser7037478
  • _ForgeUser10714587 created this issue Mar 28, 2013

    What steps will reproduce the problem?
    1./jail player
    2./pardon him


    1./tempjail somebody.

    I'm using Ultrabans 3.1.0

    When I pardon somebody, or his term expire, I get this error:
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near ")": syntax error)
        at org.sqlite.DB.newSQLException(DB.java:383)
        at org.sqlite.DB.newSQLException(DB.java:387)
        at org.sqlite.DB.throwex(DB.java:374)
        at org.sqlite.NativeDB.prepare(Native Method)
        at org.sqlite.DB.prepare(DB.java:123)
        at org.sqlite.PrepStmt.<init>(PrepStmt.java:42)
        at org.sqlite.Conn.prepareStatement(Conn.java:404)
        at org.sqlite.Conn.prepareStatement(Conn.java:399)
        at org.sqlite.Conn.prepareStatement(Conn.java:383)
        at com.modcrafting.ultrabans.db.SQLite.removeFromJaillist(Unknown Source)
        at com.modcrafting.ultrabans.commands.Pardon$1.run(Unknown Source)
        at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftTask.run(CraftTask.java:53)
        at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:344)
        at net.minecraft.server.MinecraftServer.r(MinecraftServer.java:899)
        at ho.r(DedicatedServer.java:309)
        at net.minecraft.server.MinecraftServer.q(MinecraftServer.java:857)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:744)
        at fy.run(ThreadMinecraftServer.java:16)

    Player remain to be jailed after restart.

  • _ForgeUser10714587 added the tags New Defect Mar 28, 2013
  • _ForgeUser10714587 posted a comment Apr 3, 2013

    Is project dead or there are things with higher priority?
    P.S. MySQL database works fine with rare errors while ban term expire

    Edited Apr 3, 2013
  • Haarolean posted a comment Apr 4, 2013

    @various2012: Go

    I dunno about jail updates, but u can try to do the same after new update (look commits on github, next new build here, at bukkit dev) and try to do the same with mysql, not sqlite. The problem can be with your database. If problem will appear again, please leave comment here and reopen ticket again. Thx.

  • Haarolean removed a tag New Apr 4, 2013
  • Haarolean added a tag Waiting Apr 4, 2013
  • _ForgeUser9225940 posted a comment Apr 8, 2013

    I am having the same error. I posted a ticket, didn't see this one.

  • _ForgeUser9225940 removed a tag Waiting Apr 8, 2013
  • _ForgeUser9225940 added a tag Replied Apr 8, 2013
  • Haarolean removed a tag Replied Apr 8, 2013
  • Haarolean added a tag Waiting Apr 8, 2013
  • Haarolean removed a tag Waiting Apr 8, 2013
  • Haarolean added a tag Accepted Apr 8, 2013
  • Haarolean posted a comment Jun 13, 2013

    We'll see if this will be fixed in UB v4

To post a comment, please login or register a new account.