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

    GhostToast

    i think i fixed it. just deleted old DB, recreated it, and allowed the plugin to recreate the tables.
     
  3. Offline

    godsyn

    On chest open:
    Code:
    20:56:33 [SEVERE] [LogBlock] SQL exception
     com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'intype' in 'field list'
             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:406)
             at com.mysql.jdbc.Util.getInstance(Util.java:381)
             at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
             at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
             at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
             at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
             at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
             at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
             at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
             at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
             at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
             at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
             at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
             at de.diddiz.LogBlock.LogBlock$Consumer.run(LogBlock.java:597)
             at java.lang.Thread.run(Thread.java:619)
    SQL details:
    Code:
    mysql> use minecraft
     Reading table information for completion of table and column names
     You can turn off this feature to get a quicker startup with -A
    
     Database changed
     mysql> show tables;
     +---------------------+
     | Tables_in_minecraft |
     +---------------------+
     | lb-players          |
     | nether              |
     | nether-chest        |
     | nether-sign         |
     | oldworld            |
     | oldworld-chest      |
     | oldworld-sign       |
     | pvpworld            |
     | pvpworld-chest      |
     | pvpworld-sign       |
     | world               |
     | world-chest         |
     | world-sign          |
     +---------------------+
     13 rows in set (0.00 sec)
    
    mysql> describe `world-chest`;
    +-----------+-------------+------+-----+---------+-------+
    | Field     | Type        | Null | Key | Default | Extra |
    +-----------+-------------+------+-----+---------+-------+
    | id        | int(11)     | NO   | PRI | NULL    |       |
    | inID      | smallint(6) | YES  |     | NULL    |       |
    | inAmount  | tinyint(4)  | YES  |     | NULL    |       |
    | outID     | smallint(6) | YES  |     | NULL    |       |
    | outAmount | tinyint(4)  | YES  |     | NULL    |       |
    +-----------+-------------+------+-----+---------+-------+
    5 rows in set (0.00 sec)
    
    mysql> SELECT * FROM `world-chest` LIMIT 0 , 30;
    Empty set (0.00 sec)
    
    Config:
    Code:
    syn@synserv:~/minecraft/plugins/LogBlock$ cat config.yml
    driver: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/minecraft
    username: minecraft
    password: --removed--
    delay: 6
    usePermissions: true
    keepLogDays: 14
    logExplosions: true
    defaultDist: 20
    defaultTime: 30 minutes
    logFire: true
    toolID: 280
    toolblockID: 90
    toolblockRemove: true
    worldNames:
    - world
    - nether
    - oldworld
    - pvpworld
    worldTables:
    - world
    - nether
    - oldworld
    - pvpworld
    logSignTexts: true
    logChestAccess: true
    
     
  4. Offline

    sfxworks

    .............
    MySQL is the most annoying thing ever.
    000webhost doesn't allow remote access (im guessing)

    I installed and reinstalled mysql on my computer 3 times. Keeps freezing up on installation.
    I downloaded that work bench tool....
    Stuck at this and keep getting errors when i try to test the connection. . . . (I used port 6114 because thats the one that is open. I also configured mysql to use port 6114 during installation...at least until it froze....

    What do I use as a username and password? Would the password be the password I assigned using the Instance Configuration Wizard?
    [​IMG]

    GOD why don't people just use XML.
    [MERGETIME="1299908053"][/MERGETIME]
    Edit:
    I cleared my registery and reinstalled it. Its still freezing up though. Now its saying its also installed....

    I just need a remote server to connect to so i can finally get this addon running...
     
  5. Offline

    DiddiZ

    That is it! The tablenames have upper case letters. Seems to be a bug in auto creation. I'll fix this, but you can delete this table and create it with the sql file from the website.

    Same thing, delete the *-chest table and create it from the sql file.

    Yes
    Hm, I'll should find a suitable free mysql hoster with remote access. Would also end the sqlite discussion.

    You have to run the db updates for v0.7 and than v0.7b. I'll add a note to the website.

    Did you run the taples update?
    Make sure you have a column "playerid" in both tables lb-players and lb-main (or whtever your taple ist called)
     
  6. Offline

    _Zw_

    have tried to delete, and import tables many times.

    Got this msg ingame:

    Tried to delete whole database and let it auto add it itself.
    [MERGETIME="1299925001"][/MERGETIME]
    When i deleted all tables , and installed again:

     
  7. Offline

    DiddiZ

    Try to import the *-chest table once more, I had some uppercase letters in it.
    The fixed auto creation will be released when I fixed deleting of old log.
     
  8. Offline

    _Zw_

    When i tru to import it, il get: ERROR 1017 (HY000) at line 1: Can't find file: './minecraft/players.frm' (errno: 2)
     
  9. Offline

    DiddiZ

    Ok, it seems that I didn't thoght that much yesterday ... you have to create the table players before (it's a bit below)
     
  10. Offline

    godsyn

    Issue resolved.
     
  11. Offline

    _Zw_

    ERROR 1017 (HY000) at line 17: Can't find file: './minecraft/@0025table@0025@002dextra.frm' (errno: 2)


    So i need to import all?
     
  12. Offline

    Slugslug

    thast fixed the errors, It does not tell me chest activity - only who looked inside - is that right?
    Thought it may say user took stone or soething
     
  13. Offline

    Madmonkey

    can someone gimme the sql command???
    i am kinda messed up
    please gimme the whole thing dont gimme the web thing i am messed up by the website
     
  14. Offline

    DiddiZ

    It's planned (the -chest table is for that), it will come, when the bukkit hooks are ready.
    [MERGETIME="1299931841"][/MERGETIME]
    Released v0.7c
    Fixed table auto creation and log cleaning.
    [MERGETIME="1299931888"][/MERGETIME]
    I don't have a clue, what you are talking about ...
     
  15. Offline

    Madmonkey

    im messed up with the sql thing it just gives me this error
    LogBlock] SQL exception while checking tables
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTO_INCREMENT": syntax error)
    at org.sqlite.DB.newSQLException(DB.java:383)
    at org.sqlite.DB.newSQLException(DB.java:387)
    at org.sqlite.DB.throwex(DB.java:374)
    at org.sqlite.NativeDB.prepare(Native Method)
    at org.sqlite.DB.prepare(DB.java:123)
    at org.sqlite.Stmt.execute(Stmt.java:113)
    at de.diddiz.LogBlock.LogBlock.checkTables(LogBlock.java:268)
    at de.diddiz.LogBlock.LogBlock.onEnable(LogBlock.java:77)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:451)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:217)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:83)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:61)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:191)
    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:131)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:246)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    2011-03-12 19:21:09 [SEVERE] [LogBlock] Errors while checking tables. They may not exist.
    2011-03-12 19:21:09 [INFO] LogBlock disabled.
     
  16. Offline

    DiddiZ

    Strange errors ... if you can relinquish the old log, try to delete all tables and try the fixed auto creation.
    [MERGETIME="1299932325"][/MERGETIME]
    Don't try to use sqlite, the statements are different.
     
  17. Offline

    Madmonkey

    But im using Mysql O.O
    im using PHPmyAdmi
    reply?
     
  18. Offline

    _Zw_

    same thing.
    [MERGETIME="1299937492"][/MERGETIME]
    The new build worked great for me!

    Keep it up, tnx!
     
  19. Offline

    Madmonkey

    how do i remove sqlite? please reply ill check tmr see you tmr good night peace out [​IMG][​IMG] for you
     
  20. Offline

    DiddiZ

    I can imagine two ways this happened.
    Try removing the driver entry in config. If this doesn't help, redownload the mysql connector jar.
     
  21. Offline

    captainbinary

    Hey i have been using this fine, untill recently when i noticed this popping up in the console window.

    Code:
    04:49:22 [SEVERE] [LogBlock] SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'playerid' in 'field list'
            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:406)
            at com.mysql.jdbc.Util.getInstance(Util.java:381)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
            at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
            at de.diddiz.LogBlock.LogBlock$Consumer.run(LogBlock.java:584)
    I am using log block 0.7c and CB: 531.

    I have checked my database and there is a playerid coloum in the lb-players. Where it says field list im assuming its trying to gather all the fields for the table to assign against. Unless thats the table it is looking for :S

    -----------------------

    Fixed, there was no playerid in the lb-main table. My mistake for not updating db.
     
  22. Offline

    iTz CHEEZ3

    So will this still work with CB #493?
     
  23. Offline

    Madmonkey

    not working still not D:
    it still gives me the error

    2011-03-13 14:50:49 [SEVERE] [LogBlock] SQL exception while checking tables
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTO_INCREMENT": syntax error)
    at org.sqlite.DB.newSQLException(DB.java:383)
    at org.sqlite.DB.newSQLException(DB.java:387)
    at org.sqlite.DB.throwex(DB.java:374)
    at org.sqlite.NativeDB.prepare(Native Method)
    at org.sqlite.DB.prepare(DB.java:123)
    at org.sqlite.Stmt.execute(Stmt.java:113)
    at de.diddiz.LogBlock.LogBlock.checkTables(LogBlock.java:268)
    at de.diddiz.LogBlock.LogBlock.onEnable(LogBlock.java:77)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:451)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:217)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:83)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:61)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:191)
    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:131)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:246)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    2011-03-13 14:50:49 [SEVERE] [LogBlock] Errors while checking tables. They may not exist.
    2011-03-13 14:50:49 [INFO] LogBlock disabled.


    WOOOO I GOT IT WORKING WEEE
    I JUST CHANGED THE URL TO:
    jdbc:mysql://localhost:3306/minecraft
    [​IMG] FOR YOU LOL
     
  24. Offline

    monotonehell

    Just installed LogBlock 0.7c on a test server with an existing map that's never had LogBlock running before. Getting a few errors that may interest you. (CraftBukkit b548, no other plugins running except chatBukkit and scrapBukkit)

    The first error is one that occurs a lot. Every time we tried to rollback enviroment damage with the command
    lb rollback player environment
    we got these lines in the log:
    "[INFO] [LogBlock] Queue overloaded. Size: 117"
    The numbers varied between 100 and 250.

    What does this mean?



    This second error seems to be some problem with an SQL statement's construction, it also happened when rolling back a lot of environment damage from fire and tnt with:
    lb rollback player environment

    But only two times

    severe exception (open)

    de.diddiz.LogBlock.Rollback SQL exception
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and x > -196 and x < -156 and z > 162 and z < 202 AND date > date_sub(now(), INT' at line 1
    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:406)
    at com.mysql.jdbc.Util.getInstance(Util.java:381)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
    at de.diddiz.LogBlock.Rollback.run(Rollback.java:81)
    at java.lang.Thread.run(Thread.java:662)


    The two different errors complained about these syntaxes:
    "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and x > -161 and x < -61 and z > 45 and z < 145 AND date > date_sub(now(), INTER' at line 1"

    "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and x > -196 and x < -156 and z > 162 and z < 202 AND date > date_sub(now(), INT' at line 1"


    The other features seem to work really well. I'll be installing this on my main server soon, looking forward to the logging of chest transactions as well when they become available. Good job! ;)
     
  25. Offline

    DiddiZ

    Should, there were no changes affecting LB recently.
    That has nothing to do with the rollback, rather with tnt/fire queuing lots of blocks. This should indicate, that there were more blocks to write into the db than the consumer accomplished. The consumer is limited to process 100 blocks every delay (the delay entry in config, default 6) seconds.
    Ty [​IMG]. Found the bug: The first "and" should be a "where" ... I wonder how many bug I introduced in one version
     
  26. Offline

    monotonehell

    DiddiZ" I wonder how many bug I introduced in one version"
    lol less than I do when I make changes to my stuff. ;P

    Okay so I should reduce my delay? I had it set at 6... or should I just let those events escape logging? If a building is burnt down, and those events are not logged, will BL be able to roll back?
     
  27. Offline

    DiddiZ

    Great
    What could have been there, making LB to use sqlite?
    [MERGETIME="1300015065"][/MERGETIME]
    The blocks in the queue aren't throwed away, they are processed in the next consumer run.
    They only get lost, when the server stops and there are still blocks in the queue.
    You only need to reduce the delay when the queue is constantly overloaded
     
  28. Offline

    monotonehell

    Very good. Thank you.

    I just placed it on my main server and gave my ops a tutorial. Seems to be working well.
     
  29. Offline

    DiddiZ

    Released v0.8
    • Fixed player rollback
    • Moved clearlog to an own thread (faster start-up)
    • Added playerarea rollback
    • Added leaves decay logging
    Again, leaves decay logging is optional, if you want it, you have to enable it in the config.
     
  30. Offline

    Kane

    omg sql updates. Stop doing them please lol
     
  31. Offline

    DiddiZ

    I didn't change anything in the db structure with v0.8
     

Share This Page