[INACTIVE][SEC] OwnBlocks v10.0 - Players may not break blocks placed by others [860]

Discussion in 'Inactive/Unsupported Plugins' started by cvenomz, Apr 19, 2011.

  1. Offline

    cvenomz

    OwnBlocks:
    Version: v10.0

    (7-10-2011) - Please see the latest branch of OwnBlocks, called OwnBlocksX. It is recommended you use OwnBlocksX now.

    OwnBlocks keeps track of placed blocks, and who placed them. Players are not allowed to break blocks placed by other players. Note however, that indirect breaking may still occur (i.e. fire, tnt).

    Features:
    • Blocks you place cannot be broken by others
    • Persistence; Server remembers who owns what blocks after a restart or "reload"
    • Toggleability! Use /ownblocks or /ob to toggle OwnBlocks on and off
    • Ability to exclude certain blocks from being protected
    • Support for Permissions AND non-Permissions servers
    • Auto-saving intervals for database protection
    • Add (pre-placed) blocks to the database manually
    Download OwnBlocks v10.0



    please note - If you are using iConomy, only version 4.6 is currently supported.

    Source Code
    OwnBlocks is released under the WTFPL License.

    Config File Options:
    Please note that at any time you may move/rename/delete you config file, and restart your server to produce the example/default config file with these options pre-filled along with descriptions. Also remember that lines preceded by a '#' are comments, and are ignored.
    exclude - enter comma separated integers of block-ids you wish to exclude from being protected and entered into the database. An example would be to enter the block-id for saplings, so planted trees do not have a single log at the bottom that is protected when a tree is harvested by another player.
    iConomy - enter an integer greater than '0' (zero) to enable. The number entered becomes the 'Basic Rate' at which players are charged to place protected blocks. Players will not be able to place blocks if they have insufficient funds.
    debug - If you are experiencing errors, and want to post them here to resolve them, or just want to spam your server log with information, set debug equal to 'true'
    status-message - Set this to 'disable' to not receive the message "[Username] - OwnBlocks is now activated for you....". Set this to 'simple' to receive a simple "OwnBlocks activated/deactivated" instead. Lastly, set this to 'disable' to disable messages entirely. Now that I think of it, disabling status-messages seems like a really bad idea......but the choice is yours.
    save-interval - Enter the number of seconds specifying the interval between database saves. The default is 60 seconds. Increase this number if you have an obscenely large database that takes a long time to write to disk. Decrease this number if you are paranoid and/or have very fast disk IO.
    info-id - Enter the integer representing the ID of the material or tool you would like to use as your "information tool" which will display the Owner of a block you right click with specified tool. Default is 269, which is the wooden shovel.
    add-id - Enter the integer representing the ID of the material or tool you would like to use as your "add tool" which will add the block you left click with the tool to the database. Default is 268, which is the wooden sword.
    enabled-on-login - True means that OwnBlocks is automatically activated for every player as soon as they log in. False means that OwnBlocks must be activated manually by each player when they want to start building protected blocks.


    Permissions Nodes:
    You will need to add these nodes to your Permissions configurations if your server uses Permissions:
    'OwnBlocks.ignoreOwnership' - Allows player to break blocks placed by others. This node is typically given to admins.
    'OwnBlocks.use' - Allows a player to even use OwnBlocks. If you want everyone to be able to protect blocks with OwnBlocks, and assuming you have a "normal" Permissions configuration, then add this node to your "default" class.
    'OwnBlocks.info' - Allows a player to use the info-tool to display who owns a protected block.
    'OwnBlocks.add' - Allows a player to use the add-tool to add blocks to the database for protection.


    Changelog:
    • Version 10.0 (5-20-2011)
      • Added configuration to set whether OwnBlocks is activated for players upon login
      • Added tool to add pre-built blocks to the protection database
      • Improved process of saving database
      • Fixed status-message configuration options (inconsistent verb tense)
      • Default to protecting all blocks when Permissions is not detected
    • Version 9.0 (5-5-2011)
      • Added support for Servers without the Permissions plugin
      • Added 'OwnBlocks.use' and 'OwnBlocks.info' nodes
    • Version 8.2 (5-4-2011)
      • Fixed NullPointerException when right clicking with empty hand
    • Version 8.1 (5-4-2011)
      • Added ability to use tool to display who a block belongs to. use info-id in your config file
    • Version 7.0 (5-3-2011)
      • Added database auto-saving intervals
      • Added ability to enable/disable 'status message'
    • Version 6.5 (4-29-2011)
      • Added iConomy support for charging a basic rate for each block placed
      • Added config option for debug mode
    • Version 5.0 (4-23-2011)
      • Added Permissions Integration :)
      • I think I fixed a bug that occurred when the 'reload' command is issued
    • Version 4.0 (4-23-2011)
      • Added properties file (/plugins/Ownblocks/OwnBlocks.properties)
      • 'exclude'
      • Blocks are now removed from database when broken by their owners
    • Version 3.0 (4-22-2011)
      • Added the ability to toggle OwnBlocks on and off
      • Added commands: /ownblocks or /ob
    • Version 2.0 (4-21-2011)
      • Moved data directory from main folder to the plugins folder
      • Added/fixed serialization (Persistence)
      • Made database searching more efficient
    • Version 1.0 (4-20-2011)
      • Initial Testing Release
    ToDo: Should there be continued interest in this plugin, I will consider looking into:

    • MySQL support
    • Support for group projects
    • Add configuration option to prevent "adjacent construction", where a player builds blocks on blocks owned by another player
    • Add support for Metadata values
    • Area Selection
    • Update this iConomy shenanigans.
    • Look into solution for chest protection
    • Add command to check the database for blocks that have become air because they were deleted externally by something like WorldEdit
    [​IMG]
     
  2. Offline

    I_ndex

    Awesome!, but the chest shoud be automaticly in the group :)
     
    Random123 likes this.
  3. Offline

    vasil7112

    [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'ob' in plugin OwnBlocks v10.0
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:128)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:287)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:712)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:678)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:671)
    at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:399)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.NullPointerException
    at me.cvenomz.OwnBlocks.OwnBlocks.togglePlayer(OwnBlocks.java:185)
    at me.cvenomz.OwnBlocks.OwnBlocks.onCommand(OwnBlocks.java:205)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    ... 12 more

    Plz Help!!!:)
     
  4. Offline

    killj0y

    I could do the same and yes i have the extact same issue as him. Also my database.db just have one line of funny chars? idk if thats normal? I have old back ups ( did them daily) however i could extract and get out if needed...
     
  5. Offline

    vasil7112

    Have problem with the ownblocks..any other plugin likee that?;)
     
  6. Offline

    hofec

    Ups .. only iCo 4 ? :confused:

    btw. this is amazing plugin, great job cvenomz !

    Can't wait for iConomy 5 [diamond] [diamond]
     
  7. Offline

    dukestar46

    would you be able to make it so the monsters and nothing cant blow up the blocks? Or a option so you can turn it on? thanks heaps
     
  8. Offline

    killj0y

    Thats not what this plugins is for. there is a mod that stops monsters and blast from destroying blocks. Search for "blast control"
     
  9. Offline

    bruceweed

    What is recommended for the database save interval. Something to preferably stop the 60 second lag intervals. it appears when database saves it has a moment of FGS (frozen game syndrome). I set it to 30secs but now the lag is shorter just every 30 secs. would making it a lower save interval say for example 10 secs be better? As the database saves would be more frequent but less size?
     
  10. Offline

    dukestar46

    yeah but i still want monster blasts to do damage to normal blocks just not the ones pretected from this plugin is there anyway to edit it to add that.
    thanks in advance
     
  11. Offline

    bruceweed

    Also, wanted to know is it possible to split the database into say 4 seperate databases (one for each of my worlds)?

    (note: i set save intervals to 10mins and while it helps lag in between saves. during saves its rather hectic. database file is at around 12.5MB)
     
  12. Offline

    RTRD

    @cvenomz When are you going to answer my mail and msgs? :p
     
  13. Offline

    bruceweed

    I wish this had a better method of saving. When it comes to 13mb+ database for this it starts cramping the server during saves. mysql would be great if it would help lol
     
    Emil Døsen likes this.
  14. Offline

    bruceweed

    Actually instead of Mysql I'd love this plugin to use the save method bananaprotect uses. The flatfiles for each chunk. It's VERY well built and works great. Only thing is bananaprotect doesn't have some of the options that ownblocks has. If ownblocks had this method of saving information it would be in my opinion flawless. If this also had a simple command that allowed users to build together it would be absolutely perfect.
     
  15. Offline

    Splaat

    Is it possible to block fire?
     
  16. Offline

    killj0y

    From being placed or what?
     
  17. Offline

    cvenomz

    @RTRD I just got back from my trip

    @bruceweed I was working on MySQL support. Would you like to help me test?

    By the way, I really really like this idea for how to implement group project support. I will be basing the final design off this.

    I also like the </ob allow %playername%> idea too. hmmm...


    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 13, 2016
  18. Is this plugin also working with B935?

    Thx for your help!
     
  19. Offline

    bruceweed

    I would If i didn't have problems already lol, I'm actually working on trying to fix a thing or two with server issues.

    MySQL would make the database save intervals less harsh for bigger databases won't it?

    EDIT: I agree having at least a command to enable partner building would be a great addition to this plugin. Maybe protection to surrounding blocks so that people can't place blocks on top of them. I get people doing that a lot lol.
     
  20. Offline

    cvenomz

    I just recompiled the MySQL version with the latest recommended bukkit, so yes, it should be fine.

    It would actually eliminate the save-interval, because it saves on the fly.

    Here is the MySQL version v0.2. You may or may not need the jdbc driver thing.
    Also, I seriously doubt I will continue developing this plugin if I dont receive feedback on the MySQL version. People seem to want it, but no one wants to try it out...
     
  21. Offline

    bruceweed

    I'm downloading now and going to give it a try :) (crosses fingers)

    Could I talk you into providing a command or something to allow users to build together? That would be the only thing this is missing.

    Also one question. With the database that has already been saved.... what do I do with it or will ownblocks still pick up on that database at all? (the database from the previous version)
    (the reason I ask is my database from 10.0 was 13MB >.<)
    Do I have to convert the sqlite database to a mysql database and put it in manually?
     
  22. Offline

    cvenomz

    Thanks for downloading. Let me know how it works. Talk me into adding group project support? Lol :) If you want to, go right ahead. That is the next big thing that I plan to add (after the conversion tool* see below). I am just waiting until I feel the inspiration to code it.

    And yes, I understand people will already have large databases in flatfiles. I will either add some conversion command, or create a standalone conversion tool to add the flatfile to the MySQL database. I will write this once I am somewhat satisfied that the core OwnBlocksMySQL functions correctly.
     
  23. Offline

    bruceweed

    I want to test this, but I want to be able to put my old database in with it. With all those blocks that are protected in that database, I don't want to lose protection on those blocks and have problems galore with people grieving shit non stop...
     
  24. Offline

    Splaat

    Placed by others on e.g. my blocks..
     
  25. Offline

    killj0y

    I will give this a test on a test server with about 40 or so players on it ill run it for 24 hours and post back results. ( will do this 2mrrow)
     
  26. Offline

    bruceweed

    Well I tried using it this is what I get.

    When I get these errors it SPAMS the hell out of it too.

    Code:
    2011-06-28 19:25:30 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:30 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:30 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:30 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:30 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:30 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:30 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:30 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:30 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-28 19:25:30 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:30 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:30 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:30 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:30 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:30 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:30 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:30 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:30 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:30 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:30 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:30 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-28 19:25:31 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:31 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:31 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:31 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:31 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:31 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:31 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:31 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:31 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-28 19:25:31 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:31 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:31 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:31 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:31 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:31 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:31 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:31 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:31 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:31 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:31 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:31 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-28 19:25:33 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:33 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:33 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:33 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:33 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:33 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:33 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:33 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:33 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-28 19:25:33 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:33 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:33 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:33 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:33 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:33 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:33 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:33 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:33 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:33 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:33 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:33 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-28 19:25:34 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:34 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:34 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:34 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:34 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:34 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:34 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:34 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:34 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-28 19:25:34 [SEVERE] [OwnBlocks] Failed to get block.  Probably SQL error
    2011-06-28 19:25:34 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'KushVille' in 'where clause'
    2011-06-28 19:25:34 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-28 19:25:34 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:34 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-28 19:25:34 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-06-28 19:25:34 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-06-28 19:25:34 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.getBlock(MysqlDatabase.java:90)
    2011-06-28 19:25:34 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlDatabase.addBlock(MysqlDatabase.java:72)
    2011-06-28 19:25:34 [SEVERE]     at me.cvenomz.OwnBlocks.MysqlBlockListener.onBlockPlace(MysqlBlockListener.java:87)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$27.execute(JavaPluginLoader.java:427)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:90)
    2011-06-28 19:25:34 [SEVERE]     at org.bukkit.craftbukkit.event.CraftEventFactory.callBlockPlaceEvent(CraftEventFactory.java:74)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ItemBlock.a(ItemBlock.java:82)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:226)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:563)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.Packet15Place.a(SourceFile:57)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:223)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-06-28 19:25:34 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Hmm seems that this SQL database doesn't have multiworld support is what it looks like.

    That or something else I'm not sure....

    I tried testing with world names as columns but that didn't work either I got syntax error with one of my worlds because it has a space in it. That and protection didn't stick either for some reason. Protection didn't stick with either setup, no matter if it saved into the world column or saved into a different world name column...

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

    cvenomz

    Thanks for testing. And even more, thanks for actually posting a stacktrace. I found the error right away. I forgot to include quotes around the World Name string in the SQL statements. I have updated to v0.2.1, which fixes this problem. I made sure to bring up a test server and test this one myself, and I didn't get any errors.

    That would be awesome. Please make sure to use v0.2.1 though :]
     
  28. Offline

    bruceweed

    Alright plugin is in, and everything is saving and working properly as far as I can tell. :) Great work man!

    Now, the only thing I need is a way to get my old database into the new database >.< that's A L O T of blocks to have to put into a new database a block at a time >.< lol

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

    Random123

    Cvenomz if you need any ideas PM me on this forum, i also know some VERY basic java.
     
  30. Offline

    bruceweed

    Yea been running the newest update you did ven, RUNNING GREAT!!! Haven't had any errors or any problems. Database saves GOOD, and the program takes like no resources either.

    Any idea on the ETA on the tool for the old database conversion into the MySQL databases?
     
  31. Offline

    cvenomz

    Awesome! Ill see what I can do today. Maybe I'll have something for tomorrow
     

Share This Page