{"action":"created","issue":{"url":"https://api.github.com/repos/WirelessRedstoneGroup/WirelessRedstone/issues/171","repository_url":"https://api.github.com/repos/WirelessRedstoneGroup/WirelessRedstone","labels_url":"https://api.github.com/repos/WirelessRedstoneGroup/WirelessRedstone/issues/171/labels{/name}","comments_url":"https://api.github.com/repos/WirelessRedstoneGroup/WirelessRedstone/issues/171/comments","events_url":"https://api.github.com/repos/WirelessRedstoneGroup/WirelessRedstone/issues/171/events","html_url":"https://github.com/WirelessRedstoneGroup/WirelessRedstone/issues/171","id":197000617,"number":171,"title":"SQL Exception again","user":{"login":"herm1ne","id":5259790,"avatar_url":"https://avatars.githubusercontent.com/u/5259790?v=3","gravatar_id":"","url":"https://api.github.com/users/herm1ne","html_url":"https://github.com/herm1ne","followers_url":"https://api.github.com/users/herm1ne/followers","following_url":"https://api.github.com/users/herm1ne/following{/other_user}","gists_url":"https://api.github.com/users/herm1ne/gists{/gist_id}","starred_url":"https://api.github.com/users/herm1ne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/herm1ne/subscriptions","organizations_url":"https://api.github.com/users/herm1ne/orgs","repos_url":"https://api.github.com/users/herm1ne/repos","events_url":"https://api.github.com/users/herm1ne/events{/privacy}","received_events_url":"https://api.github.com/users/herm1ne/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-21T18:23:55Z","updated_at":"2016-12-23T17:48:55Z","closed_at":null,"body":"Hi This is a little bit different from the past one but I start experiencing the sql error\r\n```\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (unrecognized token: \"0422y\")\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.DB.newSQLException(DB.java:383)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.DB.newSQLException(DB.java:387)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.DB.throwex(DB.java:374)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.NativeDB.prepare(Native Method)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.DB.prepare(DB.java:123)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.PrepStmt.<init>(PrepStmt.java:42)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.Conn.prepareStatement(Conn.java:404)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.Conn.prepareStatement(Conn.java:399)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.sqlite.Conn.prepareStatement(Conn.java:383)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getWirelessChannel(SQLiteStorage.java:516)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getAllChannels(SQLiteStorage.java:469)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat net.licks92.WirelessRedstone.GlobalCache.updateList(GlobalCache.java:52)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat net.licks92.WirelessRedstone.GlobalCache.access$000(GlobalCache.java:13)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat net.licks92.WirelessRedstone.GlobalCache$2.run(GlobalCache.java:39)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\n[00:00:59] [Craft Scheduler Thread - 6008/WARN]: \tat java.lang.Thread.run(Thread.java:745)\r\n```\r\n\r\n```\r\n[00:11:15] [Craft Scheduler Thread - 6209/WARN]: org.apache.commons.lang.UnhandledException: Plugin WirelessRedstone v3.0.0-beta.2 generated an exception while executing task 9935\r\n\tat org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:56)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.lang.NullPointerException\r\n\tat net.licks92.WirelessRedstone.Main$6.getValue(Main.java:260)\r\n\tat net.licks92.WirelessRedstone.Metrics.postPlugin(Metrics.java:407)\r\n\tat net.licks92.WirelessRedstone.Metrics.access$400(Metrics.java:49)\r\n\tat net.licks92.WirelessRedstone.Metrics$1.run(Metrics.java:215)\r\n\tat org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)\r\n\tat org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)\r\n```\r\n\r\n```\r\n[02:35:27] [Server thread/ERROR]: Could not pass event SignChangeEvent to WirelessRedstone v3.0.0-beta.2\r\norg.bukkit.event.EventException\r\n\tat org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:310) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerConnection.a(PlayerConnection.java:1864) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PacketPlayInUpdateSign.a(SourceFile:49) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PacketPlayInUpdateSign.a(SourceFile:11) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.run(SourceFile:13) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_102]\r\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_102]\r\n\tat net.minecraft.server.v1_8_R3.SystemUtils.a(SourceFile:44) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:715) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat java.lang.Thread.run(Thread.java:745) [?:1.8.0_102]\r\nCaused by: java.lang.NullPointerException\r\n\tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getWirelessChannel(SQLiteStorage.java:492) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getWirelessChannel(SQLiteStorage.java:482) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.SignManager.hasAccessToChannel(SignManager.java:461) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.Listeners.BlockListener.onSignChange(BlockListener.java:46) ~[?:?]\r\n\tat sun.reflect.GeneratedMethodAccessor617.invoke(Unknown Source) ~[?:?]\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_102]\r\n\tat java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_102]\r\n\tat org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:306) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\t... 15 more\r\n```\r\n\r\n```\r\n[02:35:57] [Server thread/ERROR]: Could not pass event BlockBreakEvent to WirelessRedstone v3.0.0-beta.2\r\norg.bukkit.event.EventException\r\n\tat org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:310) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerInteractManager.breakBlock(PlayerInteractManager.java:286) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerInteractManager.a(PlayerInteractManager.java:121) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerConnection.a(PlayerConnection.java:623) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PacketPlayInBlockDig.a(SourceFile:40) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PacketPlayInBlockDig.a(SourceFile:10) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.run(SourceFile:13) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_102]\r\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_102]\r\n\tat net.minecraft.server.v1_8_R3.SystemUtils.a(SourceFile:44) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:715) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat java.lang.Thread.run(Thread.java:745) [?:1.8.0_102]\r\nCaused by: java.lang.NullPointerException\r\n\tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getWirelessChannel(SQLiteStorage.java:492) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getWirelessChannel(SQLiteStorage.java:482) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.SignManager.hasAccessToChannel(SignManager.java:461) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.Listeners.BlockListener.onBlockBreak(BlockListener.java:185) ~[?:?]\r\n\tat sun.reflect.GeneratedMethodAccessor317.invoke(Unknown Source) ~[?:?]\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_102]\r\n\tat java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_102]\r\n\tat org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:306) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\t... 17 more\r\n```\r\n\r\nThe first and seconds error occurred periodically. The third and forth one is occurred when the specific event has triggered.  \r\nI don't know whether the first error triggers 2nd ~ 4th errors but I just want to let you know.  \r\nOne interesting point is we have the player named \"youtyan0422\" on my server and it must be somehow connected to this error. (the first error indicates `unrecognized token: \"0422y\"` )  \r\nUnfortunately, I cannot confirm that if there is a channel named `0422y` since when I type `/wr info 0422y` it threw exception as follows: (will not throw exception when I type other channel names)  \r\n```\r\n[03:18:31] [Server thread/INFO]: Ru1x issued server command: /wr info 0422y\r\n[03:18:31] [Server thread/ERROR]: null\r\norg.bukkit.command.CommandException: Unhandled exception executing command 'wr' in plugin WirelessRedstone v3.0.0-beta.2\r\n\tat org.bukkit.command.PluginCommand.execute(PluginCommand.java:46) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerConnection.handleCommand(PlayerConnection.java:1162) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerConnection.a(PlayerConnection.java:997) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:45) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:1) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.run(SourceFile:13) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_102]\r\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_102]\r\n\tat net.minecraft.server.v1_8_R3.SystemUtils.a(SourceFile:44) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:715) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557) [spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\tat java.lang.Thread.run(Thread.java:745) [?:1.8.0_102]\r\nCaused by: java.lang.NullPointerException\r\n\tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getWirelessChannel(SQLiteStorage.java:492) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.Storage.SQLiteStorage.getWirelessChannel(SQLiteStorage.java:482) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.Commands.Info.onCommand(Info.java:22) ~[?:?]\r\n\tat net.licks92.WirelessRedstone.Commands.CommandManager.onCommand(CommandManager.java:99) ~[?:?]\r\n\tat org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) ~[spigot.jar:git-Spigot-21fe707-e1ebe52]\r\n\t... 15 more\r\n```\r\n\r\nI apologize for bringing this huge issue and thank you for your support!\r\n"},"comment":{"url":"https://api.github.com/repos/WirelessRedstoneGroup/WirelessRedstone/issues/comments/269024070","html_url":"https://github.com/WirelessRedstoneGroup/WirelessRedstone/issues/171#issuecomment-269024070","issue_url":"https://api.github.com/repos/WirelessRedstoneGroup/WirelessRedstone/issues/171","id":269024070,"user":{"login":"herm1ne","id":5259790,"avatar_url":"https://avatars.githubusercontent.com/u/5259790?v=3","gravatar_id":"","url":"https://api.github.com/users/herm1ne","html_url":"https://github.com/herm1ne","followers_url":"https://api.github.com/users/herm1ne/followers","following_url":"https://api.github.com/users/herm1ne/following{/other_user}","gists_url":"https://api.github.com/users/herm1ne/gists{/gist_id}","starred_url":"https://api.github.com/users/herm1ne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/herm1ne/subscriptions","organizations_url":"https://api.github.com/users/herm1ne/orgs","repos_url":"https://api.github.com/users/herm1ne/repos","events_url":"https://api.github.com/users/herm1ne/events{/privacy}","received_events_url":"https://api.github.com/users/herm1ne/received_events","type":"User","site_admin":false},"created_at":"2016-12-23T17:48:55Z","updated_at":"2016-12-23T17:48:55Z","body":"Do you have a new build to fix this?"}}
{"actor":{"display_login":"herm1ne"}}