Autorank

Autorank

380k Downloads

Problem with MariaDB

TomekkStorm opened this issue ยท 3 comments

commented

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.

commented

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

commented

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.

commented

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