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

    What permission nodes do I use? I really need to allow moderators access to this.
     
  3. Offline

    fysics

    look in the wiki.
     
  4. Offline

    Mara1681

    Okey that's fine, thank you for your quick answer...
    I hope, that N3X15 fix this. :)
     
  5. Offline

    andrewkm

    798 + BB452 + mysql =
    WORKING PERFECT!
    everything tested.
    Thank you very much :) CHEERS!
     
  6. Offline

    matan7890

    792 +BB443 + H2:
    Code:
    2011-05-22 14:41:03 [INFO] [BBROTHER] ------------------------------------
    2011-05-22 14:41:03 [INFO] [BBROTHER] Hello, and thank you for using the TESTING
     version of BigBrother!
    2011-05-22 14:41:03 [INFO] [BBROTHER] Please note that, since this is far from c
    omplete, there will be many bugs.
    2011-05-22 14:41:03 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM O
    N http://bugs.nexisonline.net/bb
    2011-05-22 14:41:03 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbro
    ther for updates and build notifications.
    2011-05-22 14:41:03 [INFO] [BBROTHER] ------------------------------------
    2011-05-22 14:41:03 [INFO] [BBROTHER] Building `bbdata` table...
    2011-05-22 14:41:03 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NO
    T EXISTS `bbdata` (`id` INTEGER AUTO_INCREMENT PRIMARY KEY,`date` INT UNSIGNED N
    OT 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 DEFAU
    LT '0',`y` tinyint UNSIGNED NOT NULL DEFAULT '0',`z` int NOT NULL DEFAULT '0',`t
    ype` smallint NOT NULL DEFAULT '0',`data` TEXT NOT NULL DEFAULT '',`rbacked` boo
    lean NOT NULL DEFAULT '0');CREATE INDEX dateIndex on bbdata (date);CREATE INDEX
    playerIndex on bbdata (player);CREATE INDEX actionIndex on bbdata (action);CREAT
    E INDEX worldIndex on bbdata (world);CREATE INDEX posIndex on bbdata (x,y,z);CRE
    ATE INDEX typeIndex on bbdata (type);CREATE INDEX rbackedIndex on bbdata (rbacke
    d);):
    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]
    2011-05-22 14:41:03 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    2011-05-22 14:41:03 [INFO] [BBROTHER] Building `bbworlds` table...
    2011-05-22 14:41:03 [INFO] [BBROTHER] Building `bbusers` table...
    2011-05-22 14:41:03 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NO
    T EXISTS `bbusers` (`id` INT AUTO_INCREMENT PRIMARY KEY,`name` varchar(32) NOT N
    ULL DEFAULT 'Player',`flags` INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX idxUs
    ername 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]
    2011-05-22 14:41:03 [INFO] [BBROTHER] Permissions enabled using: Permissions v3.
    0
    2011-05-22 14:41:03 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    
    2011-05-22 14:41:03 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT (build #443) enabl
    ed!
    I don't know why, but it's always trying to "build" the database, but the database is currently builded...
    Any help? :S
    Thx :D
     
  7. Offline

    andrewkm

    use 452
     
  8. Offline

    matan7890

    Still the same problem:
    Code:
    2011-05-22 16:33:14 [INFO] [BBROTHER] ------------------------------------
    2011-05-22 16:33:14 [INFO] [BBROTHER] Hello, and thank you for using the TESTING
    version of BigBrother!
    2011-05-22 16:33:14 [INFO] [BBROTHER] Please note that, since this is far from c
    omplete, there will be many bugs.
    2011-05-22 16:33:14 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM O
    N http://bugs.nexisonline.net/bb
    2011-05-22 16:33:14 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbro
    ther for updates and build notifications.
    2011-05-22 16:33:14 [INFO] [BBROTHER] ------------------------------------
    2011-05-22 16:33:15 [INFO] [BBROTHER] Building `bbdata` table...
    2011-05-22 16:33:15 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NO
    T EXISTS `bbdata` (`id` INTEGER AUTO_INCREMENT PRIMARY KEY,`date` INT UNSIGNED N
    OT 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 DEFAU
    LT '0',`y` tinyint UNSIGNED NOT NULL DEFAULT '0',`z` int NOT NULL DEFAULT '0',`t
    ype` smallint NOT NULL DEFAULT '0',`data` TEXT NOT NULL DEFAULT '',`rbacked` boo
    lean NOT NULL DEFAULT '0');CREATE INDEX dateIndex on bbdata (date);CREATE INDEX
    playerIndex on bbdata (player);CREATE INDEX actionIndex on bbdata (action);CREAT
    E INDEX worldIndex on bbdata (world);CREATE INDEX posIndex on bbdata (x,y,z);CRE
    ATE INDEX typeIndex on bbdata (type);CREATE INDEX rbackedIndex on bbdata (rbacke
    d);):
    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]
    2011-05-22 16:33:15 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    2011-05-22 16:33:15 [INFO] [BBROTHER] Building `bbworlds` table...
    2011-05-22 16:33:15 [INFO] [BBROTHER] Building `bbusers` table...
    2011-05-22 16:33:15 [SEVERE] [BBROTHER] executeUpdate failed (CREATE TABLE IF NO
    T EXISTS `bbusers` (`id` INT AUTO_INCREMENT PRIMARY KEY,`name` varchar(32) NOT N
    ULL DEFAULT 'Player',`flags` INT NOT NULL DEFAULT '0');CREATE UNIQUE INDEX idxUs
    ername 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]
    2011-05-22 16:33:15 [INFO] [BBROTHER] Permissions enabled using: Permissions v3.
    0
    2011-05-22 16:33:15 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    2011-05-22 16:33:15 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT (build #452) enabl
    ed!
    Anyone?
     
  9. Offline

    andrewkm

    452 + 798 + mysql
    Just did major rollback. Went fine :) all is good. Just some errors in console:
    Code:
    2011-05-22 06:57:38 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    java.lang.NullPointerException
     at org.bukkit.craftbukkit.inventory.CraftItemStack.setAmount(CraftItemStack.java:99)
     at me.taylorkelly.bigbrother.datablock.DeltaChest.do_NewRollback(DeltaChest.java:283)
     at me.taylorkelly.bigbrother.datablock.DeltaChest.rollback(DeltaChest.java:264)
     at me.taylorkelly.bigbrother.rollback.Rollback$RollbackByTick.run(Rollback.java:230)
     at org.bukkit.craftbukkit.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:138)
     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:365)
     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:292)
     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-22 06:57:38 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    java.lang.NullPointerException
     at org.bukkit.craftbukkit.inventory.CraftItemStack.setAmount(CraftItemStack.java:99)
     at me.taylorkelly.bigbrother.datablock.DeltaChest.do_NewRollback(DeltaChest.java:283)
     at me.taylorkelly.bigbrother.datablock.DeltaChest.rollback(DeltaChest.java:264)
     at me.taylorkelly.bigbrother.rollback.Rollback$RollbackByTick.run(Rollback.java:230)
     at org.bukkit.craftbukkit.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:138)
     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:365)
     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:292)
     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Hey what does everybody keep their cleanse days as?
    is going over 3 reduce performance?
    Im thinking of upping it to 7

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

    palz2015

    It says "nothing to rollback" when I try to rollback griefers!! wtf!
     
  11. Offline

    Spl1tz

    My Big Brother or the MySQL server lags the server. I had to disable it.
    Please help, rly need this awesome plugin!

    I first posted here because i didn't know what caused the lag, later on it seemed to be BB.
    But nobody is answering there anymore.
     
  12. Offline

    Zeroi9

    To me it seems like BB can't do anything else than print out "Searching..." when I type /bb here, nor can it rollback. I don't get the "type /bb confirm" message.

    Using MySQL; bukkit #798 & BB 443.
    (Works with H2, not MySQL.)
    Edit:
    This is probably the cause.

    2011-05-23 00:15:33 [SEVERE] [BBROTHER] executeQuery failed (SELECT id,name,flags FROM bbusers WHERE `name`=?):

    http://pastebin.com/ikNCT3mR


    Didn't get time to copy more, it just spams. Went from 1 mb to 15mb in a few seconds..!
     
    AS1LV3RN1NJA likes this.
  13. Offline

    xxwllrxx

    can
    you use h2?
     
  14. Offline

    $p!k3

    Code:
    12:20:08 [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)
    D:
    i get this when i start the server.
     
  15. Offline

    B1GBADW0IF

    when i try and use this plugin and i put my mysql thing in it works but it creates bbworld and bbsata tables and on the server it wont work , sorry for my bad english
     
  16. Offline

    Tadas159

    Maybe you should try typing their names in Capital letters where they are. If you have a player like Storm don't try to rollback storm try to rollback Storm
     
  17. Offline

    Scipione

    Had to do a "bigger" rollback yesterday (Rolled back the work of a single player with a radius of 50, without t: flag). This crashed my Server and produces massive lag, even restarting the Serversoftware didn't work, i needed to restart the whole OS to get it back working.
    But tbh, this wasn't such a big rollback as it sounds, this user only created a single house with some chests, not that much blocks ...
    Since i didn't get any real error messages, i believe it has something to do with the mysql connection...
     
  18. Offline

    nitroxygen

    CB: 803
    BB: 452
    This error happends when i try to to a rollback.
    These 2 errors happend when the server boots. I know my settings are correct but i still cant connect to mysql or anyother kind of database.
     
  19. Offline

    andrewkm

    Confirming that this works great on RB #803
    Thanks alot :)
     
  20. Working on 803 no issues.
     
  21. Offline

    Letalis

    Started to get this errors in the today.
    Using RB766 and latest rel of BB0452 as of yesterday.

    Code:
    2011-05-23 18:52:50 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:52:50 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:53:02 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:53:02 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:53:02 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:53:13 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:53:13 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:53:13 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:53:25 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:53:25 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:53:25 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:53:38 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:53:38 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:53:38 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:53:49 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:53:49 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:53:49 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:54:02 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:54:02 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:54:02 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:54:14 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:54:14 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:54:14 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:54:26 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:54:26 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:54:26 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    2011-05-23 18:54:37 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending b
    locks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data'
    at row 1
    2011-05-23 18:54:37 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    
    2011-05-23 18:54:37 [WARNING] [BBROTHER] SQL send failed. Keeping data for later
     send.
    
     
  22. Offline

    onno1

    Can anyone help me?
    It is kinda working but when i so anything, it says no modifications. When i use the sticks, it says nothing.
    I get these error messages on startup:
    minecraft issue.JPG
     
  23. Offline

    eriorkless

    I suppose the sql noobs are chopped liver in all of this... Thanks... A lot
    Griefing shall run a-muck because of the asinine response--none at all.
    *sad face*
     
  24. Could someone please help me with the following problem,
    It says .minecraft/bbdata is marked as crashed and should be repaired (or something like that).
    Now I know this is a MySQL issue too, but i have COMPLETELY reinstalled MySQL and it still isn't gone.
    I have also completely clean reinstalled bb several times without success.

    I don't know if anyone knows how to do this, but I'm getting a bit crazy here, especially when i think it works and then it after 6 minutes the error pops up again[creeper]:mad:[creeper].
     
  25. Offline

    but2002

    BigBrother has native support for H2 databases. It's not a flat-file but it is a file, and doesn't require any extra server. This should do for you.

    I do HIGHLY recommend you move to a host that has MySQL support or something, because over time your BigBrother instance will become so laggy you can't even comprehend it.
     
  26. Offline

    cholo71796

    I may have asked this before, but could a simple command like "/bb logins [player]" be added that displays login/logout history for a specified player? The post says that it stores data on when players login, and I'd like to be able to check that information because I want to delete some players' belongings if I know they have not logged on in a very long time.
     
  27. Offline

    palz2015

    Every time i /reload with essentials, BB goes insane, spewing the super fast errors. Like so:
    Code:
    18:43:18 [INFO] [BBROTHER] ------------------------------------
    18:43:20 [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(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            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:125)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:750)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:253)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
            at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:336)
            at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleComma
    ndMap.java:213)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:97
    )
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:2
    70)
            at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:401)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:386)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:292)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    18:43:20 [SEVERE] Error occurred while enabling BigBrother v1.8-SNAPSHOT (Is it
    up to date?): null
    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.ja
    va:55)
            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:118)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:125)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:750)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:253)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
            at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:336)
            at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleComma
    ndMap.java:213)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:97
    )
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:2
    70)
            at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:401)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:386)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:292)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    18:43:20 [INFO] LWC     Loaded 116 locale strings (0 overrides)
    18:43:20 [INFO] LWC     Using Nijikokun's permissions plugin for permissions
    18:43:20 [INFO] [Permissions] version [2.7.3] (Phoenix)  loaded
    18:43:20 [INFO] LWC     Loading SQLite
    18:43:20 [INFO] SQLite  Using: Native
    18:43:20 [INFO] LWC     At version: v2.31
    18:43:21 [INFO] [P2] version 2.1.1 has been enabled.
    Do I really need mySQL for this?
     
  28. Offline

    onno1

    yeh
     
  29. Offline

    Zeroi9

    When do we get an update?!
    What do we use meanwhile`?
     
  30. Offline

    palz2015

    When I get it, the command line client does nothing. I open cmd, "mysql" does nothing. The service isn't started either. Should I reboot?
     
  31. Offline

    Liger_XT5

    At default, BB does not use mySQL. Leave the mySQL settings in the BB config alone and you are fine. Just delete your BB config file, maybe just the whole folder, reload, make your needed changes in the config, reload once more, done.

    I'm running just fine. Even did a fresh install and so far no problems. Can't be guaranteed since I do not have many people on my server atm.
     
Thread Status:
Not open for further replies.

Share This Page