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

    Fress_

    Is there a way to only use 'log which player made what changes here' part of this plugin, without the rollback capabilities, so it wouldn't be so CPU demanding?
     
  3. Offline

    UsefulPawn

    Two things. 1. I love your plugin and that you're keeping it alive. 2. LogBlock was working fine yesterday, now I get this
    Code:
    10:05:14 [WARNING] [LogBlock] Exception in commands handler:
    java.lang.IllegalArgumentException: No parameters specified.
            at de.diddiz.LogBlock.QueryParams.parseArgs(QueryParams.java:276)
            at de.diddiz.LogBlock.CommandsHandler.onCommand(CommandsHandler.java:21
    )
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:1
    5)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:
    78)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler
    java:757)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722
    
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
            at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.jav
    :180)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:93)
            at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.jav
    :550)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
            at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:527)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    Can you please help me?
     
  4. I like it. Nice Plugin. I have toomany Griefers and a big Banlist :D I hope you make more Plugins.
    Johann
     
    DiddiZ likes this.
  5. Offline

    RebornSheep


    What feature does that option have?
    Will LogBlocks functions be the same if i disable?
     
  6. Offline

    paulj1x

    Many thanks for saving our servers from griefers!
    LogBlock doesn't seem to track paintings. We have paintings being made and getting stolen, however if I do /lb block 321 or /lb type 321 it says "Painting changes in world: No changes found."
     
  7. Offline

    DiddiZ

    Rollback doesn't use any cpu when you don't use it :D
    Try delay 4 and time 400
    Update to dev #84+
    Yeah, that's just the online time, last and first login.
    Paintings are entities for some reason, and so don't fit in current db schema.
     
  8. Offline

    Mrchasez

    My logblock data just over loads.
    Does this mean i have a slow MYSQL?
    It takes like 40 mins for info to come up, and every 40 mins or so its already back at

    [LogBlock Consumer] Queue overloaded. Size: 12226

     
  9. Offline

    Epics

    1.50 stable yet?
     
  10. Offline

    DiddiZ

    /lb savequeue

    One last thing:
    delay 1 and force 1000
    That's the highest settings possible, if it still doesn't work, you really need a faster MySQL server :D
    Yup, but on some systems (mcmyadmin or similar) dev #84 seems to be required to use commands
     
  11. Offline

    Chromana

    I'm in the same position as you were. What setting did you find which meant it wasn't logging? I've been through every file so many times but can't find the problem.
    @DiddiZ , do you know?
    My config.yml (I removed mysql info): http://pastebin.com/KuX9beWy
    world.yml: http://pastebin.com/Z5Ek5LKL

    Also, an error. I wrote "/lb tp chromana" instead of "/lb tp player chromana" and it crashed the server.
    Code:
    2011-12-30 18:10:51 [WARNING] [LogBlock] Exception in commands handler:
    java.lang.NumberFormatException: For input string: "chromana"
        at java.lang.NumberFormatException.forInputString(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at de.diddiz.LogBlock.CommandsHandler.onCommand(CommandsHandler.java:265)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:165)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:378)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
        at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:180)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:93)
        at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:550)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
        at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:527)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
     
  12. Offline

    Sidnoea

    LogBlock just saved a town on my server from two griefers. I knew it would come in handy! Thanks a whole bunch!
     
    DiddiZ likes this.
  13. Offline

    mario00037

    Where is the [1.0.0-R1] download?
     
  14. Offline

    DiddiZ

    The first link in op?
    Update to dev #84+
    Both block break and place logging are disabled:
    Code:
      BLOCKPLACE: false
      BLOCKBREAK: false
    Enable these :D
     
  15. Offline

    Mrchasez

    What is this error from?
    Code:
    [LogBlock Consumer] Queue overloaded. Size: 1177
    14:52:14 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1325364692), lastlogin)) WHERE playerid = 27405;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'onlinetime' cannot be null
    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:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:274)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Thread.java:662)
     
  16. Offline

    iSeven77

    Any ideas why this error ?

    07:31 PM [SEVERE] Could not pass event PLAYER_JOIN to BukkitContrib
    07:31 PM [SEVERE] Player: myMC_user was not properly updated during login!
    07:31 PM [SEVERE] Could not pass event PLAYER_COMMAND_PREPROCESS to BukkitContrib

    edit : nvm i found the problem :p u have to install http://goo.gl/wxBFn spout 644 instead of BukkitContrib :S lol ma bad, its working good now :)
     
  17. Offline

    jaboy

    under the main config -> questioner -> banPermission
    whats that and what does it do ?!
     
  18. Offline

    Zooey105

    I'm getting a [LogBlock] Error while loading: CREATE command denied, but my MySql database is hosted by GoDaddy (yeah, I know.) Is there a way to grant permission to external sources?

    (where do I enter CREATE DATABASE xx; GRANT ALL ON xxt TO 'zooey'@'xx';) ?
     
  19. Offline

    kamild1996

    I have a problem. When someone quits the server, LogBlock leaves in console this:
    How to fix it?
     
  20. Offline

    raddad

    OMG
    I have used LogBlock on a few servers and installs have been painless. I love it. The big 3 merge result will certainly be full of awesome sauce.
    BUT...
    WTF? I can not get LB to log any data.
    Craftbukkit version git-Bukkit-1.0.1-R1-b1597jnks (MC: 1.0.1) (Implementing API version 1.0.1-R1)
    ...
    2012-01-01 19:46:09 [INFO] [LogBlock] Version check: Your version is up to date
    2012-01-01 19:46:09 [INFO] [LogBlock] Connecting to root@jdbc:mysql://127.0.0.1:3306/mcdb...
    2012-01-01 19:46:10 [INFO] [LogBlock] Creating table lb-world_nether.
    2012-01-01 19:46:10 [INFO] [LogBlock] Creating table lb-world_nether-sign.
    2012-01-01 19:46:10 [INFO] [LogBlock] Creating table lb-world_nether-chest.
    2012-01-01 19:46:10 [INFO] [LogBlock] Creating table lb-world.
    2012-01-01 19:46:10 [INFO] [LogBlock] Creating table lb-world-sign.
    2012-01-01 19:46:10 [INFO] [LogBlock] Creating table lb-world-chest.
    ...
    2012-01-01 19:46:15 [INFO] [LogBlock] Permissions plugin found.
    2012-01-01 19:46:15 [INFO] [LogBlock] Scheduled consumer with bukkit scheduler.
    2012-01-01 19:46:15 [INFO] LogBlock v1.50 by DiddiZ enabled.


    Looks good, right?

    2012-01-01 20:15:13 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1325448908), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1325448908), firstlogin), ip = '/208.107.116.53:59433' WHERE playerid = 2;:

    and it doesn't log block changes.

    Where have I gone wrong?
     
  21. Offline

    DiddiZ

    Just disable logging.logPlayerInfo in main config.
    That's the permission that is checked if you use /ban <name> to verify if you are allowed to ban and then ask you for rollback (if askRollbackAfterBan is enabled).
    Into your MySQL console, but on a hosted server you likely don't have one.
    You may ask your hoster why your user doesn't have create table rights.

    Likely no logging option enabled in world config.
     
    kamild1996 and jaboy like this.
  22. Offline

    raddad

    (feeling very stupid just now) Mystery solved, thank you very much for the solution and the very prompt response.
     
    DiddiZ likes this.
  23. Offline

    Staticjelly

    Is there a guide to install this on a mac? Please reply.:D
     
  24. Offline

    raoulster

  25. Offline

    darkmage0252

    my server is spamming this in the console

    org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    02.01 06:51:00 [Server] INFO at de.diddiz.LogBlock.Consumer.run(Consumer.java:274)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    02.01 06:51:00 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    02.01 06:51:00 [Server] INFO com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    02.01 06:51:00 [Server] SEVERE [LogBlock Consumer] SQL exception on INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1325483447), 12, 11, 49, 0, '32780', 12, '13855');:
    02.01 06:50:54 [Server] INFO at java.lang.Thread.run(Thread.java:722)
    02.01 06:50:54 [Server] INFO at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    02.01 06:50:54 [Server] INFO at de.diddiz.LogBlock.Consumer.run(Consumer.java:274)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    02.01 06:50:54 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    02.01 06:50:54 [Server] INFO com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    02.01 06:50:54 [Server] SEVERE [LogBlock Consumer] SQL exception on INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1325483447), 12, 11, 49, 0, '32778', 12, '13855');:
    02.01 06:50:48 [Server] INFO at java.lang.Thread.run(Thread.java:722)
    02.01 06:50:48 [Server] INFO at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    02.01 06:50:48 [Server] INFO at de.diddiz.LogBlock.Consumer.run(Consumer.java:274)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    02.01 06:50:48 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    02.01 06:50:48 [Server] INFO com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    02.01 06:50:48 [Server] SEVERE [LogBlock Consumer] SQL exception on INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1325483447), 12, 11, 49, 0, '32779', 12, '13855');:
     
  26. Offline

    Cruxsky

    Will this ever be fixed with rolling back trees? [​IMG]
     
  27. Offline

    DiddiZ

    https://github.com/DiddiZ/LogBlock/wiki/FAQ
    Enable leaves decay logging
     
  28. Offline

    pjrueda

    Is there any way that, when you get info the earlier changes appear al the bottom lines in chat and not the first ones? Because when there are a lot you can't read the recent ones
     
  29. Offline

    DiddiZ

    The recent ones are always on top, the olders get cut off when there are many.
    Anyways you can change the order by using "desc" parameter, so you get the newest at bottom, but then new newest are cut off, resp moved to the last page.
     
  30. i use Xray-Informer plugin and it needs this.
    Why i get these?
    Code:
    2012-01-02 18:53:59 [INFO] [LogBlock] Version check: Your version is up to date
    2012-01-02 18:53:59 [INFO] [LogBlock] Connecting to username@jdbc:mysql://localhost:3306/minecraft...
    2012-01-02 18:54:01 [SEVERE] [LogBlock] Error while fetching connection:
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.java:72)
    at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:258)
    at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:77)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:154)
    at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:434)
    at org.bukkit.Bukkit.reload(Bukkit.java:187)
    at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:165)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:378)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:374)
    at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:564)
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:541)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(Unknown Source)
    at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at java.net.Socket.<init>(Unknown Source)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    ... 28 more
    2012-01-02 18:54:01 [SEVERE] java.lang.reflect.InvocationTargetException
    2012-01-02 18:54:01 [SEVERE] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2012-01-02 18:54:01 [SEVERE] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    2012-01-02 18:54:01 [SEVERE] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    2012-01-02 18:54:01 [SEVERE] at java.lang.reflect.Method.invoke(Unknown Source)
    2012-01-02 18:54:01 [SEVERE] at org.getspout.spout.packet.CustomPacket.addClassMapping(CustomPacket.java:146)
    2012-01-02 18:54:01 [SEVERE] at org.getspout.spout.Spout.onEnable(Spout.java:248)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:968)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:186)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:169)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:435)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.Bukkit.reload(Bukkit.java:187)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:165)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:378)
    2012-01-02 18:54:01 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:374)
    2012-01-02 18:54:01 [SEVERE] at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:564)
    2012-01-02 18:54:01 [SEVERE] at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:541)
    2012-01-02 18:54:01 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
    2012-01-02 18:54:01 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    2012-01-02 18:54:01 [SEVERE] Caused by: java.lang.IllegalArgumentException: Duplicate packet id:195
    2012-01-02 18:54:01 [SEVERE] at net.minecraft.server.Packet.a(Packet.java:25)
    2012-01-02 18:54:01 [SEVERE] ... 21 more
    
    
    
    and when i type
    /xcheck semirotta
    LogBlock says world semicraft is not listed and it is listed
    My logged worlds:
    loggedWorlds:
    - world
    - world_nether
    - Semicraft
    - semicraft
    - semicraft_the_end
    - semicraft_nether

    Also when i type /xcheck semirotta 56

    it will show me how many diamonds ive found and gives same times THIS in console:

    Code:
    [SEVERE] [LogBlock] MySQL connection lost
    2012-01-02 19:02:48 [SEVERE] java.sql.SQLException: No connection
    2012-01-02 19:02:48 [SEVERE] at de.diddiz.LogBlock.LogBlock.getBlockChanges(LogBlock.java:282)
    2012-01-02 19:02:48 [SEVERE] at me.sourcemaker.XrayInformer.XrayInformer.checksingle_lb(XrayInformer.java:192)
    2012-01-02 19:02:48 [SEVERE] at me.sourcemaker.XrayInformer.XrayInformer.onCommand(XrayInformer.java:284)
    2012-01-02 19:02:48 [SEVERE] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
    2012-01-02 19:02:48 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:165)
    2012-01-02 19:02:48 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:378)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
    2012-01-02 19:02:48 [SEVERE] at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:180)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:93)
    2012-01-02 19:02:48 [SEVERE] at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:550)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:527)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
    2012-01-02 19:02:48 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    2012-01-02 19:02:48 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2012-01-02 19:02:56 [SEVERE] [LogBlock] MySQL connection lost
    
     
  31. Offline

    godgodgodgo

    I'm getting this error: http://pastebin.com/bDUDzbcP

    Latest version of MCBans
    Latest version of LogBlock
    Latest Recommended Build CraftBukkit


    It shows this when I ban someone.

    When I try to rollback a player it all works and tells me to do /yes

    I do /yes and the server says it's an unknown command.
     

Share This Page