[GEN] BukkitInventoryTools - Find it on BukkitDev.

Discussion in 'Inactive/Unsupported Plugins' started by Gabriel333, Sep 11, 2011.

  1. Offline

    Gabriel333

    olimoli123 likes this.
  2. Offline

    Gabriel333

    You cant.... hmmm... maybe I should remove it, completely...

    EDIT: you will be able to disable this in config.yml in next release >2.0.3

    Ahh yes... I will fix that. I think I will make a group for Buckets or "Other"

    Is it not okay to stack empty buckets??? 325???

    EDIT: I have added Permissions for a bucket group, so you can disable it. I will come in next release. > 2.0.3

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

    grinch843

    Yeah, those are fine...

    Grinch
     
  4. Offline

    Gabriel333

    Released in version 2.0.4:)

    Released in version 2.0.4 :) check config.yml

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

    cheese417624

    I cannot seem to get MYSQL to be used as the database. I put in correct information and changed the storage type to MYSQL but in the server startup it says:
    Code:
    [INFO] [BukkitInventoryTools] SQLite initializing
    This is the area out of the config file:
    Code:
    Storage:
        Type: MYSQL
        Host: localhost
        Username: inventorytools
        Password: password
        Database: bukkitinventorytools
    And yes I did save the document.
     
  6. Offline

    Gabriel333

    I had made a small error (I wrote MySQL in the code instead of MYSQL) MYSQL should work in release 2.0.5
     
  7. Offline

    cheese417624

    Ty :)
     
  8. Offline

    The3vilm0nk3y

    That is all the console and logs show. It doesnt bring down the entire server either... it just kicks the player using the sort. Here the error code is again... but with the lines before and after it...
    Code:
    2011-09-12 21:58:00 [INFO] [PLAYER_COMMAND] The3vilM0nk3y: /tp drag
    2011-09-12 21:58:27 [WARNING] Failed to handle packet: java.lang.NullPointerException
    java.lang.NullPointerException
        at net.minecraft.server.ItemStack.a(ItemStack.java:199)
        at net.minecraft.server.InventoryPlayer.f(InventoryPlayer.java:120)
        at net.minecraft.server.EntityHuman.v(EntityHuman.java:183)
        at net.minecraft.server.EntityPlayer.v(EntityPlayer.java:281)
        at net.minecraft.server.EntityLiving.m_(EntityLiving.java:218)
        at net.minecraft.server.EntityHuman.m_(EntityHuman.java:97)
        at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:193)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:299)
        at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:592)
        at net.minecraft.server.Packet10Flying.a(SourceFile:126)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
        at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:478)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-09-12 21:58:36 [INFO] The3vilM0nk3y [/192.168.1.1:50122] logged in with entity id 177 at ([Clean] 78.86447110665013, 49.41349388988699, 206.02784301415963)
    2011-09-12 21:58:36 [INFO] Reading data
    2011-09-12 21:58:36 [INFO] [Spout] Successfully authenticated The3vilM0nk3y's Spoutcraft client. Running client version: 1.0.5.262
    2011-09-12 21:59:40 [INFO] <dragon998night> 1.8 is wayy to laggy for me
    
    I could send u my server startup log if you would like but ill send that via PM as it is long. However I do not see any issues or errors on startup.
     
  9. Offline

    Gabriel333

    At the moment I don't have a clue on where the problem is... But I just noticed the you said something about infinite items!!! What do you mean by that? I have not done anything to handle "infinite items" so this could ideed be the problem. Is this a special plugin you are using? If yes then I could try that plugin on my test server to see if I can make the error and then find the bug.
     
  10. Offline

    The3vilm0nk3y

    I Use Command Book. It has the command /i id amount but you can type in -1 for ammount to get an infinite stack. I will test this now for you... try it without infinite items then with. Ok so.. Now that Im Trying To Make it crash again... i cannot... the plugin seems to have fixed itself automagically. only thing i have changed is adding the shortcuts plugin.
    It is not the infinite items doing it... it seems to be working just fine for them. Kinda odd. But I have found a bug with the locking mechanism. I set a lock with the passcode evil then made a few more... then i accidentally added another lock with the same pass... evil.... and the server came crashing down hard. The console started unloading this error...
    Code:
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: cannot commit transaction - SQL statements in progress
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: cannot commit transaction - SQL statements in progress
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:35 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:36 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:36 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    2011-09-13 10:22:36 [WARNING] [BukkitInventoryTools]Error at SQL Query: query does not return ResultSet
    
    My log file has over 500 of these lines in less than a few seconds..... and if I can recreate the sort crash i will let you know how I did it.

    sorry for canabalizing your forum with error logs. but I just got a new crash report for you. I tried locking a door and got this...
    Code:
    2011-09-13 10:26:47 [INFO] [Spout] Successfully authenticated The3vilM0nk3y's Spoutcraft client. Running client version: 1.0.5.262
    2011-09-13 10:38:38 [SEVERE] Could not pass event CUSTOM_EVENT to BukkitInventoryTools
    java.lang.ClassCastException: org.bukkit.craftbukkit.block.CraftBlockState cannot be cast to org.getspout.spoutapi.block.SpoutChest
        at dk.gabriel333.BukkitInventoryTools.BITDigiLock.loadDigiLock(BITDigiLock.java:401)
        at dk.gabriel333.BukkitInventoryTools.BITSpoutListener.onCustomEvent(BITSpoutListener.java:29)
        at org.bukkit.plugin.java.JavaPluginLoader$88.execute(JavaPluginLoader.java:862)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
        at org.getspout.spoutapi.packet.PacketControlAction.run(PacketControlAction.java:101)
        at org.getspout.spout.packet.CustomPacket.a(CustomPacket.java:129)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
        at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:478)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-09-13 10:38:40 [SEVERE] Could not pass event CUSTOM_EVENT to BukkitInventoryTools
    java.lang.ClassCastException: org.bukkit.craftbukkit.block.CraftBlockState cannot be cast to org.getspout.spoutapi.block.SpoutChest
        at dk.gabriel333.BukkitInventoryTools.BITDigiLock.loadDigiLock(BITDigiLock.java:401)
        at dk.gabriel333.BukkitInventoryTools.BITSpoutListener.onCustomEvent(BITSpoutListener.java:29)
        at org.bukkit.plugin.java.JavaPluginLoader$88.execute(JavaPluginLoader.java:862)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
        at org.getspout.spoutapi.packet.PacketControlAction.run(PacketControlAction.java:101)
        at org.getspout.spout.packet.CustomPacket.a(CustomPacket.java:129)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
        at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:478)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-09-13 10:39:17 [INFO] /50.23.30.168:35853 lost connection
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 19, 2016
  11. Offline

    Gabriel333

    You are giving me challenges :)
     
  12. Offline

    The3vilm0nk3y

    I do it because I want to see the plugin reach its full potential... It is obtaining features that are very usefull and the gui's are very easy to use. And the ability to share with other people without signs or extensive commands is great. I will keep the error posts down for a day or two. ;) And You should disable redstone from being able to trigger doors while locked.
     
  13. Offline

    Gabriel333

    Thanks. I work hard on this :)
    I have added some code to cancel the event from redstone, if it is locked. Could you please test it for me? Try version 2.0.6

    I also found and fixed some more MYSQL/MySQL bugs.
     
  14. Offline

    The3vilm0nk3y

    just tested redstone, everything still works as normal. torches buttons levers wires repeaters and blocks all send power from all directions still. but that is a minor issue compared to the unable to unlock the doors and use them. but thank you for working on this. For you: [diamond][diamond][diamond] . I will do more testing in a few hours.
    Would you like me to keep posting errors here or through PM or other means?
    Just Lemme know.
     
  15. Offline

    Gabriel333

    Thanks. You dont need to test alot on doors, because i know they does not work very well yet! But Now i need to sleep. You must be in another timezone than me :)

    Im very interested if you find bugs on the inventories.
     
  16. Offline

    cheese417624

    Code:
    19:05:55 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    
    Got about 20 of these in a fraction of a second when I tried locking a chest with MySQL enabled. Also when I started up the server with MySQL enabled it connected to the database but had this syntax error:
    Code:
    [SEVERE] [BukkitInventoryTools]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIMARY_KEY, pincode VARCHAR(4), owner VARCHAR(255), closetimer INT, x INT, y IN' at line 1
    
    I would like to resolve this issue and am guessing that it is probably because I have the newest version of MySQL (5.5) and that this may not be updated to it. :confused:
     
  17. Offline

    Zone

    I have this problem too
     
  18. Offline

    dockter

    Last edited by a moderator: May 19, 2016
  19. Offline

    Gabriel333

    This is not an error. It should only happen once. I auto-add parameters if the dont exists in your config.yml. If you want a fresh config.yml, then just delete it.
     
  20. Offline

    Sa_KE

    What does

    do?

    and congrats for making it this far with your server-mods :)!

    If you do decide to lock doors you should protect the door themselves too :)

    Code:
    2011-09-14 22:04:56 [SEVERE] Could not pass event CUSTOM_EVENT to BukkitInventor
    yTools
    
    getting this error.

    And a friend of mine using spoutcraft (cracked) cant open some of her chests. She puts the p/w but the window wont show. Works on some doesnt on others. i can open the chests though.

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

    Gabriel333

    Im sorry I cant properly not help you with a cracked version of SpoutCraft. The spout team does not support it and niether do I.

    The admin rights shout make you change the pincode on a DigiLock, which another user have created. Admin should also be able to remove the lock completly, even if the owner is another player. More features is planned, like admin will be able to change the owner of the DigiLock.

    I have started to make the lock work on doors too, but Im not finished yet. Try pointing a door and press L. You can create and remove the lock. Opening the door using the passcode does not work yet. Sorry.

    You have to give me a little bit more if Im going to help you ;-)

    I need more output from the console, I dont have a MySQL server on my laptop so its hard to debug.

    I need to see what it says in the console from the line which says :
    MySQL Initializing.

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

    Jon1155

    I recommend you get WAMP, (Windows Apache MySQL PHP), it sets up a local web server on just your computer, and it also gives you MySQL access, just a thought
     
  23. Offline

    Gabriel333

    My problem is that the laptop is my work-computer so I must be able to install it in a private catalog c:\private\MySQL and NO other place. Futher more it must ONLY run when I start it? Can WAMP do this? (This is why I use SQLite on my laptop).

    Okay ... I found an error! You were right. It is fixed in next release.

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

    dockter

    Any idea on why this conflicts with BetterShops plugin?
     
  25. Offline

    Gabriel333

    No, and Im sorry to tell, it has low priority. Im trying to make the lock work on doors now.

    I what way do you see the conflict? what happens?
     
  26. Offline

    dockter

    Hm, curious, it may not be your pluggin causing it, it may be spoutbackpack. I need to do some more debugging, I will follow up.

    Looking forward to the locked doors Idea your working on.
     
  27. Offline

    cheese417624

    This is the lengthy error message that spams the console when MySQL is in use when I make the lock. Also the SQL table was not made in the MySQL database that it was assigned to:
    Code:
    [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:50 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:51 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:51 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:51 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:51 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:54 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:54 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:54 [WARNING] [BukkitInventoryTools]Error at SQL INSERT Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:32:55 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    EDIT: Found the line!
    Code:
    [INFO] [BukkitInventoryTools] MySQL Initializing
    2011-09-14 16:15:24 [INFO] [BukkitInventoryTools] MySQL connection successful
    2011-09-14 16:15:24 [INFO] [BukkitInventoryTools] Creating table BukkitInventoryTools
    2011-09-14 16:15:24 [SEVERE] [BukkitInventoryTools]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIMARY_KEY, pincode VARCHAR(4), owner VARCHAR(255), closetimer INT, x INT, y IN' at line 1
    2011-09-14 16:15:24 [INFO] [BukkitInventoryTools] SpoutBackpack is detected.
    2011-09-14 16:15:24 [INFO] [BukkitInventoryTools] BukkitInventoryTools version 2.0.6 is enabled!
    Started it up again with the debug mode on and got a slightly different error when placing lock:
    Code:
    2011-09-14 16:44:04 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:44:04 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:44:04 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:44:04 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:44:09 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:44:09 [WARNING] [BukkitInventoryTools]Error at SQL Query: Table 'inventorytools.bukkitinventorytools' doesn't exist
    2011-09-14 16:44:09 [WARNING] [BukkitInventoryTools]Error at SQL INSERT Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'inventorytools.bukkitinventorytools' doesn't exist
     
  28. Offline

    Gabriel333

    Okay, I can now see that it is the creation of the table which goes wrong :-(

    This is the command i use:
    String query = "CREATE TABLE BukkitInventoryTools (id INT AUTO_INCREMENT PRIMARY_KEY, pincode VARCHAR(4), owner VARCHAR(255), closetimer INT, x INT, y INT, z INT, world VARCHAR(255), shared VARCHAR(255), coowners VARCHAR(255));";

    can you see any errors? (if you know SQL)

    I made in release 2.0.7. Please test if it works.

    You can now create and remove the DigiLock on a door and unlock it afterwards! :)

    The thing with redstone is not fixed yet. but I need to sleep now.

    I think i fixed redstone too now. its okay that you post errors here, but if there many they might disapear from me :)

    so if you really want, then you should use the ticket system on the dev.bukkit.org: http://dev.bukkit.org/server-mods/bukkitinventorytools/tickets/

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

    cheese417624

    Use this instead:
    Code:
    CREATE TABLE BukkitInventoryTools
        (id INT PRIMARY KEY AUTO_INCREMENT,
        pincode VARCHAR(4),
        owner VARCHAR(255),
        closetimer INT,
        x INT,
        y INT,
        z INT,
        world VARCHAR(255),
        shared VARCHAR(255),
        coowners VARCHAR(255))
    EDIT: Made the table with the script and tested it on server, worked beautifully.
     
  30. Offline

    Sa_KE

    With 2.0.6 i cant open some of the chests now that i know the p.w. to.

    Ill try 2.0.8...
     
  31. Offline

    Avarice

    Users are still able to stack tools despite having only the bukkitinventorytools.sortinventory.use node in their permissions. We're using PermissionsEx, spout, and spoutbackpack. The locking feature is not being used, and the sort achievement is also set to false, but is still appearing.
     

Share This Page