Inactive [ADMN] HeroicRebuke v1.2.7 - Warn Players and Track Warnings [211~1060]

Discussion in 'Inactive/Unsupported Plugins' started by SquallSeeD31, Feb 13, 2011.

  1. Offline

    SquallSeeD31

    HeroicRebuke - Warn Players and Track Warnings (v1.2.7)
    Download HeroicRebuke 1.2.7 [CraftBukkit 561+]
    Download HeroicRebuke 1.2.4 [CraftBukkit 560-]
    SQLite | MySQL

    Latest Jar Only

    COMPATIBILITY UPDATE: Due to recent changes in CraftBukkit version 561, all server admins upgrading to this version of CraftBukkit or higher will need to download HeroicRebuke 1.0.5 or higher. Server admins running CraftBukkit 560 and below should download HeroicRebuke 1.0.4, thank you for your understanding.

    HeroicRebuke allows the server admin and his designated moderators to Warn players for misbehaving and persistently track the warnings issued. This project was originally developed for the HeroCraft SMP server based on demand for a port of the "Warn" hey0 plugin by bootswithdefer. HeroicRebuke is an original creation extending that design with optional (but emphatically recommended) support for a lightweight SQLite database.

    Features
    • Warn players for lesser infractions not meriting a kick or ban
    • List a player's previous actions to track chronic violators
    • Supports partial name matching! (Squall, ed3, and LLSEE all match SquallSeeD31)
    • Supports SQLite or MySQL
    • Warnings can optionally root players, preventing all movement (including teleports)
    • Acknowledging your warning can optionally require a randomly-generated code, preventing automation and encouraging thorough review of the message
    • Commands can also be issued from the server console
    • Support for Permissions plugin, defining your own list of admins or just using Server Ops
    • Configurable display colors for messages, names, and key information
    Screenshots


    Help Interface
    [​IMG]

    Warning List for a Given Player
    [​IMG]

    Player Receiving a Warning
    [​IMG]

    Active Warnings List
    [​IMG]


    Installation

    HeroicRebuke works best with a database (SQLite or MySQL). The plugin is configured to look for the database connector "sqlitejdbc-v056.jar" (SQLite) or "mysql-connector-java-bin.jar" (MySQL) in the "/lib" directory of your server root. If you already have these files, you do not need to re-download them.
    1. Download latest .ZIP archive from the link at the top
    2. Extract the archive into your main server directory (archive contains directory mapping)
    3. Open /plugins/HeroicRebuke/config.yml and configure to taste
    4. Save configuration file and reload your server
    Using MySQL
    1. Check to be sure "mysql-connector-java-bin.jar" is in /lib (from server root)
    2. Set options.database to "mysql" in your config.yml
    3. Set options.mysql.location to the path (IP:port/DatabaseName) to your MySQL server
      1. It is not necessary to create a new Database for HeroicRebuke, but is recommended. The only table created currently is "warnings"
    4. Set options.mysql.username to a username that has access to the named Database on your MySQL server
    5. Set options.mysql.password to that user's password
    6. Save config.yml and reload your server
    Configuration

    config.yml
    The config file contains default text colors, options, and designated HeroicRebuke admins (if not using the Permissions plugin).

    This file is saved in the YAML format, so please be sure to maintain the formatting and change only the element values.
    Default configuration:

    Show Spoiler
    Code:
    # HeroicRebuke Configuration
    ## Color options
    ## message: Text color of all notifications, wrapped around info and names.
    ## name: Color for player names.
    ## info: Color for informational elements to make them "pop", such as command usage
    #Color is defined according to the Bukkit enum ChatColor
    #Acceptable entries:
    ##BLACK
    ##DARK_BLUE
    ##DARK_GREEN
    ##DARK_AQUA
    ##DARK_RED
    ##DARK_PURPLE
    ##GOLD
    ##GRAY
    ##DARK_GRAY
    ##BLUE
    ##GREEN
    ##AQUA
    ##RED
    ##LIGHT_PURPLE
    ##YELLOW
    ##WHITE
    #
    #If color entered is inappropriate, HeroicRebuke will default to the following values:
    ##message: RED
    ##name: DARK_AQUA
    ##info: GOLD
    colors:
        message: RED
        name: DARK_AQUA
        info: GOLD
    
    #Options:
    ##database:
    ##ACCEPTABLE VALUES:
    ###sqlite - Expects "sqlitejdbc-v056.jar" in the "/lib" directory of your server root, and uses SQLite.
    ###mysql - Expects "mysql-connector-java-bin.jar" in the "/lib" directory of your server root, and uses MySQL. MUST configure options.mysql section for this to work
    ###<anything else> - HeroicRebuke will not use a database and no data will persist
    ##permissions: String containing which permissions system to use.  Acceptable values:
    ###Permissions - Nijikokun's Permissions plugin
    ###Config - Define your own HeroicRebuke admins below under the "admins:" property
    ###Ops - Only Server Ops can use HeroicRebuke (Ops can use HeroicRebuke anyway regardless of setting)
    ##code:
    ###use: If true, a random alphanumeric code will be generated on warning, preventing users from automating the /warn acknowledge command.
    ###length: Length of random code string to use
    ##server_name: Name to display when warnings are issued from the server console
    ##block_move: Whether or not to restrict a user from moving (and teleporting) when being warned.  Move block is aggressive.
    ##only_warn_online: If true, you can only warn players who are online (enables partial matching)
    ##lines_per_page: How many warnings to display when using /warn active and /warn list commands
    ##timeformat: Uses format strings from Java SimpleDateFormat.  Read all here: http://download.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html
    ##MySQL - If using "database: mysql", you must define the location, username and password to your MySQL server
    ###location: IP:PORT/DATABASE
    ###username: Self-explanatory
    ###password: Self-explanatory
    options:
        database: sqlite
        permissions: permissions
        code:
            use: true
            length: 6
        server_name: SERVER
        block_move: true
        only_warn_online: true
        lines_per_page: 4
        timeformat: MM/dd/yyyy HH:mm:ss z
        mysql:
            location: localhost:3306/HeroicRebuke
            username: root
            password:
    
    #If you want to use the "Config" permissions system, define your admins here
    #Each line below "admins:" *MUST* be formatted as such-> "    - 'username'"
    #Four spaces, hyphen, space, single quote, name of the admin, single quote
    admins:


    Admin Definition Example:
    Show Spoiler
    Code:
    admins:
        - 'SquallSeeD31'
        - 'DThielke'
        - 'Kainzo'
    


    Permissions
    Code:
    heroicrebuke.add (use /warn add)
    heroicrebuke.clear (use /warn clear)
    heroicrebuke.delete (use /warn delete)
    heroicrebuke.active (use /warn active)
    heroicrebuke.info (use /warn info)
    heroicrebuke.list (use /warn list - Displays only YOUR previous warnings)
    heroicrebuke.list.others (use /warn list <name> to display OTHER players' warnings)
    Recommended Settings:
    Admins:
    - 'heroicrebuke.*'

    Players:
    - 'heroicrebuke.list'

    Moderators:
    - 'heroicrebuke.add'
    - 'heroicrebuke.clear'
    - 'heroicrebuke.active'
    - 'heroicrebuke.info'
    - 'heroicrebuke.list.others'

    Changelog (Download Full Changelog)

    Version 1.2.7
    • Updated listener to use PlayerMoveEvent.setTo for the "bind" effect.
    Version 1.2.6
    • Updated to 617, added author to plugin.yml
    Version 1.2.5
    • Updated to Recommended Build 600/602
    • Changed type of code column to TEXT
    Version 1.2.4
    • Bugfix: Fixed potential NullPointerException in /warn clear command.
     
    wassilij, Killie01 and dark_hunter like this.
  2. Offline

    Nipper

    How do I warn someone thats offline?

    Edit: NM Just needed to edit the config to allow offline.
     
  3. Offline

    angus22397

    How can I make it so that i can freeze players without them bieng able to lift the warning with the acknowledge command?
    please quote this message when you respond :p
     
  4. Offline

    SquallSeeD31

    The design of this plugin does not include a provision to do a hard freeze like that, but if it's a desired feature, I could look into maybe making an option to prevent the acknowledgment code from showing to users, so that you could use the code feature and then not give them the code until you're ready to let them go.
     
  5. Offline

    angus22397

    THANK YOU (if you can do that)!!!!
    please quote this message when you manage to do that, or reply.
     
  6. Offline

    Joseph3114

    Upon acknowledgement, I get "Warning acknowledge error: java.sql.SQLException: SQL logic error or missing database".
    I have the SQLite jar in the proper folder as other plugins use it too.

    heroicRebuke.db saves in the root too, but everytime the server restarts, people's infraction list is reset.

    Any ideas whats wrong with my SQLite?
     
  7. Offline

    SquallSeeD31

    Are you sure you've got the *right* SQLite jar in the *right* folder, though? The manifest is expecting a certain file in a certain place, and if it's not there it won't work properly.

    Now, you say this happens when you try to acknowledge; can you pastie your config.yml? Does this error happen anywhere else? Do you have write access to the db file? Has it been working previously, or has it never worked for you?

    And, if you can... does the heroicRebuke.db actually have any data in it? (would require you to open it with any program capable of reading SQLite, so don't consider this a mandatory troubleshooting step)
     
  8. Offline

    Joseph3114

    Config (open)

    Code:
    # HeroicRebuke Configuration
    ## Color options
    ## message: Text color of all notifications, wrapped around info and names.
    ## name: Color for player names.
    ## info: Color for informational elements to make them "pop", such as command usage
    #Color is defined according to the Bukkit enum ChatColor
    #Acceptable entries:
    ##BLACK
    ##DARK_BLUE
    ##DARK_GREEN
    ##DARK_AQUA
    ##DARK_RED
    ##DARK_PURPLE
    ##GOLD
    ##GRAY
    ##DARK_GRAY
    ##BLUE
    ##GREEN
    ##AQUA
    ##RED
    ##LIGHT_PURPLE
    ##YELLOW
    ##WHITE
    #
    #If color entered is inappropriate, HeroicRebuke will default to the following values:
    ##message: RED
    ##name: DARK_AQUA
    ##info: GOLD
    colors:
        message: RED
        name: DARK_AQUA
        info: GOLD
    
    #Options:
    ##database:
    ##ACCEPTABLE VALUES:
    ###sqlite - Expects "sqlitejdbc-v056.jar" in the "/lib" directory of your server root, and uses SQLite.
    ###mysql - Expects "mysql-connector-java-bin.jar" in the "/lib" directory of your server root, and uses MySQL. MUST configure options.mysql section for this to work
    ###<anything else> - HeroicRebuke will not use a database and no data will persist
    ##permissions: String containing which permissions system to use.  Acceptable values:
    ###Permissions - Nijikokun's Permissions plugin
    ###Config - Define your own HeroicRebuke admins below under the "admins:" property
    ###Ops - Only Server Ops can use HeroicRebuke (Ops can use HeroicRebuke anyway regardless of setting)
    ##code:
    ###use: If true, a random alphanumeric code will be generated on warning, preventing users from automating the /warn acknowledge command.
    ###length: Length of random code string to use
    ##server_name: Name to display when warnings are issued from the server console
    ##block_move: Whether or not to restrict a user from moving (and teleporting) when being warned.  Move block is aggressive.
    ##only_warn_online: If true, you can only warn players who are online (enables partial matching)
    ##lines_per_page: How many warnings to display when using /warn active and /warn list commands
    ##timeformat: Uses format strings from Java SimpleDateFormat.  Read all here: http://download.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html
    ##MySQL - If using "database: mysql", you must define the location, username and password to your MySQL server
    ###location: IP:PORT/DATABASE
    ###username: Self-explanatory
    ###password: Self-explanatory
    options:
        database: sqlite
        permissions: permissions
        code:
            use: true
            length: 4
        server_name: hgsbackup
        block_move: true
        only_warn_online: true
        lines_per_page: 4
        timeformat: MM/dd/yyyy HH:mm:ss z
        mysql:
            location: localhost:3306/HeroicRebuke
            username: root
            password:
    
    #If you want to use the "Config" permissions system, define your admins here
    #Each line below "admins:" *MUST* be formatted as such-> "    - 'username'"
    #Four spaces, hyphen, space, single quote, name of the admin, single quote
    admins:

    http://pastie.org/1726524
    There is a warnings table in the database, but it is blank. I checked on sqlite browser.
    root/lib/sqlitejdbc-v056.jar is the path for the file.

    i also modified ftp permissions for both, and I still get the error, but a heroicRebuke.db-journal was created. What is this?
     
  9. Offline

    SquallSeeD31

    Well your config looks okay, and that is the correct path for the lib... the journal would be incredibly helpful if you could post it! Might contain information we can use to debug this issue. The internets have shown this error in a few other places, some of them even with Minecraft plugins, but the general consensus is that the exception message is unfortunately very vague and potentially misleading. =(

    Now, is it always "Warning acknowledge error:" that you see the SQLite exception, or has it occurred elsewhere?
     
  10. Offline

    Joseph3114

    16:37:49 [SEVERE] [HeroicRebuke] Warning creation error: java.sql.SQLException: SQL logic error or missing database
    16:37:49 [INFO] joseph3114 is online and has been warned.
    16:38:22 [INFO] joseph3114 acknowledged your warning.
    16:38:22 [SEVERE] [HeroicRebuke] Warning acknowledge error: java.sql.SQLException: SQL logic error or missing database
     

    Attached Files:

  11. Offline

    SquallSeeD31

    Man that's killing me...

    I can see that the database has been successfully created, so your SQLite JDBC is actually working. No data is being added though, so that's interesting. If it were a big issue in the program logic though, why hasn't anyone else reported it?

    So I'm just curious, and for the time being stumped. I'm not experienced enough in SQLite to wholly diagnose this one, but I may try making an indev build with a LOT of debugging just to see if there's something I can track.
     
  12. Offline

    Joseph3114

    Is there a way to make it save flatfile?
    Don't the majority of plugins that use SQLite use it out of the plugins folder, and save inside the plugins folder?

    My heroRebuke.db ends up in the root folder, is this intended?
     
  13. Offline

    SquallSeeD31

    I don't have flatfile support for HeroicRebuke at this time, but it could be coming soon.

    When I wrote HeroicRebuke, the standard people seemed to be using was for plugin config to be in the plugin's folder and databases to be in the root folder. The standard now definitely is the plugin's folder (except for LWC); I've always thought about moving it, but I've never actually done it.
     
  14. Offline

    Joseph3114

    ah okay
    Well if everything has 777 permissions, are there any other things I can check to see why it can create a file but not write to it?
     
  15. Offline

    SquallSeeD31

    Well, the fact that the database schema has been created does mean that it can be written to at least once at the OS level, because the CREATE statements have gone through okay.

    Anyway, since you're active, if you don't mind a little testing, this is an indev build with debugging turned on that should provide more verbose debugging messages when you attempt to create or acknowledge a warning. Maybe we can see what's going on in your particular case.

    http://dl.dropbox.com/u/1131502/HeroicRebuke/plugins/HeroicRebuke-INDEV.jar
     
  16. Offline

    Joseph3114

    Code:
    18:58:28 [SEVERE] [HeroicRebuke] Warning creation error: java.sql.SQLException: SQL logic error or missing database
    18:58:28 [SEVERE] java.sql.SQLException: SQL logic error or missing database
    18:58:28 [SEVERE]       at org.sqlite.DB.throwex(DB.java:288)
    18:58:28 [SEVERE]       at org.sqlite.DB.exec(DB.java:68)
    18:58:28 [SEVERE]       at org.sqlite.Conn.commit(Conn.java:172)
    18:58:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebukeSQLite.newWarning(HeroicRebukeSQLite.java:68)
    18:58:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.makeWarning(HeroicRebuke.java:534)
    18:58:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.onCommand(HeroicRebuke.java:197)
    18:58:28 [SEVERE]       at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    18:58:28 [SEVERE]       at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80)
    18:58:28 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:221)
    18:58:28 [SEVERE]       at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:380)
    18:58:28 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:366)
    18:58:28 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:272)
    18:58:28 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    18:58:28 [INFO] joseph3114 is online and has been warned.
    >18:58:28 [SEVERE] [HeroicRebuke] Warning creation error: java.sql.SQLException: SQL logic error or missing database
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    >18:58:28 [SEVERE] java.sql.SQLException: SQL logic error or missing database
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    >18:58:28 [SEVERE]       at org.sqlite.DB.throwex(DB.java:288)
    >18:58:28 [SEVERE]       at org.sqlite.DB.exec(DB.java:68)
    >18:58:28 [SEVERE]       at org.sqlite.Conn.commit(Conn.java:172)
    >18:58:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebukeSQLite.newWarning(HeroicRebukeSQLite.java:68)
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    >18:58:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.makeWarning(HeroicRebuke.java:534)
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    >18:58:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.onCommand(HeroicRebuke.java:197)
    >18:58:28 [SEVERE]       at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    >18:58:28 [SEVERE]       at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80)
    >18:58:28 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:221)
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    >18:58:28 [SEVERE]       at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:380)
    >18:58:28 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:366)
    >18:58:28 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:272)
    >18:58:28 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    18:58:44 [INFO] Unknown console command. Type "help" for help.
    

    and on acknowledge

    Code:
    19:01:28 [SEVERE] [HeroicRebuke] Warning creation error: java.sql.SQLException: SQL logic error or missing database
    19:01:28 [SEVERE] java.sql.SQLException: SQL logic error or missing database
    19:01:28 [SEVERE]       at org.sqlite.DB.throwex(DB.java:288)
    19:01:28 [SEVERE]       at org.sqlite.DB.exec(DB.java:68)
    19:01:28 [SEVERE]       at org.sqlite.Conn.commit(Conn.java:172)
    19:01:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebukeSQLite.newWarning(HeroicRebukeSQLite.java:68)
    19:01:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.makeWarning(HeroicRebuke.java:534)
    19:01:28 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.onCommand(HeroicRebuke.java:197)
    19:01:28 [SEVERE]       at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    19:01:28 [SEVERE]       at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80)
    19:01:28 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:229)
    19:01:28 [SEVERE]       at net.minecraft.server.NetServerHandler.c(NetServerHandler.java:645)
    19:01:28 [SEVERE]       at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:608)
    19:01:28 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:602)
    19:01:28 [SEVERE]       at net.minecraft.server.Packet3Chat.a(SourceFile:24)
    19:01:28 [SEVERE]       at net.minecraft.server.NetworkManager.a(SourceFile:230)
    19:01:28 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:76)
    19:01:28 [SEVERE]       at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    19:01:28 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:357)
    19:01:28 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:272)
    19:01:28 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    19:01:39 [INFO] Ack Statement: UPDATE `warnings` SET `ack` = '1', `ack_time` = CURRENT_TIMESTAMP WHERE `ack` = '0' AND `to` LIKE 'joseph3114'
    19:01:39 [INFO] Updated.
    19:01:39 [SEVERE] [HeroicRebuke] Warning acknowledge error: java.sql.SQLException: SQL logic error or missing database
    19:01:39 [SEVERE] java.sql.SQLException: SQL logic error or missing database
    19:01:39 [SEVERE]       at org.sqlite.DB.throwex(DB.java:288)
    19:01:39 [SEVERE]       at org.sqlite.DB.exec(DB.java:68)
    19:01:39 [SEVERE]       at org.sqlite.Conn.commit(Conn.java:172)
    19:01:39 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebukeDatasource.ackWarning(HeroicRebukeDatasource.java:61)
    19:01:39 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.ackWarning(HeroicRebuke.java:578)
    19:01:39 [SEVERE]       at com.herocraftonline.squallseed31.heroicrebuke.HeroicRebuke.onCommand(HeroicRebuke.java:295)
    19:01:39 [SEVERE]       at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    19:01:39 [SEVERE]       at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:80)
    19:01:39 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:229)
    19:01:39 [SEVERE]       at net.minecraft.server.NetServerHandler.c(NetServerHandler.java:645)
    19:01:39 [SEVERE]       at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:608)
    19:01:39 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:602)
    19:01:39 [SEVERE]       at net.minecraft.server.Packet3Chat.a(SourceFile:24)
    19:01:39 [SEVERE]       at net.minecraft.server.NetworkManager.a(SourceFile:230)
    19:01:39 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:76)
    19:01:39 [SEVERE]       at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    19:01:39 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:357)
    19:01:39 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:272)
    19:01:39 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    
     
  17. Offline

    SquallSeeD31

    Have you given me a plugin list yet, Operating System, et cetera?

    I'm reading over those errors, and the stacktraces help, but I still can't figure out why this happens *only to you* and not to anyone else who uses it. I want to fix it for you, but we're getting further and further away from my own code in the process. Do you use any plugins that use SQLite (other than LWC which uses native connectors) successfully otherwise?
     
  18. Offline

    PatrickFreed

    Can you add it so after a number of user defined warnings, it bans them?
     
  19. Offline

    SquallSeeD31

    Sure, I'll work on that for my next build.
     
  20. Offline

    PatrickFreed

    Thanks, I'm not a big fan of banning people so that should come in handy :D
     
  21. Offline

    Joseph3114

    CentOS linux something
    iConomy uses SQLite maybe? and MyWarp,
     
  22. Offline

    SquallSeeD31

  23. Offline

    Joseph3114

    Okay, there are no error messages now, however
    /warn list is blank everytime the server reloads meaning it still isn't saving.
     
  24. Offline

    angus22397

    please respond to this message it was an earlier message, where you said you might be able to make it so i can freeze players without them unfreezing.
     
  25. Offline

    SquallSeeD31

    Yeah, I didn't think that'd work, just had to try it.

    This is my last shot at this particular issue, without the help of an expert it's just beyond me otherwise: http://dl.dropbox.com/u/1131502/HeroicRebuke/plugins/HeroicRebuke-INDEV.jar

    Development of new plugins comes before support of old ones for me, and Minecraft is still just a hobby. I agree with your feature request, but I'm going to do the things I get paid for first, please understand. =)

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

    angus22397

    Ok,
    is it alright if i ask another plugin developer or screw around with it myself?
     
  27. Offline

    Joseph3114

    We're back to:
    22:36:19 [SEVERE] [HeroicRebuke] Warning creation error: java.sql.SQLException: SQL logic error or missing database
    22:37:11 [SEVERE] [HeroicRebuke] Warning acknowledge error: java.sql.SQLException: SQL logic error or missing database

    :( I will ask my host if there's anything special with SQLite, they say they support it.

    Also, do you work full time for HeroCraft?
     
  28. Offline

    SquallSeeD31

    That's all covered in the license, but the short version is yes. You can try the indev build if you'd like, it's roughly implemented and tested but I'm not ready to make a public release: http://dl.dropbox.com/u/1131502/HeroicRebuke/plugins/HeroicRebuke-INDEV.jar

    To enable freezing, run it once to generate the new config options (or reload), then set "canAcknowledge" to false. This prevents users from seeing the acknowledge code or being able to acknowledge warnings, so an admin would have to manually clear them. If you combine it with block_move, they're effectively "rooted".

    So, the issue comes from when I call a commit on the connection. It works fine when the database is created, but not when I'm performing any other queries or statements. Unfortunately, when I disabled commits (and removed setAutoCommit(false), it didn't save for you (or me--I didn't have time to test before, but when I did, that happened). I tried cleaning up the connection management again with my initial code, but that didn't fix your problem.

    I suppose this is a silly question, but could you try just deleting the db file that's already been created, re-download the original build of HeroicRebuke and run it again? Could have been a weird error in the initial creation of the database that's been holding you back. (Delete the journal file too if that's still there).

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

    Joseph3114

    No luck :(

    Would switching it to MySQL work?
    No one else has this issue so obviously it's me, and I really appreciate all the time you've spent helping me today.

    Thankyou Squall
     
  30. Offline

    SquallSeeD31

    MySQL definitely doesn't have this problem, and I know a lot more about MySQL, so if it *does* happen to you, hopefully I can fix it. I can even fix the annoying transient connection error in MySQL. :p

    Sorry SQLite was such a pain for you; it's supposed to be lightweight (hence the name). Maybe I'm doing it wrong, but either way if you want to get it working and *can* use MySQL, please do. =)
     
  31. Offline

    Joseph3114

    I'll try tomorrow when I get home. Thanks for all the help troubleshooting, Squall.
     

Share This Page