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

    palz2015

    Does this support permissions? If so, which?

    Oh, and this causes all who join to get kicked (end of stream, some weird client errors). So this thing is too buggy.
     
  3. Offline

    Jack Bartlett

    What the hell....I reload my server. /bb doesn't do anything at all. Not even "Unknown command"
    Then, I delete H2, and restart, now bb wont even take commands like /bb help, /bb stick 1, /bb here.
    Just "Unreconized Command"
     
  4. Offline

    fysics

    I use it with Essentials GroupManager without a problem. I think it'll work with the Phoenix Permissions as well, but I haven't tried it personally.
     
  5. Offline

    N3X15

    NEW RECOMMENDED BUILD.
    • ChestDelta (inventory differences) re-enabled.
    • Better statement tracking
    • Displays number of open SQL statements in /bb version for debugging purposes.
    • /bb version reports Jenkins build number.
    No, I have not fixed the NullPointerException in onPlayerPickupItem because I need to know your BigBrother.yml so I can reproduce the error. PLEASE POST YOUR BIGBROTHER.YML ON PASTEBIN AND PM ME IF YOU GET THIS ERROR.
     
  6. Offline

    Jorrdan

    Hey what are the best settings for the following configs?

    cleanse-age: 7d
    deletes-per-cleansing: '20000'
    max-records: '30000000'
    type: mysql
    send-delay: 4
     
  7. Offline

    Micze

    yay updated from 433 ^^ seems to work fine so far.
     
  8. Offline

    amunro

    I get this error everytime I start up the server. Is there something wrong with my mysql config? I checked the database and it seems to be writing to it. Plugin works fine except it screws up with numbers, i.e 27 Players have modified this area: playerx.


    Code:
    17:06:19 [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:273)
            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:12)
            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:120)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    
     
  9. Offline

    eriorkless

    Do we have to use an sql database? Or can we just run it without it? Because, I don't know how to use sql stuff :oops:
     
  10. Offline

    WolwX

    please @N3X15 tell us if your plugin still support flatfile database or if we must use MYSQL ?

    and if there is no support to flatfile database can you tell use the last version supporting it ?

    Thanks
     
  11. Offline

    Dorsilfin

    Hey .. Quick question.

    Ive got 766 installed and the latest 1.8 of BB its logging data into the mysql database and will work when I DONT have permissions plugin installed.. I put the permissions back in.. Its still recording data, I can do /bb help and /bb version no problem but cant use any of the commands even tho im OP so /bb stick 1 does nothing, doesnt even register in the console on the server.

    Any suggestions?
     
  12. Offline

    Mara1681

    Hi,
    I have a problem with rollback... My friend build big "mostrum" and then, he suddenly changed his mind, and he want to destroy this "monstrum". I tell him, that I will destroy it with BB plugin. So I used to rollback that area with 30 radius. This rollback destroy his "monstrum", but also a half part of his house. Then I used command UNDO, which return his house to normal, but his "monstrum" was returned too. But in this time, I can't do more rollbacks in that area, which I select last time. Is there any chance to rollback that area with different radius, without message "Nothing to rollback"?
     
  13. Offline

    MG127

    i am a fan of using the personal logfiles, but i realy have no idear how to encrypt the timecode
     
  14. Offline

    Puremin0rez

    I've noticed that now in 443 the default Engine is INNODB rather then MyISAM.

    Is MyISAM no longer recommended over INNODB?
     
  15. Offline

    LucidLethargy

    All I did was update to 443 and this happens now... Looks pretty nasty and I'm not even using MySQL, i'm using the default h2 database.

    I am on the latest recommended build of craftbukkit (766) and I just reverted to fix this issue (reverted version works perfectly so far as I can tell - it's version 709)

     
  16. Offline

    Mara1681

    I know why this happens...
    I tested it today and I noticed that BB can't return the wrong rollbacks with owners of returned blocks.
    Can you N3X15 fix this think, please? Thank you... :)
     
  17. Offline

    quickclay

    During a bootup after installing BB443 on CB766, I get the following error, even after a database wipe and rebuild.
    BB443 error (open)

    2011-05-19 18:41:57 [INFO] [BBROTHER] ------------------------------------
    2011-05-19 18:41:57 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother!
    2011-05-19 18:41:57 [INFO] [BBROTHER] Please note that, since this is far from complete, there will be many bugs.
    2011-05-19 18:41:57 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON http://bugs.nexisonline.net/bb
    2011-05-19 18:41:57 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for updates and build notifications.
    2011-05-19 18:41:57 [INFO] [BBROTHER] ------------------------------------
    2011-05-19 18:42:01 [INFO] [BBROTHER] Building `bbdata` table...
    2011-05-19 18:42:01 [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:273)
    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:118)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-19 18:42:01 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    2011-05-19 18:42:01 [INFO] [BBROTHER] Building `bbworlds` table...
    2011-05-19 18:42:01 [INFO] [BBROTHER] Building `bbusers` table...
    2011-05-19 18:42:01 [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:273)
    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:12)
    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:120)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-19 18:42:01 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.7.3
    2011-05-19 18:42:01 [INFO] [BBROTHER] 'Help' support enabled
    2011-05-19 18:42:01 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT (build #443) enabled!
     
  18. Offline

    Tfs Halo

    are the wiping thing where it cleans the database in real days or minecraft days.. because i tryed using 3d as the time

    but then i switched it to 72h thinking it would be the same or somerthing :S but for some reason bigbrother always
    cleans the database prematurely

    I need help on the database thing where it cleans the database i don't know how it works so it cleans my database prematurely

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

    Tadas159

    Is it possible to fix this?

    Code:
    2011-05-21 13:37:48 [INFO] [BBROTHER] ------------------------------------
    2011-05-21 13:37:48 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother!
    2011-05-21 13:37:48 [INFO] [BBROTHER] Please note that, since this is far from complete, there will be many bugs.
    2011-05-21 13:37:48 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON http://bugs.nexisonline.net/bb
    2011-05-21 13:37:48 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for updates and build notifications.
    2011-05-21 13:37:48 [INFO] [BBROTHER] ------------------------------------
    2011-05-21 13:37:51 [INFO] [BBROTHER] Building `bbdata` table...
    2011-05-21 13:37:51 [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:273)
        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:118)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-21 13:37:51 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    2011-05-21 13:37:51 [INFO] [BBROTHER] Building `bbworlds` table...
    2011-05-21 13:37:51 [INFO] [BBROTHER] Building `bbusers` table...
    2011-05-21 13:37:51 [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:273)
        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:12)
        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:120)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-21 13:37:51 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.7.2
    2011-05-21 13:37:51 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    2011-05-21 13:37:51 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT (build #443) enabled!
     
  20. Offline

    Obliviator

    Code:
    2011-05-21 11:22:34 [SEVERE] [BBROTHER] onPlayerTeleport([email protected])
    java.lang.NullPointerException
            at me.taylorkelly.bigbrother.tablemgrs.BBUsersMySQL.getUserFromDB(BBUsersMySQL.java:55)
            at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.getUserByName(BBUsersTable.java:85)
            at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerTeleport(BBPlayerListener.java:132)
            at org.bukkit.plugin.java.JavaPluginLoader$8.execute(JavaPluginLoader.java:292)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:302)
            at net.minecraft.server.NetServerHandler.teleport(NetServerHandler.java:358)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:347)
            at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:97)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:33)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:87)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:377)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:292)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-21 11:22:35 [SEVERE] [BBROTHER] executeQuery failed (SELECT id,name,flags FROM bbusers WHERE `name`=?):
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.
            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:1013)
            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.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
            at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
            at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4203)
            at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4169)
            at me.taylorkelly.bigbrother.datasource.BBDB.executeQuery(BBDB.java:316)
            at me.taylorkelly.bigbrother.tablemgrs.BBUsersMySQL.getUserFromDB(BBUsersMySQL.java:53)
            at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.getUserByName(BBUsersTable.java:85)
            at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerTeleport(BBPlayerListener.java:132)
            at org.bukkit.plugin.java.JavaPluginLoader$8.execute(JavaPluginLoader.java:292)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:302)
            at net.minecraft.server.NetServerHandler.teleport(NetServerHandler.java:358)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:347)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:318)
            at net.minecraft.server.Packet10Flying.a(SourceFile:126)
            at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:377)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:292)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    The last packet successfully received from the server was 27,884 milliseconds ago.  The last packet sent successfully to the server was 10 milliseconds ago.
            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.SQLError.createCommunicationsException(SQLError.java:1116)
            at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082)
            at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516)
            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.datasource.BBDB.executeUpdate(BBDB.java:273)
            at me.taylorkelly.bigbrother.tablemgrs.BBUsersMySQL.do_addOrUpdatePlayer(BBUsersMySQL.java:74)
            at me.taylorkelly.bigbrother.tablemgrs.BBUsersTable.addOrUpdateUser(BBUsersTable.java:110)
            at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerJoin(BBPlayerListener.java:78)
            at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:243)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:302)
            at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:94)
            at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:96)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:33)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:87)
            ... 3 more
    Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
            at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529)
            at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
            ... 23 more
    
    
    Using:
    CB RB 798
    BB RB #433
    External MYSQL

    It created the tables and used them, but now it just errors :(
     
  21. Offline

    nitroxygen

    Using:
    CB RB 798
    BB RB #433
    Using: SQLITE

    I have got this error every time i boot up the server then the roll backs give a error each time i try
     
  22. Offline

    GeekPlaya

    Very frustrating!

    I used this plugin and it worked great. Then all of a sudden none of the commands worked anymore (happened before). I rebooted it and they started to work, but all the history was ERASED! WTF!? There goes an entire town.
     
  23. Offline

    Toffensko

    Does this use a lot of ram or cpu usage?
     
  24. Offline

    Darksworm

    Code:
    20:19:00 [SEVERE] [BBROTHER] Your database settings are probably incorrect:
    java.sql.SQLException: invalid database address: jdbc:jdc:jdcpool
    	at org.sqlite.JDBC.createConnection(JDBC.java:74)
    	at org.sqlite.JDBC.connect(JDBC.java:64)
    	at java.sql.DriverManager.getConnection(DriverManager.java:620)
    	at java.sql.DriverManager.getConnection(DriverManager.java:222)
    	at me.taylorkelly.bigbrother.datasource.BBDB.reconnect(BBDB.java:168)
    	at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:111)
    	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
    	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
    	at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
    	at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
    	at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
    	at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
    	at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
    	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
    	at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    20:19:00 [SEVERE] null loading BigBrother v1.8-SNAPSHOT (Is it up to date?)
    java.lang.NullPointerException
    	at me.taylorkelly.bigbrother.datasource.BBDB.tableExists(BBDB.java:121)
    	at me.taylorkelly.bigbrother.tablemgrs.DBTable.tableExists(DBTable.java:31)
    	at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.<init>(BBDataTable.java:55)
    	at me.taylorkelly.bigbrother.tablemgrs.BBDataMySQL.<init>(BBDataMySQL.java:17)
    	at me.taylorkelly.bigbrother.tablemgrs.BBDataTable.getInstance(BBDataTable.java:43)
    	at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:118)
    	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    	at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
    	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
    	at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
    	at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
    	at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
    	at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
    	at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
    	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
    	at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    
    
    using CB 760 and 000webhost MySQL
     
  25. Offline

    iggiiggi

    i really love this plugin, it has changed the entire attitude of my server, but it would be nice to have a /bb redo

    i rolled someone back, did an undo once i realized i could just do it by radius, but it had deleted all of that players logged changes, i can't think that's a good feature really :/

    thankfully i have a secondary logging program in case bb fails, but i really shouldnt need one...
     
  26. Offline

    fysics

    It looks like the bigger problem is that undoing a rollback doesn't undelete the associated records, and so the changes (or a different subset of the changes) can't be rolled back. If this is actually the case, it sounds like a bug.
     
  27. Offline

    iffa

    Damn, this plugin fails to connect to the database (which is why I can't use BB)...
     
  28. Offline

    tommy99

    minecart mania dont work with BigBrother if you installed both yo get a conection refused an big brohter spams your console
     
  29. Offline

    Mara1681

    And this is, what I wrote last page...
    Can I have a question? Did you read that post? :confused:

     
  30. Offline

    xxwllrxx

    dont know what happened please help

    18:22:11 [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:243)
    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)
    18:22:11 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    18:22:11 [INFO] [BBROTHER] Building `bbworlds` table...
    18:22:11 [INFO] [BBROTHER] Building `bbusers` table...
    18:22:11 [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: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: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)
    18:22:11 [INFO] [BBROTHER] Permissions enabled using: Permissions v2.5.1
    18:22:11 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    18:22:11 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT (build #433) enabled!
     
  31. Offline

    fysics

    I did, but I didn't fully understand what was happening until iggiiggi's post. It looks like it was submitted to the bug tracker on May 15th.
     
Thread Status:
Not open for further replies.

Share This Page