No Advancedban Table found

[devleoko]

No Advancedban Table found

[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]

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.

[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.