org.h2.jdbc.JdbcSQLException: Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192]

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafael

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

  • org.h2.jdbc.JdbcSQLException: Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.table.Column.validateConvertUpdateSequence(Column.java:335) at org.h2.table.Table.validateConvertUpdateSequence(Table.java:784) at org.h2.command.dml.Insert.insertRows(Insert.java:151) at org.h2.command.dml.Insert.update(Insert.java:114) at org.h2.command.CommandContainer.update(CommandContainer.java:98) at org.h2.command.Command.executeUpdate(Command.java:258) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) at io.github.flibio.economylite.utils.sql.SqlManager.executeUpdate(SqlManager.java:118) at io.github.flibio.economylite.impl.VirtualServiceCommon.setBalance(VirtualServiceCommon.java:77) at io.github.flibio.economylite.impl.economy.LiteEconomyService.getOrCreateAccount(LiteEconomyService.java:81) at com.arckenver.nations.cmdexecutor.nation.NationCreateExecutor.execute(NationCreateExecutor.java:111) at org.spongepowered.api.command.args.ChildCommandElementExecutor.execute(ChildCommandElementExecutor.java:179) at org.spongepowered.api.command.spec.CommandSpec.process(CommandSpec.java:332) at org.spongepowered.api.command.dispatcher.SimpleDispatcher.process(SimpleDispatcher.java:333) at org.spongepowered.common.command.SpongeCommandManager.process(SpongeCommandManager.java:274) at net.minecraft.command.ServerCommandManager.func_71556_a(SourceFile:82) at net.minecraft.network.NetHandlerPlayServer.func_147361_d(NetHandlerPlayServer.java:913) at net.minecraft.network.NetHandlerPlayServer.func_147354_a(NetHandlerPlayServer.java:892) at net.minecraft.network.play.client.CPacketChatMessage.func_148833_a(SourceFile:37) at net.minecraft.network.play.client.CPacketChatMessage.func_148833_a(SourceFile:9) at org.spongepowered.common.network.PacketUtil.onProcessPacket(PacketUtil.java:118) at net.minecraft.network.PacketThreadUtil$1.redirect$onProcessPacket$0(SourceFile:39) at net.minecraft.network.PacketThreadUtil$1.run(SourceFile:13) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at net.minecraft.util.Util.func_181617_a(SourceFile:45) at net.minecraft.server.MinecraftServer.func_71190_q(MinecraftServer.java:668) at net.minecraft.server.dedicated.DedicatedServer.func_71190_q(DedicatedServer.java:387) at net.minecraft.server.MinecraftServer.func_71217_p(MinecraftServer.java:613) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:471) at java.lang.Thread.run(Unknown Source)

Users with the same issue

batwalrus76
batwalrus763 times, last one,
andyglick
andyglick4 times, last one,
Unknown visitor1 times, last one,
tvrmsmith
tvrmsmith2 times, last one,
Andreas Häber
Andreas Häber1 times, last one,
143 more bugmates