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 nexis@7chan.org 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

    kingcole436

    I just updated BB today, CraftBukkit build 740, BB v1.8, Latest SnapShot. I use McMyAdmin, but i'm sure that dosen't effect the error at all, tested that myself. But i'm getting this as an error now. P.S BB seems to work, I'm just not sure because for all I know it could go bonkers on me and then I would be sad :(
    Code:
    2011-05-01 11:09:07 [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Undeclared variable: 3000000DELETE
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
        at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:132)
        at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
    
    IF you need more information Just let me know what is needed, AND I have another question, In my BB It says that I should switch my bbdata table to MyISAM, I go to MySQL command line and put this: ALTER TABLE bbdata ENGINE = MyISAM;
    Which Is what BB told me to do. But I get this: [​IMG]

    Thanks for any help, its appreciated, hope to hear some feedback!


    Now I am getting another error, this JUST happened:
    Code:
    2011-05-01 11:11:50 [INFO] kingcole436 [/127.0.0.1:52439] logged in with entity id 109
    2011-05-01 11:12:21 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'bb' in plugin BigBrother v1.8-SNAPSHOT
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:677)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:640)
        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)
    Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 2
        at java.lang.String.substring(Unknown Source)
        at me.taylorkelly.util.TimeParser.parseTime(TimeParser.java:41)
        at me.taylorkelly.bigbrother.rollback.RollbackInterpreter.<init>(RollbackInterpreter.java:41)
        at me.taylorkelly.bigbrother.commands.RollbackCommand.onCommand(RollbackCommand.java:26)
        at me.taylorkelly.bigbrother.BBCommand.onCommand(BBCommand.java:40)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
    Here is a Full server log: http://pastebin.com/XJeP2L8e BUT be warned that log is really long, and I'm not sure if it will help at all, Im just trying to put as much info out as possible.

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

    but2002

    USE DatabaseName;
     
  4. Offline

    1994mat

    When I try to alter the table, I get "You have an error in your SQL syntax"

    Bigbrother needs newer version of mysql?
     
  5. Offline

    andrewkm

    Willl be testing latest builds on my server in about an hour and will report back.
    (Its just hard to schedule downtimes with a 30+ user average server lol)
    Ill let you guys know how i do on the latest recommended build of BB (Released today) and [740]
     
  6. Offline

    kingcole436

    And Yet another question, my friend asked me to post this, He changed the stick ID to a wooden hoe (the ID # not the name) and We cant seem to get /bb stick 1,2, or 0 to work, absolutely nothing happens, CB Build 733, BB version 1.8.
    We have the permission set up for the ranks, bb.admin, bb.whatch bb.info and every other one.
     
  7. Offline

    1994mat

    New problem

    Code:
    2011-05-01 20:46:00 [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Undeclared variable: 3000000DELETE
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:132)
    at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
    
    +

    How do I fix this?

    Code:
    mysql> ALTER TABLE 'minecraft'.'bbdata' ENGINE = MyISAM;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''minecraft'.'bbdata' ENGINE = MyISAM' at line 1
    
     
  8. Offline

    Zazamari

    also having same problem as above with new version

    also I'm getting 'error: wand not set in configuration file' whenever i perform any action now, bb is the only mod i updated since last restart so I can only figure its that
     
  9. Offline

    kingcole436

    To alter the table do this line first, P.S Make sure u exit out of MySQL cmd line, then load it up againm THEN do this use minecraft;
    THEN: ALTER TABLE bbdata ENGINE = MyISAM
     
  10. Offline

    1994mat

    Thx, helped.

    Now need fixed bigbrother lol
     
  11. Offline

    Jessicadawn

    Some blocks still say "no edits" and it skips a person who breaks it shows "Jessicadawn has placed block Diamond_Ore" then "Jessicadawn has placed block Glass" doesnt show who broke.
     
  12. Offline

    DerKB

    Still getting MySQL errors
    Code:
    2011-05-01 21:44:41 [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3000000DELETE
     FROM bbdata WHERE id NOT IN (SELECT id FROM top_record) LIMIT 2000' at line 1
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
            at com.mysql.jdbc.Util.getInstance(Util.java:382)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:132)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
    
    If i read the SQL string, the prefix is missing, i did set it to "bb_" in the config and the tables all have that prefix, even the syntax seems not to right for a SQL string, the "3000000" seems to be from an other part of the string, if so i " " is missing.

    And till now i did not try to find the syntax in the code to maybe fix it, would have to check your source all over (but java is not my world of programming do not know that much about it, only simple basics it would take me a bit to figure your code out)

    CB is 740
    BB is 397 (now) and the error seems to be gone ... did update it some secs ago.

    But what is still missing is the prefix in the sql string wich gives a "table not found error" cause
    database.bbdata is requested in your string, but it should be for my setup
    datebase.prefixbbdata

    Code:
    2011-05-01 21:59:51 [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minecraft.bbdata' doesn't exist
            at sun.reflect.GeneratedConstructorAccessor125.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
            at com.mysql.jdbc.Util.getInstance(Util.java:382)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:135)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
    
    for me it should be as table "minecraft.bb_bbdata"

    regards
     
  13. Offline

    ctshiner

    I've been getting spammed with this all day, using BB371 and CB740

    Code:
    2011-05-01 15:38:32 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending blocks
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'data' at row 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
        at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
        at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:33)
        at java.lang.Thread.run(Thread.java:662)
    2011-05-01 15:38:32 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    2011-05-01 15:38:32 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    Anybody?
     
  14. Offline

    andrewkm

    [384]/[385]/[396]/[397]/[398] + mysql + [740]
    Code:
    2011-05-01 17:23:36 [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 20000' at line 1
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
     at java.lang.reflect.Constructor.newInstance(Unknown Source)
     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
     at com.mysql.jdbc.Util.getInstance(Util.java:382)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
     at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:135)
     at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
    This is on a fresh install as well. All tables dropped, fresh BB install. Same error. (config setup correctly.)
    -
    [383] + mysql + CB [740}
    Working perfect and fine!
    /bb here, /bb rollback and all other main commands working great! :)
    384+ Needs to be looked at.
     
  15. Offline

    Willbbz

    When I rollback a user it causes my server to restart? Any reasons this would happen?

    I've rolled back a user before and it didn't restart but that was once off.

    Suggestions?

    Here's my BigBrother.yml
    Code:
    general:
        excluded-blocks: []
        rollbacks-per-tick: 2000
        personal-log-files: false
        auto-watch: true
        debug-mode: false
        default-search-radius: 5
        tnt-threshold: 1.0
        restore-fire: false
        stick-item: 280
        library-autodownload: true
    database:
        cleanse-age: 3d
        deletes-per-cleansing: '20000'
        max-records: '3000000'
        type: H2
        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:
            drop-item: false
            ip-player: true
            disconnect: true
            login: true
            pickup-item: false
            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
    
     
  16. Offline

    Phaedrus

    Just updated to latest BB build and getting this after server load.

    20:35:55 [INFO] [BBROTHER] SQLite can't cleanse by # of records.

    no other issues i can notice...
     
  17. Offline

    ssechaud

    04:09:14 [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3000000DELETE FROM bbdata WHERE id NOT IN (SELECT id FROM top_record) LIMIT 2000' at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:132)
    at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)

    04:47:37 [SEVERE] [BBROTHER] onPlayerJoin(org.bukkit.event.player.PlayerJoinEvent@76d85c2)
    java.lang.NullPointerException
    at com.nijiko.permissions.Control.getGroup(Control.java:535)
    at com.nijiko.permissions.Control.permission(Control.java:308)
    at me.taylorkelly.bigbrother.BBPermissions.permission(BBPermissions.java:46)
    at me.taylorkelly.bigbrother.BBPermissions.watch(BBPermissions.java:65)
    at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerJoin(BBPlayerListener.java:95)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:206)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
    at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:94)
    at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:95)
    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:370)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)

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

    pjt0620

  19. Offline

    Clontarf[X]

    anyone got a link to an older, working build? My MySQL is at 100% because of a BigBrother query...
    Code:
    minecraft@www:~$ htop
    
      1  [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||100.0%]     Tasks: 254 total, 16 running
      2  [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||100.0%]     Load average: 10.64 11.18 10.52
      3  [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||100.0%]     Uptime: 24 days, 20:48:29
      4  [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||100.0%]
      Mem[||||||||||||||||||||||||||||||||||||||||||||||||||||||||1798/2048MB]
      Swp[                                                              0/0MB]
    
      PID USER     PRI  NI  VIRT   RES   SHR S CPU% MEM%   TIME+  Command
    21669 mysql     15   0  190M 42680  5672 S 93.1  2.0 29:00.53 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mys
     3785 mysql     25   0  190M 42680  5672 R 75.9  2.0 12:14.58 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mys
    11436 mysql     25   0  190M 42680  5672 R 19.0  2.0 13:20.46 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mys
    
    Code:
    16:50:20 [SEVERE] [BBROTHER] onPlayerPickupItem(org.bukkit.event.player.PlayerPickupItemEvent@43b6c732)
    java.lang.NullPointerException
            at me.taylorkelly.bigbrother.datablock.PickupItem.<init>(PickupItem.java:12)
            at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerPickupItem(BBPlayerListener.java:172)
            at org.bukkit.plugin.java.JavaPluginLoader$17.execute(JavaPluginLoader.java:302)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
            at net.minecraft.server.EntityItem.b(EntityItem.java:203)
            at net.minecraft.server.EntityHuman.i(EntityHuman.java:212)
            at net.minecraft.server.EntityHuman.u(EntityHuman.java:204)
            at net.minecraft.server.EntityPlayer.u(EntityPlayer.java:205)
            at net.minecraft.server.EntityLiving.p_(EntityLiving.java:231)
            at net.minecraft.server.EntityHuman.p_(EntityHuman.java:90)
            at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:162)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:272)
            at net.minecraft.server.Packet10Flying.a(SourceFile:126)
            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)
     

    Attached Files:

  20. Offline

    Scipione

    Same problems here as ssechaud. Needed to rollback to old version because of massive errorspam
     
  21. Offline

    MacG32

    Error starting with BB #398 and CB #740:
    Code:
    [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mc.bbdata' doesn't exist
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
            at com.mysql.jdbc.Util.getInstance(Util.java:382)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:135)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
     
  22. Whenever i try to rollback, it doesn't do anything... no console errors, no "no-permissions"....it just acts like the /bb rollback never happened. (and i've been doing rollbacks with this system for months)...
    is there anything that would make it so an OP wouldn't be able to rollback, with any console errors?
     
  23. Offline

    Phat32

    I just got the latest Bukkit and the latest BB and I got this error
    Code:
    2011-05-02 10:39:22 [SEVERE] [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3000000DELETE FROM bbdata WHERE id NOT IN (SELECT id FROM top_record) LIMIT 2000' at line 1
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
            at com.mysql.jdbc.Util.getInstance(Util.java:382)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:132)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
    To me it looks like there was a typo in the build for the cleanse thread. Namely a space between the cleanse value and delete
     
    wassilij likes this.
  24. Offline

    wassilij

    I have the same error:

    I have this sometimes too .. try a smaller Radius (/bb rollback USER r:10)

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

    N3X15

    Big Brother Build #404 (May 2, 2011 10:57:47 AM)
    Should fix a bunch of things.

    EDIT: 405 fixes cleanser prefixes. I am idort.
     
  26. Offline

    MacG32

    Thank you very much N3X15. BB #405 works like a charm. :D

     
  27. Offline

    n4Ghost

    Comes with Version #405

    Code:
    [BBROTHER] Cleanse SQL exception (by #)
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet successfully received from the server was 38,617 milliseconds ago.  The last packet sent successfully to the server was 38,617 milliseconds ago.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            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:2620)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
            at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
            at me.taylorkelly.bigbrother.tablemgrs.BBDataMySQL.getCleanseByLimit(BBDataMySQL.java:168)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.cleanByNumber(Cleanser.java:132)
            at me.taylorkelly.bigbrother.Cleanser$CleanupThread.run(Cleanser.java:81)
    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)
            ... 10 more
     
  28. Offline

    Jessicadawn

    Thanks for updating BUT it still does the same thing on certain blocks it shows no edits especially when i JSUT placed a block
     
  29. Offline

    ssechaud

    Thanks for the update, SQL is stuff is working now. But I still can't get the Admins group to be able to edit blocks, I think Permissions has a bug and is causing problems:

    21:04:15 [SEVERE] [BBROTHER] onPlayerInteract(org.bukkit.event.player.PlayerInteractEvent@35de06ec)
    java.lang.NullPointerException
    at com.nijiko.permissions.Control.getGroup(Control.java:535)
    at com.nijiko.permissions.Control.permission(Control.java:308)
    at me.taylorkelly.bigbrother.BBPermissions.permission(BBPermissions.java:46)
    at me.taylorkelly.bigbrother.BBPermissions.info(BBPermissions.java:57)
    at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerInteract(BBPlayerListener.java:220)
    at org.bukkit.plugin.java.JavaPluginLoader$9.execute(JavaPluginLoader.java:254)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
    at org.bukkit.craftbukkit.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:162)
    at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:207)
    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:370)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
     
  30. Offline

    Jack Bartlett

    It wont tell me who placed what block, it just say "no edits on this block"
     
  31. Offline

    MacG32

    Spoke too soon...Whoops. Screen is getting spammed with this:
    Code:
    [SEVERE] [BBROTHER] Connection failure, will try to reconnect is a moment...
    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.ConnectionManager.createConnection(ConnectionManager.java:75)
            at me.taylorkelly.bigbrother.datasource.ConnectionManager.getConnection(ConnectionManager.java:31)
            at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:58)
            at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
            at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
            at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
            at java.lang.Thread.run(Unknown Source)
    [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    Also this on startup:
    Code:
    [SEVERE] [BBROTHER] Error getting a connection. Make sure your database settings are correct!
    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.ConnectionManager.createConnection(ConnectionManager.java:75)
        at me.taylorkelly.bigbrother.datasource.ConnectionManager.getFirstConnection(ConnectionManager.java:157)
        at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:137)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:670)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:234)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:130)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:108)
        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)
    [SEVERE] [BBROTHER] Could not establish SQL connection. Disabling BigBrother
    Edit: Seems the newest version corrupted the database somehow. After repairing it, seems to be running fine for now. We'll see.

    Edit: Seems it making MySQL use close to 100% of the processor. Maybe it's causing MySQL to fail and then the above errors occur.
     
Thread Status:
Not open for further replies.

Share This Page