No Advancedban Table found

[RTCFlyer]

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

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

What server version (/version) are you using?
1.10.2 (updating soon)

Please provide the EXACT steps required to reproduce the problem...

1. get a MySql database with the AB website interface.
2. Try to create a acount with the AB website.

Any error/log post it through pastebin.com and link it here.
No error logs are shown

Add any aditional information below.
When I try to create the acount with the AdvancedBan website interface it gives me a error saying it can not find the AB tables. I looked in my SQL database and the plugin is not generating the tables.

[dutchy1001]

How did you setup your MySQL?
What permissions does the MySQL db have?
Have you double checked the login name/password?

[RTCFlyer]

My MySql is setup through bisecthosting.
The permissions should all be fine considering BanManager (past plugin that was bad.) was able to create tables. And lots of other plugins.
Yes I have double checked the login name/password.

[dutchy1001]

I would suggest to renew your password and DB name as the mail that was send out contained your credentials for it (not that I would, but you dont know how many others got that mail).

What I think happens here is that the host doesnt use the default 3306 port which therefor wont let AdvancedBan create the tables.
In a coming update (no ETA yet) this will change so you can set the port to your own liking.

[RTCFlyer]

Any solution to this now, I would really like to set this up. Plus is advancedban is not even accepting my credentials then how am I suppose to use the plugin fully.

[RTCFlyer]

I got it! Okay, so turns out the MySql Config file was not loading in the plugin files. I did a few server restarts and I finally got the file. The port works fine! Thanks for the help anyway.

[dutchy1001]

Thx for letting me know. I hope it will go smooth from here on.

[dutchy1001]

PS. dont forget to change the credentials

[RTCFlyer]

I have already done this :) Thanks again, also anyway to import old bans from the data?

[dutchy1001]

Unfortunately not, this was also an issue from the last update, I hope in the next update this will be added., so dont delete your old DB yet.

[RTCFlyer]

So, it has been working so far, now I am getting this error when I try to /warn someone.

09.01 22:21:43 [Server] INFO RTCFlyer issued server command: /warn test test
09.01 22:21:43 [Server] INFO AdvancedBan <> Skipped executing SQL because there is no connection to the MySQL-Server please restart the server!
09.01 22:21:43 [Server] INFO AdvancedBan <> Skipped executing SQL because there is no connection to the MySQL-Server please restart the server!
09.01 22:21:43 [Server] INFO AdvancedBan <> Skipped executing SQL because there is no connection to the MySQL-Server please restart the server!
09.01 22:21:43 [Server] WARN [AdvancedBan] Plugin AdvancedBan v2.0.5 generated an exception while executing task 145
09.01 22:21:43 [Server] INFO java.lang.NullPointerException
09.01 22:21:43 [Server] INFO at me.leoko.advancedban.utils.Punishment.create(Punishment.java:103) ~[?:?]
09.01 22:21:43 [Server] INFO at me.leoko.advancedban.manager.CommandManager$1.run(CommandManager.java:123) ~[?:?]
09.01 22:21:43 [Server] INFO at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftTask.run(CraftTask.java:71) ~[spigot-1.10.jar:git-Spigot-de459a2-51263e9]
09.01 22:21:43 [Server] INFO at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52) [spigot-1.10.jar:git-Spigot-de459a2-51263e9]
09.01 22:21:43 [Server] INFO at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_112]
09.01 22:21:43 [Server] INFO at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_112]
09.01 22:21:43 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.8.0_112]

I have checked the user and password both times, also i have restarted the server.

[dutchy1001]

when using a name that doesnt have a real UUID it will error, this will be fixed in a next update

[dutchy1001]

Edited the message as the bold was hard to read and missing the last sentence. Use spaces between sections and pastebin for logs is way better to read.

Still something with your connection to the MySQL is not set properly.