java.sql.SQLException

Before start of result set

Samebug tips1

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


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web1663

  • via Stack Overflow by BalaYesu Ch.
    ,
  • Stack trace

    • java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:841) at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5656) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5576) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616) at com.projectkorra.ProjectKorra.Commands$1.onCommand(Commands.java:792) at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44) at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141) at org.bukkit.craftbukkit.v1_8_R1.CraftServer.dispatchCommand(CraftServer.java:646) at net.minecraft.server.v1_8_R1.PlayerConnection.handleCommand(PlayerConnection.java:1115) at net.minecraft.server.v1_8_R1.PlayerConnection.a(PlayerConnection.java:950) at net.minecraft.server.v1_8_R1.PacketPlayInChat.a(PacketPlayInChat.java:26) at net.minecraft.server.v1_8_R1.PacketPlayInChat.a(PacketPlayInChat.java:53) at net.minecraft.server.v1_8_R1.PacketHandleTask.run(SourceFile:13) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at net.minecraft.server.v1_8_R1.MinecraftServer.z(MinecraftServer.java:683) at net.minecraft.server.v1_8_R1.DedicatedServer.z(DedicatedServer.java:316) at net.minecraft.server.v1_8_R1.MinecraftServer.y(MinecraftServer.java:623) at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:526) at java.lang.Thread.run(Thread.java:745)

    Write tip

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

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    MattyMatty
    Once,
    ivanszkypeterivanszkypeter
    4 times, last one
    Unknown visitor
    Unknown visitorOnce,
    jstrayerjstrayer
    4 times, last one
    148 more bugmates