{"comment":{"created_at":"2011-10-17T02:47:25Z","body":"Fixed.","updated_at":"2011-10-17T02:47:25Z","url":"https://api.github.com/repos/SwearWord/VirtualShop/issues/comments/2424481","id":2424481,"user":{"gravatar_id":"147783b09f0fa20aac9d01f8a667a3dc","avatar_url":"https://secure.gravatar.com/avatar/147783b09f0fa20aac9d01f8a667a3dc?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/SwearWord","id":826656,"login":"SwearWord"}},"action":"created","issue":{"number":9,"created_at":"2011-08-31T20:43:17Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"I run VirtualShop on an SQL database. All of my credentials are correct because when selling something it works great and inserts to the stock table. However whenever I want to view the current stock by using /stock or try buying what I just sold I receive the following. It is a remote database and I run at least 5 other plugins through SQL perfectly fine.\r\n\r\n2011-08-31 15:35:40 [WARNING] [Shop] §fError at SQL Query: Communications link failure\r\n\r\nThe last packet successfully received from the server was 37,883 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.\r\n2011-08-31 15:35:40 [SEVERE] null\r\norg.bukkit.command.CommandException: Unhandled exception executing command 'stock' in plugin VirtualShop v3.01\r\n\tat org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)\r\n\tat org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)\r\n\tat org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:352)\r\n\tat net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:737)\r\n\tat net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)\r\n\tat net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)\r\n\tat net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)\r\n\tat net.minecraft.server.NetworkManager.b(NetworkManager.java:226)\r\n\tat net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)\r\n\tat net.minecraft.server.NetworkListenThread.a(SourceFile:105)\r\n\tat net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)\r\n\tat net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)\r\n\tat net.minecraft.server.ThreadServerApplication.run(SourceFile:422)\r\nCaused by: java.lang.NullPointerException\r\n\tat org.blockface.virtualshop.objects.Offer.ListOffers(Offer.java:36)\r\n\tat org.blockface.virtualshop.managers.DatabaseManager.GetBestPrices(DatabaseManager.java:89)\r\n\tat org.blockface.virtualshop.commands.Stock.Execute(Stock.java:23)\r\n\tat org.blockface.virtualshop.VirtualShop.onCommand(VirtualShop.java:45)\r\n\tat org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)\r\n\t... 12 more","comments":3,"title":"Error when using stock or buy commands in SQL","updated_at":"2011-10-17T02:47:25Z","url":"https://api.github.com/repos/SwearWord/VirtualShop/issues/9","id":1535634,"assignee":null,"milestone":null,"closed_at":"2011-10-17T02:47:25Z","user":{"gravatar_id":"ce1b40d8a2a2e1c896ce336fdf63baa3","avatar_url":"https://secure.gravatar.com/avatar/ce1b40d8a2a2e1c896ce336fdf63baa3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/spinner0205","id":1016024,"login":"spinner0205"},"html_url":"https://github.com/SwearWord/VirtualShop/issues/9","labels":[],"state":"closed"},"legacy":{"issue_id":1535634,"comment_id":2424481}}