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.
Page 11 of 18
  1. Offline

    aPunch

    aPunch, Apr 20, 2011
    #1
    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
     
    Maxis010, May 17, 2011
    #301
  3. Offline

    phaed

    It does. It removes all entries form the database that no longer exist on the world on startup.
     
    phaed, May 17, 2011
    #302
  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.
     
    Guvnors, May 17, 2011
    #303
  5. Offline

    phaed

    phaed, May 17, 2011
    #304
  6. Offline

    Forge_User_87066605

    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
     
    Forge_User_87066605, May 17, 2011
    #305
  7. Offline

    NEO

    @phaed
     
    NEO, May 17, 2011
    #306
  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
     
    Maxis010, May 17, 2011
    #307
  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
    phaed, May 17, 2011
    #308
  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.
     
    NEO, May 17, 2011
    #309
  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.
     
    phaed, May 17, 2011
    #310
  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
     
    MrCeaser, May 17, 2011
    #311
  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.
     
    phaed, May 17, 2011
    #312
  14. Offline

    NEO

    This works. Still odd that it doesnt work with the nodes.
     
    NEO, May 17, 2011
    #313
  15. Offline

    phaed

    Ahh, yes need to fix that. Thanks for letting me know.
     
    phaed, May 18, 2011
    #314
  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
    MrCeaser, May 18, 2011
    #315
  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).
     
    phaed, May 18, 2011
    #316
  18. Offline

    Guvnors

    Guvnors, May 18, 2011
    #317
  19. Offline

    phaed

    Post here, on a code block, everything PreciousStones spits out to the console/log when your server loads.
     
    phaed, May 18, 2011
    #318
  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)
     
    Guvnors, May 18, 2011
    #319
  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.

     
    phaed, May 18, 2011
    #320
  22. Offline

    MrCeaser

    oh ok i still dontknow how to make a MySQL database could someone send me in the right direction
     
    MrCeaser, May 18, 2011
    #321
  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.
     
    phaed, May 18, 2011
    #322
  24. Offline

    MrCeaser

    thanks bud and i run it off my pc
     
    MrCeaser, May 18, 2011
    #323
  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.
     
    darksteel88, May 18, 2011
    #324
  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
     
    MrCeaser, May 18, 2011
    #325
  27. Offline

    darksteel88

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

    MrCeaser

    who is the host company and is it free?
     
    MrCeaser, May 18, 2011
    #327
  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.
     
    darksteel88, May 18, 2011
    #328
  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
    phaed, May 18, 2011
    #329
  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.
     
    darksteel88, May 18, 2011
    #330
Page 11 of 18
Thread Status:
Not open for further replies.

Share This Page