Problem with MariaDB
TomekkStorm opened this issue ยท 3 comments
Hello,
i've got this message while the installation:
13:40:17 INFO: SQLException: 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 'null (uuid VARCHAR(255) not NULL, time INTEGER not NULL, modified TIMESTAMP no' at line 1
13:40:17 INFO: SQLState: 42000
13:40:17 INFO: VendorError: 1064
The db table autorank was not created.
If a user joins the server i've got these messages:
13:45:20 INFO: SQLException: 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 'null WHERE uuid='ed7c6e4a-6ef9-4d60-9569-d265156a9cf1'' at line 1
13:45:20 INFO: SQLState: 42000
13:45:20 INFO: VendorError: 1064
13:45:20 INFO: SQLDataStorage.execute
13:45:20 INFO: SQLException: 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 'null VALUES ('ed7c6e4a-6ef9-4d60-9569-d265156a9cf1', 5, CURRENT_TIMESTAMP) ON DU' at line 1
13:45:20 INFO: SQLState: 42000
13:45:20 INFO: VendorError: 1064
[13:45:21 INFO]: SQLDataStorage.executeQuery
[13:45:21 INFO]: SQLException: 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 'null WHERE uuid='ed7c6e4a-6ef9-4d60-9569-d265156a9cf1'' at line 1
[13:45:21 INFO]: SQLState: 42000
[13:45:21 INFO]: VendorError: 1064
Can you please post your MySQL settings but delete the password and username?
Thanks.
It might be the DataBase name that you entered.
If you left it as "AutoRank" that's not correct and it will start sending ERROR(s) in Console.
I had the same problem, so here is what I did.
Changed the DataBase name from AutoRank
to my DataBase name that I created.
MySQL comes with a password, username, and a DataBase name. <- That's the one.
This is my configuration:
IP, Username and Password is not real ;-)
sql:
enabled: true
hostname: 123.456.789.0:3306
username: user
password: 'pw'
database: sid140314_1
table: autorank2
I get the following error:
[20:57:21 INFO]: SQLDataStorage.execute
[20:57:21 INFO]: SQLException: 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 'null (uuid VARCHAR(255) not NULL, time INTEGER not NULL, modified TIMESTAMP no' at line 1
[20:57:21 INFO]: SQLState: 42000
[20:57:21 INFO]: VendorError: 1064