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

    Evetsi

    Is it possible to use a database program other than MySql? the comp where my server is running has SQLAnywhere 10. I have no choice in that matter but wonder if it would be possible to have it work with logblock. I worry installing both MySql and Sqlanywhere might cause issues
     
  3. Offline

    Willven

    I get an error using any command, which is something to do with spout?

    Code:
    2012-02-01 19:43:49 [WARNING] [LogBlock] Exception in commands handler:
    java.lang.NullPointerException
    at de.diddiz.LogBlock.QueryParams.getTable(QueryParams.java:120)
    at de.diddiz.LogBlock.QueryParams.getQuery(QueryParams.java:105)
    at de.diddiz.LogBlock.LogBlock.getCount(LogBlock.java:306)
    at de.diddiz.LogBlock.CommandsHandler.onCommand(CommandsHandler.java:237)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:386)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:777)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:737)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:725)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:178)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:33)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:100)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:587)
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:537)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:435)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
    2012-02-01 19:43:53 [WARNING] [LogBlock] Exception in commands handler:
    java.lang.ArrayIndexOutOfBoundsException: 1
    at de.diddiz.LogBlock.CommandsHandler.onCommand(CommandsHandler.java:264)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:386)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:777)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:737)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:725)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:178)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:33)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:100)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:587)
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:537)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:435)
    Any help would be appreciatted ;)
     
  4. Offline

    iSeven77

    One of the best plugins ! I do have 1 Question :p

    How to use /lb tool chestaccess ? or is it not working right now ? i have CB #1848 SpoutPlugin #737 it seems like lb is loggin but only the chestaccess it says not found :S when i right click with the /lb tool [wooden pickaxe] so i must be doing something wrong, or maybe i have to restart the questionier.jar ? i have LWC 4.0.7 btw idk if that is messing it up :p THANKS FOR YOUR HELP in ADVANCE ! :)
     
  5. Offline

    macman

    Hello,

    Im getting this error spammed in my console, Any idea what causes it?

    Code:
    2012-02-01 21:11:25 [INFO] [LogBlock Consumer] Queue overloaded. Size: 4635
    2012-02-01 21:11:25 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-newsurvival` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1328126784), 21, 0, 8, 7, '10008', 11, '99991');:
    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 java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
    Logblock 1.50 Craftbukkit++ build #53

    Thanks
     
  6. Offline

    Gibbo3771

    Eh, installation guide takes me to a blank github page and this seems complex to install. Anyone got a guide?
     
  7. Offline

    acdev

    Watch post #6254
     
  8. Offline

    macman

    That did not help....
     
  9. Offline

    Evetsi

    Is there a non-wiki installation guide? The one linked in the main post has been erased. Don't even see it in the wiki page history.
     
  10. Offline

    XxRayRayxX

    I am having some serious trouble with this..

    i have tried to use 3 different Msql databases and none of them work.

    it says

    [​IMG]

    idk what else to do can you please help me?
     
  11. Offline

    JosephW1993

    It appears to have suffered from some vandalism. I am looking for an installation page myself.
     
  12. Offline

    iforgot290

    um, yeah, i want to install this on my server, but all the installation page says is:
    I CANT FUCKING DO IT!
     
  13. Offline

    Fishfish0001

    iforgot290 and DiddiZ like this.
  14. Offline

    JosephW1993

  15. Offline

    Fishfish0001

    No problem :D
     
  16. Offline

    FuRiouSOne

    Are there any conflicts with lb1.5 and bukkit 1.1 R3 build? I tried doing a rollback on a selections and it asked for confirmation but when i typed in /yes nothing happens then logblock doesnt want to work any more other then the /lb base command. Is it safe to use the dev build of lb against bukkit 1.1 R3?
     
  17. Offline

    turbotas

    Hi, Thanks for the reply: sorry I was slow noticing your post! Yes, I can rule out player fire with !fire, but then there is nothing in the log. The problem is that the fire starting method is not logged. To test logblock If I start a fire myself in the 'normal' way, then it is logged, so I'm wondering if there is a method greifers can use that logblock misses. thsi has only started happening recently. I'm wodering if it's an egg of a mob spawn which is not logged maybe and a fire starts?
     
  18. Offline

    __pwned__

    Hi, i get this error.
    Code:
    20:38:49 [SEVERE] [LogBlock] Error while fetching connection:
    java.sql.SQLException: Access denied for user 'logblock'@'localhost' (using password: YES)
        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.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.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        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:160)
        at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:133)
        at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:52)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:151)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:411)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
    
    I'm on mac using MAMP. I have entered the user name, password and host correctly but it doesn't work. I have tried using this my sql http://www.mysql.com/ but i don't know what my password or my username is or how do i create a database.
     
  19. Offline

    DiddiZ

    This error occures when using /lb me in a not logged world, latest dev build fixed that.
    You need to enable chest logging in world config.
    Change x and z columns datatypes:
    https://github.com/DiddiZ/LogBlock/wiki/FAQ
    It's a problem with WorldEdit, that change the message so the questions can't catch the /yes cause it got transformed to yes/.

    I'm not sure if they fixed that, so try updating WE, otherwise remove the questioner.
    Ty, seems like some kiddy got mad ...

    JosephW1993 Evetsi Gibbo3771
    Installation page is back

    Try to put the password in single quotes, like
    password: '123'
    In some cases it's not recognized as string.
    If that's not the issue, did you grant the right to the database when you created it? If not:
    GRANT ALL ON `database`.* TO 'logblock'@'localhost' IDENTIFED BY password;
    No changes by other players at all?
    I'm thinking of placed lava or something.
     
  20. Offline

    iSeven77

    TY SO MUCH ! i did the change in yml and it didnt worked thats why i posted the question finally but my problem was that i /stop the server but not completely turn off and restarted it lol once i did that then it worked lol :p my bad :) THANKS AGAIN !
     
  21. Offline

    Sorken

    DiddiZ
    How do i clear out lever switches older then 90d?

    "lb clearlog switched before 90d" will not work, as it does not recognize switched. It also does not understand "replaced". And what about chat entries? I tried using search together with a clearlog and searching for various things, like chat, switched and even bogus words like test. All come up with wanting to clear some 11 million records.. id rather not do that :)
     
  22. Offline

    DiddiZ

    Sry, deleting from the chat table isn't supported yet.
    switched and replaced aren't keywords
    To clear out levers add to autoclearlog (or use ingame):
    world "world" block lever stone_button before 90d
     
  23. Offline

    Sorken

    Wont this delete placing and destroying levers before 90d aswell? i only want to clear the usage data. Not actual placing/removal.

    Also, "lb clearlog world eden destroyed before 180d" just wiped my chest logs.. Why did it do that? Im fairly sure thats not a destroyed anything.
     
  24. Offline

    nopresnik

    What website do you recomend for mysql hosting. Cause the one i pick dont seem to work. I also cant use a local database because my server is not hosted on my local machine.
    So whats the best mysql hosting you would recomend?
    Thanks
     
  25. Offline

    FuRiouSOne

    http://www.freemysql.net/ Easy and fast to set up but no phpmyadmin
    or
    http://sharkserve.com/

    Sharkserve is a webhost but you get free database and storage, the free side effect is server can get lagged out or down. They do offer a 1 time fee of 10$ for their premium server which is more stable and less lag/downtime. Plus you get a free web host to make your minecraft server website on.
     
  26. Offline

    Strahan

    Is there documentation anywhere that lists the types in mysql and what they mean? Thanks.
     
  27. Offline

    SuperPyroManiac

    Well since 1.1 RB has been out LB has not been working with chat, even with its logging disabled my console is spammed to all hell. I selected what I could but log was moving so fast I could not get it all.

    Code:
    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:289)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
    2012-02-04 13:00:08 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-chat` (date, playerid, message) VALUES (FROM_UNIXTIME(1328381972), 1, '/');:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1125392' for key 'PRIMARY'
    at sun.reflect.GeneratedConstructorAccessor21.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: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:289)
    at java.util.TimerThread.mainLoop(Unknown Sour
    Here is a better error I got.

    Code:
    2012-02-04 13:01:02 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-chat` (date, playerid, message) VALUES (FROM_UNIXTIME(1328382043), 1, '/tell captainferret /donate');:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1125392' for key 'PRIMARY'
    at sun.reflect.GeneratedConstructorAccessor21.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: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:289)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
    2012-02-04 13:01:04 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-chat` (date, playerid, message) VALUES (FROM_UNIXTIME(1328382043), 1, '/');:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1125392' for key 'PRIMARY'
    at sun.reflect.GeneratedConstructorAccessor21.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: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:289)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 18, 2016
  28. Offline

    bigggan

    Is there a command to force savequeue? i tried savequeue but it said it was unable to save.
     
  29. Offline

    MinecraftxNoob

    I get this error -.-
    Code:
    2012-02-04 20:07:20 [WARNING] [LogBlock] Exception in commands handler:
    java.lang.IllegalArgumentException: No or wrong count of arguments for 'block'
    at de.diddiz.LogBlock.QueryParams.parseArgs(QueryParams.java:306)
    at de.diddiz.LogBlock.QueryParams.(QueryParams.java:49)
    at de.diddiz.LogBlock.CommandsHandler.onCommand(CommandsHandler.java:291)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:386)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:777)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:737)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:725)
    at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:33)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:100)
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:536)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:434)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
    I get this when i type /lb block
    please help =(
     
  30. Offline

    King_KYl3

    Ive tried every thing to fix this been on the error page and all and nothin helps ive deleted all mysql file tried every thing please help! error:

    2012-02-05 10:17:11 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2012-02-05 10:17:15 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1328437030), 575, 0, 83, 0, '219', 63, '92725');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'z' at row 1
     
  31. Offline

    GameProfi

    Please help!
    I installed it right, all works but the messages not
    when ive got the tool/toolblock and right or left clickin an block it says NOTHING...
    Please i need some help..!
    Message me please..
     

Share This Page