Error converting H2 DB to MySQL about craftconomy3 HOT 12 OPEN

Same problem, this log:

[00:59:27 INFO]: [Craftconomy3] Enabling Craftconomy3 v3.3-e72ac42-trv178 [00:59:27 INFO]: [Craftconomy3] Starting up! [00:59:27 INFO]: [Craftconomy3] Loading the Configuration [00:59:27 INFO]: [Craftconomy3] Loading listeners. [00:59:28 INFO]: [Craftconomy3] Loading commands [00:59:28 INFO]: [Craftconomy3] Loading the Database Manager [00:59:28 WARN]: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". [00:59:28 WARN]: SLF4J: Defaulting to no-operation (NOP) logger implementation [00:59:28 WARN]: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. [00:59:28 INFO]: [Craftconomy3] Starting database convertion to MySQL. This can take come time. [00:59:28 INFO]: [Craftconomy3] Starting database convertion to MySQL. This can take come time. [00:59:28 INFO]: [Craftconomy3] Getting accounts information [00:59:28 ERROR]: Error occurred while enabling Craftconomy3 v3.3-e72ac42-trv178 (Is it up to date?) java.lang.NullPointerException at java.util.UUID.fromString(UUID.java:192) ~[?:1.8.0_66-internal] at com.greatmancode.craftconomy3.converter.H2ToMySQLConverter.run(H2ToMySQLConverter.java:64) ~[?:?] at com.greatmancode.craftconomy3.Common.convertDatabase(Common.java:412) ~[?:?] at com.greatmancode.craftconomy3.Common.initialiseDatabase(Common.java:397) ~[?:?] at com.greatmancode.craftconomy3.Common.onEnable(Common.java:143) ~[?:?] at com.greatmancode.craftconomy3.tools.interfaces.BukkitLoader.onEnable(BukkitLoader.java:49) ~[?:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java:356) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java:316) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at net.minecraft.server.v1_8_R3.MinecraftServer.s(MinecraftServer.java:418) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at net.minecraft.server.v1_8_R3.MinecraftServer.k(MinecraftServer.java:382) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at net.minecraft.server.v1_8_R3.MinecraftServer.a(MinecraftServer.java:337) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at net.minecraft.server.v1_8_R3.DedicatedServer.init(DedicatedServer.java:256) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:528) [craftbukkit_bigcraft.jar:git-Spigot-44c59bf-8f0f4ed] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_66-internal]
log in readable format

from craftconomy3.

same here

from craftconomy3.

Oh, never posted an answer here: The problem was a huge amount of broken database-entries mostly from converting to UUIDs in the past. I was unable to show database with common h2-tool but was able to restore entries into sql-commands in a textfile. After a lot of search and replace with Notepad++ and adding 425 UUIDs manually I fixed it by myself. Since then no new inconsistencies appeared so problem solved. Sad story for other people with this kind of error.

from craftconomy3.

Andorokai maybe there is a way to hack the h2 database and convert into a sql query?

from craftconomy3.

i got a different errors, now last dev "work" but it trow a error and don't convert...
http://hastebin.com/suyoninuyo.avrasm

from craftconomy3.

Table "ECO_SKYBLOCK_ACCOUNT" not found;

Corrupt database as in my case. Try fixing it with this tool: http://www.h2database.com/html/quickstart.html#h2_console
If it shows no tables you can test exporting it with build in rescue-tools. Sorry for late reply, forgot you o:-)

from craftconomy3.

is not corrupt, is a prefix issue, by using cc3_ work perfect, if i select other prefix it don't work

from craftconomy3.

Good to know

from craftconomy3.

is not good, i can set only 1 craftconomy istance in mysql :(

from craftconomy3.

Maybe if possible use a second table as a workaround.

from craftconomy3.

mmm i try
use default cc3, stop the converter, then rename the table to new name and in the config, might work ^^

from craftconomy3.

mmm got a different error if i use cc3_
this plugin is a mess, and data are imported from essetnials data years ago, i bet these null values are still here, @greatman please fix this
http://hastebin.com/haposufano.avrasm

from craftconomy3.