Inactive [ADMN/RPG] Jail - Jail bad players

Discussion in 'Inactive/Unsupported Plugins' started by matejdro, Jan 24, 2011.

  1. Offline

    matejdro

    Jail

    This plugins adds Jail to your minecraft server. Admins can define several jails and then jail/unjail people or jail them on time basis. Plugin also offers wide variety of protections, so players won't escape out of your jail.



    See BukkitDev page for more information and download links: http://dev.bukkit.org/server-mods/jail/
    (you can use your minecraft forum username and password on BukkitDev)
     
  2. Offline

    Loart

    >.< Thank you, I believe I was just too much of an idiot and only marked the floor.

    Edit: I still can only stand on one square when I do it. Am I supposed to do mark ceiling then floor? It just always moves me back to the one block. Then I'm also running into an error now with deleting a jail, saying to empty. And I jail force clear and it doesn't work. And there is no on jailed.
     
  3. Offline

    undefinedarray

    yup
     
  4. Offline

    bruce

    i have 714 (mcbans groupmanager and jail and bigbrother ) "in error has occoured when attempting too perform this command " is all i get form any jail commands can you help me figure this out thanks you can hop on my ts 173.19.152.152:9987
     
  5. Offline

    matejdro

  6. Offline

    Kiithnaras

    Attempting to execute the command yields no result at all. It does not give me an unknown command error, but it also does not give any message of any kind after using "jailcreate" in console.

    Code:
    >jailcreate babababa
    >jailclearforce
    02:40:55 [INFO] Everyone have been cleared!
    >jail
    02:40:56 [INFO] Usage: /jail [Name] (Time) (Jail Name)
    >jailcreate
    >jailcreate yaddayadda
    >durpdurp
    02:41:16 [INFO] Unknown console command. Type "help" for help.
     
  7. Offline

    matejdro

    jailcreate won't work from console, since you obviously cannot select cuboid and teleport points inside console. But I'm wondering about other commands that you listed above as broken. Since you can't create jail, nothing will probably happen, but you should at least get an error message.
     
  8. Offline

    andrewkm

    Running 1.4_01
    CD [684] Jail [0.6]
    Updating from Jail [0.5.6] using MySQL
    Recieve this on plugin update
    Code:
    2011-04-24 09:05:20 [INFO] [Jail] Updating database
    2011-04-24 09:05:20 [SEVERE] [Jail] Error while updating tables to the new version - Duplicate column name 'reason'
    2011-04-24 09:05:20 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'reason'
    2011-04-24 09:05:20 [SEVERE]  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-24 09:05:20 [SEVERE]  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 09:05:20 [SEVERE]  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 09:05:20 [SEVERE]  at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    2011-04-24 09:05:20 [SEVERE]  at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    2011-04-24 09:05:20 [SEVERE]  at com.matejdro.bukkit.jail.InputOutput.Update(InputOutput.java:418)
    2011-04-24 09:05:20 [SEVERE]  at com.matejdro.bukkit.jail.InputOutput.UpdateDB(InputOutput.java:390)
    2011-04-24 09:05:20 [SEVERE]  at com.matejdro.bukkit.jail.InputOutput.PrepareDB(InputOutput.java:385)
    2011-04-24 09:05:20 [SEVERE]  at com.matejdro.bukkit.jail.Jail.onEnable(Jail.java:68)
    2011-04-24 09:05:20 [SEVERE]  at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-24 09:05:20 [SEVERE]  at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-24 09:05:20 [SEVERE]  at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-24 09:05:20 [SEVERE]  at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-24 09:05:20 [SEVERE]  at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-24 09:05:20 [SEVERE]  at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-24 09:05:20 [SEVERE]  at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-24 09:05:20 [SEVERE]  at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-24 09:05:20 [SEVERE]  at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-24 09:05:20 [SEVERE]  at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    Something with mysql new tables or something I dunno. Thought it may help you in finding a bug if I posted it.
    I deleted my old mysql tables "jail_prisoners" and "jail_zones" and tried again.
    Everything up and okay! :) Not a problem I only had like 4 jails... just gotta remake them.
    Thanks for this plugin again :) Cheers!

    Well upon testing the 0.6 on [684] with mySQL here is what im getting:
    I created a jail just fine. However upon sending user to jail i receive:
    Code:
    2011-04-24 09:19:20 [SEVERE] [Jail] Error while inserting Prisoner into DB! - Duplicate entry 'andrewkm' for key 'PRIMARY'
    2011-04-24 09:19:20 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'andrewkm' for key 'PRIMARY'
    2011-04-24 09:19:20 [SEVERE]  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-24 09:19:20 [SEVERE]  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 09:19:20 [SEVERE]  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 09:19:20 [SEVERE]  at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011-04-24 09:19:20 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011-04-24 09:19:20 [SEVERE]  at com.matejdro.bukkit.jail.InputOutput.InsertPrisoner(InputOutput.java:276)
    2011-04-24 09:19:20 [SEVERE]  at com.matejdro.bukkit.jail.Jail.Jail(Jail.java:223)
    2011-04-24 09:19:20 [SEVERE]  at com.matejdro.bukkit.jail.Jail.onCommand(Jail.java:475)
    2011-04-24 09:19:20 [SEVERE]  at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011-04-24 09:19:20 [SEVERE]  at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80)
    2011-04-24 09:19:20 [SEVERE]  at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:254)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.NetServerHandler.c(NetServerHandler.java:637)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:600)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:594)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.Packet3Chat.a(SourceFile:24)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-04-24 09:19:20 [SEVERE]  at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-24 09:19:21 [SEVERE] [Jail] Error while updating Prisoner into DB!
    2011-04-24 09:19:21 [SEVERE] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'andrewkm'
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011-04-24 09:19:21 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011-04-24 09:19:21 [SEVERE]  at com.matejdro.bukkit.jail.InputOutput.UpdatePrisoner(InputOutput.java:298)
    2011-04-24 09:19:21 [SEVERE]  at com.matejdro.bukkit.jail.Jail$1.actionPerformed(Jail.java:319)
    2011-04-24 09:19:21 [SEVERE]  at javax.swing.Timer.fireActionPerformed(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at javax.swing.Timer$DoPostEvent.run(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.event.InvocationEvent.dispatch(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventQueue.access$000(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventQueue$1.run(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventQueue$1.run(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.security.AccessController.doPrivileged(Native Method)
    2011-04-24 09:19:21 [SEVERE]  at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventQueue.dispatchEvent(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    2011-04-24 09:19:21 [SEVERE]  at java.awt.EventDispatchThread.run(Unknown Source)
    -
    And then every couple seconds
    Code:
    2011-04-24 09:21:11 [SEVERE] [Jail] Error while updating Prisoner into DB!
    2011-04-24 09:21:11 [SEVERE] com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'andrewkm'
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011-04-24 09:21:11 [SEVERE]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011-04-24 09:21:11 [SEVERE]  at com.matejdro.bukkit.jail.InputOutput.UpdatePrisoner(InputOutput.java:298)
    2011-04-24 09:21:11 [SEVERE]  at com.matejdro.bukkit.jail.Jail$1.actionPerformed(Jail.java:319)
    2011-04-24 09:21:11 [SEVERE]  at javax.swing.Timer.fireActionPerformed(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at javax.swing.Timer$DoPostEvent.run(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.event.InvocationEvent.dispatch(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventQueue.access$000(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventQueue$1.run(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventQueue$1.run(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.security.AccessController.doPrivileged(Native Method)
    2011-04-24 09:21:11 [SEVERE]  at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventQueue.dispatchEvent(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    2011-04-24 09:21:11 [SEVERE]  at java.awt.EventDispatchThread.run(Unknown Source)
    As well things such as mute prisoner settings were not working, and the stepping outside of jail caused intense lag and would take about 10-15 seconds to knock you back inside.
    Back to [0.5.6] and all is perfect again :) Im going to wait till i can go 1.5_02 before trying again, maybe that is the issue. Thanks again.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 7, 2016
  9. Offline

    matejdro

    Try deleting everything and restarting.
     
  10. Offline

    andrewkm

    Would you mean the whole jail plugin? That was done.
    Or do you mean remove all plugins and try with just jail? (If so ill need to do it in a couple hours and schedule the maintenance, server sitting at 20 users average)
     
  11. Offline

    matejdro

    First one.

    Weird. Can you export your jail tables and send them to me?
     
  12. Offline

    andrewkm

    Thats what I did.
    I deleted the entire plugin [0.5.6] and installed [0.6]
    This put out the first mysql error.
    I later deleted the whole plugin, INCLUDING the mysql tables... and it worked, loaded, set up the tables and all was fine, created a jail, and then upon jailing the errors began. I also noticed there is no [reason] when using just command /jail which puts out its usage "/jail [playername] [time] [jailname]"
    Im not too smart when it comes to mysql. Hmm how would i do this?
    Would you like me to reproduce the error i was getting? and right after.... send the tables?
    Not sure how to "export your jail tables"
    Heres what i got. Mysql, running on localhost, and i can see/add/drop tables and so forth using MySQL workbench program. I right click a table but see no export option, sorry if i sound stupid, which i probably do... can you assist somehow?

    Ahh i think i see, export record set to extrenal file... allows a save in .csv to a path i provide?
    This right?
    Should I reproduce error first?
    Jail someone first? How would you like them sent?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 7, 2016
  13. Offline

    TheMadMan697

    i had problems with /jailclear and /jailclearforce when using sqllite. i got the following error message and the jail files would not be cleared

    So i decided to to try mysql. with mysql everything seems to work ok but when i jail a player that is not online, when they join the game i get the following error in the log.

    It does not appear to have any negitive effect on anything. the player is still sent to jail and verything works ok. but i just dont like seeing errors like that. o and i forgot to say im using craftbukkit version 714 and this is my first time ever using this plugin so i did not have any previous files or database's
     
  14. Offline

    andrewkm

    That is exactly the error i am recieving... mysql :(
    and so is :
    http://forums.bukkit.org/threads/admn-jail-v0-6-jail-bad-players-714.1912/page-27#post-235245
    Code:
    2011-04-24 17:46:01 [SEVERE] [Jail] Error while updating Prisoner into DB!
    
    Try jail [0.5.6] its mint. :) I think there is some stuff going on with 0.6
    In recent changes on 0.6 i noticed
    Maybe its this causing these sql update errors.
     
  15. Offline

    TheMadMan697

    Can anyone post a link to jail 0.5.6 ?
    I would really like to use this plugin however with 0.6 its riddled with bugs. I am getting errors when using both sqllite and mysql. My main problem with sqllite is that i cant clear all jailed players because it says "An internal error occured while attempting to perform this command" This only seems to happen when the jailed player is offline. there could be more problems that i have not noticed.

    EDIT: you can not unjail any player that is offline.

    When i use mysql i get an error with the mute column in the database.
    its trying to insert the playername into the mute column on the database. of coruse it will not accept this because the mute column is definted as tinyint(1) on the database so it can not take a playername. I hope this gets fixed soon.
     
  16. Offline

    matejdro

    Oops, i made some really stupid mistakes. Sorry.

     
  17. Offline

    Rick

    My server is stuck in Updating database
     
  18. Offline

    matejdro

    so each time you turn it on, you get updating database?

    Can you send me sqlite file?
     
  19. Offline

    Rick

    im using mysql

    i get this if i force quit and restart the server

    2011-04-24 16:27:25 [INFO] [Jail] Updating database
    2011-04-24 16:27:25 [SEVERE] [Jail] Error while updating tables to the new version - Duplicate column name 'reason'
    2011-04-24 16:27:25 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'reason'
    2011-04-24 16:27:25 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-24 16:27:25 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 16:27:25 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 16:27:25 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    2011-04-24 16:27:25 [SEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    2011-04-24 16:27:25 [SEVERE] at com.matejdro.bukkit.jail.InputOutput.Update(InputOutput.java:425)
    2011-04-24 16:27:25 [SEVERE] at com.matejdro.bukkit.jail.InputOutput.UpdateDB(InputOutput.java:397)
    2011-04-24 16:27:25 [SEVERE] at com.matejdro.bukkit.jail.InputOutput.PrepareDB(InputOutput.java:392)
    2011-04-24 16:27:25 [SEVERE] at com.matejdro.bukkit.jail.Jail.onEnable(Jail.java:68)
    2011-04-24 16:27:25 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-24 16:27:25 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-24 16:27:25 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-24 16:27:25 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    2011-04-24 16:27:25 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    2011-04-24 16:27:25 [SEVERE] at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    2011-04-24 16:27:25 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    2011-04-24 16:27:25 [SEVERE] at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    2011-04-24 16:27:25 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    2011-04-24 16:27:25 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-04-24 16:27:25 [INFO] [Jail] Loaded 1 jail zones.
    2011-04-24 16:27:25 [INFO] [Jail] Loaded 0 prisoners.

    i manually delete the column and im back to being stuck again

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 7, 2016
  20. Offline

    matejdro

    Can you also delete muted column?
     
  21. Offline

    TheMadMan697

    Ok i updated to version 0.6.1 and im still getting errors with mute column when using mysql. I deleted the database completely and let it create it again and it is still the same.

    To repoduce this error jail a player then mute them and unmute them. when you unmute them it gives the error.

    I tried sqllite too and that works better now. I dont get an error when removing an offline user from the jail. /jailclear and /jailclear force only half work though. They work for online players but if you jail a player that does not exist or that is not online and you type /jailclear or /jailclear force it will not remove them from the jail list.
     
  22. Offline

    matejdro

    Are you sure you updated to 0.6.1?
     
  23. Offline

    TheMadMan697

    yes i am i double checked by opening jail.jar with winrar and inside the plugin.yml it says version: 0.6.1

    I get the mysql error when i "unmute a player"

    I would prefer to just use sqllite because its simple. if you could fix the /jailclear and /jailclear force then i would use that. i only tried mysql because i was getting errors before.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 7, 2016
  24. Offline

    matejdro

    Oh, sorry. I was sure that this fix got into 0.6.1. Anyway, updated the file.
     
  25. Offline

    TheMadMan697

    still getting the same problem with the mute field when using mysql. and /jail clear does not clear offline players in both mysql and sqllite
     
  26. Offline

    matejdro

    Again updated file.
     
  27. Offline

    TheMadMan697

    Nice it seems to be working now. Do you think you could make /jailclear and /jailclear force remove all the players from jail even of they are offline because at the moment it only removes the players if they are online. if you by mistake jail a name that does not exist then it can not be removed.
     
  28. Offline

    matejdro

    /jailclearforce will remove everyone from jail. Also /unjailforce will remove specific name from jail even if it's not online.
     
  29. Offline

    TheMadMan697

    Cheers /unjailforce [playername] works alright but /jailclearforce does not do anything for me.
     
  30. Offline

    andrewkm

    You good sir are a genious! I thank you SO MUCH for pushing 0.6.1 so quickly for us :)
    Huge cheers! :)
    Everything seems to work beautifully except some bugs, which I had from 0.5.6 as well so I can live with them.
    My Moderators have all the permissions for the following commands (And believe me im 100 thousand percent sure my permissions file has no mistakes i run over 15+ plugins with like 6 groups all commands working like they should for all groups.)
    Anyways...
    OPs can use all commands in your plugin however:
    /jaillist
    /jailcheck
    Does not work with permissions jail.command.jailcheck / jail.command.jaillist
    jail.command.jail and jail.command.unjail works for them.
    Those are the four i give my moderators. Only two of them work.
    Any ideas?
    Not huge problem however. I can live with it.
    Incase youd like someinformation once again im on [0.6.1] [684] [1.4_01]
    -
    Sorry if i keep posting problems. I just run quite a big server, and your plugin is highly used in it. Lol! :)
    -
    PS: totally low priority but on your next update /jail should put out Usage: "/jail [name] [time] [jailname] [reason]" as opposed to the current: /jail [name] [time] [jailname] [reason]
    Just something i noticed.
    Reason does work though.
     
  31. Offline

    TheMadMan697

    I just tested this and it i have the same problem with /jailcheck but /jaillist works fine for me. so i decided to try and give my moderators
    When i gve them this command then /jailcheck worked. So seen as i want my moderators to have all the permissions except create and delete i then added
    This also worked and it removed create and delete from the moderators but it also caused the /jailcheck to stop working. So then I tested by removing
    This fixed the problem with /jailcheck not working. so now my moderators have the following permission nodes.

    Now it allows them to access all the jail commands except /jaildelete
    So if adding -jail.command.jailcreate stops /jailcheck from working then there must be a problem with that permision node or something. I hope this helps somewhat in fixing the problem
     

Share This Page