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

    Blazednlovinit

    how much of a footprint does this plugin leave on a server? with all the things it does it seems like it may be quite intensive
     
  3. Offline

    Raqn

    Just registered to say this is seriously the best plugin I have ever installed on my server. Grieving is so easy for me to moderate unlike before. Thanks so much for making this.
     
  4. Offline

    quickclay

    After updating to build 429 from 405, I get the following errors on startup:

    2011-05-08 09:52:48 [INFO] [BBROTHER] ------------------------------------
    2011-05-08 09:52:48 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother!
    2011-05-08 09:52:48 [INFO] [BBROTHER] Please note that, since this is far from complete, there will be many bugs.
    2011-05-08 09:52:48 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON http://bugs.nexisonline.net/bb
    2011-05-08 09:52:48 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for updates and build notifications.
    2011-05-08 09:52:48 [INFO] [BBROTHER] ------------------------------------
    2011-05-08 09:52:48 [INFO] [BBROTHER] Building `bbdata` table...
    2011-05-08 09:52:48 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NOT EXISTS `bbdata` (`id` INTEGER AUTO_INCREMENT PRIMARY KEY,`date` INT UNSIGNED NOT NULL DEFAULT '0',`player` INT UNSIGNED NOT NULL DEFAULT '0',`action` tinyint NOT NULL DEFAULT '0',`world` tinyint NOT NULL DEFAULT '0',`x` int NOT NULL DEFAULT '0',`y` tinyint UNSIGNED NOT NULL DEFAULT '0',`z` int NOT NULL DEFAULT '0',`type` smallint NOT NULL DEFAULT '0',`data` TEXT NOT NULL DEFAULT '',`rbacked` boolean NOT NULL DEFAULT '0');CREATE INDEX dateIndex on bbdata (date);CREATE INDEX playerIndex on bbdata (player);CREATE INDEX actionIndex on bbdata (action);CREATE INDEX worldIndex on bbdata (world);CREATE INDEX posIndex on bbdata (x,y,z);CREATE INDEX typeIndex on bbdata (type);CREATE INDEX rbackedIndex on bbdata (rbacked);):
    org.h2.jdbc.JdbcSQLException: Index "DATEINDEX" already exists; SQL statement:
    CREATE INDEX dateIndex on bbdata (date);CREATE INDEX playerIndex on bbdata (player);CREATE INDEX actionIndex on bbdata (action);CREATE INDEX worldIndex on bbdata (world);CREATE INDEX posIndex on bbdata (x,y,z);CREATE INDEX typeIndex on bbdata (type);CREATE INDEX rbackedIndex on bbdata (rbacked); [42111-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.CreateIndex.update(CreateIndex.java:76)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.command.CommandList.update(CommandList.java:41)
    at org.h2.command.CommandList.executeRemaining(CommandList.java:36)
    at org.h2.command.CommandList.update(CommandList.java:42)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
    at me.taylorkelly.bigbrother.datasource.BBDB.executeUpdate(BBDB.java:241)
    at me.taylorkelly.bigbrother.tablemgrs.DBTable.createTable(DBTable.java:35)
    at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.<init>(BBDataTable.java:57)
    at me.taylorkelly.bigbrother.tablemgrs.BBDataH2.<init>(BBDataH2.java:13)
    at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTable.java:47)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:115)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:632)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-08 09:52:48 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    2011-05-08 09:52:48 [INFO] [BBROTHER] Building `bbworlds` table...
    2011-05-08 09:52:48 [INFO] [BBROTHER] Building `bbusers` table...
    2011-05-08 09:52:48 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NOT EXISTS `bbusers` (`id` INT AUTO_INCREMENT PRIMARY KEY,`name` varchar(32) NOT NULL DEFAULT 'Player',`flags` INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX idxUsername ON `bbusers` (`name`)):
    org.h2.jdbc.JdbcSQLException: Index "IDXUSERNAME" already exists; SQL statement:
    CREATE TABLE IF NOT EXISTS `bbusers` (`id` INT AUTO_INCREMENT PRIMARY KEY,`name` varchar(32) NOT NULL DEFAULT 'Player',`flags` INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX idxUsername ON `bbusers` (`name`) [42111-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.CreateIndex.update(CreateIndex.java:76)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.CommandList.executeRemaining(CommandList.java:36)
    at org.h2.command.CommandList.update(CommandList.java:42)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
    at me.taylorkelly.bigbrother.datasource.BBDB.executeUpdate(BBDB.java:241)
    at me.taylorkelly.bigbrother.tablemgrs.DBTable.createTable(DBTable.java:35)
    at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.<init>(BBUsersTable.java:67)
    at me.taylorkelly.bigbrother.tablemgrs.BBUsersH2.<init>(BBUsersH2.java:11)
    at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.getInstance(BBUsersTable.java:54)
    at me.taylorkelly.bigbrother.BBPlayerInfo.<init>(BBPlayerInfo.java:50)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:117)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:632)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-08 09:52:48 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.7
    2011-05-08 09:52:49 [INFO] [BBROTHER] 'Help' support enabled
    2011-05-08 09:52:49 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT (build #429) enabled!

    CB740

    EDIT: I downgraded to build #419 and the problem remained. Downgraded to #410 and it still remained. At #409 the problem was gone.
     
  5. Offline

    Lil_Lyon

    When updating to 429 it added duplicate fields to the setting .yml. These need to be filled in for bb to function properly.

    Just a heads up.
     
    vapid2323 likes this.
  6. Offline

    Radix

    Hi guys,

    I have downloaded the most recent BigBrother with the intention of using it with SQLite,

    I have placed sqlite.jar in both the minecraft root directory and in the Bigbrother directory and changed the bigbrother.yml to "sqlite"

    Anyway whatever i am doing i am doing it wrong because it absolutely wont work, its not logging anything. Can someone please take a look at my bigbrother.yml and tell me where i am going wrong here, i'd really appreciate it.

    Code:
    general:
        rollbacks-per-tick: 2000
        personal-log-files: false
        auto-watch: true
        debug-mode: false
        default-search-radius: 2
        restore-fire: false
        stick-item: 280
        library-autodownload: true
    database:
        cleanse-age: 3d
        deletes-per-cleansing: '20000'
        max-records: '3000000'
        type: sqlite
        send-delay: 4
        mysql:
            port: 3306
            username: minecraft
            engine: MyISAM
            prefix: ''
            low-priority-insert: true
            hostname: localhost
            password: ''
            database: minecraft
    watched:
        environment:
            lava-flow: false
            leaf-decay: false
        player:
            ip-player: true
            disconnect: true
            login: true
            teleport: true
        explosions:
            tnt: true
            creeper: true
            misc: true
        chat:
            commands: true
            chat: true
        blocks:
            chest-changes: true
            block-place: true
            block-break: true
        misc:
            flint-logging: true
            door-open: false
            lever-switch: false
            button-press: false
    
     
  7. Offline

    vapid2323

    Thanks for posting that!
     
  8. Offline

    BlackCore

    Confirming that,EXACTLY looking error.
    Also:When someone is saying something in chat...

    Code:
    23:27:20 [SEVERE] [BBROTHER] onPlayerChat(org.bukkit.event.player.PlayerChatEvent@5578cce2)
    java.lang.NoClassDefFoundError: me/taylorkelly/bigbrother/datablock/Chat
            at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerChat(BBPlayerListener.java:153)
            at org.bukkit.plugin.java.JavaPluginLoader$6.execute(JavaPluginLoader.java:236)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:646)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:634)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
            at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    
     
  9. Offline

    Randy Schouten

    The Snapshot link doesn't work for me...
     
  10. Offline

    NeatMonster

    Ticket opened.
     
  11. Offline

    N3X15

    Fffff. Tomcat (the server hosting ci.nexisonline.net) crashed again. I need another stick of DDR2. :|

    Once the server's done flailing around, there should be a new build up for BigBrother that imports the old config.

    I've got a bunch of shit to do today, so I may not get around to fixing the pickup bug.
     
  12. Offline

    LucidLethargy

    I am getting the exact same error. Staying on 409 until it's figured out.
     
  13. Offline

    ScottSpittle

     
  14. Offline

    cholo71796

    Where can I check the most recent time a player has logged in/off? I know BigBrother logs it, but do I have to check the database or is there a command?
     
  15. Offline

    Zeroi9

    I woke up today and saw my server.log file had gone from 11mb to 992mb over one night.
    I checked the logs. Seems like BB spams insane amounts of stuff in the log. Cleaned it up, went out a couple of hours.
    Now it's 400mb.

    Code:
    .server.ItemBlock.a(ItemBlock.java:74)
    	at net.minecraft.server.ItemStack.placeItem(ItemStack.java:56)
    	at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:217)
    	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:521)
    	at net.minecraft.server.Packet15Place.a(SourceFile:57)
    	at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
    	at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
    	at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    	at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:
    
    
    All I could catch.
    Also saw "bbusers", using mysql.
     
  16. Offline

    Kartus

    in mysql DB i have following textes in column "data" since ca. 2 weeks:
    Code:
    [BLOB - 5 Bytes]
    i'm logging chat, so i can't see, what my players chattext is? = logging chat broken/useless?
     
  17. Offline

    Lil_Lyon

    Open the blob and read the data if it is that important. A much more practical way would to just read the server log.

    I use mySQL workbench to read mine when I have to.
     
  18. Does anybody elses server restart after each rollback of a player?
    When I rollback a player by entering '/bb rollback JohnLennon ' it will undoubtedly restart my server but sometimes (rarely) if I type '/bb rollback JohnLennon r:10' it will just rollback as it should with no need to restart.

    Might just be on my end but If anybody can assist me with this I'd be very grateful.
     
  19. Offline

    ALufkin24

    I've added the bb to my permissions and such. But when I try it with permissions, it said 'Go to bb configuration or webaddy. It was working fine till I add permissions. Any help is great! Thanks!~
     
  20. Offline

    Kartus

    The problem is, that my server.log will be reset after every server restart. i one have daily restart + manual restarts. it only makes a server.old.log. but this only logs the period from 2nd last to last restart. so the maximum will be logged is 48h = too less.
     
  21. Offline

    Stephen92

    all the builds keep telling me that whenever I type /bb stick that the commands are unrecognized by bb and I have it setup like I use to before all this stuff messed up, im using 764 for the bukkit build and i've used several other builds as well as builds from your github or w/e and they all say the same.
     
  22. Offline

    Kartus

    i have same issues. try BB #409, its working for me at bukkit #740
     
  23. Offline

    Ethan Hall

    Snapshot link is broken/server hosting the file is down.
     
  24. Offline

    Spathizilla

    Out of interest, what sort of load increases/memory usage increase do people see after installing BB?
     
  25. Offline

    ThorSve33

    I used the Mac OSX installer for MySQL. It appeared to install properly, but when I went to use the provided setup commands, they weren't recognized by Terminal. Any help? I'm running Mac OS X 10.6. I have no clue as to why it isn't working...HALP

    [EDIT] I installed it properly now, but i get this on startup: pastebin.com
     
  26. Offline

    NeatMonster

    Is possible to log what users loose when they died ?
     
  27. Offline

    Kartus

    i found bug in BB #433 and earlier. the DB connection informations in config will be reset all time at restart:
    Code:
        username: ''
        password: ''
        hostname: ''
        database: ''
    so it's not possible to connect to mysql DB with empty values :oops: N3X, please fix this. but i got an easy myself fix working -> delete following 2 files in /plugins/BigBrother:
    DATABASE_VERSION​
    VERSION​

    After that fill in your MySQL-DB username, password, hostname, database in bigbrother config, restart server, and it works!
     
  28. Offline

    Evotr1p197

    Where is the Download link? : ) Sorry dont found him :/

    Sorry foundet : D

    Me fool ^^

    I tested it and its a VERY GREAT Plugin! Thank you : )

    Is there a function like /bb unwatch ????? because i want to remove some who are watched : )
     
  29. Offline

    Kalais

    Is this normal at startup?
    Show Spoiler

    09:23:30 [INFO] [BBROTHER] ------------------------------------
    09:23:32 [INFO] [BBROTHER] Building `bbdata` table...
    09:23:32 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NOT EXISTS `b
    bdata` (`id` INTEGER AUTO_INCREMENT PRIMARY KEY,`date` INT UNSIGNED NOT NULL DEF
    AULT '0',`player` INT UNSIGNED NOT NULL DEFAULT '0',`action` tinyint NOT NULL DE
    FAULT '0',`world` tinyint NOT NULL DEFAULT '0',`x` int NOT NULL DEFAULT '0',`y`
    tinyint UNSIGNED NOT NULL DEFAULT '0',`z` int NOT NULL DEFAULT '0',`type` smalli
    nt NOT NULL DEFAULT '0',`data` TEXT NOT NULL DEFAULT '',`rbacked` boolean NOT NU
    LL DEFAULT '0');CREATE INDEX dateIndex on bbdata (date);CREATE INDEX playerIndex
    on bbdata (player);CREATE INDEX actionIndex on bbdata (action);CREATE INDEX wor
    ldIndex on bbdata (world);CREATE INDEX posIndex on bbdata (x,y,z);CREATE INDEX t
    ypeIndex on bbdata (type);CREATE INDEX rbackedIndex on bbdata (rbacked);):
    org.h2.jdbc.JdbcSQLException: Index "DATEINDEX" already exists; SQL statement:
    CREATE INDEX dateIndex on bbdata (date);CREATE INDEX playerIndex on bbdata (play
    er);CREATE INDEX actionIndex on bbdata (action);CREATE INDEX worldIndex on bbdat
    a (world);CREATE INDEX posIndex on bbdata (x,y,z);CREATE INDEX typeIndex on bbda
    ta (type);CREATE INDEX rbackedIndex on bbdata (rbacked); [42111-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.CreateIndex.update(CreateIndex.java:76)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.command.CommandList.update(CommandList.java:41)
    at org.h2.command.CommandList.executeRemaining(CommandList.java:36)
    at org.h2.command.CommandList.update(CommandList.java:42)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedS
    tatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement
    .java:129)
    at me.taylorkelly.bigbrother.datasource.BBDB.executeUpdate(BBDB.java:243
    )
    at me.taylorkelly.bigbrother.tablemgrs.DBTable.createTable(DBTable.java:
    35)
    at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.<init>(BBDataTable.ja
    va:57)
    at me.taylorkelly.bigbrother.tablemgrs.BBDataH2.<init>(BBDataH2.java:13)

    at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTab
    le.java:47)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:115)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:632)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:218)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    09:23:32 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    09:23:32 [INFO] [BBROTHER] Building `bbworlds` table...
    09:23:32 [INFO] [BBROTHER] Building `bbusers` table...
    09:23:32 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NOT EXISTS `b
    busers` (`id` INT AUTO_INCREMENT PRIMARY KEY,`name` varchar(32) NOT NULL DEFAULT
    'Player',`flags` INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX idxUsername ON `
    bbusers` (`name`)):
    org.h2.jdbc.JdbcSQLException: Index "IDXUSERNAME" already exists; SQL statement:

    CREATE TABLE IF NOT EXISTS `bbusers` (`id` INT AUTO_INCREMENT PRIMARY KEY,`name`
    varchar(32) NOT NULL DEFAULT 'Player',`flags` INT NOT NULL DEFAULT '0');CREATE
    UNIQUE INDEX idxUsername ON `bbusers` (`name`) [42111-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.CreateIndex.update(CreateIndex.java:76)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.CommandList.executeRemaining(CommandList.java:36)
    at org.h2.command.CommandList.update(CommandList.java:42)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedS
    tatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement
    .java:129)
    at me.taylorkelly.bigbrother.datasource.BBDB.executeUpdate(BBDB.java:243
    )
    at me.taylorkelly.bigbrother.tablemgrs.DBTable.createTable(DBTable.java:
    35)
    at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.<init>(BBUsersTable.
    java:67)
    at me.taylorkelly.bigbrother.tablemgrs.BBUsersH2.<init>(BBUsersH2.java:1
    1)
    at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.getInstance(BBUsersT
    able.java:54)
    at me.taylorkelly.bigbrother.BBPlayerInfo.<init>(BBPlayerInfo.java:50)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:117)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:632)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:218)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)



     
  30. Offline

    MangoStarr

    I'm also having the problem where BB will spam my server log making it go up to nearly 1GB in one day. I've tried replacing the .jar but that didn't seem to do anything... BB seems to work fine In-Game, though..

    Anyone help?
     
  31. Offline

    Skrip037

    Hey guys, having a self-describing issue, please see screen below. Any fixes available?

    [​IMG]
     
Thread Status:
Not open for further replies.

Share This Page