[BUG] Error connecting to the database

[m0baer]

Describe the bug
Me again, I'm sorry ;) I have problem with the database connection at the moment. During the week the parkours of the server stopped working. While debugging I found out that the sqlite data seems to be okay, I can easily read a copied version of the db. Permissions of the file haven't changed, there seems to be another problem. Something with MaterialData? Is this just my setup?

To Reproduce
Unsure, at one time in the week parkour stopped working

Expected behavior
It should run forever ;)

Screenshots
No Screenshot, but console output:

19:37:54
[HubParkour]: There has been an error connecting to the database. The plugin will now be disabled.  Stack Trace:
Console19:37:54
java.lang.ClassCastException: class org.bukkit.material.MaterialData cannot be cast to class org.bukkit.material.Sign (org.bukkit.material.MaterialData and org.bukkit.material.Sign are in unnamed module of loader java.net.URLClassLoader @5a10411)
	at HubParkour-2.8.1.jar/me.block2block.hubparkour.managers.DatabaseManager.loadSigns(DatabaseManager.java:649) ~[HubParkour-2.8.1.jar:?]
	at HubParkour-2.8.1.jar/me.block2block.hubparkour.managers.DatabaseManager.load(DatabaseManager.java:68) ~[HubParkour-2.8.1.jar:?]
	at HubParkour-2.8.1.jar/me.block2block.hubparkour.HubParkour.onEnable(HubParkour.java:223) ~[HubParkour-2.8.1.jar:?]
	at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:284) ~[paper-api-1.21.4-R0.1-SNAPSHOT.jar:?]
	at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:202) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:109) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:520) ~[paper-api-1.21.4-R0.1-SNAPSHOT.jar:?]
	at org.bukkit.craftbukkit.CraftServer.enablePlugin(CraftServer.java:656) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:605) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:743) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:488) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:322) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1163) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at net.minecraft.server.MinecraftServer.lambda$spin$2(MinecraftServer.java:310) ~[paper-1.21.4.jar:1.21.4-138-5395ae3]
	at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]
INFO19:37:54
[HubParkour]: Disabling HubParkour v2.8.1

Environment (please complete the following information):
Server Version: Paper version 1.21.4-138-main@5395ae3
Plugin Version: 2.8.1
Server Software PaperSpigot
Other Plugins Installed: AdvancedRegionMarket (3.5.3), AutoUpdateGeyser (5.5), BlueMap (3.20), Geyser-Spigot (2.6.0-SNAPSHOT), HubParkour (2.8.1), LuckPerms (5.4.131), PlaceholderAPI (2.11.6), RegionTeleport (3.2.0), Shopkeepers (2.23.3), Vault (1.7.3-b131), WorldEdit (7.3.10-beta-01+cb9fd58), WorldGuard (7.0.13-beta-2+5c4848b), floodgate (2.2.3-SNAPSHOT (b114-83fbd6e)), voicechat (2.5.27)

Additional context
It may be my setup/the other mods, but I do not understand the error pointing to the database. All other mods seem to be running without a problem.

[0x7d8]

similar issue,

[08:39:46 ERROR]: [HubParkour] One of your parkours has a material that is not valid. We have defaulted the value to a Slime Ball. Please change this using edit mode. Stack trace:
java.lang.IllegalArgumentException: No enum constant org.bukkit.Material.0
        at java.base/java.lang.Enum.valueOf(Enum.java:293) ~[?:?]
        at org.bukkit.Material.valueOf(Material.java:138) ~[purpur-api-1.21.4-R0.1-SNAPSHOT.jar:?]
        at HubParkour-2.8.1.jar/me.block2block.hubparkour.managers.DatabaseManager.loadParkours(DatabaseManager.java:554) ~[HubParkour-2.8.1.jar:?]
        at HubParkour-2.8.1.jar/me.block2block.hubparkour.managers.DatabaseManager.load(DatabaseManager.java:66) ~[HubParkour-2.8.1.jar:?]
        at HubParkour-2.8.1.jar/me.block2block.hubparkour.HubParkour.onEnable(HubParkour.java:223) ~[HubParkour-2.8.1.jar:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:280) ~[purpur-api-1.21.4-R0.1-SNAPSHOT.jar:?]
        at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:202) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:109) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:520) ~[purpur-api-1.21.4-R0.1-SNAPSHOT.jar:?]
        at org.bukkit.craftbukkit.CraftServer.enablePlugin(CraftServer.java:671) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:620) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:746) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:491) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:365) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1178) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.lambda$spin$2(MinecraftServer.java:313) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]
[08:39:46 ERROR]: [HubParkour] There has been an error connecting to the database. The plugin will now be disabled.  Stack Trace:
java.lang.NumberFormatException: For input string: "SLIME_BALL"
        at java.base/jdk.internal.math.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2054) ~[?:?]
        at java.base/jdk.internal.math.FloatingDecimal.parseDouble(FloatingDecimal.java:110) ~[?:?]
        at java.base/java.lang.Double.parseDouble(Double.java:792) ~[?:?]
        at com.mysql.cj.protocol.a.MysqlTextValueDecoder.getDouble(MysqlTextValueDecoder.java:258) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at com.mysql.cj.result.AbstractNumericValueFactory.createFromBytes(AbstractNumericValueFactory.java:47) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:151) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:127) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:235) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:122) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1301) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at com.mysql.cj.jdbc.result.ResultSetImpl.getShort(ResultSetImpl.java:889) ~[mysql-connector-j-9.1.0.jar:9.1.0]
        at HubParkour-2.8.1.jar/org.apache.commons.dbcp2.DelegatingResultSet.getShort(DelegatingResultSet.java:843) ~[HubParkour-2.8.1.jar:?]
        at HubParkour-2.8.1.jar/org.apache.commons.dbcp2.DelegatingResultSet.getShort(DelegatingResultSet.java:843) ~[HubParkour-2.8.1.jar:?]
        at HubParkour-2.8.1.jar/me.block2block.hubparkour.managers.DatabaseManager.loadParkours(DatabaseManager.java:559) ~[HubParkour-2.8.1.jar:?]
        at HubParkour-2.8.1.jar/me.block2block.hubparkour.managers.DatabaseManager.load(DatabaseManager.java:66) ~[HubParkour-2.8.1.jar:?]
        at HubParkour-2.8.1.jar/me.block2block.hubparkour.HubParkour.onEnable(HubParkour.java:223) ~[HubParkour-2.8.1.jar:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:280) ~[purpur-api-1.21.4-R0.1-SNAPSHOT.jar:?]
        at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:202) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at io.papermc.paper.plugin.manager.PaperPluginManagerImpl.enablePlugin(PaperPluginManagerImpl.java:109) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:520) ~[purpur-api-1.21.4-R0.1-SNAPSHOT.jar:?]
        at org.bukkit.craftbukkit.CraftServer.enablePlugin(CraftServer.java:671) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:620) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.loadWorld0(MinecraftServer.java:746) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.loadLevel(MinecraftServer.java:491) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.dedicated.DedicatedServer.initServer(DedicatedServer.java:365) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1178) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at net.minecraft.server.MinecraftServer.lambda$spin$2(MinecraftServer.java:313) ~[purpur-1.21.4.jar:1.21.4-2398-196c176]
        at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]

[Block2Block]

Thanks @m0baer for reporting this issue! I will take a look into it.

@0x7d8 Your issue is unrelated and seems to be an issue with your configured item. You will need to do as the error instructs and edit this using edit mode.

[Block2Block]

@0x7d8 Taking a second look there does indeed seem to be an issue, can you send me what your table looks like in MySQL/phpMyAdmin?

[Block2Block]

@0x7d8 I have isolated your issue and will be coming in the upcoming 2.8.2 update.