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

    guard5002

    Odd enough, as soon as the problem started, it's gone. I didn't change anything that I know of.

    Figured i'd tell you

    But I am getting this error occasionally, but only when 1 or 2 people are on my server.

    [SEVERE] [LogBlock] MySQL connection lost

    [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.GeneratedConstructorAccessor104.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    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.GeneratedConstructorAccessor107.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    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(DriverManager.java:620)
    at java.sql.DriverManager.getConnection(DriverManager.java:200)
    at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.java:73)
    at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:253)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:269)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Thread.java:636)
    Caused by: java.net.ConnectException: Connection timed out
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
    at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)
    at java.net.Socket.connect(Socket.java:546)
    at java.net.Socket.connect(Socket.java:495)
    at java.net.Socket.<init>(Socket.java:392)
    at java.net.Socket.<init>(Socket.java:235)
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)



    While it says severe, nothing bad has happened, and it only happens when there's a few people on my server. I'm assuming its causes by logblock and my remote SQL server not communicating due to inactivity?

    again, it isn't affecting anything that I know of.

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

    Staticjelly

    Anyone knows how to make this work on a MAC? anyone? PLease skype me hajelaedwin if that doesnt work put [email protected]. Thank you! I already have a Database if just setting it up that I am having problems with!
     
  4. Offline

    Matt_Lumixia

    Thanks I updated to 1.5 but people can still access logblock commands without the permission D:​
    Some permissions plugins inherit the superpermissions, change defaultPermission from true to op for both tools.

    Thank for your reply but now it doesnt seem to be logging anything + I want it to be able to be used by some non-ops via permissions
     
  5. Offline

    Raycrash

    Is it enough to drop the jar in the plugins folder or do I have to do more ?
     
  6. Offline

    Mikkula1

    Looks like your MySql user doesn't have SELECT permission
     
  7. Offline

    DiddiZ

    Then give them the tool permissions:
    logblock.tools.tool
    logblock.tools.toolblock
    logblock.spawnTools

    check/relete world config file
    Yes, autoupdater will do the rest.
     
  8. Offline

    Matt_Lumixia

    Thanks for the quick reply, logblock is working like a charm now!
     
  9. Offline

    discoverdan

    Thanks! What will disabling logging.playerInfo do? Thanks.

    Also is there a way I can filter the results of a /lb search? Like to search for everything EXCEPT waterflow?

    Is there a way to search for both player "discoverdan" and "fire" to say, find the person who started a fire easily?

    I also can't seem to access the permission nodes page on the wiki."You do not have permission to update this wiki."
     
  10. Offline

    Sshadow

    I see this pop up from time to time. Is it anything to be concerned with?

    Code:
    [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1327170924), lastlogin)) WHERE playerid = 12482;:
    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:57)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
            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:295)
            at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
            at java.lang.Thread.run(Thread.java:722)
     
  11. Offline

    Strahan

    Grrr.. stupid forum, every time I hit "Search this thread" it searches the entire forum instead so sorry if this was already covered.

    After my box BSOD'd, I rebooted and restored my map from backup. Running MC, I see my log filling with:

    2012-01-21 14:30:02 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-chat` (date, playerid, message) VALUES
    (FROM_UNIXTIME(1327174200), 590, '/say Saving world data. Expect lag for a short while.');:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '68205' for key 'PRIMARY'

    Is there a command to tell LogBlock to wipe it's cache of SQL stuff to be committed? I fixed it by just emptying the lb-chat table so there'd be no index conflicts, but I'd really prefer a better method.
     
  12. Offline

    SuperPyroManiac

    Very random failure on Logblock, it was fine for weeks no plugin changed, I have not changed a single file, now its saying it cant connect to me database, here is the error.
    Code:
    2012-01-21 13:30:28 [INFO] [LogBlock] Version check: Your version is up to date
    2012-01-21 13:30:28 [INFO] [LogBlock] Connecting to [email protected]:mysql://localhost:3306/SuperPyroManiac...
    2012-01-21 13:30:29 [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:73)
    at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:253)
    at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:72)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:158)
    at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:131)
    at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:52)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:407)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
    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)
    ... 23 more
     
  13. Offline

    DiddiZ

    /lb player !waterflow
    /lb player discoverdan fire
    /lb area 30 created block fire
    https://github.com/DiddiZ/LogBlock/wiki/Permissions
    No, just online time logging.
    Disable logging.playerInfo.
    MySQL query:
    REPAIR TABLE `lb-chat`;
    Popbably MySQL server down, try to restart it.
     
  14. Offline

    Sshadow

    Thanks :)
     
  15. Offline

    SuperPyroManiac

    [quote="
    Popbably MySQL server down, try to restart it.[/quote]

    Yep fixed it thanks
     
  16. Offline

    Crayder

    If I rollback chestaccess changes, will the items be removed from the player?
     
  17. Offline

    ledut

    can you plz update this to work with minecraft 1.1!!!!! plz i need it!!!!!!
     
  18. Offline

    BeeT

    2012-01-22 12:45:46 [INFO] [LogBlock Consumer] Queue overloaded. Size: 45249

    After that logblock doesn't log...
     
  19. Offline

    DiddiZ

    Not yet.
    Calm down, it works.
    /lb savequeue

    You might have to adjust some consumer settings, try forceToProcess 1000.
     
  20. Offline

    BeeT

    My server had many freezes I deleted logblock...
     
  21. Offline

    monir

  22. Offline

    DiddiZ

    The jars are corrupted, redownload will solve this, likely due to file upload in non binary mode.
     
    monir likes this.
  23. Offline

    tassox33

  24. Offline

    domingo15

    when updating do i have to switch the version from 1.42 to 1.50?
     
  25. Offline

    Strahan

    Thanks!
     
  26. Offline

    DiddiZ

    Nah, that's for the auto updater, just replace the jar.
     
  27. Offline

    iNubb

    Every time I try and have LB start logging, it doesn't work. It shows up in the /plugins list as green, but I use the tool (270; wooden pickaxe) and right/left click and nothing happens. I type /lb and it says this: "No database connected. Please check your MySQL user/pw and database for typos. Start/restart your MySQL server."

    This is what I have under "mysql" in the config for LogBlock:
    mysql:
    user: minecraft
    password: server
    host: localhost
    database: minecraft
    port: 25565

    The I.P I use to connect is 71.99.136.55, and the port that is open is 25565. So if someone could change this just to how it should look for my specific server... I can't think of a reward, but it would be GREATLY appreciated. Thanks.
     
  28. I think my table for the world log is corrupt. When I try to /lb area after i break a block it doesnt show a thing.. But when I use the bedrock it keeps telling me that waterflow destoyed whatever.

    Is there a way I can fix this?

    logblock works with all my other worlds but not the main world.
     
  29. Offline

    killerciao

    ad.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:57 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403408), 8, 10, 49, 0, '999820', 10, '999773');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:52 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403408), 8, 10, 49, 0, '999821', 10, '999773');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:47 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403408), 8, 10, 49, 0, '999822', 10, '999772');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:42 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403408), 8, 10, 49, 0, '999820', 10, '999772');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:37 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403408), 8, 10, 49, 0, '999821', 10, '999772');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:32 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 39, 8, 11, '999945', 13, '999800');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:27 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 10, 49, 0, '999870', 10, '999801');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:22 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 10, 49, 0, '999871', 10, '999801');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:17 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 10, 49, 0, '999851', 10, '999795');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:12 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 10, 49, 0, '999852', 10, '999795');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:07 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 10, 49, 0, '999851', 10, '999794');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:27:02 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 10, 49, 0, '999852', 10, '999794');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
    2012-01-24 11:26:57 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-demigods` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1327403407), 8, 10, 49, 0, '999853', 10, '999793');:
    at java.util.TimerThread.run(Timer.java:484)
    at java.util.TimerThread.mainLoop(Timer.java:534)
    at de.diddiz.LogBlock.Consumer.run(Consumer.java:295)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)




    This is the error given in console by logblock after some hour of running!
    What I can do?
     
  30. Offline

    Odai

    Hey DiddiZ, wollte mal fragen ob du (oder Ihr mit Guardian) sowas wie oreRespawn einarbeiten könntet. Das man Erze Konfigurieren kann und die automatisch wieder nach einer Einstellbaren Zeit wieder regeneriert werden.
    Oder das man dies auf Einzelne auf selbst festgelegte Blöcke anwenden kann.

    MfG Odai
     
  31. Offline

    DiddiZ

    /lb savequeue (to make sure all block changes in queue are written to the database)

    To repair a table use following MySQL query:
    REPAIR TABLE `lb-world`; (or whatever your table is called)
    Guardian? Nein, aber ich plane mein altes AnyReg auf LB / Guardian Basis wieder lauffähig zu machen.
    Do you actually have a MySQL server on localhost?
    You need to modify x and z columns:

    https://github.com/DiddiZ/LogBlock/wiki/FAQ
     

Share This Page