java.sql.SQLException

tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Failed to migrate database
    via GitHub by leetom
    ,
  • Strange SQLException: Column not found
    via Stack Overflow by akafortes
    ,
  • Before start of result set
    via Stack Overflow by BalaYesu Ch.
    ,
  • SQL ResultSet closing suddently
    via Stack Overflow by Tom Lima
    ,
  • SQL exception before Start (with .next())
    via Stack Overflow by bateras
    ,
    • java.sql.SQLException: Column 'ip' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at com.lenis0012.bukkit.loginsecurity.modules.migration.LegacyMigration.getProfile(LegacyMigration.java:162)[LoginSecurity.jar:git-LoginSecurity-cf1b468] at com.lenis0012.bukkit.loginsecurity.modules.migration.AbstractMigration.loadProfiles(AbstractMigration.java:116)[LoginSecurity.jar:git-LoginSecurity-cf1b468] at com.lenis0012.bukkit.loginsecurity.modules.migration.LegacyMigration.execute(LegacyMigration.java:80)[LoginSecurity.jar:git-LoginSecurity-cf1b468] at com.lenis0012.bukkit.loginsecurity.modules.migration.MigrationModule.enable(MigrationModule.java:33)[LoginSecurity.jar:git-LoginSecurity-cf1b468] at com.lenis0012.bukkit.loginsecurity.libs.pluginutils.Registry.enableModule(Registry.java:88)[LoginSecurity.jar:git-LoginSecurity-cf1b468] at com.lenis0012.bukkit.loginsecurity.libs.pluginutils.Registry.enableModules(Registry.java:58)[LoginSecurity.jar:git-LoginSecurity-cf1b468] at com.lenis0012.bukkit.loginsecurity.libs.pluginutils.PluginHolder.onEnable(PluginHolder.java:28)[LoginSecurity.jar:git-LoginSecurity-cf1b468] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:356)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:316)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:418)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:382)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:337)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:256)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:528)[spigot-1.8.7-R0.1-SNAPSHOT.jar:git-Spigot-44c59bf-1880a9c] at java.lang.Thread.run(Thread.java:745)[?:1.7.0_80]

    Users with the same issue

    ivanszkypeter
    4 times, last one,
    Unknown visitor1 times, last one,
    jstrayer
    4 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    145 more bugmates