Solved PlayerChatEvent Problem

Hey Guys,

im new on Java (yes im learning ) and now i test to make a little WebChatplugin (for my Server ).
My Problem:

When i typing Ingame a text then the plugin save this in a mysql database.

Now this not working, i become following error:

Code:

[15:58:13] [Netty IO #3/ERROR]: Could not pass event AsyncPlayerChatEvent to ExternalChat v0.5
org.bukkit.event.EventException
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:320) ~[srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:486) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:468) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.server.v1_7_R1.PlayerConnection.chat(PlayerConnection.java:878) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.server.v1_7_R1.PlayerConnection.a(PlayerConnection.java:828) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.server.v1_7_R1.PacketPlayInChat.a(PacketPlayInChat.java:28) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.server.v1_7_R1.PacketPlayInChat.handle(PacketPlayInChat.java:47) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.server.v1_7_R1.NetworkManager.a(NetworkManager.java:72) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.server.v1_7_R1.NetworkManager.channelRead0(NetworkManager.java:192) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:98) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:337) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:323) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:173) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:337) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:323) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:173) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:337) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:323) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:337) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:323) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.handler.timeout.ReadTimeoutHandler.channelRead(ReadTimeoutHandler.java:149) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:337) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:323) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:785) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:100) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:480) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:447) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:341) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at net.minecraft.util.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:101) [srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    at java.lang.Thread.run(Unknown Source) [?:1.7.0_45]
Caused by: java.lang.NullPointerException
    at ChatListener.InsertChat(ChatListener.java:51) ~[?:?]
    at ChatListener.onPlayerChat(ChatListener.java:44) ~[?:?]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_45]
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_45]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_45]
    at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.7.0_45]
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:318) ~[srv.jar:git-Bukkit-1.7.2-R0.3-b3020jnks]
    ... 31 more
[15:58:13] [Netty IO #3/INFO]: <Microlost> wsftwerf

My Pluginsnippet:

Code:

@EventHandler
    public void onPlayerChat(AsyncPlayerChatEvent e){
        Player p = e.getPlayer();
        e.getMessage();
       
        p.sendMessage(e.getMessage()+"1");
        InsertChat(p.getName(), e.getMessage()); //Line 44
       
    }
   
    public void InsertChat(String Player, String Text)
    {
       
        sql.queryUpdate("INSERT INTO ucp_webchat (name, text, time) VALUES ('" + Player +"', '" + Text + "', '0')"); //Line 51
    }

i hope you can help me,

Best Regards,
Domi

PS: Sry, but im from Austria (I mean this for my bad english)

 

I think your variable "sql" is null.

 

Yup you have to define new database connection with the variable sql

 

Oh, i have seen

I had forgot to add

Code:

this.sql = new MYSQL();
        MYSQL sql = this.getMySQL();