There has been a persistent issue with MySQL database creation and connection since the plugin was released!

[wlm1455925277]

[00:28:12 WARN]: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS quick_return_click_type TEXT' at line 2
[00:28:12 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
[00:28:12 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
[00:28:12 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:990)
[00:28:12 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:384)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.shaded.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.shaded.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.storage.sources.MySQLDataSource.lambda$createTables$0(MySQLDataSource.java:52)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.utility.ExceptionUtil.runWithSQLExceptionHandling(ExceptionUtil.java:30)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.utility.Executors.lambda$supplyAsyncWithSQLException$3(Executors.java:63)
[00:28:12 WARN]: at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)[00:28:12 WARN]: at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1760)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1310)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1841)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1806)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
[00:28:12 WARN]: java.util.concurrent.CompletionException: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS quick_return_click_type TEXT' at line 2
[00:28:12 WARN]: at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315)
[00:28:12 WARN]: at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320)
[00:28:12 WARN]: at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1770)[00:28:12 WARN]: at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1760)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1310)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1841)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1806)
[00:28:12 WARN]: at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
[00:28:12 WARN]: Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS quick_return_click_type TEXT' at line 2
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.utility.ExceptionUtil.runWithSQLExceptionHandling(ExceptionUtil.java:33)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.utility.Executors.lambda$supplyAsyncWithSQLException$3(Executors.java:63)
[00:28:12 WARN]: at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)[00:28:12 WARN]: ... 6 more
[00:28:12 WARN]: Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS quick_return_click_type TEXT' at line 2
[00:28:12 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
[00:28:12 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
[00:28:12 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:990)
[00:28:12 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:384)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.shaded.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.shaded.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.storage.sources.MySQLDataSource.lambda$createTables$0(MySQLDataSource.java:52)
[00:28:12 WARN]: at Malts-1.0.2.jar//dev.jsinco.malts.utility.ExceptionUtil.runWithSQLExceptionHandling(ExceptionUtil.java:30)
[00:28:12 WARN]: ... 8 more

[Jsinco]

Hi, I need more information than this. What MySQL/MariaDB server version are you using? Also what server version are you running?

[wlm1455925277]

您好，我需要更多信息。您使用的是哪个 MySQL/MariaDB 服务器版本？您运行的服务器版本又是多少？

[22:20:08 INFO]: Checking version, please wait...
[22:20:09 INFO]: This server is running AdvancedSlimePaper version 1.21.8-16783-main@6a660f3 (2025-09-22T16:51:40Z) (Implementing API version 1.21.8-R0.1-SNAPSHOT)
You are 17 version(s) behind
Download the new version from our Discord: https://discord.gg/YevvsMa

MySQL 8.0.29

[Jsinco]

MySQL 8.0.29 is EOL and no longer supported. The reason you're getting this error is probably because this database doesn't support the language feature. I'd recommend upgrading or switching to SQLite.

[Jsinco]

MySQL 8.0.29 is EOL and no longer supported. The reason you're getting this error is probably because this database doesn't support the language feature. I'd recommend upgrading or switching to SQLite.

After looking into this more, it actually seems like this isn't proper MySQL syntax and is specific to some more modern versions of MariaDB (oops). I'll check out #2 later and see to finding a nice solution for supporting MySQL properly. Although, your database version is still EOL and seems to have some data issues I'd look into.

[wlm1455925277]

MySQL 8.0.29 已停止维护，不再提供支持。出现此错误的原因可能是该数据库不支持相应的语言特性。我建议您升级或切换到 SQLite。

经过进一步研究，我发现这实际上并非标准的 MySQL 语法，而是某些较新版本的 MariaDB 特有的（哎呀）。我稍后会查看#2，并努力找到一个能够正确支持 MySQL 的解决方案。不过，你的数据库版本已经停止维护，而且似乎存在一些数据问题，我建议你调查一下。

I have sent you a zipper request that you can refer to

[wlm1455925277]

#3