MySQL Syntax error

Question

MySQL Syntax error

Pdani001 opened this issue 8 years ago · 14 comments

Pdani001 commented 8 years ago

This error shows up for me on plugin startup:
http://pastebin.com/CQYPU56n

games647 · Answer 1 · 2016-09-16T19:36:50.000Z

Try it without a reload

games647 · Answer 2 · 2016-09-16T19:37:28.000Z

I need your password-removed sql.yml

Pdani001 · Answer 3 · 2016-09-16T20:05:10.000Z

"SQL-Settings:
Username: ackills1
Password: ************************
Isolation: SERIALIZABLE
Driver: com.mysql.jdbc.Driver
Url: jdbc:mysql://db4free.net:3306/ackills1
Timeout: 1000
uuidUse: false"

Pdani001 · Answer 4 · 2016-09-17T06:41:02.000Z

http://pastebin.com/6g3TzXPU

games647 · Answer 5 · 2016-09-17T09:07:21.000Z

What version do you use? I don't find the line 196 in the latest version.

Pdani001 · Answer 6 · 2016-09-17T11:30:39.000Z

I use 0.8.3, but i got this problem every version above it.

Pdani001 · Answer 7 · 2016-09-17T11:32:55.000Z

It's right there: https://gyazo.com/8bc02acbd3248a62b10bf47ce3202ee0

games647 · Answer 8 · 2016-09-17T11:31:40.000Z

It cannot find your sql config. That's why it tries to invoke SQLite everytime.

games647 · Answer 9 · 2016-09-17T11:33:38.000Z

But it cannot parse it. Correctly, because it tries to setup a SQLite database.

Pdani001 · Answer 10 · 2016-09-17T11:41:38.000Z

Now i have a new problem.

Pdani001 · Answer 11 · 2016-09-17T11:42:08.000Z

When i try to change the mysql server it always use the last server.

games647 · Answer 12 · 2016-09-17T11:46:55.000Z

Try it without a reload

Pdani001 · Answer 13 · 2016-09-17T11:53:20.000Z

It's working now Thank You!

games647 · Answer 14 · 2016-09-16T20:42:18.000Z

Please use haste/pastebin or gists.

Share to