Issues on index creation

[HappyAreaBean]

Hi, I have some issues when using MySQL, here is my entity.

MySQL 5.7.44

Click here for Error

[18:58:17 ERROR]: Error occurred while enabling SimpleJoinMessage v1.2.0-SNAPSHOT-5972ed9 (Is it up to date?)
sjm.libs.nivixx.database.ndatabase.api.exception.DatabaseCreationException: Error during index creation by de-normalization for NEntity cc.happyareabean.sjm.database.SJMData
	at sjm.libs.nivixx.database.ndatabase.core.dao.jdbc.JdbcDao.createIndexes(JdbcDao.java:250) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at sjm.libs.nivixx.database.ndatabase.core.RepositoryManager.getOrCreateRepository(RepositoryManager.java:58) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at sjm.libs.nivixx.database.ndatabase.core.NDatabaseAPIImpl.getOrCreateRepository(NDatabaseAPIImpl.java:19) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at cc.happyareabean.sjm.database.DatabaseManager.<init>(DatabaseManager.java:42) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at cc.happyareabean.sjm.SimpleJoinMessage.loadDatabase(SimpleJoinMessage.java:111) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at cc.happyareabean.sjm.SimpleJoinMessage.onEnable(SimpleJoinMessage.java:77) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:287) ~[paper-api-1.20.4-R0.1-SNAPSHOT.jar:?]
	at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:188) ~[paper-1.20.4.jar:git-Paper-493]
	at io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:104) ~[paper-1.20.4.jar:git-Paper-493]
	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:507) ~[paper-api-1.20.4-R0.1-SNAPSHOT.jar:?]
	at org.bukkit.craftbukkit.v1_20_R3.CraftServer.enablePlugin(CraftServer.java:639) ~[paper-1.20.4.jar:git-Paper-493]
	at org.bukkit.craftbukkit.v1_20_R3.CraftServer.enablePlugins(CraftServer.java:550) ~[paper-1.20.4.jar:git-Paper-493]
	at net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:671) ~[paper-1.20.4.jar:git-Paper-493]
	at net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:431) ~[paper-1.20.4.jar:git-Paper-493]
	at net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:309) ~[paper-1.20.4.jar:git-Paper-493]
	at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1131) ~[paper-1.20.4.jar:git-Paper-493]
	at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:319) ~[paper-1.20.4.jar:git-Paper-493]
	at java.lang.Thread.run(Thread.java:833) ~[?:?]
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 collection_name_index ON sjm_data(collection_name)' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) ~[mysql-connector-j-8.2.0.jar:8.2.0]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.2.0.jar:8.2.0]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912) ~[mysql-connector-j-8.2.0.jar:8.2.0]
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) ~[mysql-connector-j-8.2.0.jar:8.2.0]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at sjm.libs.nivixx.database.ndatabase.core.dao.jdbc.JdbcDao.denormalizeFieldIntoColumn(JdbcDao.java:283) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	at sjm.libs.nivixx.database.ndatabase.core.dao.jdbc.JdbcDao.createIndexes(JdbcDao.java:246) ~[SimpleJoinMessage-1.2.0-SNAPSHOT.jar:?]
	... 17 more
[18:58:17 INFO]: [SimpleJoinMessage] Disabling SimpleJoinMessage v1.2.0-SNAPSHOT-5972ed9
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 collection_name_index ON sjm_data(collection_name)' at line 1

---

MariaDB 10.6.16

Click here for Error

Caused by: java.sql.SQLSyntaxErrorException: 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 '{4}))' at line 1

[NivixX]

Hello, thank you for reporting the issue with details.

I will write an adapter for Mysql 5.7 <= and then for mariaDB

[HappyAreaBean]

Hello! Thank you for the update! MySQL seems to be working well right now.
But I still have the same error with MariaDB.