WORLD GUARD- CHEST SHOP

Discussion in 'Spigot Plugin Help' started by Marius1999, Mar 2, 2020.

  1. This happens only when "isaias" enters the server






    [11:41:24] [User Authenticator #39/INFO]: UUID of player isaias is c63a3448-4f10-3e7e-8fd0-0e67726b5e37
    > [11:41:24] [WorldGuard Task Executor - 31/WARN]: [WorldGuard] Failed to execute queries
    java.sql.SQLException: statement is not executing
    at org.sqlite.core.CoreStatement.checkOpen(CoreStatement.java:55) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.core.CorePreparedStatement.batch(CorePreparedStatement.java:125) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.jdbc3.JDBC3PreparedStatement.setString(JDBC3PreparedStatement.java:417) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at com.sk89q.worldguard.util.profile.cache.SQLiteCache.executePut(SQLiteCache.java:137) ~[?:?]
    at com.sk89q.worldguard.util.profile.cache.SQLiteCache.putAll(SQLiteCache.java:118) ~[?:?]
    at com.sk89q.worldguard.util.profile.cache.AbstractProfileCache.put(AbstractProfileCache.java:37) ~[?:?]
    at com.sk89q.worldguard.util.profile.cache.SQLiteCache.put(SQLiteCache.java:47) ~[?:?]
    at com.sk89q.worldguard.bukkit.session.BukkitSessionManager.lambda$onPlayerProcess$0(BukkitSessionManager.java:66) ~[?:?]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_212]
    at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:111) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:58) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:75) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_212]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_212]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_212]
    > [11:41:25] [Server thread/INFO]: isaias[/181.12.6.10:49680] logged in with entity id 26687 at ([Towny]144.0955608387305, 68.0, 439.13253186048144)
    > [11:41:25] [Craft Scheduler Thread - 267/WARN]: [ChestShop] Error while updating account [email protected]:
    java.sql.SQLException: Unable to run update stmt on object [email protected]: UPDATE `accounts` SET `name` = ?, `uuid` = ?, `lastSeen` = ? WHERE `shortName` = ?
    at com.Acrobot.ChestShop.ORMlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:25) ~[ChestShop.jar:?]
    at com.Acrobot.ChestShop.ORMlite.stmt.mapped.MappedUpdate.update(MappedUpdate.java:129) ~[ChestShop.jar:?]
    at com.Acrobot.ChestShop.ORMlite.stmt.StatementExecutor.update(StatementExecutor.java:472) ~[ChestShop.jar:?]
    at com.Acrobot.ChestShop.ORMlite.dao.BaseDaoImpl.update(BaseDaoImpl.java:410) ~[ChestShop.jar:?]
    at com.Acrobot.ChestShop.ORMlite.dao.BaseDaoImpl.createOrUpdate(BaseDaoImpl.java:391) ~[ChestShop.jar:?]
    at com.Acrobot.ChestShop.UUIDs.NameManager.storeUsername(NameManager.java:301) [ChestShop.jar:?]
    at com.Acrobot.ChestShop.Listeners.Player.PlayerConnect$1.run(PlayerConnect.java:32) [ChestShop.jar:?]
    at org.bukkit.craftbukkit.v1_14_R1.scheduler.CraftTask.run(CraftTask.java:81) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.craftbukkit.v1_14_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:54) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_212]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_212]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_212]
    Caused by: org.sqlite.SQLiteException: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)
    at org.sqlite.core.DB.newSQLException(DB.java:941) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.core.DB.newSQLException(DB.java:953) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.core.DB.execute(DB.java:857) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.core.DB.executeUpdate(DB.java:895) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:102) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at com.Acrobot.ChestShop.ORMlite.jdbc.JdbcDatabaseConnection.update(JdbcDatabaseConnection.java:294) ~[?:?]
    at com.Acrobot.ChestShop.ORMlite.jdbc.JdbcDatabaseConnection.update(JdbcDatabaseConnection.java:217) ~[?:?]
    at com.Acrobot.ChestShop.ORMlite.stmt.mapped.MappedUpdate.update(MappedUpdate.java:101) ~[?:?]
    ... 10 more
    > [11:41:41] [Server thread/WARN]: [ChestShop] Error while updating account [email protected]:
    java.sql.SQLException: Unable to run insert stmt on object [email protected]: INSERT INTO `accounts` (`name` ,`shortName` ,`uuid` ,`lastSeen` ) VALUES (?,?,?,?)
    at com.Acrobot.ChestShop.ORMlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:25) ~[?:?]
    at com.Acrobot.ChestShop.ORMlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:138) ~[?:?]
    at com.Acrobot.ChestShop.ORMlite.stmt.StatementExecutor.create(StatementExecutor.java:458) ~[?:?]
    at com.Acrobot.ChestShop.ORMlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:329) ~[?:?]
    at com.Acrobot.ChestShop.ORMlite.dao.BaseDaoImpl.createOrUpdate(BaseDaoImpl.java:388) ~[?:?]
    at com.Acrobot.ChestShop.UUIDs.NameManager.storeUsername(NameManager.java:301) ~[?:?]
    at com.Acrobot.ChestShop.UUIDs.NameManager.getAccountFromShortName(NameManager.java:173) ~[?:?]
    at com.Acrobot.ChestShop.UUIDs.NameManager.getAccountFromShortName(NameManager.java:141) ~[?:?]
    at com.Acrobot.ChestShop.UUIDs.NameManager.getLastAccountFromShortName(NameManager.java:191) ~[?:?]
    at com.Acrobot.ChestShop.UUIDs.NameManager.onAccountQuery(NameManager.java:127) ~[?:?]
    at sun.reflect.GeneratedMethodAccessor338.invoke(Unknown Source) ~[?:?]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_212]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_212]
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:316) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:529) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:514) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at com.Acrobot.ChestShop.Listeners.PreShopCreation.NameChecker.handleEvent(NameChecker.java:44) ~[?:?]
    at com.Acrobot.ChestShop.Listeners.PreShopCreation.NameChecker.onPreShopCreation(NameChecker.java:24) ~[?:?]
    at sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source) ~[?:?]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_212]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_212]
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:316) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:529) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:514) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at com.Acrobot.ChestShop.ChestShop.callEvent(ChestShop.java:455) ~[?:?]
    at com.Acrobot.ChestShop.Listeners.Block.SignCreate.onSignChange(SignCreate.java:49) ~[?:?]
    at sun.reflect.GeneratedMethodAccessor395.invoke(Unknown Source) ~[?:?]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_212]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_212]
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:316) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:70) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:529) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:514) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.PlayerConnection.a(PlayerConnection.java:2381) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.PacketPlayInUpdateSign.a(SourceFile:44) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.PacketPlayInUpdateSign.a(SourceFile:10) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.PlayerConnectionUtils.lambda$0(PlayerConnectionUtils.java:19) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.TickTask.run(SourceFile:18) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeTask(SourceFile:144) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.IAsyncTaskHandlerReentrant.executeTask(SourceFile:23) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeNext(SourceFile:118) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.MinecraftServer.aX(MinecraftServer.java:910) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.MinecraftServer.executeNext(MinecraftServer.java:903) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.awaitTasks(SourceFile:127) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.MinecraftServer.sleepForTick(MinecraftServer.java:887) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at net.minecraft.server.v1_14_R1.MinecraftServer.run(MinecraftServer.java:820) [spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_212]
    Caused by: org.sqlite.SQLiteException: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)
    at org.sqlite.core.DB.newSQLException(DB.java:941) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.core.DB.newSQLException(DB.java:953) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.core.DB.execute(DB.java:857) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.core.DB.executeUpdate(DB.java:895) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:102) ~[spigot-1.14.4.jar:git-Spigot-9de398a-9c887d4]
    at com.Acrobot.ChestShop.ORMlite.jdbc.JdbcDatabaseConnection.insert(JdbcDatabaseConnection.java:188) ~[?:?]
    at com.Acrobot.ChestShop.ORMlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:91) ~[?:?]
    ... 47 more
     
    #1 Marius1999, Mar 2, 2020
    Last edited: Mar 2, 2020
  2. Best thing you can probably do is to go inte the data file for ChestShop and remove "Isaias" from it.
     
  3. I delete the file "users.db" ?
     
  4. Download it so you have a save of it in case it does not help, but yes. Keep in mind that this might break currently placed chest shops and people could need to remake them.