com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • DB Out of date
    via GitHub by FranciscoContreras
    ,
  • Drop table in mysql Database with java
    via Stack Overflow by Ernanirst
    ,
    • com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'last_migration' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[?:1.8.0_101] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[?:1.8.0_101] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[?:1.8.0_101] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[?:1.8.0_101] at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.Util.getInstance(Util.java:387)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2546)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1541)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2605)[patched_1.10.2.jar:git-Paper-885] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1469)[patched_1.10.2.jar:git-Paper-885] at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)[CivModCore-1.5.02.jar:?] at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)[CivModCore-1.5.02.jar:?] at vg.civcraft.mc.civmodcore.dao.ManagedDatasource.getReady(ManagedDatasource.java:177)[CivModCore-1.5.02.jar:?] at vg.civcraft.mc.civmodcore.dao.ManagedDatasource.<init>(ManagedDatasource.java:170)[CivModCore-1.5.02.jar:?] at vg.civcraft.mc.namelayer.NameLayerPlugin.loadDatabases(NameLayerPlugin.java:141)[NameLayer-2.9.06.jar:?] at vg.civcraft.mc.namelayer.NameLayerPlugin.onEnable(NameLayerPlugin.java:64)[NameLayer-2.9.06.jar:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:292)[patched_1.10.2.jar:git-Paper-885] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:316)[patched_1.10.2.jar:git-Paper-885] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:407)[patched_1.10.2.jar:git-Paper-885] at org.bukkit.craftbukkit.v1_10_R1.CraftServer.enablePlugin(CraftServer.java:375)[patched_1.10.2.jar:git-Paper-885] at org.bukkit.craftbukkit.v1_10_R1.CraftServer.enablePlugins(CraftServer.java:325)[patched_1.10.2.jar:git-Paper-885] at net.minecraft.server.v1_10_R1.MinecraftServer.t(MinecraftServer.java:418)[patched_1.10.2.jar:git-Paper-885] at net.minecraft.server.v1_10_R1.MinecraftServer.l(MinecraftServer.java:383)[patched_1.10.2.jar:git-Paper-885] at net.minecraft.server.v1_10_R1.MinecraftServer.a(MinecraftServer.java:329)[patched_1.10.2.jar:git-Paper-885] at net.minecraft.server.v1_10_R1.DedicatedServer.init(DedicatedServer.java:275)[patched_1.10.2.jar:git-Paper-885] at net.minecraft.server.v1_10_R1.MinecraftServer.run(MinecraftServer.java:584)[patched_1.10.2.jar:git-Paper-885] at java.lang.Thread.run(Thread.java:745)[?:1.8.0_101]

    Users with the same issue

    rocday
    2 times, last one,
    Kialandei
    9 times, last one,
    jshakil
    23 times, last one,
    mortalman7
    1 times, last one,
    Unknown visitor1 times, last one,
    115 more bugmates