Inactive [INFO/ADMIN] LogBlock v1.54 - Enderdragon Logging! Tree Grow Logging! [1.4.5]

Discussion in 'Inactive/Unsupported Plugins' started by DiddiZ, Feb 15, 2011.

  1. Offline

    DiddiZ

    Version: 1.50​
    [​IMG]
    [​IMG]
    Find and Backroll those Damn Griefers
    LogBlock release are on DevBukkit:
    http://dev.bukkit.org/server-mods/logblock/

    LogBlock dev builds:
    http://ci.kitteh.org/job/LogBlock/

    Please read the installation guide

    I won't port LogBlock myself to mcAPI. Source code is available, so it shouldn't be to difficult for someone else to do it, also I'm still here. so I can answer questions. If there is more than one willing, that's up to you to handle that.




    The reasons I take this step, are the usual: I quit playing Minecraft about 5 months ago and lastly I was struggling to keep up with updates. The developement of Guardian made slow progress, so I fear it won't be ready to fully replace LB in time.


    Download latest dev build: Jenkins
    View the source code: GitHub
    Table of contents:
    1. Description
    2. Features
    3. Why to use LogBlock
    4. Example command
    5. Older versions
    6. Change log
    7. Todo list / feature requests
    8. Permission nodes
    9. Plugins supporting this
    10. Support the dev
    11. How to post error messages
    12. Advertizing
    Description:

    LogBlock logs block changes into a MySQL database. Block changes can be placed or destroyed block, explosions, burned blocks, sign text changes, chest access, leaves decay etc.
    It can be used as griefer identification tool, to find out who build a particular building, or even roll back changes by certain players. Other purposes can be e.g: Undoing of forest fires
    All additional features are optional, to keep the database as short as possible. All database actions run in their own threads to avoid server lags.
    The use of permissions plugin (or any clone) is possible, but not necessary.
    Uses Spout for chest logging (but it's fully optional, and there is no need for the client mod at all).

    Features:
    • Logging for block placing, block braking, fire, explosions, leaves decay, signtexts, lava flow and chest content
    • Very mighty commands system, not only allowing to rollback and redo, but also to tp to blockchanges, delete log ingame etc. Full list of commands.
    • Many parameters for lookup/rollback/redo/tp/clearlog commands: Block changes of one ore more player, in a specific area, in a world edit selection, specific block types only, block changes older or newer that a specific date, destroyed/created block only, in a different world and combinations of all these parameters. Full list of parameters.
    • Rebuilding map after importing a backup (/lb redo)
    • Last parameter to use the parameters of the last command
    • Quick ingame lookup of block history a wood pickaxe or a bedrock block.
    • All commands accessible from console (exept tools :D)
    • Custom queries for tools.
    • Different tool modes (lookup, rollback, redo, writelogfile and clearlog)
    • Saves block data like wool color, log type, torch adjustment, etc
    • Multiworld and multiserver support (some servers sharing the same database)
    • BigBrother log import
    • Loggable super pickaxe plugin (not to confuse with WorldEdit's super pickaxe)
    • API
    • Webstats
    Why to use LogBlock:

    Example commands: (thanks to tha d0ctor, read more about commands here)

    /lb rollback player fire since 1d3h – rolls back fire 1 day 3 hours
    /lb rollback player fire since 1d3h area 15 – rolls back fire 1 day 3 hours within a radius of 15 blocks

    /lb rollback player thad0ctor since 1h - rolls back thad0ctor 1 hour
    /lb rollback player thad0ctor since 1d area 5 – rolls back thad0ctor actions for the last day within 5 blocks
    /lb rollback area 10 since 1h30m - rolls back all modifications within 10 blocks since the list 1 hours and 30 mins
    /lb rollback area 10 before 06.11.2011 - roll back all changes in an area of 1o before June 11th, 2011
    /lb rollback player thad0ctor since 05:36:00 - roll back all changes of thad0ctor since 05:36 (server time)


    Download, Command, Configuration and Details:
    [​IMG]http://diddiz.insane-architects.net/logblock.php

    Changelog:
    -> Full changelog
    • LogBlock v1.50 # 81 (Dez. 13, 2011)
      Works with CraftBukkit 1.0.1-R1
      • Feature: /lb me shows the total block count
      • Feature: Chest logging without spout
      • Feature: Enderdragon logging
      • Feature: Logging for tree and mushroom grow (thanks to MD5 for the api)
      • Fix: Area param works again with default radius
      • Fix: Rollbacks got slowed down a bit to avoid rare server crashes
      • Fix: If mysql username, password or database only consist of unquoted numbers, LB will read them now
      • Config: World configs changed totally, some names changed and all logging options are now in an own section
    • LogBlock v1.41 #63 (Nov. 15, 2011)
      Works with CraftBukkit recommended build #1337
      • Fix: Players with spawnTools permission are no longer allowed to spawn all tools.
      • Fix: Added a check to avoid "The permission xy is already defined!" errors
    • LogBlock v1.40 #60 (Nov. 09, 2011)
      Works with CraftBukkit recommended build #1337
      • Feature: Custom auto ClearLog
      • Feature: Reduced error spam. Instead of like 40 line of error code, there is now just a warning stating the MySQL con
      • Feature: The queue will now be dumped after 10 tries even when the MySQL server is connected
      • Feature: Custom material names, allows naming custom blocks
      • Feature: LogBlock will now respond to messages when started without MySQL connection
      • Fix: Log import runs now async
      • Fix: Log import errors won't crash the server
      • Fix: Console commands work again
      • Fix: You can now use upper case letter in tool names (I don't know why you even should, but ...)
      • Config: Added clearlog.auto, clearlog.enableAutoClearlog in main config. Added materials.yml. Removed clearlog.keepLogDays
      • Permissions: Added 'logblock.spawnTools'
    • LogBlock v1.32 (Oct. 04, 2011)
      Works with CraftBukkit recommended build #1240
      • Feature: Player info logging: firstLogin, lastLogin, onlinetime, ip. No ingame lookup yet.
      • Feature: /lb queuesize to see the current queue size
      • Fix: Door logging logs now also fence gates
      • Fix: Bukkit api break in CB #1191
      • Fix: time restriction works now as intended. Thanks to xrobau
      • Fix: Players with insufficient permissions can't smuggle bedrock from one world to another
      • Config: Added logPlayerInfo
    • LogBlock v1.30 (Sep. 22, 2011)
      Works with CraftBukkit recommended build #1185
      • Feature: Chat lookup /lb chat player diddiz search +admin +sucks +dicks (more info)
      • Feature: Door logging
      • Feature: Dynamic tools, define your own tools
      • Feature: Use since and before to define a timespan
      • Feature: Enderman logging
      • Feature: cake logging (who ate it)
      • Config: Added logEndermen, logCakes and logDoors to world config and moved the tool section in main config.
      • Permissions: logblock.tool changed to logblock.tools.tool and
        logblock.toolblock to logblock.tools.toolblock.
    Todo List:

    https://github.com/LogBlock/LogBlock/issues

    Permission Nodes:
    https://github.com/LogBlock/LogBlock/wiki/Permissions

    Plugins supporting Logblock:
    List (open)

    When you want to appear your plugin here, tell me about



    Support the developer (that's me :D):
    If you want to support me writing plugins or want to thank me for the plugin/support, you can: Suggest features I missed, report bugs (best with fix :D), donate via PayPal, flattr my plugins, gift me The Witcher 2 (thanks to newyoukdaily), 2x 1GB DDR1 modules (thanks to HonestFlames), or send me the inner life of a laptop or netbook with a broken display (need it to build a model aircraft, so there is no need for parts like display and keyboard).

    [​IMG]


    How to post error messages:


    I won't aswer questions to general MySQL setup/installation/what is MySQL (there are lots of good tutorials out there, use google)
    Please read the installation guide before asking a question about installation problems.
    Please read the FAQ before posting a error report. It may be solved there.
    In case of rollback or lookup problems: Type /lb savequeue and try again (when it's fixed then, it was a consumer problem, see FAQ)
    When you post error messages, it's important to paste the whole stack trace!

    Advertizing:
    Newyorkdailys Plugin Support Buisness (open)
    Still can't get LogBlock working, or any other plugin? Are you getting errors in your console and cant figure out why? Newyorkdaily offers Basic/Advanced Plugin support.
    • General/Advanced troubleshooting: FREE!
    • Plugin Installations: 1-2 Plugins - FREE!
    • 3 or More Plugins - $2
    Click on the link below to connect to him now!
    http://wbe001.mibbit.com/?settings=7cb4fd3cdd72754df475fb92a0b65f6c&server=irc.Mibbit.Net&channel=#CBPluginSupport


    There is a LogBlock irc channel: #logblock at irc.esper.net.
    You can ask me on skype. My name is 'hawky.diddiz'.
     
  2. Offline

    CapturedHD

    When I download the links and extract it doesnt give me the jar. how can i get the jar file?
     
  3. Offline

    Retricide

    Oh Sorry, I didn't see the permission nodes in the diddiz link, so it lead me to misinterpret the first post.
     
  4. Offline

    DiddiZ

    Don't use IE or rename the .zip to .jar
    --- merged: Feb 18, 2011 12:18 AM ---
    It's unter "Configuration"
     
  5. Offline

    CapturedHD

    thanks. I used google chome and it worked
     
  6. Offline

    tygreen19

    mine is getting a no suitable driver found. i believe i have the sql set up properly. can someone copy their setup config file for me to see? im using wamp BTW

    EDIT:

    nevermind! just changed the server /db on the original config to the database.
    then had to restart the server. not just reload it.

    AMAZING plugin =D
     
  7. Offline

    Kane

    Still a scared child to try this haha. I guess I better or I will never move to 1.2.
     
  8. Offline

    DiddiZ

    Just try, can't be that bad [​IMG]
     
  9. Offline

    Lee Hayward

    This isn't working for me.. I've set up a mysql database on a seperate server, added the ip address of my minecraft server to the allowed hosts names. Copied files accross as per your instructions and set up the config file etc.. The plugin starts up fine and when I type /lb it talks to me, but doesn't give me any block edited information. Also the database is empty, so appears not to be getting populated. Any way I can check whether your plugin is actually talking to my server, or a way to figure this out at all :)
     
  10. Offline

    DiddiZ

    Huh, that is new to me. Do you have error mesages in you server log?
     
  11. Offline

    Lee Hayward

    No.. I'm stumped!
     
  12. Offline

    thunderz

    same thing is happening to me it is not logging any block information.
     
  13. Offline

    Lee Hayward

    I also noticed that when this plugin is enabled it breaks Redstone circuit plugin, WoolColor plugin and my Light Vote plugin etc.. So I'm going back to BB for now...
     
  14. Offline

    DiddiZ

    I'll check this, but atm I can't confirm any plugin break caused by LB
     
  15. Offline

    Kane

    I can't see this really causing any breaks it's pretty passive no?
     
  16. Offline

    DiddiZ

    What craftbukkit version you are using? The block break hook was implemented only a few build before 326.
    --- merged: Feb 18, 2011 5:10 PM ---
    Me too
     
  17. Offline

    Kane

    @DiddiZ so I tested this using remote sql for fun to see what happens on a pretend load bad load I guess.. I clicked 4 blocks in a circle holding down right click on the woodenpick for about 10 seconds. The server totally spammed
    2011-02-18 12:32:20 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?

    But also caused my 2nd client connected to lag hardcore including the first. I was wondering if there is a way to prevent it from using all the resources of the main thread I guess its called not sure.
     
  18. Offline

    Lee Hayward

    I'm using BigBrother with the same MySQL database and it's working fine. The BBstats script is pretty fun to play with as well. I'm going to stick with BB for now as I don't have time to wait for things to work. I'm using the latest version of everything.. I'll keep an eye on your plugin development, hope it gets fixed soon :)
     
  19. Offline

    DiddiZ

    Tested this in my server, holding down right mouse button on various blocks for some minutes, but didn't get any cant keep up or a significant cpu or memory peak.
    Don't know how you managed it, but I know there are many funny (resp, annoying) side effects from other plugins, like the turning track from minecart mania. What plugins are you running?

    I heard that there are some problems running both plugins parallel. I'll check this when I get BB to run.
     
  20. Offline

    Lee Hayward

    No, sorry, I mean that I simply stopped using your plugin then moved over to BigBrother and used the same database connection. On another note, the unofficial update of BB now Rollbacks for me in Bukkit.. I love it.. Even writing my own custom stats page.. The unofficial BB update is here : https://github.com/downloads/OniTux/BigBrother/BigBrother.jar
     
  21. Offline

    DiddiZ

    Which plugin you use is up to you, I only try to figure out what goes wrong.
    --- merged: Feb 18, 2011 11:44 PM ---
    (The following lines aren't directed to someone scecial)
    I'll be glad to help, to bring my plugin to work, if it doesn't. But therefore I need some info. Saying its broke doesn't help at all. At least craftbukkut version, serverlog and other running plugins.
     
  22. Offline

    Lee Hayward

    I actually said in a previous post that i'm going to keep an eye on your plugin, when it's working properly I'll start using it again. Simply snapping at me for using something else, that works, isn't the best to keep my interest. I didn't just say it was broke, I actually told you exactly what the issue was and the other plugins it was effecting, I also mentioned that I'm using the latest version of Bukkit etc..
     
  23. Offline

    Anoniempje

    Is there a bigbrother to logblock converter?
     
  24. Offline

    DurtyFree

    Yes a importerer were very awesome :D
     
  25. Offline

    anon

    If I use /bb area or anythink it works great, but if I use a bedrockblock or woodpickaxe to get the modifications on the block I get this erros:

    Code:
    2011-02-18 22:05:43 [INFO] [PLAYER_COMMAND] anon: /i 7
    2011-02-18 22:05:45 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:05:47 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:05:49 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:05:50 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    SitePlayerlist - Playerlist sent!
    2011-02-18 22:05:55 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:06:03 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:06:06 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:06:07 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:06:09 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockPlace(LogBlock.java:460)
            at org.bukkit.plugin.java.JavaPluginLoader$21.execute(JavaPluginLoader.java:226)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.ItemBlock.a(ItemBlock.java:104)
            at net.minecraft.server.ItemStack.a(ItemStack.java:56)
            at net.minecraft.server.ItemInWorldManager.a(ItemInWorldManager.java:141)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:498)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    Unknown command: /i
    2011-02-18 22:07:15 [INFO] [PLAYER_COMMAND] anon: /i 270
    2011-02-18 22:07:17 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockRightClick(LogBlock.java:452)
            at org.bukkit.plugin.java.JavaPluginLoader$20.execute(JavaPluginLoader.java:221)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:496)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    2011-02-18 22:07:20 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'root'@'localhost' for column 'id' in table 'blocks'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
            at de.diddiz.LogBlock.LogBlock.showBlockHistory(LogBlock.java:242)
            at de.diddiz.LogBlock.LogBlock.access$7(LogBlock.java:225)
            at de.diddiz.LogBlock.LogBlock$LBLBlockListener.onBlockRightClick(LogBlock.java:452)
            at org.bukkit.plugin.java.JavaPluginLoader$20.execute(JavaPluginLoader.java:221)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:60)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:214)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:496)
            at net.minecraft.server.Packet15Place.a(SourceFile:57)
            at net.minecraft.server.NetworkManager.a(SourceFile:232)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:104)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:317)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:232)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:512)
    
     
  26. Offline

    DiddiZ

    I'm sorry, I was a bit upset.

    Hm, I will do that (shouldn't be more than a few lines SQL code)

    For now, I'm working on multiworld support (and even multi servers with the same db), therefore I'll change the table names. The bb -> lb converter will be ready then.
     
  27. Offline

    Anoniempje

    Seems to me that the server does not have access to your mysql database.
    Check the sqlsettings.
    passwords, ip/localhost, port username, database, tables those things
     
  28. Offline

    anon

    I solved this. Have no idea of what it was thou. I had v0.2, then downloaded v0.3 and this hapaned. So I redownloaded the mysql conector thing and deleted the database and recriated it. Now it works :3
     
  29. Offline

    parsons

    One suggestion would be to be able to see who has opened chests previously, like BigBrother did. That has helped us many a time with 'Damn Griefers.' I prefer the old school hMod LogBlock than BigBrother and would like to keep using it :D
     
  30. Offline

    DiddiZ

    Yup, I lost today a half stack of cacti, because LWC unlocked my chests somehow. I really wanted to find and burn this guy. I'll add this to the todo list. Multiworld support is nearly ready.
     
  31. Offline

    aflyingturtle

    I run a small eight slot server, and I really would appreciate SQLite support because I think that setting up MySQL would take more RAM than it saves in an 8 person server. Correct me if I'm wrong.
     

Share This Page