Statement in the database error

[Querko7]

What version of AdvancedBan (/AdvancedBan) are you using?

§8[]=====[§7Enabling AdvancedBan§8]=====[]
§8| §cInformation:
§8| §cName: §7AdvancedBan
§8| §cDeveloper: §7Leoko
§8| §cVersion: §72.1.5-SNAPSHOT
§8| §cStorage: §7MySQL (external)
§8| §cSupport:
§8| §cSkype: §7Leoko33
§8| §cMail: §7Leoko4433@gmail.com
§8| §cGithub: §7https://github.com/DevLeoko/AdvancedBan/issues
§8| §cDiscord: §7https://discord.gg/ycDG6rS
§8| §cUpdate:
§8| §7There is a new version available! [2.1.4]
§8[]================================[]§f

What kind of server do you have (Bungeecord/single server)?
Bungeecord

What server version (/version) are you using?

??9This server is running BungeeCord version git:BungeeCord-Bootstrap:1.12-SNAPSHOT:fde2c3f:1310 by md_5

Please povide the EXACT steps required to reproduce the problem...
1.
2.
3.

Any error/log post it through pastebin.com and link it here.

https://pastebin.com/QQNkj8MF

Add any additional information below.

Latest.log:
https://pastebin.com/k8qvn0XR

[DevLeoko]

seems to be the same bug as #198. Thanks for the report

[RainOfPain125]

I'll subskroob to this report incase I can help someway.

[itaquito]

Any updates? My console is full of this error. :p

[NanoAi]

This error is still around...

>AdvancedBan
[17:10:33 INFO]: -===== AdvancedBan v2 =====-
[17:10:33 INFO]:   Dev ? Leoko
[17:10:33 INFO]:   Status ? Stable
[17:10:33 INFO]:   Version ? 2.1.5-RELEASE
[17:10:33 INFO]:   License ? Public
[17:10:33 INFO]:   Storage ? MySQL (external)
[17:10:33 INFO]:   Server ? Spigot/Bukkit
[17:10:33 INFO]:   UUID-Mode ? INTERN
[17:10:33 INFO]:   Prefix ? AdvancedBan ?
[17:10:33 INFO]: -=========================-
>version
[17:11:08 INFO]: This server is running CraftBukkit version git-Spigot-642f6d2-57ab4cf (MC: 1.12.2) (Implementing API version 1.12.2-R0.1-SNAPSHOT)

[16:22:39 INFO]: [AdvancedBan] An unexpected error has ocurred executing an Statement in the database
Please check the plugins/AdvancedBan/logs/latest.log file and report thiserror in: https://github.com/DevLeoko/AdvancedBan/issues
[16:22:39 ERROR]: Could not pass event AsyncPlayerPreLoginEvent to AdvancedBan v2.1.5-RELEASE
org.bukkit.event.EventException: null
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:306) ~[spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
        at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:500) [spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:482) [spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
        at net.minecraft.server.v1_12_R1.LoginListener$LoginHandler.fireEvents(LoginListener.java:271) [spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
        at net.minecraft.server.v1_12_R1.LoginListener$3.run(LoginListener.java:224) [spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
Caused by: java.lang.NullPointerException
        at me.leoko.advancedban.manager.PunishmentManager.load(PunishmentManager.java:47) ~[?:?]
        at me.leoko.advancedban.Universal.callConnection(Universal.java:212) ~[?:?]
        at me.leoko.advancedban.bukkit.listener.ConnectionListener.onConnect(ConnectionListener.java:20) ~[?:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_171]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_171]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_171]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:302) ~[spigot-1.12.2.jar:git-Spigot-642f6d2-57ab4cf]
        ... 5 more

[16:22:39] An unexpected error has ocurred executing an Statement in the database
Please check the plugins/AdvancedBan/logs/latest.log file and report thiserror in: https://github.com/DevLeoko/AdvancedBan/issues
[16:22:39] Query: 
SELECT * FROM `Punishments` WHERE `uuid` = ? OR `uuid` = ?

[A248]

I have the same issue. It doesn't seem to be at all related to online/offline mode. However, I have noticed it only occurs with external storage (MySQL).

[A248]

#291 , another duplicate of this issue, provides more testimony to suggest this bug is MySQL-specific.