IP-Check

IP-Check

Bukkit Plugins
105k Downloads

errror: in your SQL syntax

makemp1997 opened this issue ยท 1 comments

commented

Issue Report

IP-Check Version:
2.07
Java Version:
8
Database Type:
MySQL
Description of the problem:
Evertime I restart the server I got the message, after I have congigurd the myqul database:

[IP-Check] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-check.ipcheck_user' at line 1

I tried every datbase config, for exemple:
dbUsername: "makemp1997"
dbPassword: "test123"
dbHostname: "123.123.321.123"
dbName: "ip-check"
dbPort: 3306

Although it have contact to the datase, becase there is database sturcture of ip-check, but still I got that error.
So do you know how I can fix this?

How to replicate:

Checklist:

  • I made sure there aren't duplicates of this report (Use Search)
  • I made sure I am using an up-to-date version of IP-Check.
  • I Made sure the bug/error is not caused by any other plugin.
commented

As a cursory, I'd first verify that there are no spaces in the dbName field. The error would seem to suggest that the database name is being cut off for some reason.

If there are no spaces, my next suggestion would be to change the value of dbName from 'ip-check' to 'ipcheck' and reflect this change in your MySQL database accordingly. It's possible that whatever SQL version is being used by your server may have a problem with the dash '-' character being used.

If neither of these work, please let me know.

-Jnk