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

    Maxis010

    SQLite doesn't support the JOIN query and flatfiles cause more and more lag the bigger they get so MySQL is currently the only option for phaed
    @Guvnors
    If you can't get MySQL working at all give me a shout and I'll upload a pre-v4 copy of PreciousStones
    Don't ask me for help with it, don't ask phaed help with it, he isn't supporting it and neither will I
     
  3. Offline

    phaed

    It does. It removes all entries form the database that no longer exist on the world on startup.
     
  4. Offline

    Guvnors

    Ahh after testing I got it to work, however no commands work it just says /ps help.
    I am an OP, I have added permissions. Thanks for the help so far.
     
  5. Offline

    phaed

  6. Honestly, getting slightly f*ked off at this now bud, I've tried the latest 4.2.2 above n the .1, still got the "/ps help" issue.

    It was working fine, until i updated and then i lost the .jar file. :(

    Also, please add a config SPECIFIC to that plugin so it doesnt rely on bukkit.yml, i'm on a box which is semi-managed and with me having root access to the MYSQL database i had to add a "minecraft" databse as editing the url: jdbc:mysql://localhost/minecraft to url: jdbc:mysql://localhost/eastonch didn't seem to work.

    I'd like to be able to do this, thanks #eastonch
     
  7. Offline

    NEO

    @phaed
     
  8. Offline

    Maxis010

    @NEO
    You are understanding the nodes correctly, I can assure you of that

    Stupid idea but one which has worked for me in the past, break the bounce and launcher blocks, turn PS off then once it returns they are off turn it back on again
    Replace the blocks
    /ps info them to ensure that they have been placed correctly

    Chances are you have already done this but thought I would recommend it anyway as there have been multiple times when I thought I placed a block correctly but PreciousStones disagreed
     
  9. Offline

    phaed

    You don't need to have the database named "minecraft" it could be named whatever you want as long as it exists and is specified in the bukkit.yml.

    Obviously you haven't heard that we are using bukkit's built-in persistence system called ebeans which is shared amongst all plugins, so your idea of a SPECIFIC config does not apply here.

    Very odd, haven't heard of this before, have you tried changing the radius etc, and testing around? What verison of CB you using?

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

    NEO

    CB 766, ive tried changing everything, ive tested for hours. I finally decided to post. It does work for the user who placed it and anyone with the * permission. Ive triple checked my permissions aswell. Nodes are correctly placed and spelled.
     
  11. Offline

    phaed

    Aha, i will check on this. If you do /ps allow *. Does this make it work? How about allowing one user making sure you're using the correct case for his name.
     
  12. Offline

    MrCeaser

    I need this so bad but i do not know sql could someone make me a sample one i can fill in to get this working like the whole plugin in general
     
  13. Offline

    phaed

    Lmao, you ask this as if it were something someone could do for you in a few minutes. What you ask has nothing to do with SQL, it is building a whole system which may take dozens upon dozens of hours. You are basically asking to recreate BigBrother for you, so "you can fill it in", whatever that means. Granted it is a good idea.
     
  14. Offline

    NEO

    This works. Still odd that it doesnt work with the nodes.
     
  15. Offline

    phaed

    Ahh, yes need to fix that. Thanks for letting me know.
     
  16. Offline

    MrCeaser

    lol see i dont know enough to know it would take that long lol

    the instructions just seem to say make a myswl database named minecraft, so the inside of the database should be blank?

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

    phaed

    Yes you don't need to create any tables in the database (by database i mean a MySQL database, not a .db file like sqlite).
     
  18. Offline

    Guvnors

  19. Offline

    phaed

    Post here, on a code block, everything PreciousStones spits out to the console/log when your server loads.
     
  20. Offline

    Guvnors

    Code:
    2011-05-18 13:49:53 [INFO] [iChat] Found Permissions (v2.7.3)
    2011-05-18 13:49:53 [INFO] iChat (v2.2.3) enabled
    2011-05-18 13:49:53 [INFO] Lockette version 1.3.8 is being enabled!  Yay!  (Core version 1.0)
    2011-05-18 13:49:53 [INFO] Lockette: Detected craftbukkit build [766] ok.
    2011-05-18 13:49:53 [INFO] Lockette: Linked to Permissions plugin version 2.7.3
    2011-05-18 13:49:53 [INFO] Lockette: Using ops file for admin permissions.
    2011-05-18 13:49:53 [INFO] Lockette: Ready to protect your containers.
    2011-05-18 13:49:53 [INFO] LoginMessage 0.6_4 enabled
    2011-05-18 13:49:53 [INFO] [mcMMO] Permissions enabled.
    2011-05-18 13:49:53 [INFO] mcMMO version 1.0.07 is enabled!
    2011-05-18 13:49:53 [INFO] NoFire version 1.1 is enabled!
    2011-05-18 13:49:53 [INFO] Can not test connection as heartbeatsql is not set
    2011-05-18 13:49:53 [INFO] Closing Connection[PreciousStones.1] psReuse[0] psCreate[1] psSize[0]
    2011-05-18 13:49:53 [INFO] Installing database for PreciousStones due to first time usage
    2011-05-18 13:49:53 [INFO] runScript
    2011-05-18 13:49:53 [INFO] executing 1 of 14 create table ps_allowed_players ( id                        bigint primary key,...
    2011-05-18 13:49:53 [INFO] executing 2 of 14 create table ps_cloaked ( id                        bigint primary key, data_byt...
    2011-05-18 13:49:53 [INFO] executing 3 of 14 create table ps_fields ( id                        bigint primary key, x...
    2011-05-18 13:49:53 [INFO] executing 4 of 14 create table ps_item_stacks ( id                        bigint primary key, type...
    2011-05-18 13:49:53 [INFO] executing 5 of 14 create table ps_snitch_entries ( id                        bigint primary key, n...
    2011-05-18 13:49:53 [INFO] executing 6 of 14 create table ps_unbreakables ( id                        bigint primary key, x...
    2011-05-18 13:49:53 [INFO] executing 7 of 14 alter table ps_allowed_players add constraint fk_ps_allowed_players_field_1 fore...
    2011-05-18 13:49:53 [INFO] Can not test connection as heartbeatsql is not set
    2011-05-18 13:49:53 [INFO] Closing Connection[PreciousStones.0] psReuse[0] psCreate[7] psSize[6]
    2011-05-18 13:49:53 [INFO] DataSourcePool [PreciousStones] grow; id[PreciousStones.2] busy[3] max[20]
    2011-05-18 13:49:53 [SEVERE] 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)] loading PreciousStones v4.2.2 (Is it up to date?)
    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:253)
        at net.sacredlabyrinth.Phaed.PreciousStones.PreciousStones.setupDatabase(PreciousStones.java:154)
        at net.sacredlabyrinth.Phaed.PreciousStones.PreciousStones.onEnable(PreciousStones.java:85)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:218)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:205)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:260)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    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)
        ... 13 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)
        ... 15 more
    2011-05-18 13:49:53 [INFO] [SimpleWhisper] Permissions system detected!
    2011-05-18 13:49:53 [INFO] [SimpleWhisper] Version 1.3 has been enabled!
    2011-05-18 13:49:53 [INFO] Stargate v.0.4.8 is enabled.
    2011-05-18 13:49:53 [INFO] [Stargate] Loaded 1 gate layouts
    2011-05-18 13:49:53 [INFO] [Stargate] {world} Loaded 46 stargates with 0 set as always-on
    2011-05-18 13:49:53 [INFO] [Stargate] Found Permissions (v2.7.3)
    2011-05-18 13:49:53 [INFO] Weather Man - On Air!
    2011-05-18 13:49:53 [INFO] WorldEdit 4.4 enabled.
    2011-05-18 13:49:53 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    2011-05-18 13:49:53 [INFO] Enabled DefaultPermissions v0.2
    2011-05-18 13:49:53 [INFO] Done (0.525s)! For help, type "help" or "?"
    2011-05-18 13:49:55 [INFO] Guvnors [/82.12.77.195:50551] logged in with entity id 82
    2011-05-18 13:50:06 [INFO] [AntiCreeper] is DISABLED!
    2011-05-18 13:50:06 [INFO] [AssignPermissions] Plugin disabled. (version1.1)
    2011-05-18 13:50:06 [INFO] [bColoredChat] version 2.0.0 disabled!
    2011-05-18 13:50:06 [INFO] [iChat] iChat Disabled
    2011-05-18 13:50:06 [INFO] Lockette: Closing all automatic doors.
    2011-05-18 13:50:06 [INFO] mcMMO was disabled.
    2011-05-18 13:50:06 [INFO] NoFire version 1.1 is disabled!
    2011-05-18 13:50:06 [INFO] [Permissions] (Phoenix) saved all data.
    2011-05-18 13:50:06 [INFO] [Permissions] (Phoenix) disabled successfully.
    2011-05-18 13:50:06 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    2011-05-18 13:50:06 [INFO] [iChat] Permissions plugin lost.
    2011-05-18 13:50:06 [INFO] [Stargate] Permissions plugin lost.
    2011-05-18 13:50:06 [SEVERE] [PreciousStones] Error Saving:
    2011-05-18 13:50:06 [INFO] [PreciousStones] data saved.
    2011-05-18 13:50:06 [INFO] [SimpleWhisper] Version 1.3 has been disabled!
    2011-05-18 13:50:06 [INFO] Closing all stargates.
    2011-05-18 13:50:06 [INFO] Weather Man - Off Air!
    2011-05-18 13:50:06 [INFO] Disabled DefaultPermissions v0.2
    2011-05-18 13:50:07 [INFO] [Permissions] (Phoenix) was Initialized.
    2011-05-18 13:50:07 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    2011-05-18 13:50:07 [INFO] Entities enhanced[0] subclassed[6]
    2011-05-18 13:50:07 [SEVERE] java.io.IOException: The system cannot find the path specified
    2011-05-18 13:50:07 [SEVERE]     at java.io.WinNTFileSystem.createFileExclusively(Native Method)
    2011-05-18 13:50:07 [SEVERE]     at java.io.File.createNewFile(Unknown Source)
    2011-05-18 13:50:07 [SEVERE]     at me.captain.SimpleWhisper.SimpleWhisperConfig.getMsgFormat(SimpleWhisperConfig.java:20)
    2011-05-18 13:50:07 [SEVERE]     at me.captain.SimpleWhisper.SimpleWhisper.<init>(SimpleWhisper.java:36)
    2011-05-18 13:50:07 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-05-18 13:50:07 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-05-18 13:50:07 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-05-18 13:50:07 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:164)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:191)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:115)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:100)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:336)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleCommandMap.java:201)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
    2011-05-18 13:50:07 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:278)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:682)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:645)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:639)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:372)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:287)
    2011-05-18 13:50:07 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-18 13:50:07 [INFO] [AntiCreeper] version 1.0 is enabled.
    2011-05-18 13:50:07 [INFO] [Permissions] version [2.7.3] (Phoenix)  loaded
    2011-05-18 13:50:07 [INFO] [AssignPermissions] Plugin enabled! (version1.1)
    2011-05-18 13:50:07 [INFO] [bColoredChat] Permission system found
    2011-05-18 13:50:07 [INFO] [bColoredChat] version 2.0.0 is enabled!
    2011-05-18 13:50:08 [WARNING] Version mismatch! Please update EssentialsSpawn to the same version.
    2011-05-18 13:50:08 [INFO] Loaded Essentials build 2.2.11 maintained by Zenexer, ementalo, Aelux, Brettflan, KimKandor, snowleo and ceulemans.
    2011-05-18 13:50:08 [SEVERE] com.earth2me.essentials.Util.i18n(Ljava/lang/String;)Ljava/lang/String; loading EssentialsSpawn v2.2.17 (Is it up to date?)
    java.lang.NoSuchMethodError: com.earth2me.essentials.Util.i18n(Ljava/lang/String;)Ljava/lang/String;
        at com.earth2me.essentials.spawn.EssentialsSpawn.onEnable(EssentialsSpawn.java:30)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:336)
        at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleCommandMap.java:201)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:278)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:682)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:645)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:639)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:372)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:287)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-18 13:50:08 [INFO] [iChat] Found Permissions (v2.7.3)
    2011-05-18 13:50:08 [INFO] iChat (v2.2.3) enabled
    2011-05-18 13:50:08 [INFO] Lockette version 1.3.8 is being enabled!  Yay!  (Core version 1.0)
    2011-05-18 13:50:08 [INFO] Lockette: Detected craftbukkit build [766] ok.
    2011-05-18 13:50:08 [INFO] Lockette: Linked to Permissions plugin version 2.7.3
    2011-05-18 13:50:08 [INFO] Lockette: Using ops file for admin permissions.
    2011-05-18 13:50:08 [INFO] Lockette: Ready to protect your containers.
    2011-05-18 13:50:08 [INFO] LoginMessage 0.6_4 enabled
    2011-05-18 13:50:08 [INFO] [mcMMO] Permissions enabled.
    2011-05-18 13:50:08 [INFO] mcMMO version 1.0.07 is enabled!
    2011-05-18 13:50:08 [INFO] NoFire version 1.1 is enabled!
    2011-05-18 13:50:08 [INFO] Can not test connection as heartbeatsql is not set
    2011-05-18 13:50:08 [INFO] Closing Connection[PreciousStones.2] psReuse[0] psCreate[1] psSize[0]
    2011-05-18 13:50:08 [INFO] DataSourcePool [PreciousStones] grow; id[PreciousStones.3] busy[4] max[20]
    2011-05-18 13:50:08 [INFO] Installing database for PreciousStones due to first time usage
    2011-05-18 13:50:08 [INFO] runScript
    2011-05-18 13:50:08 [INFO] executing 1 of 14 create table ps_allowed_players ( id                        bigint primary key,...
    2011-05-18 13:50:08 [INFO] executing 2 of 14 create table ps_cloaked ( id                        bigint primary key, data_byt...
    2011-05-18 13:50:08 [INFO] executing 3 of 14 create table ps_fields ( id                        bigint primary key, x...
    2011-05-18 13:50:08 [INFO] executing 4 of 14 create table ps_item_stacks ( id                        bigint primary key, type...
    2011-05-18 13:50:08 [INFO] executing 5 of 14 create table ps_snitch_entries ( id                        bigint primary key, n...
    2011-05-18 13:50:08 [INFO] executing 6 of 14 create table ps_unbreakables ( id                        bigint primary key, x...
    2011-05-18 13:50:08 [INFO] executing 7 of 14 alter table ps_allowed_players add constraint fk_ps_allowed_players_field_1 fore...
    2011-05-18 13:50:08 [INFO] Can not test connection as heartbeatsql is not set
    2011-05-18 13:50:08 [INFO] Closing Connection[PreciousStones.3] psReuse[0] psCreate[7] psSize[6]
    2011-05-18 13:50:08 [INFO] DataSourcePool [PreciousStones] grow; id[PreciousStones.4] busy[5] max[20]
    2011-05-18 13:50:08 [SEVERE] 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)] loading PreciousStones v4.2.2 (Is it up to date?)
    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:253)
        at net.sacredlabyrinth.Phaed.PreciousStones.PreciousStones.setupDatabase(PreciousStones.java:154)
        at net.sacredlabyrinth.Phaed.PreciousStones.PreciousStones.onEnable(PreciousStones.java:85)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:676)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:249)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:131)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:109)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:336)
        at org.bukkit.command.SimpleCommandMap$ReloadCommand.execute(SimpleCommandMap.java:201)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:278)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:682)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:645)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:639)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:372)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:287)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    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
    2011-05-18 13:50:08 [INFO] [SimpleWhisper] Permissions system detected!
    2011-05-18 13:50:08 [INFO] [SimpleWhisper] Version 1.3 has been enabled!
    2011-05-18 13:50:08 [INFO] Stargate v.0.4.8 is enabled.
    2011-05-18 13:50:08 [INFO] [Stargate] Loaded 1 gate layouts
    2011-05-18 13:50:08 [INFO] [Stargate] {world} Loaded 46 stargates with 0 set as always-on
    2011-05-18 13:50:08 [INFO] [Stargate] Found Permissions (v2.7.3)
    2011-05-18 13:50:08 [INFO] Weather Man - On Air!
    2011-05-18 13:50:08 [INFO] WorldEdit 4.4 enabled.
    2011-05-18 13:50:08 [INFO] WorldEdit: Permissions plugin detected! Using Permissions plugin for permissions.
    2011-05-18 13:50:09 [INFO] Enabled DefaultPermissions v0.2
    2011-05-18 13:50:09 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2011-05-18 13:51:24 [INFO] §9[PLAYER_COMMAND] Guvnors: /give Guvnors 57 64
    2011-05-18 13:51:29 [INFO] Guvnors issued server command: clearinvneotry
    2011-05-18 13:51:33 [INFO] §9[PLAYER_COMMAND] Guvnors: /clearinventory
    2011-05-18 13:51:36 [INFO] §9[PLAYER_COMMAND] Guvnors: /give Guvnors 57 64
    2011-05-18 13:51:41 [INFO] §9[PLAYER_COMMAND] Guvnors: /give Guvnors 278 1
    2011-05-18 13:51:54 [INFO] Guvnors lost connection: disconnect.quitting
    2011-05-18 13:51:54 [INFO] Connection reset
    2011-05-18 13:52:08 [INFO] Disconnecting givemehead [/75.84.4.17:51062]: You are not white-listed on this server!
    2011-05-18 14:05:15 [INFO] /50.28.6.244:33893 lost connection
    2011-05-18 14:06:11 [INFO] Disconnecting veriron [/78.70.221.134:34133]: You are not white-listed on this server!
    2011-05-18 14:06:34 [INFO] Gono [/109.156.31.122:52283] logged in with entity id 2923
    2011-05-18 14:07:26 [INFO] §9[PLAYER_COMMAND] Gono: /online
    2011-05-18 14:07:31 [INFO] Lockette: (Admin) Gono has bypassed a door owned by god14029
    2011-05-18 14:07:34 [INFO] Lockette: (Admin) Gono has bypassed a door owned by god14029
    2011-05-18 14:07:34 [INFO] Lockette: (Admin) Gono has bypassed a door owned by god14029
    2011-05-18 14:08:16 [INFO] Lockette: (Admin) Gono has bypassed a door owned by Gboys123
    2011-05-18 14:08:19 [INFO] Lockette: (Admin) Gono has bypassed a door owned by Gboys123
    2011-05-18 14:08:31 [INFO] Lockette: (Admin) Gono has snooped around in a container owned by Gboys123!
    2011-05-18 14:08:43 [INFO] Lockette: (Admin) Gono has bypassed a door owned by Gboys123
    2011-05-18 14:08:46 [INFO] Lockette: (Admin) Gono has bypassed a door owned by Gboys123
    2011-05-18 14:09:03 [INFO] Disconnecting Capsman08 [/69.250.112.241:50091]: You are not white-listed on this server!
    2011-05-18 14:10:40 [INFO] §9[PLAYER_COMMAND] Gono: /time day
    2011-05-18 14:17:00 [INFO] Disconnecting chrisjc123 [/96.28.30.168:49600]: You are not white-listed on this server!
    2011-05-18 14:27:48 [INFO] MisseyMC [/82.12.77.195:55264] logged in with entity id 46632
    2011-05-18 14:27:53 [INFO] §9[PLAYER_COMMAND] MisseyMC: /online
    2011-05-18 14:28:00 [INFO] [Player§f] MisseyMC: hi gono
    2011-05-18 14:28:15 [INFO] §9[PLAYER_COMMAND] MisseyMC: /home
    2011-05-18 14:28:23 [INFO] §9[PLAYER_COMMAND] MisseyMC: /mail read
    2011-05-18 14:28:29 [INFO] §9[PLAYER_COMMAND] MisseyMC: /mail clear
    2011-05-18 14:29:58 [INFO] Bobthecactus [/109.156.27.125:53955] logged in with entity id 52436
    2011-05-18 14:30:01 [INFO] §9[PLAYER_COMMAND] Bobthecactus: /online
    2011-05-18 14:30:05 [INFO] [Player§f] MisseyMC: hi gonooo
    2011-05-18 14:30:05 [INFO] §9[PLAYER_COMMAND] Bobthecactus: /time day
    2011-05-18 14:30:09 [INFO] §9[PLAYER_COMMAND] MisseyMC: /online
    2011-05-18 14:30:22 [INFO] [§6Admin§f] §6Bobthecactus§f: §2hey, im not gono >.>
    2011-05-18 14:30:31 [INFO] [Player§f] MisseyMC: yh but i just joined lol
    2011-05-18 14:30:36 [INFO] [Player§f] MisseyMC: hi bob then
    2011-05-18 14:30:37 [INFO] [Player§f] MisseyMC: lol
    2011-05-18 14:30:40 [INFO] [§6Admin§f] §6Bobthecactus§f: §2ahh right
    2011-05-18 14:30:44 [INFO] [§6Admin§f] §6Bobthecactus§f: §2:L
    2011-05-18 14:31:13 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'spawn' in plugin EssentialsSpawn v2.2.17
        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:278)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:682)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:645)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:639)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:196)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:75)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:372)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:287)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: java.lang.NoSuchMethodError: com.earth2me.essentials.Essentials.onCommandEssentials(Lorg/bukkit/command/CommandSender;Lorg/bukkit/command/Command;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/ClassLoader;Ljava/lang/String;)Z
        at com.earth2me.essentials.spawn.EssentialsSpawn.onCommand(EssentialsSpawn.java:42)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
     
  21. Offline

    phaed

    Meh.... you are trying to use SQLite. I have stated that SQLite is not supported. You are not using the bukkit.yml I told you to use. Did you not run the bukkit.yml through the parser like I suggested? I found a few errors, a spacing issue and errors with the '*' character which I gather you added to mask your username and password . Fix them, and get MySQL working to use PS. And why is it you've been harassing me about the/ps menu, the whole while PS is generating a shit ton of errors and you don't think of letting me know until I have to spoon feed it out of you? Follow instructions or switch to OwnBlocks but please, please, please stop wasting my time.

     
  22. Offline

    MrCeaser

    oh ok i still dontknow how to make a MySQL database could someone send me in the right direction
     
  23. Offline

    phaed

    Do you run the server off your own computer? Or of a hosting service? If its off your own computer google installing MySQL on windows. If its a host you must ask them to fill out the bukkit.yml for you or get the info from them and fill it out yourself.
     
  24. Offline

    MrCeaser

    thanks bud and i run it off my pc
     
  25. Offline

    darksteel88

    Could someone help me get it running? I setup the MySQL database, and I'm admin. I gave the default class the first two permissions so they could create them (as it states). However, whenever I step over, say, a Proximity Mine, regardless of who created it, nothing happens. When others step over stuff I create, it does work, so I'm sure the plugin is working. It's just, the stones aren't affecting me properly.

    I want to be able to setup Mines that are owned by nobody, in order to create PvP areas. I have another plugin that will work nicely with this. I can't really test it out if it doesn't work on me.

    If someone could suggest what's going on or if you need any extra info, please let me know. Thanks.
     
  26. Offline

    MrCeaser

    hey how do i set up the database i insalled mysql installer which has workbench and everything but do not know what to do
     
  27. Offline

    darksteel88

    Idk about the MySQL, I use a host company who set it up for me (they like it that way).
     
  28. Offline

    MrCeaser

    who is the host company and is it free?
     
  29. Offline

    darksteel88

    Brohoster and no, but the rates are really good and I'm liking them so far. No host company is free, they're a business that makes money by hosting servers.
     
  30. Offline

    phaed

    You are impervious to your own mines, plus you have the 'preciousstones.bypass.mine' permission as an admin so you wont trigger anyones mines.

    If you want to trigger other peoples mines give yourself a negative permission like so (notice the minus sign *inside* the quotes): '-preciousstones.bypass.mine'

    If you want to trigger your own mines, change the owner of the mines you place with: /ps setname [fakename]

    Google how to create a database using MySQL workbench. Then make one named minecraft. Then fill out the default bukkit.yml I have in the OP with your username and password. That should be it.

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

    darksteel88

    Thanks phaed for letting me know. I was wondering why I wasn't triggering but I guess I just have '*' as admin. I'll be sure to try that out.
     
Thread Status:
Not open for further replies.

Share This Page