AuthMe Reloaded

AuthMe Reloaded

3M Downloads

MySQL Connected To The Plugin But It Cames With an Error.

ItzZisker opened this issue ยท 4 comments

commented

I have Created A MySql Server in My Ubuntu Then I Started To Make An Empty Database called: "authme"
Then I Have Typed The Correct Information Inside The Authme MySQL Config, But This happened,
Its The Log:

[17:16:34 INFO]: [HamsterAPI] Enabling HamsterAPI v0.0.5
[17:16:34 INFO]: [Spartan] Enabling Spartan vBuild 347
[17:16:35 INFO]: [Spartan Build 347] Updating the Search Engine's data.
[17:16:35 INFO]: [Spartan Build 347] Done loading 115KB of data.
[17:16:35 INFO]: [PluginConstructorAPI] Enabling PluginConstructorAPI v1.0.52
[17:16:35 INFO]: [WorldEdit] Enabling WorldEdit v6.1.9;caf0ad9
[17:16:36 INFO]: WEPIF: Using the Bukkit Permissions API.
[17:16:36 INFO]: [WorldEdit] Using com.sk89q.worldedit.bukkit.adapter.impl.Spigot_v1_12_R2 as the Bukkit adapter
[17:16:36 INFO]: [CustomChat] Enabling CustomChat v2.1.1
[17:16:36 INFO]: [CustomChat] CustomChat has been Enabled!
[17:16:36 INFO]: [PlaceholderAPI] Enabling PlaceholderAPI v2.10.6
[17:16:36 INFO]: [PlaceholderAPI] Fetching available expansion information...
[17:16:36 INFO]: [ServerSelectorX] Enabling ServerSelectorX v3.5.4-legacy
[17:16:36 INFO]: [ServerSelectorX] Thank you for using ServerSelectorX. If you enjoy using this plugin, please consider buying the premium version. It has more features and placeholders update instantly. https://github.com/ServerSelectorX/ServerSelectorX/wiki/Premium
[17:16:36 INFO]: [NoteBlockAPI] Enabling NoteBlockAPI v1.5.0
[17:16:36 INFO]: [AuthMe] Enabling AuthMe v5.6.0-beta1-b2226
[17:16:36 INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
[17:16:36 WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Starting...
[17:16:36 WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Start completed.
[17:16:37 WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Shutdown initiated...
[17:16:37 WARN]: [Server thread] INFO fr.xephi.authme.libs.com.zaxxer.hikari.HikariDataSource - AuthMeMYSQLPool - Shutdown completed.
[17:16:37 WARN]: [AuthMe] Can't initialize the MySQL database: [MySQLSyntaxErrorException]: 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 '. VARCHAR(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL' at line 1
[17:16:37 WARN]: [AuthMe] Please check your database settings in the config.yml file!
[17:16:37 WARN]: [AuthMe] Could not create data source: [MySQLSyntaxErrorException]: 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 '. VARCHAR(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL' at line 1
[17:16:37 WARN]: [AuthMe] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[17:16:37 WARN]: [AuthMe] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
[17:16:37 INFO]: [AuthMe] Waiting for 0 tasks to finish
[17:16:37 INFO]: [AuthMe] AuthMe 5.6.0-beta1-b2226 disabled!
[17:16:37 INFO]: [ExploitFixer] Enabling ExploitFixer v1.3.3
[17:16:37 INFO]: [ExploitFixer] Successfully hooked with HamsterAPI!
[17:16:37 INFO]: [BungeeAuth] Enabling BungeeAuth v1.3
[17:16:37 INFO]: [ViaVersion] Enabling ViaVersion v3.0.1
[17:16:37 INFO]: [ModChat] Enabling ModifiedChat v1.0
[17:16:37 INFO]: [VoidSpawn] Enabling VoidSpawn v1.17.0
[17:16:37 INFO]: [VoidSpawn] No SkyBlock plugins found, disabling island mode support.
[17:16:37 INFO]: [VoidSpawn] v1.17.0 by EnderCrest enabled
[17:16:37 INFO]: [WorldGuard] Enabling WorldGuard v6.2.2-SNAPSHOT;8eeab68
[17:16:37 INFO]: [WorldGuard] (world) TNT ignition is PERMITTED.
[17:16:37 INFO]: [WorldGuard] (world) Lighters are PERMITTED.
[17:16:37 INFO]: [WorldGuard] (world) Lava fire is blocked.
[17:16:37 INFO]: [WorldGuard] (world) Fire spread is UNRESTRICTED.
[17:16:37 INFO]: [WorldGuard] Loaded configuration for world 'world'
[17:16:37 INFO]: [WorldGuard] (world_nether) TNT ignition is PERMITTED.
[17:16:37 INFO]: [WorldGuard] (world_nether) Lighters are PERMITTED.
[17:16:37 INFO]: [WorldGuard] (world_nether) Lava fire is blocked.
[17:16:37 INFO]: [WorldGuard] (world_nether) Fire spread is UNRESTRICTED.
[17:16:37 INFO]: [WorldGuard] Loaded configuration for world 'world_nether'
[17:16:37 INFO]: [WorldGuard] (world_the_end) TNT ignition is PERMITTED.
[17:16:37 INFO]: [WorldGuard] (world_the_end) Lighters are PERMITTED.
[17:16:37 INFO]: [WorldGuard] (world_the_end) Lava fire is blocked.
[17:16:37 INFO]: [WorldGuard] (world_the_end) Fire spread is UNRESTRICTED.
[17:16:37 INFO]: [WorldGuard] Loaded configuration for world 'world_the_end'
[17:16:37 INFO]: [WorldGuard] Loading region data...
[17:16:37 INFO]: [JukeBox] Enabling JukeBox v1.12
[17:16:37 INFO]: [JukeBox] Placeholders registered
[17:16:37 INFO]: [JukeBox] This JukeBox version requires NoteBlockAPI version 1.2.5 or more. Please ensure that before using JukeBox (you are using NBAPI ver. 1.5.0)
[17:16:37 INFO]: [JukeBox] Loaded language file en.yml
[17:16:37 INFO]: [JukeBox] 2 songs loadeds. Sorting by name...
[17:16:37 INFO]: [JukeBox] Songs sorted ! 2 songs. Number of pages : 1
[17:16:37 INFO]: [SimpleScore] Enabling SimpleScore v3.3.2
[17:16:37 INFO]: [SimpleScore] Loading disabled scoreboards...
[17:16:37 INFO]: [SimpleScore] Disabled scoreboards loaded.
[17:16:37 INFO]: Done (10.267s)! For help, type "help" or "?"
[17:16:37 INFO]: Stopping server
[17:16:37 INFO]: [SimpleScore] Disabling SimpleScore v3.3.2
[17:16:37 INFO]: [SimpleScore] Saving disabled scoreboards...
[17:16:37 INFO]: [SimpleScore] Disabled scoreboards saved.
[17:16:37 INFO]: [JukeBox] Disabling JukeBox v1.12
[17:16:37 INFO]: [WorldGuard] Disabling WorldGuard v6.2.2-SNAPSHOT;8eeab68
[17:16:37 INFO]: [WorldGuard] Shutting down executor and waiting for any pending tasks...
[17:16:37 INFO]: [VoidSpawn] Disabling VoidSpawn v1.17.0
[17:16:37 INFO]: [VoidSpawn] v1.17.0 saving config
[17:16:37 INFO]: [VoidSpawn] v1.17.0 disabled
[17:16:37 INFO]: [ModChat] Disabling ModifiedChat v1.0
[17:16:37 INFO]: [ViaVersion] Disabling ViaVersion v3.0.1
[17:16:37 INFO]: [ViaVersion] ViaVersion is disabling, if this is a reload and you experience issues consider rebooting.
[17:16:37 INFO]: [BungeeAuth] Disabling BungeeAuth v1.3
[17:16:37 INFO]: [ExploitFixer] Disabling ExploitFixer v1.3.3
[17:16:37 INFO]: [NoteBlockAPI] Disabling NoteBlockAPI v1.5.0
[17:16:37 INFO]: [ServerSelectorX] Disabling ServerSelectorX v3.5.4-legacy
[17:16:37 INFO]: [PlaceholderAPI] Disabling PlaceholderAPI v2.10.6
[17:16:37 INFO]: [CustomChat] Disabling CustomChat v2.1.1
[17:16:37 INFO]: [CustomChat] CustomChat has been Disabled!
[17:16:37 INFO]: [WorldEdit] Disabling WorldEdit v6.1.9;caf0ad9
[17:16:37 INFO]: [PluginConstructorAPI] Disabling PluginConstructorAPI v1.0.52
[17:16:37 INFO]: [Spartan] Disabling Spartan vBuild 347
[17:16:38 INFO]: [HamsterAPI] Disabling HamsterAPI v0.0.5
[17:16:38 INFO]: [LobbyAPI] Disabling LobbyAPI v3.7.104
[17:16:38 INFO]: Saving players
[17:16:38 INFO]: Saving worlds
[17:16:38 INFO]: Saving chunks for level 'world'/overworld
[17:16:38 INFO]: Saving chunks for level 'world_nether'/the_nether
[17:16:38 INFO]: Saving chunks for level 'world_the_end'/the_end

commented

pls help, i never seen that before.

commented

Hallo Sadly You Dident Follow The Issue Template But I Think In Your Configuration File You Have Named A MySQL Column With Just A Dot And That Is Not Allowed Certain Columns Can Be Made Optional But Not All And If You Want To Make A Column Optional Just Put An Empty String Like So '' Thanks

commented

pleas aswer if this solved your problem !

commented

Closing due to inactivity