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

    latexink

    The name is set with the appropriate capitalization.. it's logging other worlds fine. I even checked the cases of all the folder names and references everywhere, tried removing all entries everywhere, redoing the tables.. everything. It creates the tables named correctly, it just won't start logging the world.
     
  3. Offline

    DiddiZ

    Update to latest lb dev, what does /lb logging return then?
     
  4. Offline

    latexink

    I don't see anything newer than 1.50 that I'm using... Edit: RTOP.. trying now :/

    /lb logging returns:

    Untitled.png

    Then I get in console:


    It sounds to me like Bukkit is derped again... purely a speculative hunch though.

    I updated to the newest dev build and it works... I love it when plugins are supported... beats the shit out of any customer service, being confident that you will respond :)

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

    AHgpeu

    Code:
    2011-12-17 22:07:10 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `l
    b-world-sign` (id, signtext) values (LAST_INSERT_ID(), '??????  ?? ??????? :? ')
    ;:
    java.sql.SQLException: Incorrect string value: '\xC1\xEE\xEB\xFC\xF8\xE5...' for
     column 'signtext' at row 1
            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.Consumer.run(Consumer.java:276)
            at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    
            at java.lang.Thread.run(Unknown Source)
    2011-12-17 22:07:16 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `l
    b-world-sign` (id, signtext) values (LAST_INSERT_ID(), '????????  77eSkimoS77 Gr
    andwolf ');:
    java.sql.SQLException: Incorrect string value: '\xD3\xEA\xF0\xE0\xF1\xE8...' for
     column 'signtext' at row 1
            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.Consumer.run(Consumer.java:276)
            at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    
            at java.lang.Thread.run(Unknown Source)
    реально достала эта байда... UTF-8 слабо сделать?
     
  6. Offline

    VitalViper

    This!, how do I fix this? My users have figured out that they can just use /lb toolblock and /lb tool....
     
  7. Offline

    DiddiZ

    Install the yeti permissions bridge for your permissions plugin, like permissions.jar for pex or essentialsgroupbridge.jar from groupmanager.
    Indeed, looks like unicode paring got wrong. Maybe changing the collation of the sign table to a latin charset could help.
     
  8. Offline

    VitalViper

    Got that, its enabled and functioning, as far as I can tell.
    Edit: using essentials groupmanager
     
  9. Offline

    SuperPyroManiac

    Should add a /lb total [params]
    Basically it just adds everything together to give a number like say a person made 5 blocks and destroyed 3,
    ./lb total player person
    RESULT:
    CREATED - DESTROYED
    5 3

    like lb sum b but all blocks and support for chat like
    /lb total player lol chat
    CHAT
    55
     
  10. Offline

    DiddiZ

    kk, then give you players
    - '-logblock.tools.tool'
    - '-logblock.tools.toolblock'
    - '-logblock.spawntools'
    Yeah, I really should.
     
  11. Offline

    SuperPyroManiac

    also silverfish logging lol
     
  12. Offline

    nopresnik

    All i get is
    2011-12-19 11:34:19 [SEVERE] [LogBlock] Error while loading: while scanning a simple key; could not found expected ':'
     
  13. Offline

    shauwk

    hey its logging fire grief as fire , how do i make it show it as the player that set it on fire?
     
  14. Offline

    akaBruce

    Ok, I have a dedicated server with LogBlock but I have a local MySQL server. In my config I set the host to my IP and not 'localhost' because it is a dedicated server. However it gives me:
    2011-12-18 17:18:30 [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 timed out: connect
    at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connect(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

    I think its because I got the Host wrong. Any ideas on what I should put in that field?
     
  15. Offline

    DiddiZ

    That's not possible. But you can find the griefer:
    /lb area 10 created block fire player !fire
    Syntax error in your config.
    http://yaml-online-parser.appspot.com/
    Your ip (not your lan ip).
    Also make sure your routers firewall is forwarding port 3306 to you computer.
     
  16. Offline

    akaBruce

    I used the external IP, the IP that others connect to your mc server. (I have a dedi and a home hosted) I have portforwarded the port 3306 too on my router. Even with my firewall off, it still would not let me connect
     
  17. Offline

    pjrueda

    I have the same permissions problems (Using Groupmanager) is there any way to prevent players from using /lb command? I already deleted those permissions, but they can still get access to /lb
     
  18. Offline

    DiddiZ

    Already tried that:
    - '-logblock.tools.tool'
    - '-logblock.tools.toolblock'
    - '-logblock.spawntools'
    Next thing to do is enable remote access on the mysql server. You have to edit the config and delete (if present) skip-networking and set bind-address to the ip/domain of your mc server, or if that's not static, 0.0.0.0 (to allow connections from all ips.
     
  19. Offline

    akaBruce

    Wait a sec...which MySQL are you talking about? I really suck at SQL programs. The most experience I've had is with WampServer2.2 and Im not sure it has it..
     
  20. Offline

    pjrueda

    Yes i tried, they now can not perform anything, but the /lb command continues working
     
  21. Offline

    DiddiZ

    That one.
    And always will, it's a help page.
     
  22. Offline

    puyttre

    Every time a player joins my server, this error comes up:

    Code:
    2011-12-18 09:28:02 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1324222078), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1324222078), firstlogin), ip = '/xxx.xxx.xx.xxx:50195' WHERE playerid = 4;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastlogin' in 'field list'
        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.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        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(Unknown Source)
    
    Has anyone had this problem or know how to fix it? I'm not very good with MySQL, but I know for sure that I configured it right and I put in the correct username and password in LogBlock's config.
    Bukkit 1.0.1-RI
    LogBlock 1.50
     
  23. Offline

    xcanner

    Got this error (logblock 1.50 and bukkit 1.0.0-R1:

    16:37:50 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1324222668), lastlogin)) WHERE playerid = 2665;:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect time value: '839:34:52'
     
  24. Offline

    monir

    Do i get this with logblock or is it somthing else?

    18.12 17:41:50 [Server] INFO VendorError: 1048
    18.12 17:41:50 [Server] INFO SQLState: 23000
    18.12 17:41:50 [Server] INFO SQLException: Column 'x' cannot be null
     
  25. Offline

    Lolcat

    Hey Diddiz ich habe gerade versucht meine webstats einzurichten habe halt mehrere Welten und komme da echt nicht klar und in dem wiki finde ich auch nicht wie es geht. Ich denke es sollte so sein oder?
    "$tables = array('lb-world');('lb-world2');('lb-world3');('lb-world4'); //List of all tables that should get summed up"
    oder mache ich das so falsch?
     
  26. Offline

    VitalViper

    That just disabled it for everyone :S ugh.. I'm about to just give up.. I guess users having the ability to use /lb toolblock is not 'that' bad......
     
  27. Offline

    DiddiZ

    Autoupdater fail, set version in lb config to '1.30' and restart
    Nope, logblock wouldn't give messages without [LogBlock] in front of.

    Ja, etwas :D
    Code:
    $tables = array('lb-world', 'lb-world2', 'lb-world3', 'lb-world4');
     
    Lolcat likes this.
  28. Offline

    Drumpie

    No I had the question that my Moderators can't use the /lb toolblock and /lb tool. They can use LB if they have bedrock in their inventory but they can't use the command /lb toolblock and /lb tool.
     
  29. Offline

    Pr07o7yp3

    Please, I need by help. Can I back the world with one hour?
    Becouse some griefers just burned houses....
     
  30. Offline

    Spl1tz

    Something is causing some serieus problems for my Logblock atm.

    Code:
    2011-12-18 19:26:08 [INFO] [LogBlock] Remaining queue size: 7639
    2011-12-18 19:26:08 [INFO] [LogBlock] Remaining tries: 1
    2011-12-18 19:26:08 [INFO] [LogBlock Consumer] Queue overloaded. Size: 7639
    2011-12-18 19:26:08 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1324231221), 8, 10, 49, 0, '2109', 10, '60071');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'z' 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:274)
        at de.diddiz.LogBlock.LogBlock.onDisable(LogBlock.java:233)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:190)
        at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:989)
        at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:296)
        at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:289)
        at org.bukkit.craftbukkit.CraftServer.disablePlugins(CraftServer.java:181)
        at net.minecraft.server.MinecraftServer.stop(MinecraftServer.java:376)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:455)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    This is when server was running.
    I restarted the server and in the process of running Logblock it did this:


    Code:
    2011-12-18 19:26:35 [INFO] [LogBlock] Trying to import queue-1324232768215-4.sql ...
    main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1324231617), 8, 10, 49, 0, '1831', 10, '61546');': Data truncation: Out of range value for column 'z' at row 1
    2011-12-18 19:26:35 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1324231617), 8, 10, 49, 0, '1831', 10, '61545');': Data truncation: Out of range value for column 'z' at row 1
    2011-12-18 19:26:35 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1324231617), 8, 10, 49, 0, '1831', 10, '61544');': Data truncation: Out of range value for column 'z' at row 1
    
    And goes on and goes on...
     till:
    
    2011-12-18 19:26:35 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-
    2011-12-18 19:26:36 [INFO] [LogBlock] Successfully imported queue-1324232768215-4.sql.
    2011-12-18 19:26:36 [INFO] [LogBlock] Trying to import queue-1324232768215-7.sql ...
    2011-12-18 19:26:36 [INFO] [dynmap] Loaded 12 shaders.
    2011-12-18 19:26:36 [INFO] [LogBlock] Successfully imported queue-1324232768215-7.sql.
    2011-12-18 19:26:36 [INFO] [LogBlock] Successfully imported stored queue. (1404 rows imported, 6267 errors)
    Using latest Logblock and Recommended CB.
    It stopped tho, just want an explanation about this.
     
  31. Offline

    Lolcat

    danke dir
     

Share This Page