PreciousStones - Back under the development of phaed

Discussion in 'Inactive/Unsupported Plugins' started by aPunch, Apr 20, 2011.

Thread Status:
Not open for further replies.
  1. Offline

    aPunch

    Ryannober, Avous and kahlilnc like this.
  2. Offline

    Ryannober

    I know this is kind of annoying, but can someone send me a config.yml file with all of the Pstones taken out except city protect snitch and deathblock? whenever i try to do this it get errors thrown at me. Thanks in advance!
    -Ryan
     
  3. Offline

    devatrox

    This is pretty cool :D Trying it now on our server because people never seem to understand cuboid selections and this seems easy enough!

    A question: Is there a way to remove a force field from a block without destroying it? Because sometimes I want to just build with it but don't want to use the field. Put most of my force fields to Ore blocks though because they look ugly enough to not use them for building.

    Some bugs I have found so far (will put that in the Github):
    I placed a city protection block, gave it a name and then placed more blocks to make it bigger. It seems to link up fine but the entry/leave messages still only work around the very first block force field.

    When I placed an Air of Atlantis block in the water and then destroyed it, it said "force field destroyed" but the breathing effect was still there.
     
  4. Offline

    Maxis010

    To have a PS block without a forcefield use /ps off before you place the block down, just remember to /ps on afterwards
    As for the CP block that isn't a bug, you need to link all the blocks then name them
     
  5. Offline

    Ryannober

    I get a ton of errors when i edit anything in my config.yml file, even when i have the exact copy of my friends config ( which works perfectly on his server) It fails on mine
    heres the error(s)
    Code:
    2011-06-18 22:04:23 [SEVERE] Could not pass event CREATURE_SPAWN to PreciousStones
    java.lang.NullPointerException
        at net.sacredlabyrinth.Phaed.PreciousStones.managers.ForceFieldManager.isAnimalSpawnProtected(Unknown Source)
        at net.sacredlabyrinth.Phaed.PreciousStones.listeners.PSEntityListener.onCreatureSpawn(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader$59.execute(JavaPluginLoader.java:654)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:310)
        at org.bukkit.craftbukkit.event.CraftEventFactory.callCreatureSpawnEvent(CraftEventFactory.java:232)
        at net.minecraft.server.World.addEntity(World.java:820)
        at net.minecraft.server.SpawnerCreature.spawnEntities(SourceFile:155)
        at net.minecraft.server.World.doTick(World.java:1595)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:389)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-18 22:04:23 [SEVERE] Could not pass event CREATURE_SPAWN to PreciousStones
    java.lang.NullPointerException
        at net.sacredlabyrinth.Phaed.PreciousStones.managers.ForceFieldManager.isAnimalSpawnProtected(Unknown Source)
        at net.sacredlabyrinth.Phaed.PreciousStones.listeners.PSEntityListener.onCreatureSpawn(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader$59.execute(JavaPluginLoader.java:654)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:310)
        at org.bukkit.craftbukkit.event.CraftEventFactory.callCreatureSpawnEvent(CraftEventFactory.java:232)
        at net.minecraft.server.World.addEntity(World.java:820)
        at net.minecraft.server.SpawnerCreature.spawnEntities(SourceFile:155)
        at net.minecraft.server.World.doTick(World.java:1595)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:389)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-18 22:04:23 [SEVERE] Could not pass event CREATURE_SPAWN to PreciousStones
    java.lang.NullPointerException
        at net.sacredlabyrinth.Phaed.PreciousStones.managers.ForceFieldManager.isAnimalSpawnProtected(Unknown Source)
        at net.sacredlabyrinth.Phaed.PreciousStones.listeners.PSEntityListener.onCreatureSpawn(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader$59.execute(JavaPluginLoader.java:654)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:310)
        at org.bukkit.craftbukkit.event.CraftEventFactory.callCreatureSpawnEvent(CraftEventFactory.java:232)
        at net.minecraft.server.World.addEntity(World.java:820)
        at net.minecraft.server.SpawnerCreature.spawnEntities(SourceFile:155)
        at net.minecraft.server.World.doTick(World.java:1595)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:389)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-18 22:04:29 [INFO] ?e|||||||?8|||?f ?fsilence1453?f: no creeper your fine
    2011-06-18 22:04:41 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:41 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:41 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:42 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:42 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:42 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:42 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:42 [INFO] ?e|||||?8|||||?f ?fcreeperliam?f: there was a zombie in your tree room
    2011-06-18 22:04:43 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    2011-06-18 22:04:43 [SEVERE] Could not pass event PLAYER_MOVE to PreciousStones
    java.lang.NullPointerException
    
    I have the most up-to-date version of this plugin and Bukkit.
    Any ideas?
    -Ryan
     
  6. Offline

    Maxis010

    Can you post your config, I don't know what checks you have performed and what programs you have used to do so but just because a file looks identical doesn't mean it is
     
  7. Offline

    Ryannober

    Here it is: :) I use text edit to open and edit things if that means anything
    Code:
    bypass-blocks: [39,40,51,59]             # mushrooms, fire, crops
    unbreakable-blocks: []                 # gold
    unprotectable-blocks: []      # chest, workbench, furnaces
    tool-items: [269,270,271,273,274,275,277,278,279,284,285,286,290,291,292,293,294]   #tools
    cloak:
        cloakable-blocks: [54,58,61]         # chest, workbench, furnace
        cloak-blocks: [1,2,3,4,5,7,17,20,43,45,49,60,78,80,82,87,88] # everyday solid materials
        viewing-radius:
            min: 5
            max: 20
            default: 7
    force-field-blocks:
        -
          title: "Large Protection"
          block: 57
          radius: 10
          custom-height: 36
          prevent-fire: true
          prevent-place: true
          prevent-destroy: true
          prevent-explosions: true
          prevent-unprotectable: true
          guard-dog: false
          nameable: true
          welcome-message: true
          farewell-message: true
          slow-damage: false
          slow-heal: false
          prevent-entry: false
          prevent-pvp: false
          breakable: false
        -
          title: "Small Protection"
          block: 41
          radius: 4
          custom-height: 32
          prevent-fire: true
          prevent-place: true
          prevent-destroy: true
          prevent-explosions: true
          prevent-unprotectable: true
          guard-dog: false
          nameable: false
          welcome-message: false
          farewell-message: false
          slow-damage: false
          slow-heal: false
          prevent-entry: false
          prevent-pvp: false
          breakable: false
        -
          title: "Donator Village"
          block: 19
          radius: 17
          custom-height: 100
          prevent-fire: true
          prevent-place: true
          prevent-destroy: true
          prevent-explosions: true
          prevent-unprotectable: true
          guard-dog: false
          nameable: true
          welcome-message: true
          farewell-message: true
          slow-damage: false
          slow-heal: true
          prevent-entry: true
          prevent-pvp: true
          breakable: false
        -
          title: "Healing Block"
          block: 22
          radius: 0
          custom-height: 6
          prevent-fire: false
          prevent-place: false
          prevent-destroy: false
          prevent-explosions: false
          prevent-unprotectable: true
          guard-dog: false
          nameable: false
          welcome-message: false
          farewell-message: false
          slow-damage: false
          slow-heal: true
          prevent-entry: false
          prevent-pvp: false
          breakable: false
        -
          title: "Proximity Snitch"
          block: 56
          radius: 10
          snitch: true
          no-conflict: true
    #    -
    #      title: "Launch Pad"
    #      block: 21
    #      radius: 1
    #      launch: true
    #      no-conflict: true
        -
          title: "Death Block"
          block: 21
          radius: 5
          slow-damage: true
          no-conflict: true
    #    -
    #      title: "Dungeon"
    #      block: 88
    #      radius: 20
    #      custom-height: 4
    #      prevent-fire: false
    #      prevent-place: false
    #      prevent-destroy: false
    #      prevent-explosions: false
    #      prevent-unprotectable: false
    #      guard-dog: false
    #      nameable: false
    #      welcome-message: false
    #      farewell-message: false
    #      slow-damage: true
    #      slow-heal: false
    #      prevent-entry: false
    #      prevent-pvp: false
    #      breakable: false
    log:
        entry: false
        fire: true
        pvp: false
        place: false
        destroy: false
        destroy-area: false
        unprotectable: true
        bypass-pvp: true
        bypass-delete: true
        bypass-destroy: true
        bypass-unprotectable: true
        conflict-place: true
    notify:
        place: false
        destroy: false
        bypass-place: false
        bypass-destroy: true
        bypass-unprotectable: true
        guard-dog: true
    warn:
        entry: true
        fire: true
        pvp: true
        place: true
        destroy: true
        destroy-area: true
        unprotectable: true
        instant-heal: true
        slow-heal: true
        slow-damage: true
        give-air: true
        launch: true
        cannon: true
        mine: true
    settings:
        public-block-details: true
        allowed-can-break-pstones: false
        sneaking-bypasses-damage: true
        drop-on-delete: true
        disable-alerts-for-admins: true
        disable-bypass-alerts-for-admins: false
        off-by-default: false
        lines-per-page: 12
    saving:
        frequency-minutes: 5
        purge-backups-after-days: 7
     
  8. Offline

    Maxis010

    Well your config is not at fault, I was kind of hoping it was but oh well
    Do you by any chance have WorldGuard while your friend does not, I recall seeing this error for MultiVerse when WorldGuard was installed
     
  9. Offline

    Ryannober

    Started a convo with you, and yes my friend does have world guard ;)
     
  10. Offline

    Keegan

    I installed mysql with the database and everything, but I still get "unknown command" whenever I type /ps or any ps commands.
     
  11. Offline

    phaed

    If you change a field in your config from one block type to another, then you have to remove all fields stored in the database that are using the old block type. Otherwise you will get errors.
     
  12. Offline

    Latros

    Hey Phaed - I'd like to report an issue with your plugin,

    When you do the name feature (name fields so people see what area they're entering), if you are doing the name feature overtop multiple forcefield (usually lots), it lags and in some cases can CRASH a server.

    I run a server with currently 55,000 forcefields placed and we're starting to feel the occasional hiccup, and I check the log and its because someone is doing the name command.

    Just something to look into :) And/or add a permissions node so I can DENY players access to that command.
     
  13. Offline

    Maxis010

    preciousstones.benefit.setname
    Revoke this permission
     
  14. I need to create all mysql tables manually. Post sql-query please.
    Just export yours in sql format and post.
     
  15. Offline

    Maxis010

    If someone else gives you a query then use that, if not then you can build the tables off of this
    Code:
    ps_allowed_players
    +----------+--------------+------+-----+---------+----------------+
    | Field    | Type         | Null | Key | Default | Extra          |
    +----------+--------------+------+-----+---------+----------------+
    | id       | bigint(20)   | NO   | PRI | NULL    | auto_increment |
    | name     | varchar(255) | NO   |     | NULL    |                |
    | perm     | varchar(255) | NO   |     | NULL    |                |
    | field_id | bigint(20)   | YES  | MUL | NULL    |                |
    +----------+--------------+------+-----+---------+----------------+
    
    ps_cloaked
    +-----------+------------+------+-----+---------+----------------+
    | Field     | Type       | Null | Key | Default | Extra          |
    +-----------+------------+------+-----+---------+----------------+
    | id        | bigint(20) | NO   | PRI | NULL    | auto_increment |
    | data_byte | tinyint(4) | YES  |     | NULL    |                |
    +-----------+------------+------+-----+---------+----------------+
    
    ps_fields
    +----------------+--------------+------+-----+---------+----------------+
    | Field          | Type         | Null | Key | Default | Extra          |
    +----------------+--------------+------+-----+---------+----------------+
    | id             | bigint(20)   | NO   | PRI | NULL    | auto_increment |
    | x              | int(11)      | YES  | MUL | NULL    |                |
    | y              | int(11)      | YES  |     | NULL    |                |
    | z              | int(11)      | YES  |     | NULL    |                |
    | world          | varchar(255) | YES  |     | NULL    |                |
    | radius         | int(11)      | YES  |     | NULL    |                |
    | height         | int(11)      | YES  |     | NULL    |                |
    | velocity       | float        | YES  |     | NULL    |                |
    | type_id        | int(11)      | YES  |     | NULL    |                |
    | owner          | varchar(255) | NO   |     | NULL    |                |
    | name           | varchar(255) | NO   |     | NULL    |                |
    | cloak_entry_id | bigint(20)   | YES  | MUL | NULL    |                |
    | chunk_x        | int(11)      | YES  |     | NULL    |                |
    | chunk_z        | int(11)      | YES  |     | NULL    |                |
    +----------------+--------------+------+-----+---------+----------------+
    
    ps_item_stacks
    +----------------+-------------+------+-----+---------+----------------+
    | Field          | Type        | Null | Key | Default | Extra          |
    +----------------+-------------+------+-----+---------+----------------+
    | id             | bigint(20)  | NO   | PRI | NULL    | auto_increment |
    | type           | int(11)     | YES  |     | NULL    |                |
    | amount         | int(11)     | YES  |     | NULL    |                |
    | data_byte      | tinyint(4)  | YES  |     | NULL    |                |
    | durability     | smallint(6) | YES  |     | NULL    |                |
    | cloak_entry_id | bigint(20)  | YES  | MUL | NULL    |                |
    +----------------+-------------+------+-----+---------+----------------+
    
    ps_snitch_entries
    +-------------+--------------+------+-----+---------+----------------+
    | Field       | Type         | Null | Key | Default | Extra          |
    +-------------+--------------+------+-----+---------+----------------+
    | id          | bigint(20)   | NO   | PRI | NULL    | auto_increment |
    | name        | varchar(255) | NO   |     | NULL    |                |
    | reason      | varchar(255) | NO   |     | NULL    |                |
    | details     | varchar(255) | NO   |     | NULL    |                |
    | event_count | int(11)      | YES  |     | NULL    |                |
    | field_id    | bigint(20)   | YES  | MUL | NULL    |                |
    +-------------+--------------+------+-----+---------+----------------+
    
    ps_unbreakables
    +---------+--------------+------+-----+---------+----------------+
    | Field   | Type         | Null | Key | Default | Extra          |
    +---------+--------------+------+-----+---------+----------------+
    | id      | bigint(20)   | NO   | PRI | NULL    | auto_increment |
    | x       | int(11)      | YES  | MUL | NULL    |                |
    | y       | int(11)      | YES  |     | NULL    |                |
    | z       | int(11)      | YES  |     | NULL    |                |
    | world   | varchar(255) | YES  |     | NULL    |                |
    | owner   | varchar(255) | NO   |     | NULL    |                |
    | type_id | int(11)      | YES  |     | NULL    |                |
    +---------+--------------+------+-----+---------+----------------+
    I can't fetch a query without allowing remote connections to the database, unless someone knows an SQL command for that purpose that can be entered in to a console
    P.S Don't recommend phpMyAdmin or any other such tools, it's set up this way for a reason
     
    Raxo likes this.
  16. Offline

    phaed

    Run this, it will create them for you.

    Code:
    -- phpMyAdmin SQL Dump
    -- version 2.11.9.4
    -- http://www.phpmyadmin.net
    --
    -- Host:
    -- Generation Time: Jun 19, 2011 at 02:21 PM
    -- Server version: 5.0.77
    -- PHP Version: 5.2.14
    
    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    
    --
    -- Database: `minecraft`
    --
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `ps_allowed_players`
    --
    
    CREATE TABLE IF NOT EXISTS `ps_allowed_players` (
      `id` bigint(20) NOT NULL auto_increment,
      `name` varchar(255) NOT NULL,
      `perm` varchar(255) NOT NULL,
      `field_id` bigint(20) default NULL,
      PRIMARY KEY  (`id`),
      KEY `ix_ps_allowed_players_field_1` (`field_id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `ps_cloaked`
    --
    
    CREATE TABLE IF NOT EXISTS `ps_cloaked` (
      `id` bigint(20) NOT NULL auto_increment,
      `data_byte` tinyint(4) default NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `ps_fields`
    --
    
    CREATE TABLE IF NOT EXISTS `ps_fields` (
      `id` bigint(20) NOT NULL auto_increment,
      `x` int(11) default NULL,
      `y` int(11) default NULL,
      `z` int(11) default NULL,
      `world` varchar(255) default NULL,
      `radius` int(11) default NULL,
      `height` int(11) default NULL,
      `velocity` float default NULL,
      `type_id` int(11) default NULL,
      `owner` varchar(255) NOT NULL,
      `name` varchar(255) NOT NULL,
      `cloak_entry_id` bigint(20) default NULL,
      `chunk_x` int(11) default NULL,
      `chunk_z` int(11) default NULL,
      PRIMARY KEY  (`id`),
      UNIQUE KEY `uq_ps_fields_1` (`x`,`y`,`z`,`world`),
      KEY `ix_ps_fields_cloakEntry_2` (`cloak_entry_id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `ps_item_stacks`
    --
    
    CREATE TABLE IF NOT EXISTS `ps_item_stacks` (
      `id` bigint(20) NOT NULL auto_increment,
      `type` int(11) default NULL,
      `amount` int(11) default NULL,
      `data_byte` tinyint(4) default NULL,
      `durability` smallint(6) default NULL,
      `cloak_entry_id` bigint(20) default NULL,
      PRIMARY KEY  (`id`),
      KEY `ix_ps_item_stacks_cloakEntry_3` (`cloak_entry_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `ps_snitch_entries`
    --
    
    CREATE TABLE IF NOT EXISTS `ps_snitch_entries` (
      `id` bigint(20) NOT NULL auto_increment,
      `name` varchar(255) NOT NULL,
      `reason` varchar(255) NOT NULL,
      `details` varchar(255) NOT NULL,
      `event_count` int(11) default NULL,
      `field_id` bigint(20) default NULL,
      PRIMARY KEY  (`id`),
      KEY `ix_ps_snitch_entries_field_4` (`field_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `ps_unbreakables`
    --
    
    CREATE TABLE IF NOT EXISTS `ps_unbreakables` (
      `id` bigint(20) NOT NULL auto_increment,
      `x` int(11) default NULL,
      `y` int(11) default NULL,
      `z` int(11) default NULL,
      `world` varchar(255) default NULL,
      `owner` varchar(255) NOT NULL,
      `type_id` int(11) default NULL,
      PRIMARY KEY  (`id`),
      UNIQUE KEY `uq_ps_unbreakables_1` (`x`,`y`,`z`,`world`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `teams`
    --
    
    CREATE TABLE IF NOT EXISTS `teams` (
      `id` bigint(20) NOT NULL auto_increment,
      `tag` varchar(25) NOT NULL,
      `color_tag` varchar(25) NOT NULL,
      `name` varchar(100) NOT NULL,
      `friendly_fire` tinyint(1) default '0',
      `founded` datetime NOT NULL,
      `last_used` datetime NOT NULL,
      `packed_allies` text NOT NULL,
      `packed_rivals` text NOT NULL,
      `packed_bb` mediumtext NOT NULL,
      PRIMARY KEY  (`id`),
      UNIQUE KEY `uq_teams_1` (`tag`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `team_players`
    --
    
    CREATE TABLE IF NOT EXISTS `team_players` (
      `id` bigint(20) NOT NULL auto_increment,
      `name` varchar(16) NOT NULL,
      `leader` tinyint(1) default '0',
      `tag` varchar(25) NOT NULL,
      `friendly_fire` tinyint(1) default '0',
      `neutral_kills` int(11) default NULL,
      `rival_kills` int(11) default NULL,
      `civilian_kills` int(11) default NULL,
      `deaths` int(11) default NULL,
      `last_seen` datetime NOT NULL,
      PRIMARY KEY  (`id`),
      UNIQUE KEY `uq_team_players_1` (`name`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
     
    Raxo likes this.
  17. Offline

    Biebboek

    Hi,

    Thanks for your hard work on this wonderful plugin. I am getting an error. Needless to say, PreciousStones does not work.

    Server log:
    Show Spoiler
    00:13:34 [SEVERE] Error occurred while enabling PreciousStones v4.2.5 (Is it up to date?): Error: Error executing stmt[alter table ps_allowed_players add constraint fk_ps_allowed_players_field_1 foreign key (field_id) references ps_fields (id)] error[[SQLITE_ERROR] SQL error or missing database (near "constraint": syntax error)]
    javax.persistence.PersistenceException: Error: Error executing stmt[alter table ps_allowed_players add constraint fk_ps_allowed_players_field_1 foreign key (field_id) references ps_fields (id)] error[[SQLITE_ERROR] SQL error or missing database (near "constraint": syntax error)]
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:233)
    at org.bukkit.plugin.java.JavaPlugin.installDDL(JavaPlugin.java:251)
    at net.sacredlabyrinth.Phaed.PreciousStones.PreciousStones.setupDatabase(Unknown Source)
    at net.sacredlabyrinth.Phaed.PreciousStones.PreciousStones.onEnable(Unknown Source)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:125)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:799)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:253)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:140)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:118)
    at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:345)
    at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleCommandMap.java:247)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:128)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:287)
    at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:712)
    at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:678)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:671)
    at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:399)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.RuntimeException: Error executing stmt[alter table ps_allowed_players add constraint fk_ps_allowed_players_field_1 foreign key (field_id) references ps_fields (id)] error[[SQLITE_ERROR] SQL error or missing database (near "constraint": syntax error)]
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:281)
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:246)
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:224)
    ... 22 more
    Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "constraint": syntax error)
    at org.sqlite.DB.newSQLException(DB.java:383)
    at org.sqlite.DB.newSQLException(DB.java:387)
    at org.sqlite.DB.throwex(DB.java:374)
    at org.sqlite.NativeDB.prepare(Native Method)
    at org.sqlite.DB.prepare(DB.java:123)
    at org.sqlite.PrepStmt.<init>(PrepStmt.java:42)
    at org.sqlite.Conn.prepareStatement(Conn.java:404)
    at org.sqlite.Conn.prepareStatement(Conn.java:399)
    at org.sqlite.Conn.prepareStatement(Conn.java:383)
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnection.prepareStatement(PooledConnection.java:426)
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnection.prepareStatement(PooledConnection.java:396)
    at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:271)
    ... 24 more

    bukkit.yml:
    Show Spoiler
    settings:
    update-folder: update
    database:
    username: not-root
    isolation: SERIALIZABLE
    driver: com.mysql.jdbc.Driver
    password: correct-password
    url: jdbc:mysql://localhost/minecraft

    I have a database called ''minecraft'' and the user has all the required permissions to it. LogBlock, the only other plugin I have installed that uses SQL does also use this user and database. I am probably doing something wrong or there is something I overlooked. What is it?
     
  18. Offline

    Maxis010

    Check that LogBlock is in fact using that MySQL database as what I see and what you say works except for the SQLITE_ERROR in that error stack
    @phaed might have a genius in sight for this
     
  19. Offline

    Biebboek

    Hmm, couldn't fix it yet. LogBlock seems to use MySQL and appears to be running fine. It is strange that it is a Sqlite error, is it? My config seems to be a MySQL one and I have no idea what I am doing wrong.

    Never mind, when I rebooted the machine just now (and MySQL got it's first reboot) it apparently started to work. Thanks for your help Maxis010!
     
  20. Using /ps delete <player> just gives me No force-fields found :( I cant clean up the forcefields of ppl who have left or been banned :
     
  21. Offline

    fugue2005

    i'm an op and admin with *

    when i do /ps delete all o get is

    /ps help- displays presciousstones commands
     
  22. same
     
  23. Offline

    FusedZero

  24. Offline

    Hitman4Hire

    How on earth do you install Sql? Could you have an option to disable it...
     
  25. Offline

    minechomp

    uh the commands dont do anything and the blocks dont work.
     
  26. Offline

    dfdgsdfg

  27. Offline

    Bronski

    I'm still having occasional problems with names being saved. I can do setname to name the area, verify it with /ps info, walk just outside the range and come back, getting both the leaving the entering messages correctly displayed, but once I do /ps save, it reverts back. I'll post more if I figure it out but this is now 2 servers where I've experienced this problem (setup by 2 different, unconnected people).
     
  28. Offline

    Ratchet

    I don't know what to tell you guys, i'm still getting this problem where protection sponges I have sometimes turn the blocks around them to "Air". look at this screenshot:
    [​IMG]
     
  29. Offline

    Fre3bz

    Hey a few little issues we have found with pstones are that when you break the block it isn't destroying the field, if you have the redstone ore as a pstone for admin only pstones, upon break it doesn't return the ore, it gives the redstone dust. I'm not sure what you could do about something like this but just thought you should be informed.
     
  30. Offline

    Hitman4Hire

    Could you add the ability to set the welcome and departure message for a peace keeper?
     
  31. Offline

    phaed

    You can already do this. Add flags nameable, welcome, farewell.
     
Thread Status:
Not open for further replies.

Share This Page