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

    MineCleric

    2011-10-22 15:47:20 [INFO] [Minecart Mania] MinecartManiaCore version 1.2.8 is disabled!
    2011-10-22 15:47:20 [INFO] [NoCheat] version [2.12a] is disabled.
    2011-10-22 15:47:20 [INFO] [Playtime] Playtime version 0.4 unloaded.
    2011-10-22 15:47:20 [INFO] VIP Disabled
    2011-10-22 15:47:20 [INFO] WorldGuard 5.0-alpha10 disabled.
    2011-10-22 15:47:20 [INFO] [Permissions] (Yeti) saving data...
    2011-10-22 15:47:20 [INFO] [Permissions] (Yeti) saved all data.
    2011-10-22 15:47:20 [INFO] [Permissions] (Yeti) disabled successfully.
    2011-10-22 15:47:20 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    2011-10-22 15:47:20 [INFO] WorldGuard: Permissions plugin detected! Using Permissions plugin for permissions.
    2011-10-22 15:47:20 [INFO] LogBlockQuestioner disabled
    2011-10-22 15:47:20 [INFO] [Permissions] SQL Interface disabled!
    2011-10-22 15:47:20 [INFO] Lockette: Closing all automatic doors.
    2011-10-22 15:47:20 [INFO] [OnlineSigns] version 0.1 loaded.
    2011-10-22 15:47:20 [INFO] [iChat] iChat Disabled
    2011-10-22 15:47:20 [INFO] LogBlock disabled.
    2011-10-22 15:47:20 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    2011-10-22 15:47:20 [INFO] Entities enhanced[0] subclassed[2]
    2011-10-22 15:47:21 [INFO] ControllerBlock: 1.18 by Hell_Fire
    2011-10-22 15:47:21 [INFO] ControllerBlock: Using IRON_BLOCK (42) as ControllerBlock, loaded 0 disallowed types from config
    2011-10-22 15:47:21 [INFO] [Permissions] (Yeti) was initialized.
    2011-10-22 15:47:21 [SEVERE] org.bukkit.Bukkit.getConsoleSender()Lorg/bukkit/command/ConsoleCommandSender; initializing LogBlock v1.32 (Is it up to date?)
    java.lang.NoSuchMethodError: org.bukkit.Bukkit.getConsoleSender()Lorg/bukkit/command/ConsoleCommandSender;
    at de.diddiz.LogBlock.Config.<init>(Config.java:167)
    at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:68)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:141)
    at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:408)
    at org.bukkit.Bukkit.reload(Bukkit.java:173)
    at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:353)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:756)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:721)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:714)
    at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:500)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:464)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011-10-22 15:47:22 [INFO] Spout 1.0.6.449 has been initialized
    2011-10-22 15:47:22 [INFO] [Permissions] version [3.1.6] (Yeti) loaded
    2011-10-22 15:47:22 [INFO] [Minecart Mania] Debug mode switched to NORMAL
    2011-10-22 15:47:22 [INFO] [Minecart Mania] MinecartManiaCore version 1.2.8 is enabled!
    2011-10-22 15:47:22 [INFO] ControllerBlock: Enabling full redstone check
    2011-10-22 15:47:22 [INFO] ControllerBlock: Events registered
    2011-10-22 15:47:22 [INFO] [NoCheat] This version is for CB #1317. It may break at any time and for any other version.
    2011-10-22 15:47:22 [INFO] [NoCheat] version [2.12a] is enabled.
    2011-10-22 15:47:22 [INFO] [Playtime] Permissions 3.1.6 found.
    2011-10-22 15:47:22 [INFO] [Playtime] Playtime version 0.4 loaded.
    2011-10-22 15:47:22 [INFO] VIP version 1.0.1 by Kostronor is enabled!
    2011-10-22 15:47:22 [INFO] WorldEdit 4.6 enabled.
    2011-10-22 15:47:22 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    2011-10-22 15:47:22 [INFO] WorldGuard: Permissions plugin detected! Using Permissions plugin for permissions.
    2011-10-22 15:47:22 [WARNING] Found option with no heading blacklist.txt for '- message (optional message to show the user instead; %s is the item name)'
    2011-10-22 15:47:22 [WARNING] Found option with no heading blacklist.txt for '- log (log to console/file/database)'
    2011-10-22 15:47:22 [WARNING] Found option with no heading blacklist.txt for '- tell (tell a player that that's not allowed)'
    2011-10-22 15:47:22 [INFO] WorldGuard: Blacklist loaded.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland) Single session is enforced.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland) TNT ignition is PERMITTED.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland) Lighters are blocked.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland) Lava fire is blocked.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland) All fire spread is disabled.
    2011-10-22 15:47:22 [INFO] WorldGuard: Loaded configuration for world 'Minecraft Nordland"
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland_nether) Single session is enforced.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland_nether) TNT ignition is blocked.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland_nether) Lighters are blocked.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland_nether) Lava fire is blocked.
    2011-10-22 15:47:22 [INFO] WorldGuard: (Minecraft Nordland_nether) All fire spread is disabled.
    2011-10-22 15:47:22 [INFO] WorldGuard: Loaded configuration for world 'Minecraft Nordland_nether"
    2011-10-22 15:47:22 [INFO] WorldGuard: 4 regions loaded for 'Minecraft Nordland'
    2011-10-22 15:47:22 [INFO] WorldGuard 5.0-alpha10 enabled.
    2011-10-22 15:47:22 [INFO] [OwnBlocksX] version 0.2.3 initialized with MySQL
    2011-10-22 15:47:22 [INFO] LogBlockQuestioner v0.02 enabled
    2011-10-22 15:47:22 [INFO] Loaded Essentials build 2.4.2 by: Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    2011-10-22 15:47:22 [INFO] [Permissions] SQL Interface enabled!
    2011-10-22 15:47:22 [INFO] [Minecart Mania] MinecartManiaAutocart version 1.2.0 is enabled!
    2011-10-22 15:47:22 [INFO] Lockette version 1.4.4 is being enabled! Yay! (Core version 1.2.3)
    2011-10-22 15:47:22 [INFO] Lockette: Detected craftbukkit build [1185] ok.
    2011-10-22 15:47:22 [INFO] Lockette: Linked to Permissions plugin version 3.1.6
    2011-10-22 15:47:22 [INFO] Lockette: Using ops file for admin permissions.
    2011-10-22 15:47:22 [INFO] Lockette: Ready to protect your containers.
    2011-10-22 15:47:22 [INFO] Loaded EssentialsSpawn build 2.4.2 by: Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    2011-10-22 15:47:22 [INFO] [OnlineSigns] Permissions 3.1.6 found.
    2011-10-22 15:47:22 [INFO] [OnlineSigns] version 0.1 loaded.
    2011-10-22 15:47:22 [INFO] [iChat] Found Permissions (v3.1.6)
    2011-10-22 15:47:22 [INFO] iChat (v2.3.3-p3) enabled
    2011-10-22 15:47:22 [INFO] Loaded EssentialsGeoIP build 2.4.2 by: Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans and Xeology
    2011-10-22 15:47:22 [INFO] This product includes GeoLite data created by MaxMind, available from http://www.maxmind.com/.
    2011-10-22 15:47:23 [SEVERE] Error occurred while enabling LogBlock v1.32 (Is it up to date?): null
    java.lang.NullPointerException
    at de.diddiz.LogBlock.LogBlock.onEnable(LogBlock.java:144)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:920)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:173)
    at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:156)
    at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:410)
    at org.bukkit.Bukkit.reload(Bukkit.java:173)
    at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:353)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:756)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:721)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:714)
    at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:500)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:464)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
     
  3. Offline

    DiddiZ

    You are trying to use LB 1.20 with a CB build prior #1192. Use LB 1.30 instead.
     
  4. Offline

    Megalanias

    @DiddiZ ... strange xD okay I'm gonna try it again ^^
     
  5. Offline

    Roman_Jefimow

    Code:
    2011-10-22 20:22:57 [INFO] [LogBlock] Version check: Your version is up to date
    2011-10-22 20:22:57 [INFO] [LogBlock] Connecting to **************@jdbc:mysql://***********:****/**************...
    2011-10-22 20:22:58 [INFO] [LogBlock] Found 1imports.
    2011-10-22 20:22:58 [INFO] [LogBlock] Trying to import queue-1319302470134-0.sql ...
    2011-10-22 20:23:15 [WARNING] [LogBlock] Failed to import queue-1319302470134-0.sql:
    java.sql.BatchUpdateException: You can't specify target table 'lb-players' for update in FROM clause
        at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065)
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:102)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:414)
        at com.earth2me.essentials.commands.Commandreloadall.run(Commandreloadall.java:18)
        at com.earth2me.essentials.commands.EssentialsCommand.run(EssentialsCommand.java:96)
        at com.earth2me.essentials.Essentials.onCommandEssentials(Essentials.java:445)
        at com.earth2me.essentials.Essentials.onCommand(Essentials.java:359)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:358)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:354)
        at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:506)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:485)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011-10-22 20:23:15 [INFO] [LogBlock] Successfully imported stored queue.
    LogBlock Version: v.1.32 (CB #1240-1337)
    Bukkit Version: #1240
    Habe das Problem grade bekommen,
    davor hat der nie irgendetwas gespeichert sondern immer alles lokal im Import Ordner !
    Dann habe ich die neue LogBlock Version Gedownloaded und klappte wieder aber jetzt importiert der gar nicht's mehr ..
     
  6. Offline

    DiddiZ

    Versuchs mit dem latest dev, hab da einige sachen bezüglich imports geändert, vorallem crasht ein fehler nicht mehr alles.
     
  7. Offline

    XRayted

    Hello great DiDDiZ,
    Do you know if the Dev. of Chunkster is still active or know someone who can answer questions about fixing a world?

    LogBlock: Great to see that 1337 is supported now.
     
  8. Offline

    DiddiZ

    No, sry.

    1337 was supported the whole time, it's just me beeing lazy to change the title :D
     
  9. Offline

    XRayted

    People are going to try anyways :p
    Thanks for your answer!
     
  10. Offline

    Roman_Jefimow

    Danke ;)
     
  11. Offline

    Megalanias

    Ui ein deutscher ^^ hey ^^ naja danke für die hilfe Diddiz,jetzt klappt alles ^^
    thanks for the help Diddiz i reinstalled and now everything works !
     
    DiddiZ likes this.
  12. Had a SEVERE:

    Code:
    22:44:10 [SEVERE] [LogBlock Lookup] SELECT date, replaced, type, data, playername, signtext, itemtype, itemamount, itemdata FROM `lb-oldbux` INNER JOIN `lb-players` USING (playerid) LEFT JOIN `lb-oldbux-sign` USING (id) LEFT JOIN `lb-oldbux-chest` USING (id) WHERE x = '-115' AND y = '64' AND z = '1110' ORDER BY date DESC, id DESC LIMIT 15: 
    java.lang.NullPointerException
            at de.diddiz.LogBlock.QueryParams.getWhere(QueryParams.java:236)
            at de.diddiz.LogBlock.QueryParams.getWhere(QueryParams.java:167)
            at de.diddiz.LogBlock.QueryParams.getQuery(QueryParams.java:101)
            at de.diddiz.LogBlock.CommandsHandler$CommandLookup.run(CommandsHandler.java:404)
            at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
            at java.lang.Thread.run(Thread.java:722)
    
     
  13. Offline

    DiddiZ

    Do you know the query command that caused the error?
    According to the stack trace the location was null, but that's unlikely as it was able to display the location in the error message ...
     
  14. Offline

    Spudski

    Code:
    161 recipes
    17 achievements
    22:44:43 [INFO] Starting minecraft server version Beta 1.8.1
    22:44:43 [INFO] Loading properties
    22:44:43 [INFO] Starting Minecraft server on *:25565
    22:44:43 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1112-g54a13b2-b1240jnks (MC: 1.8.1)
    22:44:44 [INFO] [Permissions] (Yeti) was initialized.
    22:44:44 [INFO] [LogBlock] Version check: Your version is up to date
    22:44:44 [INFO] [LogBlock] Connecting to spudski@jdbc:mysql://sql09.freemysql.net:3306/spudski...
    22:44:47 [INFO] [Permissions] version [3.1.6] (Yeti)  loaded
    22:44:47 [INFO] Spout 1.0.6.449 has been initialized
    22:44:47 [INFO] Preparing level "private"
    22:44:47 [INFO] Default game type: 1
    22:44:47 [INFO] Preparing start region for level 0 (Seed: 2850301192033674260)
    22:44:48 [INFO] [AutoSave] Loading config file
    22:44:48 [INFO] [AutoSave] Version 2.0.1 is enabled: a2626668-59bb-4940-9f81-408e42d64273
    22:44:48 [INFO] [AutoSave][Permission] Custom Permissions "Local Permissions" found: Loaded
    22:44:48 [INFO] [AutoSave][Permission] PermissionsEx not found.
    22:44:48 [INFO] [AutoSave][Permission] Permissions (Phoenix) hooked.
    22:44:48 [INFO] [AutoSave][Permission] Permissions (Phoenix) found: Loaded
    22:44:48 [INFO] [BlockBlock] BlockBlock version 1.42 has been enabled!
    22:44:48 [INFO] [BlockBlock] BlockBlock Config is loaded!
    22:44:48 [INFO] BorderGuard version 4.2 is enabled!
    22:44:48 [INFO] Loaded Essentials build 2.6.3 by: Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo, ceulemans, Xeology, KHobbits
    22:44:48 [INFO] Essentials: Using Permissions 3 based permissions.
    22:44:48 [INFO] Loaded EssentialsChat build 2.6.3 by: essentials team
    22:44:48 [INFO] Loaded EssentialsSpawn build 2.6.3 by: essentials team
    22:44:48 [INFO] KiwiAdmin version 2.2 is enabled!
    22:44:48 [INFO] LogBlockQuestioner v0.02 enabled
    22:44:48 [INFO] [NoCheat] This version is for CB #1317. It may break at any time and for any other version.
    22:44:48 [INFO] [NoCheat] version [2.12a] is enabled.
    22:44:48 [INFO] RocketBoots v0.3.6 enabled!
    22:44:48 [INFO] [VanishNoPickup] 1.9.12 enabled.
    22:44:48 [INFO] VoxelDoop version 1.7 is enabled!
    22:44:48 [INFO] [VoxelSniper] Config loaded
    22:44:48 [INFO] VoxelSniper version 5.019 is enabled! Snipe away.
    22:44:48 [INFO] WorldEdit 4.7 enabled.
    22:44:48 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    22:44:49 [INFO] WorldGuard: Permissions plugin detected! Using Permissions plugin for permissions.
    22:44:49 [INFO] WorldGuard: (private) Single session is enforced.
    22:44:49 [INFO] WorldGuard: (private) TNT ignition is blocked.
    22:44:49 [INFO] WorldGuard: (private) Lighters are blocked.
    22:44:49 [INFO] WorldGuard: (private) Lava fire is blocked.
    22:44:49 [INFO] WorldGuard: (private) All fire spread is disabled.
    22:44:49 [INFO] WorldGuard: Loaded configuration for world 'private"
    22:44:49 [INFO] WorldGuard: 4 regions loaded for 'private'
    22:44:49 [INFO] WorldGuard 5.3 enabled.
    22:44:49 [INFO] [LogBlock] Permissions plugin found.
    22:44:49 [INFO] [LogBlock] Scheduled consumer with bukkit scheduler.
    22:44:49 [INFO] LogBlock v1.32 by DiddiZ enabled.
    22:44:49 [INFO] properTime reading from config at /Users/Dallen/Desktop/SpudCraft/plugins/properTime/properTime.conf
    22:44:49 [INFO] properTime 1.9.0 initialized
    22:44:49 [INFO] Server permissions file permissions.yml is empty, ignoring it
    22:44:49 [INFO] Done (0.208s)! For help, type "help" or "?"
    
    So, I have all LogBlock permissions, and nothing wrong in the console. But it ceases to work! I have tried anything, if it helps, I am running CraftBukkit build number 1240.

    Could it be something with Permissions?
     
  15. Offline

    agentc0re

    I've been trying to get logblock working and here's what i get at my McMyAdmin console during the server start up.
    Code:
    Info:	Reading configuration, please wait...
    2011-10-22 22:12:56 [INFO] Starting minecraft server version Beta 1.8.1
    2011-10-22 22:12:56 [INFO] Loading properties
    2011-10-22 22:12:56 [INFO] Starting Minecraft server on *:25565
    2011-10-22 22:12:56 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1131-g86b7fa8-b1337jnks (MC: 1.8.1)
    2011-10-22 22:12:56 [INFO] LWC: Loading shared objects
    2011-10-22 22:12:56 [INFO] LWC: Protection cache: 0/10000
    2011-10-22 22:12:56 [INFO] LWC: Native library: plugins/LWC/lib/native/Linux/amd64/libsqlitejdbc.so
    2011-10-22 22:12:56 [INFO] MLog clients using java 1.4+ standard logging.
    2011-10-22 22:12:57 [INFO] [LogBlock] Version check: Your version is up to date
    2011-10-22 22:12:57 [INFO] [LogBlock] Connecting to minecraft@jdbc:mysql://localhost:3306/logblock...
    2011-10-22 22:12:57 [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.
    Caused by: java.net.ConnectException: Connection refused
    2011-10-22 22:12:57 [SEVERE] [LogBlock] Error while loading:
    2011-10-22 22:12:57 [INFO] Preparing level "Andromeda"
    2011-10-22 22:12:57 [INFO] Default game type: 0
    2011-10-22 22:12:57 [INFO] Preparing start region for level 0 (Seed: 2034107458)
    2011-10-22 22:12:57 [INFO] Preparing start region for level 1 (Seed: 2034107458)
    2011-10-22 22:12:58 [INFO] LogBlockQuestioner v0.02 enabled
    
    
    My user can in fact log into mysql to access the data base that I've created.

    Code:
    minecraft@minecraft:~$ mysql -u minecraft -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.1.56-log Source distribution
    
    Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL v2 license
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | logblock           |
    +--------------------+
    2 rows in set (0.00 sec)
    
    mysql> quit
    
    
    I'm a bit stumped on where to go from here.

    my.cnf:
    http://pastebin.com/PiTMjzLM

    config.yml
    http://pastebin.com/WV1CiAS9

    Any suggestions would be much appreciated.

    Problem Solved. My sql user, minecraft, didn't have any user permissions, only database access permissions. Webmin to the rescue!

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

    DiddiZ

    Try "/lb permissions", this lists all permissions you've got.
     
  17. Offline

    Tomi Joo

    Getting error message every few minutes. Lags the server so much.

    Code:
    2011-10-23 14:14:52 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1319393689), lastlogin)) WHERE playerid = 276;:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'onlinetime' in 'field list'
    	at sun.reflect.GeneratedConstructorAccessor52.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.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:278)
    	at java.util.TimerThread.mainLoop(Timer.java:534)
    	at java.util.TimerThread.run(Timer.java:484)
    
     
  18. Offline

    DiddiZ

    Set version in config to '1.30' and restart.
     
  19. Offline

    MagikarpLOL123

    Im having some trouble with mySQL. I downloaded and installed it but yet when i run my server i still get tons of errors
    To be more specific, this: lolzo.PNG
     
  20. Offline

    davvem

    Acces denied for user root @ local host, how to fix? :(
     
  21. Offline

    Spudski

    logblock.me
    logblock.lookup
    logblock.tp
    logblock.rollback
    logblock.clearlog
    logblock.hide
    logblock.ignoreRestrictions
    logblock.tools.toolblock
    logblock.tools.tool

    I have got all of those...
     
  22. Offline

    DiddiZ

    Did you set MySQL data in config?
    Try to connect to your ip/domain instead of localhost.
    kk, so in which way LB fails to work?
     
  23. Offline

    davvem

    Ok, thanks DiddiZ, i'll try right away!

    **EDIT**
    It dident work! Tried both local and public ip :(
     
  24. Offline

    Spudski

    I get either the tool, or toolblock, and absolutely nothing happens when I attempt to use either.
     
  25. Offline

    MagikarpLOL123

    Am I supposed to put in my MySQL data?
     
  26. Offline

    oxbudy

    issue: hey, i am loving this plugin! everything is working perfectly except for chest logging, when i log a chest with the wood pick, it just shows who created the chest, not who stole/ put stuff in it, and when i rollback a area, it also removes the chest and not the contents inside, if you could help me with this i would really appreciate it! (btw, is this supposed to happen? :p)

    -oxbudy
     
  27. Offline

    DiddiZ

    Yes
    Depends. Did you enable chest logging in world config?
     
  28. Offline

    Herogx

    How do i enable it to delete logs, it wont work. it gives me the error "cant connect to mysql database"
    My server host says he can see it connecting, any ideas?
     
  29. Offline

    DiddiZ

    Set dumpDeletedLog to false
     
  30. Offline

    Herogx

    i tried that, it gave me an exception and told me to check the error log
     
  31. Offline

    Nonin

    I'm getting this in console:
    Code:
    23.10 21:26:19 [Server] INFO Spout 1.0.6.449 has been initialized
    23.10 21:26:19 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    23.10 21:26:19 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    23.10 21:26:19 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:485)
    23.10 21:26:19 [Server] INFO     at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:506)
    23.10 21:26:19 [Server] INFO     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:351)
    23.10 21:26:19 [Server] INFO     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:355)
    23.10 21:26:19 [Server] INFO     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
    23.10 21:26:19 [Server] INFO     at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
    23.10 21:26:19 [Server] INFO     at org.bukkit.Bukkit.reload(Bukkit.java:182)
    23.10 21:26:19 [Server] INFO     at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:411)
    23.10 21:26:19 [Server] INFO     at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:139)
    23.10 21:26:19 [Server] INFO     at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:79)
    23.10 21:26:19 [Server] INFO     at de.diddiz.LogBlock.Updater.update(Updater.java:117)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    23.10 21:26:19 [Server] INFO     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    23.10 21:26:19 [Server] INFO     at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    23.10 21:26:19 [Server] INFO     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    23.10 21:26:19 [Server] INFO     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    23.10 21:26:19 [Server] INFO     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    23.10 21:26:19 [Server] INFO com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'lastlogin'
    23.10 21:26:19 [Server] SEVERE [LogBlock Updater] Error:
    23.10 21:26:19 [Server] INFO [LogBlock] Updating tables to 1.31 ...
    23.10 21:26:19 [Server] INFO [LogBlock] Connecting to mburns_user@jdbc:mysql://localhost:3306/mburns_mysql...
    23.10 21:26:19 [Server] INFO [LogBlock] Version check: Your version is up to date
    And logblock isn't working. Any ideas on how to fix it?
     

Share This Page