Inactive [SEC] BigBrother 1.11.0 - Catch griffers red-handed [1060]

Discussion in 'Inactive/Unsupported Plugins' started by N3X15, Apr 13, 2011.

Thread Status:
Not open for further replies.
  1. Offline

    N3X15

    [​IMG]
    Important Crap

    I'm done, but BB isn't.
    I've got 10 developers on the contributors' list who supposedly want to help, but I haven't heard a word from them since the day I added them. BigBrother's so full of bugs now that I don't know where to start, and I simply don't have the time or patience to work on it anymore. If you want something that works, pick up LogBlock. I'm fucking done. I updated it to "run" on 1060, but that's as far as I'm taking this. If you still want to help, email me at [email protected] and give me a rundown of your experience in coding plugins so I know you'll do something.​
    UPDATE: 3 developers have been added to the repo, but I'm waiting for them to get familiarized and start committing before I declare this crisis over. I appreciate the support and help that has been thrown this way. If you'd still like to help, but don't know how to code, there are many other ways to contribute. See the Contributors section for more info.​


    Version: 1.11.0
    Original Author: tkelly910

    Contributors
    • Development Team
      • N3X15
      • Mafio
      • FalconGaming
    • Quality Assurance (QA) Team (Testing, ONLY ON LATEST RB*!)
      • N3X15
      • Mineral
      • All of the poor bastards on the 7chan.org minecraft server + other dev servers
      • *NOTE: Unless EvilSeph or other bukkit devs indicate an RB is imminent, e.g. within the next week.
    • Bug Triage (Sorting through bugs, marking duplicates, closing, prioritizing)
      • N3X15
    • Documentation (Wiki, FAQ, other stuff people will read)
      • N3X15
    • MORE NEEDED. PLEASE PM ME IF YOU ARE INTERESTED IN TESTING OR DEVELOPING.
    Introduction

    BigBrother is a powerful plugin that enables you to investigate roll back griefing via a large and all-knowing database. You have a choice between using immensely powerful commands to search an area for changes, or you can whack a block with a stick or place a log to see changes within a single block.

    • /bb log - Gives you the BigBrother Multipurpose Tool, or a simple log. Hit something with it to see changes in that spot, and place it if the block you're check is non-solid, like water, lava or air.
    • /bb done - Removes the log from your inventory, and gives you back any items it replaced.
    • Want to check an entire area? Use /bb here to list who changed what!
    • Need to roll back EvilGuy and DoucheBug's edits? Use /bb rollback EvilGuy DoucheBug!
      • Have to roll back edits up to 5 minutes ago? Simple! /bb rollback t:5m
      • Need to only roll back within a certain radius? /bb rollback r:<radius-in-blocks>
      • Roll back specific actions with /bb rollback a:10,BLOCK_PLACE
    • If you screw up, /bb undo
    • (NEW) /bb history "Suspicious Guy" to see that player's recent history! (add pg:# to go to page #)
    • Mow your lawn with /bb mowlawn!
    See the full list of commands and Permissions nodes here.

    Screenshots

    [​IMG]
    [​IMG]
    [​IMG](Yes, stationary_* and regular blocks got reversed, this is fixed.)​
    [​IMG]

    Need Help?

    • What version of CraftBukkit and BigBrother? If you don't know, type /version and /bb version.
    • What database engine are you using? Look at the value for database.type in BigBrother.yml. I use MySQL on my server and test on H2.
    • Do you get any errors? If so, please link to a pastebin with your server.log
    • What steps do I have to take to reproduce this behavior?
    • What other plugins are you using?
    Known Issues
    • Everything listed here
    • ItemCraft is not supported due to it sending unexpected NULLs via Block.getType(). Can be fixed by adding a new enum value for unknown blocks.
    • Bugs everywhere, stopped counting.
    Coming Soon
    • /bb history - Gets the history of a player
    • Fixed /bb update
    • Updated API
    • Externally accessible API
    • Custom Action IDs (for WorldEdit support, etc.)
    More Information

    IRC: Support/Chatter/Developer Jive @ irc.7chan.org #bigbrother (Moved so my build notification bot has an easier time notifying multiple channels)

    Changelog
    BigBrother 1.11.0 Changelog
    • Centralize and update bystander checks.
    • Fix parsing errors in DeltaChest
    • Clarify /bb log
    • Fix sign lines being too far down
    • Add command censoring (for people worried about xAuth and the like)
    • Fix pagination capping
    • Fix an error in DeltaChest reading
    • Add ?autoReconnect=true to the MySQL DSN
    • Remove all H2 support
    • Removed /bb stick from /bb help since it is now obsolete
    • Fixed it so commands that work won't say commands not recognized after they already work
    • Fixed the issue of when you had the /bb log if you broke something it would not record the break even if you were watched
    • Now if the user tries to find the history of an invalid user it won't throw null errors.
    • Yell at the users if they don't follow the setup procedure
    • Should fix most of the errors dealing with the log and watch/unwatch problems
    • Update README
    1.10.0+ (open)

    BigBrother 1.10.1 Changelog
    • Fix a rollback SQL syntax error
    • Fix explosion logging
    • Clarify database trimming message in log
    • Fix /bb history
    • Continue rolling back incorrectly-logged BlockBurns, if the data field is unparsable, default to 0.
    • Fix Heartbeat logging
    • Fix SuperPerms support.
    BigBrother 1.10.0 Changelog

    New Features:
    • Brand new plugin API! (Wiki)
    • Database change. There is now a converter, but you might still lose data!
    • Compact chest changes: (+Added)(=Replaced)(-Removed)
    • Heartbeat Action: Logs users online and the current time, both to keep your database connection open, and for monitoring of your server's uptime!
    • Piston Actions!
    • Bukkit Superperms support!
    • RB 1000 support!
    • /bb history!
    • Formatting fix for rollbacks
    • A buttload of NPE fixes
    Bugfixes:


    • [BB-81] Rollback doesn't work because of empty data-values
    • [BB-78/BB-69] onPickupItem/onDropItem NPEs
    • Memory leak fix (Thanks to Wootalyzer!)
    BigBrother 1.9.1:

    • Use BlockSpreadEvent for tracking fires (later told by EvilSeph that there's no current way to track fire in Bukkit)
    • Display a "Permission Denied" to users trying to use commands with insufficient priviliges instead of silently failing.
    • Add /bb mowlawn.
    • Fix stupid mixup between String.format usage on C# and Java in DeltaChest
    • Automatically update plugin.yml via Maven (internal crap)
    BigBrother 1.9


    • Support for 928+
    • NEW: Lava/Water/Fire flow logging (AND ACTUALLY TESTED, FOR ONCE!)
    • NEW: a: directive for rollbacks, for specifying comma-delimited action IDs to track
    • Lots and lots of bugfixes.
    • Marginally better H2 support
    • More automated tests
    • Standardized QA tests (ongoing)
     
  2. Offline

    Sadaki

    Note: The returned error where BB attempts to create a database file and table when one already exists (ie half the errors people are posting in the thread) is still occurring. It has been stated before that this is a nonfatal error, but it is still quite the space hogger in the log.

    Also, has the output of the cleanser thread to log been squelched yet?
     
  3. Offline

    defthefirst

    Here is my error list when i try to /bb rollback player t:10m, but the others rollback do the same, i call give you more informations to help, just ask this plugin is awsome.
    The rollback works, but the error stay, i removed all item tracking, the last time i tested it my console has been error flooded, Bukkit 677 maybe not compatible ?
    Code:
    2011-04-17 00:27:46 [SEVERE] [BBROTHER] Rollback edit SQL Exception: UPDATE  bbdata AS bbdataSET rbacked = true WHERE action IN('0','1','4','12','2','13','15','16','17','19','20') AND player IN ('2') AND date > '1302992806' AND rbacked = false;
    org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "UPDATE  BBDATA AS BBDATASET RBACKED[*] = TRUE WHERE ACTION IN('0','1','4','12','2','13','15','16','17','19','20') AND PLAYER IN ('2') AND DATE > '1302992806' AND RBACKED = FALSE; "; expected "SET"; SQL statement:
    UPDATE  bbdata AS bbdataSET rbacked = true WHERE action IN('0','1','4','12','2','13','15','16','17','19','20') AND player IN ('2') AND date > '1302992806' AND rbacked = false; [42001-153]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.getSyntaxError(DbException.java:192)
        at org.h2.command.Parser.read(Parser.java:2737)
        at org.h2.command.Parser.parseUpdate(Parser.java:658)
        at org.h2.command.Parser.parsePrepared(Parser.java:423)
        at org.h2.command.Parser.parse(Parser.java:275)
        at org.h2.command.Parser.parse(Parser.java:247)
        at org.h2.command.Parser.prepare(Parser.java:201)
        at org.h2.command.Parser.prepareCommand(Parser.java:214)
        at org.h2.engine.Session.prepareLocal(Session.java:426)
        at org.h2.engine.Session.prepareCommand(Session.java:374)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
        at me.taylorkelly.bigbrother.rollback.Rollback$Rollbacker.run(Rollback.java:200)
     
  4. Offline

    N3X15

    DELTA_CHEST logging fix committed, requires a database change but it should be done automatically. Going to test it before I make it a Recommended build.

    After that, I'm going to take another crack at fixing rollbacks.
     
  5. Offline

    TheBeast808

    You should create a version that uses SQLite rather then MySQL, because I cba to figure it out when SQLite is so easy.
     
  6. Offline

    anonymous

    Glad to see BB is being worked on.
     
  7. Offline

    xZise

    Hi, nice that you proceed with supporting BigBrother. I installed it now, but how could I get the status of chests? And could you please log the furnace changes. I mean it behaves like a chest.

    Fabian
     
  8. Offline

    andrewkm

    [677] [338]
    Everytime trying to rollback /bb rollback username t:1m for example

    Code:
    2011-04-16 23:36:24 [SEVERE] [BBROTHER] Rollback get SQL Exception
    java.sql.SQLException: Position 'pos' can not be < 1
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
     at com.mysql.jdbc.Blob.getBytes(Blob.java:134)
     
  9. Offline

    WolwX

    677 for me and still stuck on those numerous error (using default settings) :

    Code:
    2011-04-17 05:34:15 [SEVERE] Could not pass event PLAYER_PICKUP_ITEM to BigBrother
    java.lang.NullPointerException
        at me.taylorkelly.bigbrother.datablock.PickupItem.<init>(PickupItem.java:12)
        at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerPickupItem(BBPlayerListener.java:138)
        at org.bukkit.plugin.java.JavaPluginLoader$16.execute(JavaPluginLoader.java:294)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:255)
        at net.minecraft.server.EntityItem.b(EntityItem.java:204)
        at net.minecraft.server.EntityHuman.i(EntityHuman.java:205)
        at net.minecraft.server.EntityHuman.r(EntityHuman.java:197)
        at net.minecraft.server.EntityPlayer.r(EntityPlayer.java:199)
        at net.minecraft.server.EntityLiving.f_(EntityLiving.java:231)
        at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
        at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:260)
        at net.minecraft.server.Packet10Flying.a(SourceFile:126)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-17 05:34:15 [SEVERE] Could not pass event PLAYER_PICKUP_ITEM to BigBrother
    java.lang.NullPointerException
        at me.taylorkelly.bigbrother.datablock.PickupItem.<init>(PickupItem.java:12)
        at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerPickupItem(BBPlayerListener.java:138)
        at org.bukkit.plugin.java.JavaPluginLoader$16.execute(JavaPluginLoader.java:294)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:255)
        at net.minecraft.server.EntityItem.b(EntityItem.java:204)
        at net.minecraft.server.EntityHuman.i(EntityHuman.java:205)
        at net.minecraft.server.EntityHuman.r(EntityHuman.java:197)
        at net.minecraft.server.EntityPlayer.r(EntityPlayer.java:199)
        at net.minecraft.server.EntityLiving.f_(EntityLiving.java:231)
        at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
        at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:260)
        at net.minecraft.server.Packet10Flying.a(SourceFile:126)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    Anyone have any solution ?
     
  10. Offline

    andrewkm

    try [677] + [334] best combo imo well for me atleast at the moment.
     
  11. Offline

    Sooks

    I"m sticking to LogBlock until this thing doesn't have as many people experiencing errors!
     
  12. Offline

    andrewkm

    [677] + [334] is perfect
    There are absolutely no problems, log block sucks lol
    Big Brother is honestly mint and PERFECT using above combination!
     
  13. Offline

    Sooks

    Uh not what I've heard I'll try it after minecraft gets 1.5
     
  14. Offline

    but2002

    By default it uses an H2 database (Similar to SQLite, but faster). However. I highly recommend you use MySQL, otherwise BigBrother will become slower than a toked out snail, because file-based databases are EXTREMELY slow compared to MySQL.
     
  15. Offline

    jareq

    hi, when im typing /bb help i can see help - but when i type /bb here or any else command - nothing happens.
    Why is that ? Im in op.txt file and in Admins group wich have bb.admin.* permission
     
  16. Offline

    Black_Jack

    Code:
    17:47:48 [SEVERE] Could not pass event PLAYER_PICKUP_ITEM to BigBrother
    java.lang.NullPointerException
            at me.taylorkelly.bigbrother.datablock.PickupItem.<init>(PickupItem.java:12)
            at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerPickupItem(BBPlayerListener.java:138)
            at org.bukkit.plugin.java.JavaPluginLoader$16.execute(JavaPluginLoader.java:294)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:255)
            at net.minecraft.server.EntityItem.b(EntityItem.java:204)
            at net.minecraft.server.EntityHuman.i(EntityHuman.java:205)
            at net.minecraft.server.EntityHuman.r(EntityHuman.java:197)
            at net.minecraft.server.EntityPlayer.r(EntityPlayer.java:199)
            at net.minecraft.server.EntityLiving.f_(EntityLiving.java:231)
            at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
            at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:260)
            at net.minecraft.server.Packet10Flying.a(SourceFile:126)
            at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    
     
  17. Offline

    N3X15

    Hey guys. Got some much-needed sleep last night, so I'll get to the BLOB errors in a sec.

    Sorry this shit is so goddamn buggy.

    EDIT: Try build 340 if you have BLOB-related errors. Moving on to the other exceptions.

    Working on this; Bukkit changed how they handle ItemStacks in 677, so I'm getting info from the bukkit devs before proceeding so I know how to handle the errors correctly.

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

    Whysopro

    Alright so,

    Me and another guy just got box acces on a server, and we're supposed to fix the BB on it. We've tried checking the wiki for any guide on updating it, but that page doesn't exist for some reason. Can we just download the latest bigbrother.jar and replace it with the one currently in the server? (Since apperantly it has something to do with MySQL aswell????) Or do we have to edit more files?
     
  19. Offline

    N3X15

    Depending on how old it is, you may have to delete your BB database (database upgrades take a LONG time), but other than that, it should auto-upgrade.

    Also, Build 341 fixes PLAYER_ITEM_PICKUP exceptions.
     
  20. Offline

    Whysopro

    I have no idea how old it is, I'm guessing it was the latest released version of the old thread.
    How would we go about updating/deleting BB database? Does that automatically happen when you replace the .jar? Because it's not the database we need to update, just BB itself (Unless that somehow connects to eachother updating-wise)
     
  21. Offline

    MacVaultDweller

    List of errors i'm getting with the latest version of bb and cb 617


    14:05:04 [SEVERE] tried to access class org.anjocaido.groupmanager.GroupManager$1 from class org.anjocaido.groupmanager.GroupManager loading BedrockControl v1.3 (Is it up to date?)
    java.lang.IllegalAccessError: tried to access class org.anjocaido.groupmanager.GroupManager$1 from class org.anjocaido.groupmanager.GroupManager
    at org.anjocaido.groupmanager.GroupManager.enableScheduler(GroupManager.java:106)
    at org.anjocaido.groupmanager.GroupManager.onEnable(GroupManager.java:83)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:514)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
    at com.nijikokun.bukkit.Permissions.Permissions.onEnable(Permissions.java:61)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:514)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
    at com.nijikokun.bukkit.Permissions.Permissions.checkEnable(Permissions.java:95)
    at com.nijikokun.bukkit.Permissions.Permissions.getHandler(Permissions.java:85)
    at nl.robinvandervliet.BedrockControl.BedrockControl.onEnable(BedrockControl.java:53)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:514)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:94)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:72)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    14:05:04 [INFO] [BBROTHER] ------------------------------------
    14:05:04 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother!
    14:05:04 [INFO] [BBROTHER] Please note that, since this is far from complete, there will be many bugs.
    14:05:04 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON http://bugs.nexisonline.net/bb
    14:05:04 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for updates and build notifications.
    14:05:04 [INFO] [BBROTHER] ------------------------------------
    14:05:05 [INFO] [BBROTHER] Building `bbdata` table...
    14:05:05 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    14:05:06 [SEVERE] [BBROTHER] Create World Table SQL Exception
    org.h2.jdbc.JdbcSQLException: Table "BBWORLDS" already exists; SQL statement:
    CREATE TABLE `bbworlds` (`id` INTEGER PRIMARY KEY,`name` varchar(50) NOT NULL DEFAULT 'world'); [42101-153]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.get(DbException.java:144)
    at org.h2.command.ddl.CreateTable.update(CreateTable.java:108)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:125)
    at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110)
    at me.taylorkelly.bigbrother.WorldManager.createWorldTable(WorldManager.java:100)
    at me.taylorkelly.bigbrother.WorldManager.<init>(WorldManager.java:20)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:143)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:118)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:514)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:94)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:72)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    14:05:06 [INFO] [BBROTHER] Building `bbusers` table...
    14:05:06 [INFO] [BBROTHER] Permissions enabled using: GroupManager v1.0(alpha-5)
    14:05:07 [INFO] [BBROTHER] 'Help' support enabled
    14:05:07 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT enabled
     
  22. Offline

    Edgard Mok

    Code:
    20:38:39 [GRAVE] [BBROTHER] Could not executeUpdate for Upgrading to BLOBs inste
    ad of VARCHAR.:
    org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "ALTER TABLE ""BBDAT
    A"" CHANGE[*] ""DATA"" ""DATA"" BLOB NOT NULL "; expected "., ADD, SET, RENAME,
    DROP, ALTER"; SQL statement:
    ALTER TABLE `bbdata` CHANGE `data` `data` BLOB NOT NULL [42001-153]
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
            at org.h2.message.DbException.get(DbException.java:167)
            at org.h2.message.DbException.getSyntaxError(DbException.java:192)
            at org.h2.command.Parser.getSyntaxError(Parser.java:487)
            at org.h2.command.Parser.parseAlterTable(Parser.java:4774)
            at org.h2.command.Parser.parseAlter(Parser.java:4162)
            at org.h2.command.Parser.parsePrepared(Parser.java:302)
            at org.h2.command.Parser.parse(Parser.java:275)
            at org.h2.command.Parser.parse(Parser.java:251)
            at org.h2.command.Parser.prepare(Parser.java:201)
            at org.h2.command.Parser.prepareCommand(Parser.java:214)
            at org.h2.engine.Session.prepareLocal(Session.java:426)
            at org.h2.engine.Session.prepareCommand(Session.java:374)
            at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
            at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
    1)
            at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
            at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.jav
    a:83)
            at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.jav
    a:99)
            at me.taylorkelly.bigbrother.fixes.Fix6.apply(Fix6.java:26)
            at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:175)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:578)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:216)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
            at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    20:38:39 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.5.5


    Strange. Any idea ?
     
  23. Offline

    Whysopro

    Well me and the other guy just tried replacing the BigBrother.jar in the server, and it doesn't seem to be doing anything, the commands don't work ingame after a restart.
     
  24. Offline

    WolwX

    just add the right settings

    Code:
    watched:
        environment:
            lava-flow: true
            leaf-decay: true
        player:
            drop-item: false
            ip-player: true
            disconnect: true
            login: true
            pickup-item: false
            teleport: true
    Because actually player drop-item and player pickup-item are not correctly integrated
     
  25. Offline

    mb01

    We have approximately 12.000.000 entries on our table, do you think that's too much for the auto-upgrade?
    Thanks.
     
  26. Offline

    ChadTheDJ

    Any chance of MultiVerse (multi world) support? It seems it logs the default world just fine but nothing in the other worlds.
     
  27. Offline

    cartman-2000

    ^ It does log mutiple worlds, I have 3 on my server, 2 normal worlds, one with hostile mobs and one without, and a nether world, and BB works between them.

    I had ~20-22 million records(2.2-2.4gb database.) in my mysql db at one time it took a few minutes to update it, in the previous major DB change, although it didn't complete correctly, only converted one playername to the new style so I reset the db(deleted the BB tables and let them be recreated.) and started with a new one. This last db change, changing the data field to a blob, only took about 1 and a half minutes to complete with 7 million records. Running my server and the mysql db on a core i7 2600k and using the 64bit version of mysql v5.1.56 on windows 7 .
     
  28. Offline

    Arrorn

    I have the same error as Edgar Mok : page 4

    Code:
    2011-04-17 17:53:11 [SEVERE] [BBROTHER] Could not executeUpdate for Upgrading to BLOBs instead of VARCHAR.:
    org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "ALTER TABLE ""BBDATA"" CHANGE[*] ""DATA"" ""DATA"" BLOB NOT NULL "; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
    ALTER TABLE `bbdata` CHANGE `data` `data` BLOB NOT NULL [42001-153]
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
            at org.h2.message.DbException.get(DbException.java:167)
            at org.h2.message.DbException.getSyntaxError(DbException.java:192)
            at org.h2.command.Parser.getSyntaxError(Parser.java:487)
            at org.h2.command.Parser.parseAlterTable(Parser.java:4774)
            at org.h2.command.Parser.parseAlter(Parser.java:4162)
            at org.h2.command.Parser.parsePrepared(Parser.java:302)
            at org.h2.command.Parser.parse(Parser.java:275)
            at org.h2.command.Parser.parse(Parser.java:251)
            at org.h2.command.Parser.prepare(Parser.java:201)
            at org.h2.command.Parser.prepareCommand(Parser.java:214)
            at org.h2.engine.Session.prepareLocal(Session.java:426)
            at org.h2.engine.Session.prepareCommand(Session.java:374)
            at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
            at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
            at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
            at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:83)
            at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:99)
            at me.taylorkelly.bigbrother.fixes.Fix6.apply(Fix6.java:26)
            at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:175)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:216)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:203)
            at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:258)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    
     
  29. Offline

    footwo

    I get something similar. I've dropped all bb related tables and it recreates the bbworlds/bbusers fine, it just will not create the bbdata table:

    Code:
    2011-04-17 22:16:45 [SEVERE] [BBROTHER] Can't create the bbdata table
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'data' can't have a default value
        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.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.StatementImpl.executeUpdate(StatementImpl.java:1662)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
        at me.taylorkelly.bigbrother.tablemgrs.DBTable.createTable(DBTable.java:64)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.<init>(BBDataTable.java:55)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataMySQL.<init>(BBDataMySQL.java:16)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTable.java:43)
        at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:145)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
        at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-17 22:16:45 [SEVERE] [BBROTHER] Could not retreive table information.
    java.sql.SQLException: Illegal operation on empty result set.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:841)
        at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5656)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5576)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataMySQL.getEngine(BBDataMySQL.java:141)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataMySQL.checkDBEngine(BBDataMySQL.java:93)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataMySQL.onLoad(BBDataMySQL.java:83)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.<init>(BBDataTable.java:61)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataMySQL.<init>(BBDataMySQL.java:16)
        at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTable.java:43)
        at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:145)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
        at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-17 22:16:45 [INFO] [BBROTHER] BBData MySQL Driver r1 loaded!
    2011-04-17 22:16:45 [INFO] [BBROTHER] Updating tables for 1.8
    2011-04-17 22:16:45 [SEVERE] [BBROTHER] Could not executeUpdate for Upgrading to BLOBs instead of VARCHAR.:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minecraft.bbdata' doesn't exist
        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.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:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
        at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:86)
        at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:99)
        at me.taylorkelly.bigbrother.fixes.Fix6.apply(Fix6.java:26)
        at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:175)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
        at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
     
  30. Offline

    andrewkm

    +1 mysql is a MUST for this plugin!
     
  31. Offline

    JavaJosh

    I'm getting the same error as footwo :(
     
Thread Status:
Not open for further replies.

Share This Page