LogBlock
Works 100% with 1.7 / 1.8
The best block logging and rollback solution for the savvy server administrator.
LogBlock is the best block logging plugin for Bukkit server. Not only is it awesomely powerful, it’s blazing fast! Everything is logged into a MySQL database, allowing developers to hook in and produce things such as player stats and even administrative panels. Every loggable action can be logged with LogBlock: WorldEdit, leave decay, fire, sign changes, explosions, chest changes, player and animal deaths, chat, commands and more!
Development builds of this project can be acquired at the provided continuous integration server. These builds have not been approved by the BukkitDev staff. Use them at your own risk.
LogBlock will very rarely break between Minecraft / Bukkit updates, however if you find it does, please be sure to try a development build from above, as we generally test new releases there until deemed stable.
What is LogBlock?
LogBlock is a tool which allows you to keep track of almost everything on your server, while also giving you the ability to rollback (revert) or redo changes made by users and natural occurrences such as liquid flow or leaf decay. Additionally, LogBlock is able to log and rollback chest contents, sign text and more! LogBlock was originally created by bootswithdefer for HMod, ported to Bukkit by DiddiZ and is now actively maintained by md_5, ammar2 and the community of developers on Bukkit. We accept pull requests on GitHub frequently which means that community developers can add features they wish to see quicker than LogBlock developers are able to from tickets. All database actions are run not only in their own threads, but are queued into a consumer to minimize lag on the main thread. This is great for larger servers! All optional features (not dependencies below) are enabled and disabled from within the config file allowing complete control over what is logged thus ensuring database size is kept to a minimum.
Notices
Most virtual chest plugins are not compatible with LogBlock. Because they do not set the player who is opening the “chest”, LogBlock can’t do what it’s meant to be able to do, thus, making errors in your console. Please report these issues to the fake-chest plugin developer, NOT LogBlock developers.
Issues are read more frequently on the GitHub Issues page as compared to the comments below. When updating to LB1.57, if you already have a large database and have changed your columns to MEDIUMINT, INT or LARGEINT, you do not need the updater to fix this for you automatically. To stop this behaviour, simply change “version” in the configuration to ‘1.57’.
If you are experiencing an error such as this please read the FAQ for answers.
If you're receiving errors regarding players from the consumer such as "[Consumer] Failed to add player <playername>" then change all `playerid` columns to MEDIUMINT or INT in each table that contains them. This may take a long time if you have a lot of rows.
Optional Dependencies
- WorldEdit (Recommended)
- Permissions plugin
- LogBlock Questioner
Need help?
Found a bug or an issue? Please report it (and attach code if you know how to squash it) on our ticket manager.
Just need help in general or have an urgent, more private bug? Join us on IRC at irc.esper.net #LogBlock and ping a +o or +v for faster help. Webchat is available here if you don't have a client, or prefer to use it.
As always, check if your question is on the FAQ before asking!
Installation
More Information
- FAQ (read me first!)
- Command reference
- Configuration
- Helpful Commands
- MySQL Connection Problems
- MySQL Schema
- SQL Queries
- Parameters
Are you a Developer?
If you wish to contribute to the LogBlock project, head on over to the GitHub page, fork the project and submit your pull request(s).
If you wish to develop a plugin that interacts with LogBlock in some way, read up on the API here. Support for API and more can be found in the IRC channel, which is listed above.
Developer builds can be found here. (These builds have not been approved by the BukkitDev staff. Use them at your own risk.)
Still need help? Join us on IRC at irc.esper.net #LogBlock and ping a +o or +v for faster help.
Please do not post comments requesting support. Report bugs here or, alternatively, talk to a real person. Commenting below is a surefire way to not receive help.
-
View User Profile
-
Send Message
Posted May 25, 2012@mtrc
that's because you are running a very outdated jar. Download the dev jar from the jenkins link above in the plugin description. The current version is 1.52, not 1.4.1 :)
-
View User Profile
-
Send Message
Posted May 25, 2012I'm having similar problems to GlassZ. The server is set up, and Bukkit reports no issues on loading LogBlock. The SQL server shows that the tables are set up correctly, and that one player (me) has been recorded as having joined. But all the entries for that player (such as the last login time) are set to 0. And no other actions are recorded - chat, block placement, etc.
I've enabled all of these in the config YAML files and so on, I've restarted the server since then, but I'm still not getting events logged properly. Any thoughts?
EDIT - My mistake, LB does report an error on startup:
Error occurred while enabling LogBlock v1.41 (Is it up to date?) java.lang.NoClassDefFoundError: org/bukkit/event/block/BlockListener
EDIT - This version certainly is behind the latest dev build. Why is that? Also LBQuestioner isn't on the dev build site, seemingly, which leads to LB reporting that LBQ is now out of date... Hmm. I'll take a look. Let me know if anyone has any thoughts.
-
View User Profile
-
Send Message
Posted May 24, 2012@GlassZ
you need to enable the worlds to be logged in the config and make sure that the separate world configs exist.
-
View User Profile
-
Send Message
Posted May 24, 2012I got the MySQL server set up with wamp, and the tables are created with no errors. The problem is, it's not logging anything besides player names. For this reason, any block checking returns 0 edits. Why aren't anything besides player names being logged?
-
View User Profile
-
Send Message
Posted May 23, 2012@TheCurlySheep
and that error would be...
-
View User Profile
-
Send Message
Posted May 23, 2012error where i cant connect or somthing??
-
View User Profile
-
Send Message
Posted May 22, 2012@tylercage12
You need to modify your MySQL table. The x and z columns are by default SMALLINT and need to be changed into MEDIUMINT. This will allow for larger x and z values. SMALLINT only allows for values up to 32767. I modify my tables for every new world on my server.
if you know SQL you could use something like this.
-
View User Profile
-
Send Message
Posted May 20, 2012@MarioG1 https://github.com/DiddiZ/LogBlockQuestioner/downloads
@tylercage12 use pastebin.com for long errors.. "Data truncation: Out of range value for column 'x' at row 1" read the wiki, there's a solution there.
@jimmybrite ./lb rollback player tnt since 1d
@rautamiekka change it in the config, add chests to a blacklist
@olimoli123 Are you using LogBlock 1.52 from the jenkins?
@GROMkill My apologies, I meant that LogBlock was not able to save it's config, that's what the error was for. You may have a folder permission problem.
-
View User Profile
-
Send Message
Posted May 19, 2012<<reply 714139="">>
I get this also It is s anoying
-
View User Profile
-
Send Message
Posted May 19, 2012Anyone know why I'm getting this?!!
19.05 12:00:23 [Multicraft] Skipped 926 lines due to rate limit (30/s) 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500217', 10, '500009');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500218', 10, '500009');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500219', 10, '500010');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500217', 10, '500010');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500218', 10, '500010');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500219', 10, '500011');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500217', 10, '500011');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500218', 10, '500011');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500219', 10, '500012');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442570), 7, 10, 49, 0, '500218', 10, '500012');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442568), 7, 10, 49, 0, '500211', 10, '500055');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] INFO [LogBlock] LogBlock v1.52 by DiddiZ enabled. 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442568), 7, 10, 49, 0, '500210', 10, '500056');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442568), 7, 10, 49, 0, '500211', 10, '500056');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442568), 7, 10, 49, 0, '500210', 10, '500057');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442568), 7, 10, 49, 0, '500211', 10, '500057');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442568), 7, 10, 49, 0, '500212', 10, '500058');': Data truncation: Out of range value for column 'x' at row 1 19.05 12:00:19 [Server] WARNING [LogBlock] Error while importing: 'INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337442568), 7, 10, 49, 0, '500210', 10, '500058');': Data truncation: Out of range value for column 'x' at row 1
-edit, and this when i try to log block in that area19.05 12:03:32 [Server] INFO at java.lang.Thread.run(Thread.java:722) 19.05 12:03:32 [Server] INFO at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34) 19.05 12:03:32 [Server] INFO at de.diddiz.LogBlock.Consumer.run(Consumer.java:292) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) 19.05 12:03:32 [Server] INFO at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591) 19.05 12:03:32 [Server] INFO com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'x' at row 1 19.05 12:03:32 [Server] SEVERE [LogBlock Consumer] SQL exception on INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337443405), 4, 2, 0, 0, '499697', 62, '499941');:
-
View User Profile
-
Send Message
Posted May 18, 2012@MarioG1
its hard to find but there is a logblockquestioner.jar out there that does just that. you have to confirm the purge of the rollback data
-
View User Profile
-
Send Message
Posted May 18, 2012Is there a way to disable clear-log after a rollback?
@jimmybrite
Logblock can rollback TNT but TNT is on the blacklist at default.
-
View User Profile
-
Send Message
Posted May 17, 2012@xSDMx I like it too, but it's kind of buggy! It Doesn't rollback tnt, and it doesn't purge properly.
-
View User Profile
-
Send Message
Posted May 17, 2012@nate302
Sorry, I will use pastebin next time. Do you mean residence as in the Residence plugin? And how could I fix the possible read/write permission problem?
-
View User Profile
-
Send Message
Posted May 17, 2012How to make LB not touch chests during rollback ? Chest's code is 54.
-
View User Profile
-
Send Message
Posted May 17, 2012@Eventzocker
That describes my issue perfectly!
On the plus side, not to advertise or anything, but I am really loving Coreprotect.
-
View User Profile
-
Send Message
Posted May 16, 2012@xSDMx
same with my server, the problem started 2 days ago.
while playing the server is just restarting, its not saving anything, nor shutting it down. when i look into the log file i see that me and my friends write to each other and a second later the server is just starting again, its starting like it was offline. the problem is, that the inventory and position of all players is resetted to a previous state like 3 hours ago. it doesnt sound like the problem would come from this plugin, but i didnt put any other new plugins on the server, i just installed this plugin a week ago and since 2 days its starting my server again, while it is already started. too bad, that there are no error messages at all in the log file, just the messages of a regular server start.
-
View User Profile
-
Send Message
Posted May 16, 2012@nate302 Any ideas what may be causing this? http://pastebin.com/DPAr2rsy Why would essentials intefere?
-
View User Profile
-
Send Message
Posted May 15, 2012@GROMkill
It's not letting residence create the file that doesn't exist. You may have a read/write permission problem for the folder. Use pastebin.com in the future :)
@brandonn1
use pastebin for errors, and be more specific. Posting a log doesn't help much.
@xSDMx
can you be more specific?
-
View User Profile
-
Send Message
Posted May 15, 2012Logblock seems to be crashing my server - this just started happening in the past two days.
I switched to Blocklog, but it isn't the same.
Are there any fixed, or reasonable alternatives to Logblock?