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

    erdrickk

    ok I was playing with all the roll back commands and the only one that works for me is the /lb rollback area 10 before 06.11.2011 of course with the proper date...but yah, thats the only one that seems to work which is fine with me.

    I can't seem to get the rollbacks working with specific players.... let me try it again with 99 days lol.....
     
  3. Offline

    TruDan

    Hey, just a note. after a while it fails to log stuff. so for when you make it make the sql tables. make the id column "UNSIGNED" and int(255) <- i changed my database to those then i stopped getting sql "duplicate entry" errors.
     
  4. Offline

    DiddiZ

    "duplicate key" means your id column is messed up. You can fix that also with "REPAIR TABLE".
    UNDIGNED was added in v1.23 and 255 doesn't affect anything as 12 is the maximum :D
     
    TruDan likes this.
  5. Offline

    jungalist81

    Whenever I try to restart my server, Logblock will say in the console,
    "LogBlock: Remaining queue size: 63LogBlock: Remaining queue size: 62
    LogBlock: Remaining queue size: 61
    LogBlock: Remaining queue size: 60
    LogBlock: Remaining queue size: 59".

    It is like a long countdown before it can restart. What is that about and how can i resolve this?
     
  6. Offline

    DiddiZ

    It's saving your block changes queue to databaser instead of dropping it.
    Set forceToProcess to 20 or 50
     
  7. Offline

    jungalist81

    Alright it worked, thanks
     
  8. Offline

    Odai

    Hallo ich mal wieder ^^
    Gibt es eine möglichkeit es abzustellen das er wenn die MySQL verbindung mal kurz abbricht, dass er nicht immer diesen fehler bericht raushaut? Dies bringt den server immer zum crash. Sonst hab ich keine probleme mehr ab und zu nur noch ein paar mal immer dieser verbindungsabbrüche für ein paar millisekunden.

    Code:
    01:15:02 [SEVERE] [LogBlock] Error while fetching connection
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet successfully received from the server was 19 milliseconds ago.  The last packet sent successfully to the server was 19 milliseconds ago.
            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:532)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
            at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082)
            at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
            at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
            at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
            at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
            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.GeneratedConstructorAccessor28.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:71)
            at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:246)
            at de.diddiz.LogBlock.Consumer.run(Consumer.java:248)
            at java.util.TimerThread.mainLoop(Timer.java:534)
            at java.util.TimerThread.run(Timer.java:484)
    Caused by: java.net.SocketException: Connection reset
            at java.net.SocketInputStream.read(SocketInputStream.java:185)
            at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)
            at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)
            at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)
            at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2526)
            at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
            ... 23 more
    thx Odai
     
  9. Offline

    TruDan

    lol, thanks :p im not much of a sql person. im more php ;)
    could there be a thing in the plugin that repairs the table if it detects an error? because this duplicate entry thing happened to occur when i needed it most. (i had grief :/)
     
  10. Offline

    DiddiZ

    Der server crasht? Der sollte eig eine Fehlermeldung alle 6 sek verkraften ...
    Möglichkeit 1:
    Eigener MySQL server auf localhost :D
    Möglichkeit 2:
    timePerRun unf delayBetweenRuns um den selben Faktor erhöhen (von mir aus 2,3,4 oder 5). Würde aufjedenfall die auftretenswahrscheinlichekeit verringern.
     
  11. Offline

    Odai

    ja kA immer wenn der fehler kommt das die verbindung kurz weg ist dann bekommen alle lag, haut alle raus is kurz nicht erreichbar und dann wieder da. schon nervig auf dauer :confused:

    Auf localhost kann ich leider nicht umstellen da mein provider meint es sei unmöglich webserver und gameserver zusammen zu bringen *hust idioten hust*

    toll wär ne option um die fehler ausgabe abzuschalten/ignorieren das er einfach dann weitermacht (da er ja eh dann gleich wieder reconnected) ^^
     
  12. Offline

    DiddiZ

    jop, hab ich mir auch schon überlegt, einmal sollte der stacktrace ja reichen
     
  13. Offline

    1born2kill

    I get this when I Try to Run the Server after an unexpected crash from /reload, because of LogBlock:

    Code:
    [LogBlock] Found stored queue. Try to import now.
    And My Server Wont load after, Even if i waited for 1hr, it would not load anything else... just that Message...
     
  14. Offline

    DiddiZ

    delete or rename plugins/LogBlock/consumer/queue.sql
     
  15. Offline

    Sh4d0w

    LB 1.23 doesn't work at me.
    It creates the new tables, but no working after it.
    Bukkit Contrib 0.17 & Bukkit #1000
     
  16. Offline

    DiddiZ

    Um, no errors?
    Try /lb savequeue
     
  17. Offline

    1born2kill

    Weird, i Cant find queue.sql :/
     
  18. Offline

    DiddiZ

    plugins/LogBlock/consumer/queue.sql
    It has to be there, otherwise LB wouldn't try to import it.
     
  19. Offline

    Sh4d0w

    no errors are there.
    In the log are the messages, that new tables are created, but no function. If i breadk a block, no entry is produced. And if right-click with tool no entries are available.

    What does /lb savequeue?
    Can't so easy test it, because on my server are a lot of players online...
     
  20. Offline

    DiddiZ

    Guess that's the reason. Set forceToProcess to 50.
    Savequeue instantly writes all log in queue to db.
     
  21. Offline

    Kainzo

    Seeing this happen when I attempt to start @DiddiZ
    2011-07-23 16:15:24 [INFO] Read timed out
    2011-07-23 16:15:29 [INFO] Read timed out
    2011-07-23 16:15:30 [WARNING] [LogBlock] Failed to import stored queue:
    java.sql.SQLException: Subquery returns more than 1 row
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    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.LogBlock.onLoad(LogBlock.java:87)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:157)
    at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:118)
    at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:51)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:132)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)

    can I DELETE the queue somehow?
    Deleting the queue.sql - fixed this issue.
     
  22. Offline

    deshadowc

    What would you recommend setting the consumer to on a server with 120 active players?
     
  23. Offline

    DiddiZ

    Guess you've enough cores, so maybe something like:
    delayBetweenRuns: 5
    timePerRun: 1000
     
  24. Offline

    EdGruberman Retired Staff

    With the new per world config, how would I go about installing this plugin for worlds that have a forward slash in their name? I can't name the per world configuration files as "Worlds/World1.yml" for instance. Should I put them under a folder named "Worlds" to match my world naming in the LogBlock folder?
     
  25. Offline

    DiddiZ

    Put the world with path in the main config, reload and the file will be autocreated
     
  26. Offline

    xDpPx_abno96

    Sorry this is not really clear to me (as in the post). What are the permission nodes? =P
     
  27. Offline

    runerqp

    ok i give up, looked from page 80 to 97 and could find an answer for my question:
    Does it support permissionsbukkit v1.0?
     
  28. Offline

    xcanner

    What is the data column "data" used for in the MySQL table? Im trying to figure this out for my own stat table (got data from logblock hey0, bigbrother and soon logblock bukkit).
     
  29. Offline

    wassilij

    Bukkit 1000
    Code:
    2011-07-24 00:59:46 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1311461949), 44, 78, 0, 0, '5000081', 87, '100134');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        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:272)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:636)
    2011-07-24 00:59:49 [INFO]  jeahaha: warte 
    2011-07-24 00:59:51 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1311461949), 44, 78, 0, 0, '5000080', 86, '100133');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        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:272)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:636)
    2011-07-24 00:59:56 [INFO] StammiVIP jay89boy: h?? 
    2011-07-24 00:59:57 [INFO]  jeahaha: jetzt 
    2011-07-24 01:00:02 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1311461950), 44, 78, 0, 0, '5000078', 86, '100133');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        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:272)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:636)
    2011-07-24 01:00:08 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1311461950), 44, 78, 0, 0, '5000077', 86, '100132');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        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:272)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:636)
    2011-07-24 01:00:13 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1311461951), 44, 78, 0, 0, '5000076', 86, '100132');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        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:272)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:636)
    2011-07-24 01:00:21 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1311461951), 44, 78, 0, 0, '5000075', 86, '100132');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        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:272)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:636)
    2011-07-24 01:00:27 [INFO]  jeahaha: hop 
    2011-07-24 01:00:29 [INFO] StammiVIP jay89boy: bring jeaha 
    2011-07-24 01:00:30 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1311461952), 44, 78, 0, 0, '5000073', 84, '100131');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        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:272)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
        at java.lang.Thread.run(Thread.java:636)
     
  30. Offline

    DiddiZ

    -> https://github.com/DiddiZ/LogBlock/wiki/Permissions
    No, but working on
    Things like oriantation (which are insignificant for stats) but unfortunately also wool color/wood types
    -> http://www.minecraftwiki.net/wiki/Data_values#Data
    -> https://github.com/DiddiZ/LogBlock/wiki/FAQ
     
    wassilij likes this.
  31. Offline

    wassilij

    Oh and i have a idea .. my moderators sometimes cheat .. (rollback diamondblock ..), could you log, where the diamondblock is and delete ist from the inventory when you rollback?
    So that you can't double it?
    If this is too hard .. could you make it so, that you can't rollback yourself?
     

Share This Page