MySQL error

[MauzerBrayn]

Bug Report

• Plugin Version: EliteEssentials v2.0.9
• Hytale Version: v0.5.7

Hi ! I found what seems to be a MySQL schema initialization bug.

Environment:
EliteEssentials 2.0.9
MySQL 8.0.46
Java 25.0.3

The plugin connects successfully and creates ee_players, but then fails during index creation with:

You have an error in your SQL syntax near
'IF NOT EXISTS idx_ee_players_name'

It looks like SchemaManager generates 'CREATE INDEX IF NOT EXISTS ...'
which is not valid MySQL syntax.

[rishita120805]

Thanks for reporting this!

Root Cause
MySQL does not natively support the IF NOT EXISTS clause in CREATE INDEX statements (unlike SQLite or MariaDB), which causes the syntax error during schema initialization.
Fix
We need to update SchemaManager to build the CREATE INDEX query without IF NOT EXISTS when using the MySQL dialect.

Standard MySQL Syntax:

CREATE INDEX idx_ee_players_name ON ee_players (<column_name>);