[Solved] Not a registered eBean entity?

Discussion in 'Plugin Development' started by captainawesome7, Apr 29, 2011.

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

    captainawesome7

    Please help me. Lots of people are whining that my plugin doesn't have persistence, but how do you register an ebean entity? When I start my plugin it says what it should, then I get:
    Code:
    15:14:57 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'rename' in plugin DispNameChanger v1
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:675)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:638)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:632)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: javax.persistence.PersistenceException: me.captain.DispNameChanger.DNCPersistence is NOT an Entity Bean registered with this server?
        at com.avaje.ebeaninternal.server.core.DefaultServer.createQuery(DefaultServer.java:1031)
        at com.avaje.ebeaninternal.server.core.DefaultServer.createQuery(DefaultServer.java:988)
        at com.avaje.ebeaninternal.server.core.DefaultServer.find(DefaultServer.java:1024)
        at me.captain.DispNameChanger.DispNameChanger.onCommand(DispNameChanger.java:83)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
    
    The two classes in my jar (pastebin links):
    DispNameChanger.java
    DNCPersistence.java
     
  2. Offline

    Sammy

    You need to add the eBean setup to your JavaPlugin class:
    Code:
     private void setupDatabase() {
            try {
                getDatabase().find(DNCPersistence.class).findRowCount();
            } catch (PersistenceException ex) {
                System.out.println("Installing database for " + getDescription().getName() + " due to first time usage");
                installDDL();
            }
        }
        @Override
        public List<Class<?>> getDatabaseClasses() {
            List<Class<?>> list = new ArrayList<Class<?>>();
            list.add(DNCPersistence.class);
            return list;
        }
    And :
    Code:
     public void onEnable() {
    setupDatabase()
    }
    
    And you need to add this to the plugin.yml
    Code:
    database: true
     
  3. Offline

    captainawesome7

    hmm, as I recall I had already addd that, but I probably deleted it for some reason. I'll get back to you @Sammy

    @Sammy wtf?
    Code:
    16:24:54 [SEVERE] Error: Error executing stmt[create table DispNameChanger.DispNameChanger ( id                        integer primary key, player_name               varchar(255), display_name              varchar(255)) ] error[[SQLITE_ERROR] SQL error or missing database (unknown database DispNameChanger)] loading DispNameChanger v1 (Is it up to date?)
    javax.persistence.PersistenceException: Error: Error executing stmt[create table DispNameChanger.DispNameChanger ( id                        integer primary key, player_name               varchar(255), display_name              varchar(255)) ] error[[SQLITE_ERROR] SQL error or missing database (unknown database DispNameChanger)]
        at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:233)
        at org.bukkit.plugin.java.JavaPlugin.installDDL(JavaPlugin.java:253)
        at me.captain.DispNameChanger.DispNameChanger.setupDatabase(DispNameChanger.java:44)
        at me.captain.DispNameChanger.DispNameChanger.onEnable(DispNameChanger.java:74)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:632)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: java.lang.RuntimeException: Error executing stmt[create table DispNameChanger.DispNameChanger ( id                        integer primary key, player_name               varchar(255), display_name              varchar(255)) ] error[[SQLITE_ERROR] SQL error or missing database (unknown database DispNameChanger)]
        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 (unknown database DispNameChanger)
        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
    
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 14, 2016
  4. Offline

    Sammy

    If you already have a DispNameChanger.db made delete it
    Don't forget to create a eBean.properties file (doesn't mater if its empty)
    If nothing works I must see the new src
     
  5. Offline

    captainawesome7

    Oh. Ok. Where do I put the eBean.properties file? For now I will leave it in plugins/DispNameChanger

    Ok. Error (sorry if Im stupid)
    Code:
    >Andrews-MacBook-Pro:ServerFiles andrewbulkeley$ java -Xmx512M -Xms512M -jar craftbukkit.jar
    [Lnet.minecraft.server.Statistic;@5cbfe9d
    146 recipes
    [Lnet.minecraft.server.Statistic;@5cbfe9d
    16 achievements
    16:52:44 [INFO] Starting minecraft server version Beta 1.5_02
    16:52:44 [WARNING] **** NOT ENOUGH RAM!
    16:52:44 [WARNING] To start the server with more ram, launch it as "java -Xmx1024M -Xms1024M -jar minecraft_server.jar"
    16:52:44 [INFO] Loading properties
    16:52:44 [INFO] Starting Minecraft server on *:25565
    16:52:44 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
    16:52:44 [WARNING] The server will make no attempt to authenticate usernames. Beware.
    16:52:44 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect with any username they choose.
    16:52:44 [WARNING] To change this, set "online-mode" to "true" in the server.settings file.
    16:52:44 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-700-gf3ae4c3-b733jnks (MC: 1.5_02)
    16:52:44 [INFO] Preparing level "world"
    16:52:44 [INFO] Preparing start region
    16:52:45 [SEVERE] ebean.properties not found
    16:52:45 [INFO] DataSourcePool [DispNameChanger] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    16:52:46 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    16:52:46 [INFO] Entities enhanced[0] subclassed[1]
    16:52:46 [INFO] Permission system not detected, defaulting to OP
    16:52:46 [INFO] [Annoyer] Annoyer has been enabled!
    16:52:46 [INFO] Permission system not detected, defaulting to OP
    16:52:46 [INFO] Can not test connection as heartbeatsql is not set
    16:52:46 [INFO] Closing Connection[DispNameChanger.1] psReuse[0] psCreate[1] psSize[0]
    16:52:46 [INFO] Installing database for DispNameChanger due to first time usage
    16:52:46 [INFO] runScript
    16:52:46 [INFO] executing 1 of 1 create table disp_names ( id                        integer primary key, player_...
    16:52:46 [INFO] ... end of script
    16:52:46 [INFO] [DispNameChanger] DispNameChanger has been enabled!
    16:52:46 [INFO] Permission system not detected, defaulting to OP
    16:52:46 [INFO] [SimpleCompass] Version 1.0 Has been enabled!
    16:52:46 [INFO] [SimpleFall] Version 1.0 has been enabled!
    16:52:46 [INFO] [SimpleWhisper] Permission system not detected, defaulting to OP
    16:52:46 [INFO] [SimpleWhisper] SimpleWhisper has been enabled!
    16:52:46 [INFO] Done (0.244s)! For help, type "help" or "?"
    16:53:12 [INFO] captainawesome7 [/10.0.1.30:49984] logged in with entity id 123
    16:53:21 [INFO] Can not test connection as heartbeatsql is not set
    16:53:21 [INFO] Closing Connection[DispNameChanger.0] psReuse[0] psCreate[2] psSize[1]
    16:53:21 [INFO] DataSourcePool [DispNameChanger] grow; id[DispNameChanger.2] busy[3] max[20]
    16:53:21 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'rename' in plugin DispNameChanger v1
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:675)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:638)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:632)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (no such column: PlayerName) 
    Bind values:[null] 
    Query was:
    select t0.id c0, t0.player_name c1, t0.display_name c2 
    from disp_names t0 
    where lower(PlayerName) =?  
    
    
        at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:849)
        at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:829)
        at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:238)
        at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:104)
        at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:344)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1469)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
        at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
        at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
        at me.captain.DispNameChanger.DispNameChanger.onCommand(DispNameChanger.java:103)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
    Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: PlayerName)
        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.query.CQuery.prepareBindExecuteQuery(CQuery.java:399)
        at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:198)
        ... 20 more
    16:53:24 [INFO] <?4DERP> fuck
    16:53:26 [INFO] Connection reset
    16:53:26 [INFO] captainawesome7 lost connection: disconnect.quitting
    >
    
    
    will post new source in a minute

    http://pastebin.com/63faDvGu
    http://pastebin.com/kMvxStkn

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

    Sammy

    Code:
    16:52:45 [SEVERE] ebean.properties not found
    Try Creating this file on your server main folder
    After that remove the db
    If it doesn't work try removing the @NotEmpty remove the database again and try it
    Code:
    @NotEmpty <---- delete this
        private String DisplayName; //Player chosen name
     
  7. Offline

    captainawesome7

    ok

    Code:
    >Andrews-MacBook-Pro:ServerFiles andrewbulkeley$ java -Xmx512M -Xms512M -jar craftbukkit.jar
    [Lnet.minecraft.server.Statistic;@23394894
    146 recipes
    [Lnet.minecraft.server.Statistic;@23394894
    16 achievements
    17:11:26 [INFO] Starting minecraft server version Beta 1.5_02
    17:11:26 [WARNING] **** NOT ENOUGH RAM!
    17:11:26 [WARNING] To start the server with more ram, launch it as "java -Xmx1024M -Xms1024M -jar minecraft_server.jar"
    17:11:26 [INFO] Loading properties
    17:11:26 [INFO] Starting Minecraft server on *:25565
    17:11:26 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
    17:11:26 [WARNING] The server will make no attempt to authenticate usernames. Beware.
    17:11:26 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect with any username they choose.
    17:11:26 [WARNING] To change this, set "online-mode" to "true" in the server.settings file.
    17:11:26 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-700-gf3ae4c3-b733jnks (MC: 1.5_02)
    17:11:26 [INFO] Preparing level "world"
    17:11:26 [INFO] Preparing start region
    17:11:27 [INFO] Preparing spawn area: 93%
    17:11:27 [INFO] DataSourcePool [DispNameChanger] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    17:11:28 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    17:11:28 [INFO] Entities enhanced[0] subclassed[1]
    17:11:28 [INFO] Permission system not detected, defaulting to OP
    17:11:28 [INFO] [Annoyer] Annoyer has been enabled!
    17:11:28 [INFO] Permission system not detected, defaulting to OP
    17:11:28 [INFO] Can not test connection as heartbeatsql is not set
    17:11:28 [INFO] Closing Connection[DispNameChanger.1] psReuse[0] psCreate[1] psSize[0]
    17:11:28 [INFO] Installing database for DispNameChanger due to first time usage
    17:11:28 [INFO] runScript
    17:11:28 [INFO] executing 1 of 1 create table disp_names ( id                        integer primary key, player_...
    17:11:28 [INFO] ... end of script
    17:11:28 [INFO] [DispNameChanger] DispNameChanger has been enabled!
    17:11:28 [INFO] Permission system not detected, defaulting to OP
    17:11:28 [INFO] [SimpleCompass] Version 1.0 Has been enabled!
    17:11:28 [INFO] [SimpleFall] Version 1.0 has been enabled!
    17:11:28 [INFO] [SimpleWhisper] Permission system not detected, defaulting to OP
    17:11:28 [INFO] [SimpleWhisper] SimpleWhisper has been enabled!
    17:11:28 [INFO] Done (0.246s)! For help, type "help" or "?"
    17:11:42 [INFO] captainawesome7 [/10.0.1.30:50267] logged in with entity id 122
    17:11:52 [INFO] Can not test connection as heartbeatsql is not set
    17:11:52 [INFO] Closing Connection[DispNameChanger.0] psReuse[0] psCreate[2] psSize[1]
    17:11:52 [INFO] DataSourcePool [DispNameChanger] grow; id[DispNameChanger.2] busy[3] max[20]
    17:11:52 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'rename' in plugin DispNameChanger v1
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:675)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:638)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:632)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (no such column: PlayerName)
    Bind values:[null]
    Query was:
    select t0.id c0, t0.player_name c1, t0.display_name c2
    from disp_names t0
    where lower(PlayerName) =?
     
        at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:849)
        at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:829)
        at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:238)
        at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:104)
        at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:344)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1469)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
        at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
        at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
        at me.captain.DispNameChanger.DispNameChanger.onCommand(DispNameChanger.java:103)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
    Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: PlayerName)
        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.query.CQuery.prepareBindExecuteQuery(CQuery.java:399)
        at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:198)
        ... 20 more
    17:11:54 [INFO] <derp> wow
    17:11:56 [INFO] Connection reset
    17:11:56 [INFO] captainawesome7 lost connection: disconnect.quitting
    >
    
    I put the eBean.properties in my main server directory. It seems that there was no column or something :(

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

    Acrobot

    @captainawesome7
    try deleting the database file from /plugins/DispNameChanger/DispNameChanger.db

    Also, your playerName must be @NotEmpty
     
  9. Offline

    captainawesome7

    Ok, and I already did delete it several times.

    Code:
    19:25:00 [INFO] Can not test connection as heartbeatsql is not set
    19:25:00 [INFO] Closing Connection[DispNameChanger.0] psReuse[0] psCreate[2] psSize[1]
    19:25:00 [INFO] DataSourcePool [DispNameChanger] grow; id[DispNameChanger.2] busy[3] max[20]
    19:25:00 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'rename' in plugin DispNameChanger v1
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:85)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:255)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:677)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:640)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:634)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:32)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:195)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:74)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:370)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:285)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (no such column: PlayerName)
    Bind values:[null]
    Query was:
    select t0.id c0, t0.player_name c1, t0.display_name c2
    from disp_names t0
    where lower(PlayerName) =?
     
        at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:849)
        at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:829)
        at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:238)
        at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine.java:104)
        at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:344)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1469)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
        at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
        at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
        at me.captain.DispNameChanger.DispNameChanger.onCommand(DispNameChanger.java:103)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
    Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: PlayerName)
        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.query.CQuery.prepareBindExecuteQuery(CQuery.java:399)
        at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:198)
        ... 20 more
    
    I went into the database file myself there definitely is a column called PlayerName.

    I think I found the problem. It says that no column called PlayerName is there, and when I rename player_name to PlayerName it says no column called player_name is there. How do I change what values use what columns?

    no errors now, but it doesn't save the names ( the columns are now PlayerName, DisplayName, player_name, display_name)

    I got it fixed, turns out it was a letter not being capitalized in DNCPersistence :/

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 14, 2016
Thread Status:
Not open for further replies.

Share This Page