search

eccentricdevotion / TARDIS

A Spigot / Paper plugin for all Doctor Who fans - create and use a TARDIS! It's bigger on the inside!
GNU General Public License v3.0
79 stars 27 forks source link

SQL Create Table Error on MySql #818

Closed eccentricdevotion closed 3 months ago

eccentricdevotion commented 4 months ago

Submitted by

Nowe101

Describe the bug

The plugin is unable to create multiple tables at startup.

MySQL create table error: 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 ''0, PRIMARY KEY (chameleon_id)) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci' at line 1

Storagetype is mysql.

Mysql Server:

Server version: 10.4.18-MariaDB-1:10.4.18+maria~focal - mariadb.org binary distribution Protocol version: 10 Server charset: cp1252 West European (latin1)

To Reproduce

The plugin is unable to create multiple tables at startup. Restart of the Server doesn´t solve the Problem.

Log files

Debug-Log (Tardis-Plugin): https://paste.gg/p/anonymous/9230b72b0e9e4f36a662e68f1b3bb3b5

'/tardis version' output

[16:42:24 INFO]: [TARDIS] Server version: git-Paper-350 (MC: 1.20.4) [16:42:24 INFO]: [TARDIS] TARDIS version: 5.4.0-b2802 [16:42:24 INFO]: [TARDIS] Vault version: 1.7.3-CMI [16:42:24 INFO]: [TARDIS] PlaceholderAPI version: 2.11.5 [16:42:24 INFO]: [TARDIS] floodgate version: 2.2.2-SNAPSHOT (b96-7f38765) [16:42:24 INFO]: [TARDIS] WorldGuard version: 7.0.9+5934e49 [16:42:24 INFO]: [TARDIS] BlueMap version: 3.20 [16:42:24 INFO]: [TARDIS] LibsDisguises version: 10.0.42 [16:42:24 INFO]: [TARDIS] Checking for new TARDIS builds... [16:42:26 INFO]: [TARDIS] You are running the latest version!

eccentricdevotion commented 3 months ago

Should be fixed in build 2810 and higher