search

ScreamingSandals / BedWars

Simple BedWars minigame plugin for Spigot version 1.8.8 - 1.21.1
https://www.spigotmc.org/resources/bedwars.63714/
GNU Lesser General Public License v3.0
263 stars 94 forks source link

Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY #328

Closed MrKayfer-gg closed 3 years ago

MrKayfer-gg commented 3 years ago

Describe the bug

This error occurs each time you start the server, and sometimes there is an error that means an error loading player data from the database (The server does not display holograms)

P.S. Perhaps the problem is that I'm trying to use with the plugin Russian characters?

Server and plugin version

Spigot version: PaperSpigot 1.17 #46 BedWars version: 0.2.17

Installed plugins on server

BedWars 0.2.17 Multiverse-Core 4.2.2 ProtocolLib 4.7.0-SNAPSHOT-b521 SecuredNetwork 3.1 ViaBackwards 4.0.0 ViaRewind 2.0.0 ViaVersion 4.0.0 WorldEdit 7.2.6-SNAPSHOT+5842-43da91a WorldGuard 7.0.6-SNAPSHOT+2132-e88d8a5

Console log

[20:13:00] [main/INFO]: Environment: authHost='https://authserver.mojang.com', accountsHost='https://api.mojang.com', sessionHost='https://sessionserver.mojang.com', servicesHost='https://api.minecraftservices.com', name='PROD' [20:13:01] [main/INFO]: Reloading ResourceManager: Default, bukkit [20:13:02] [Worker-Main-7/INFO]: Loaded 7 recipes [20:13:03] [Server thread/INFO]: Starting minecraft server version 1.17 [20:13:03] [Server thread/INFO]: Loading properties [20:13:03] [Server thread/INFO]: This server is running Paper version git-Paper-46 (MC: 1.17) (Implementing API version 1.17-R0.1-SNAPSHOT) (Git: 9e07703) [20:13:04] [Server thread/INFO]: Debug logging is disabled [20:13:04] [Server thread/INFO]: Using 4 threads for Netty based IO [20:13:04] [Server thread/INFO]: Server Ping Player Sample Count: 0 [20:13:04] [Server thread/INFO]: Default game type: ADVENTURE [20:13:04] [Server thread/INFO]: Generating keypair [20:13:04] [Server thread/INFO]: Starting Minecraft server on 0.0.0.0:25451 [20:13:04] [Server thread/INFO]: Using epoll channel type [20:13:05] [Server thread/INFO]: [WorldEdit] Loading WorldEdit v7.2.6-SNAPSHOT+5842-43da91a [20:13:05] [Server thread/INFO]: Got request to register class com.sk89q.worldedit.bukkit.BukkitServerInterface with WorldEdit [com.sk89q.worldedit.extension.platform.PlatformManager@758d9e68] [20:13:05] [Server thread/INFO]: [ViaVersion] Loading ViaVersion v4.0.0 [20:13:05] [Server thread/INFO]: [ViaVersion] ViaVersion 4.0.0 is now loaded, injecting! [20:13:06] [Via-Mappingloader-0/INFO]: [ViaVersion] Loading 1.12 -> 1.13 mappings... [20:13:06] [Via-Mappingloader-1/INFO]: [ViaVersion] Loading 1.13 -> 1.13.2 mappings... [20:13:06] [Via-Mappingloader-2/INFO]: [ViaVersion] Loading 1.13.2 -> 1.14 mappings... [20:13:06] [Via-Mappingloader-3/INFO]: [ViaVersion] Loading 1.14 -> 1.15 mappings... [20:13:06] [Via-Mappingloader-4/INFO]: [ViaVersion] Loading 1.15 -> 1.16 mappings... [20:13:06] [Via-Mappingloader-5/INFO]: [ViaVersion] Loading 1.16 -> 1.16.2 mappings... [20:13:06] [Via-Mappingloader-6/INFO]: [ViaVersion] Loading 1.16.2 -> 1.17 mappings... [20:13:06] [Server thread/INFO]: [ViaBackwards] Loading ViaBackwards v4.0.0 [20:13:06] [Server thread/INFO]: [ViaBackwards] Loading translations... [20:13:06] [Via-Mappingloader-0/INFO]: [ViaVersion] Loading block connection mappings ... [20:13:06] [Via-Mappingloader-1/INFO]: [ViaBackwards] Loading 1.10 -> 1.9.4 mappings... [20:13:06] [Via-Mappingloader-3/INFO]: [ViaBackwards] Loading 1.11 -> 1.10 mappings... [20:13:06] [Via-Mappingloader-6/INFO]: [ViaBackwards] Loading 1.13.2 -> 1.13 mappings... [20:13:06] [Via-Mappingloader-6/INFO]: [ViaBackwards] Loading 1.14 -> 1.13.2 mappings... [20:13:06] [Via-Mappingloader-5/INFO]: [ViaBackwards] Loading 1.13 -> 1.12 mappings... [20:13:06] [Via-Mappingloader-5/INFO]: [ViaBackwards] Loading 1.15 -> 1.14 mappings... [20:13:06] [Via-Mappingloader-5/INFO]: [ViaBackwards] Loading 1.16 -> 1.15 mappings... [20:13:06] [Via-Mappingloader-6/INFO]: [ViaBackwards] Loading 1.16.2 -> 1.16 mappings... [20:13:06] [Via-Mappingloader-6/INFO]: [ViaBackwards] Loading 1.17 -> 1.16.2 mappings... [20:13:07] [Server thread/INFO]: [WorldGuard] Loading WorldGuard v7.0.6-SNAPSHOT+2132-e88d8a5 [20:13:07] [Server thread/INFO]: [Multiverse-Core] Loading Multiverse-Core v4.2.2-b812 [20:13:07] [Server thread/INFO]: [ProtocolLib] Loading ProtocolLib v4.7.0-SNAPSHOT-b521 [20:13:08] [Server thread/INFO]: [ViaRewind] Loading ViaRewind v2.0.0 [20:13:08] [Server thread/INFO]: [BedWars] Loading BedWars v0.2.17 [20:13:08] [Server thread/INFO]: [SecuredNetwork] Loading SecuredNetwork v3.1 [20:13:08] [Server thread/INFO]: Server permissions file permission.yml is empty, ignoring it [20:13:08] [Server thread/INFO]: [WorldEdit] Enabling WorldEdit v7.2.6-SNAPSHOT+5842-43da91a [20:13:08] [Server thread/INFO]: Registering commands with com.sk89q.worldedit.bukkit.BukkitServerInterface [20:13:08] [Server thread/INFO]: WEPIF: Using the Bukkit Permissions API. [20:13:08] [Server thread/INFO]: Using com.sk89q.worldedit.bukkit.adapter.impl.Spigot_v1_17_R1 as the Bukkit adapter [20:13:10] [Server thread/INFO]: [ProtocolLib] Enabling ProtocolLib v4.7.0-SNAPSHOT-b521 [20:13:10] [Server thread/INFO]: [ProtocolLib] Started structure compiler thread. [20:13:10] [Server thread/INFO]: [ViaRewind] Enabling ViaRewind v2.0.0 [20:13:10] [Server thread/WARN]: **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE! [20:13:10] [Server thread/WARN]: The server will make no attempt to authenticate usernames. Beware. [20:13:10] [Server thread/WARN]: Whilst this makes it possible to use BungeeCord, unless access to your server is properly restricted, it also opens up the ability for hackers to connect with any username they choose. [20:13:10] [Server thread/WARN]: Please see http://www.spigotmc.org/wiki/firewall-guide/ for further information. [20:13:10] [Server thread/WARN]: To change this, set "online-mode" to "true" in the server.properties file. [20:13:10] [Server thread/INFO]: Preparing level "world" [20:13:10] [Server thread/INFO]: Preparing start region for dimension minecraft:overworld [20:13:12] [Worker-Main-3/INFO]: Preparing spawn area: 0% [20:13:12] [Worker-Main-7/INFO]: Preparing spawn area: 0% [20:13:12] [Worker-Main-6/INFO]: Preparing spawn area: 0% [20:13:12] [Worker-Main-3/INFO]: Preparing spawn area: 0% [20:13:12] [Worker-Main-5/INFO]: Preparing spawn area: 0% [20:13:13] [Server thread/INFO]: Time elapsed: 2268 ms [20:13:13] [Server thread/INFO]: [ViaVersion] Enabling ViaVersion v4.0.0 [20:13:13] [Server thread/INFO]: [ViaBackwards] Enabling ViaBackwards v4.0.0 [20:13:13] [Server thread/INFO]: [WorldGuard] Enabling WorldGuard v7.0.6-SNAPSHOT+2132-e88d8a5 [20:13:13] [Server thread/INFO]: [WorldGuard] (world) TNT ignition is PERMITTED. [20:13:13] [Server thread/INFO]: [WorldGuard] (world) Lighters are PERMITTED. [20:13:13] [Server thread/INFO]: [WorldGuard] (world) Lava fire is PERMITTED. [20:13:13] [Server thread/INFO]: [WorldGuard] (world) Fire spread is UNRESTRICTED. [20:13:13] [Server thread/INFO]: [WorldGuard] Loaded configuration for world 'world' [20:13:13] [Server thread/INFO]: [WorldGuard] Loading region data... [20:13:13] [Server thread/INFO]: [Multiverse-Core] Enabling Multiverse-Core v4.2.2-b812 [20:13:13] [Server thread/WARN]: [Multiverse-Core] "Multiverse-Core v4.2.2-b812" has registered a listener for org.bukkit.event.entity.EntityCreatePortalEvent on method "public void com.onarandombox.MultiverseCore.listeners.MVPortalListener.entityPortalCreate(org.bukkit.event.entity.EntityCreatePortalEvent)", but the event is Deprecated. "Server performance will be affected"; please notify the authors [dumptruckman, Rigby, fernferret, lithium3141, main--]. [20:13:13] [Server thread/INFO]: [Multiverse-Core] We are aware of the warning about the deprecated event. There is no alternative that allows us to do what we need to do and performance impact is negligible. It is safe to ignore. [20:13:13] [Server thread/INFO]: Preparing start region for dimension minecraft:mine [20:13:16] [Worker-Main-6/INFO]: Preparing spawn area: 0% [20:13:16] [Worker-Main-8/INFO]: Preparing spawn area: 0% [20:13:16] [Worker-Main-1/INFO]: Preparing spawn area: 0% [20:13:16] [Worker-Main-4/INFO]: Preparing spawn area: 0% [20:13:16] [Worker-Main-7/INFO]: Preparing spawn area: 0% [20:13:16] [Worker-Main-6/INFO]: Preparing spawn area: 0% [20:13:16] [Worker-Main-6/INFO]: Preparing spawn area: 0% [20:13:16] [Server thread/INFO]: Time elapsed: 3051 ms [20:13:16] [Server thread/INFO]: [WorldGuard] (mine) TNT ignition is PERMITTED. [20:13:16] [Server thread/INFO]: [WorldGuard] (mine) Lighters are PERMITTED. [20:13:16] [Server thread/INFO]: [WorldGuard] (mine) Lava fire is PERMITTED. [20:13:16] [Server thread/INFO]: [WorldGuard] (mine) Fire spread is UNRESTRICTED. [20:13:16] [Server thread/INFO]: [WorldGuard] Loaded configuration for world 'mine' [20:13:16] [Server thread/INFO]: [Multiverse-Core] 2 - World(s) loaded. [20:13:16] [Server thread/WARN]: [Multiverse-Core] Buscript failed to load! The script command will be disabled! [20:13:16] [Server thread/INFO]: [Multiverse-Core] Version 4.2.2-b812 (API v24) Enabled - By dumptruckman, Rigby, fernferret, lithium3141 and main-- [20:13:16] [Server thread/INFO]: [BedWars] Enabling BedWars v0.2.17 [20:13:16] [Server thread/INFO]: [BedWars] Successfully loaded messages for BedWars! Language: Russian [20:13:16] [Server thread/INFO]: [BedWars] Loading statistics from database ... [20:13:16] [Server thread/INFO]: [org.screamingsandals.bedwars.lib.HikariCP.hikari.HikariDataSource] HikariPool-1 - Starting... [20:13:17] [Server thread/INFO]: [org.screamingsandals.bedwars.lib.HikariCP.hikari.HikariDataSource] HikariPool-1 - Start completed. [20:13:17] [Server thread/WARN]: java.sql.SQLException: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY. [20:13:17] [Server thread/WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) [20:13:17] [Server thread/WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [20:13:17] [Server thread/WARN]: at com.mysql.cj.jdbc.result.ResultSetImpl.first(ResultSetImpl.java:603) [20:13:17] [Server thread/WARN]: at org.screamingsandals.bedwars.lib.HikariCP.hikari.pool.HikariProxyResultSet.first(HikariProxyResultSet.java) [20:13:17] [Server thread/WARN]: at org.screamingsandals.bedwars.statistics.PlayerStatisticManager.initializeLeaderboard(PlayerStatisticManager.java:87) [20:13:17] [Server thread/WARN]: at org.screamingsandals.bedwars.statistics.PlayerStatisticManager.initialize(PlayerStatisticManager.java:53) [20:13:17] [Server thread/WARN]: at org.screamingsandals.bedwars.Main.onEnable(Main.java:380) [20:13:17] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:263) [20:13:17] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:370) [20:13:17] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:500) [20:13:17] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_17_R1.CraftServer.enablePlugin(CraftServer.java:518) [20:13:17] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_17_R1.CraftServer.enablePlugins(CraftServer.java:432) [20:13:17] [Server thread/WARN]: at net.minecraft.server.MinecraftServer.loadWorld(MinecraftServer.java:643) [20:13:17] [Server thread/WARN]: at net.minecraft.server.dedicated.DedicatedServer.init(DedicatedServer.java:304) [20:13:17] [Server thread/WARN]: at net.minecraft.server.MinecraftServer.x(MinecraftServer.java:1118) [20:13:17] [Server thread/WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:320) [20:13:17] [Server thread/WARN]: at java.base/java.lang.Thread.run(Thread.java:831) [20:13:17] [Server thread/INFO]: ===================== by ScreamingSandals <Misat11, Iamceph, Pronze> [20:13:17] [Server thread/INFO]: + Screaming BedWars + Version: 0.2.17 FREE [20:13:17] [Server thread/INFO]: ===================== STABLE VERSION [20:13:17] [Server thread/INFO]: [BW] Arena Mine loaded! [20:13:17] [Server thread/INFO]: Everything is loaded! If you like our work, consider visiting our Patreon! <3

[20:13:17] [Server thread/INFO]: [SecuredNetwork] Enabling SecuredNetwork v3.1 [20:13:17] [Server thread/INFO]: [SecuredNetwork] Thank you for downloading SecuredNetwork! [20:13:17] [Server thread/INFO]: Running delayed init tasks [20:13:17] [Server thread/INFO]: [ViaVersion] ViaVersion detected server version: 1.17 (755) [20:13:17] [Server thread/INFO]: [ViaVersion] Finished mapping loading, shutting down loader executor!

[20:13:17] [Server thread/INFO]: Timings Reset

Configuration (of config.yml and shop.yml)

config.yml

locale: custom debug: false allow-crafting: false keep-inventory-on-death: false in-lobby-colored-leather-by-team: true jointeam-entity-show-name: true friendlyfire: false player-drops: true join-randomly-after-lobby-timeout: false prevent-killing-villagers: true compass-enabled: true join-randomly-on-lobby-join: false add-wool-to-inventory-on-join: true prevent-spawning-mobs: true spawner-holograms: true spawner-disable-merge: true prevent-lobby-spawn-mobs-in-radius: 16 spawner-holo-height: 0.25 spawner-holograms-countdown: true damage-when-player-is-not-in-arena: false remove-unused-target-blocks: true allow-block-falling: true game-start-items: false player-respawn-items: false gived-game-start-items: [] gived-player-respawn-items: [] disable-hunger: false automatic-coloring-in-shop: true sell-max-64-per-click-in-shop: true destroy-placed-blocks-by-explosion-except: [] destroy-placed-blocks-by-explosion: true holo-above-bed: true allow-spectator-join: false disable-server-message: player-join: false player-leave: false disable-flight: true respawn-cooldown: enabled: true time: 5 stop-team-spawners-on-die: false allow-fake-death: false allowed-commands: [] change-allowed-commands-to-blacklist: false bungee: enabled: true serverRestart: false serverStop: false server: bedwars-lobby auto-game-connect: true kick-when-proxy-too-slow: true motd: enabled: false waiting: '%name%: Waiting for players [%current%/%max%]' waiting_full: '%name%: Game is full [%current%/%max%]' running: '%name%: Game is running [%current%/%max%]' rebuilding: '%name%: Rebuilding...' disabled: '%name%: Game is disabled' farmBlocks: enable: false blocks: [] scoreboard: enable: true title: §a%game%§r - %time% bedLost: §c✘ anchorEmpty: §e✘ bedExists: §a✔ teamTitle: '%bed%%color%%team%' title: enabled: true fadeIn: 0 stay: 20 fadeOut: 0 shop: rows: 4 render-actual-rows: 6 render-offset: 9 render-header-start: 0 render-footer-start: 45 items-on-row: 9 show-page-numbers: true inventory-type: CHEST citizens-enabled: false items: jointeam: COMPASS leavegame: SLIME_BALL startgame: DIAMOND shopback: BARRIER shopcosmetic: GRAY_STAINED_GLASS_PANE pageback: ARROW pageforward: ARROW team-select: WHITE_WOOL vault: enable: true reward: kill: 5 win: 20 final-kill: 5 bed-destroy: 0 resources: gold: material: GOLD_INGOT color: GOLD name: Золото interval: 20 translate: resource_gold spread: 1.0 iron: material: IRON_INGOT color: GRAY name: Железо interval: 10 translate: resource_iron spread: 1.0 bronze: material: COPPER_INGOT color: DARK_RED name: Медь interval: 1 translate: resource_bronze spread: 1.0 respawn: protection-enabled: true protection-time: 2 specials: action-bar-messages: true rescue-platform: is-breakable: false delay: 0 break-time: 10 distance: 1 material: GLASS protection-wall: is-breakable: false delay: 20 break-time: 0 width: 5 height: 3 distance: 2 material: CUT_SANDSTONE tnt-sheep: speed: 0.25 follow-range: 10.0 max-target-distance: 32 explosion-time: 8 arrow-blocker: protection-time: 10 delay: 5 warp-powder: teleport-time: 6 delay: 0 magnet-shoes: probability: 75 golem: speed: 0.25 follow-range: 10 health: 20 name-format: '%teamcolor%%team% Golem' show-name: true delay: 0 collidable: false teamchest: turn-all-enderchests-to-teamchests: true throwable-fireball: explosion: 3.0 damage: 2.0 auto-igniteable-tnt: explosion-time: 8 damage-placer: true sounds: bed_destroyed: sound: ENTITY_ENDER_DRAGON_GROWL volume: 1 pitch: 1 my_bed_destroyed: sound: ENTITY_ENDER_DRAGON_GROWL volume: 1 pitch: 1 countdown: sound: UI_BUTTON_CLICK volume: 1 pitch: 1 game_start: sound: ENTITY_PLAYER_LEVELUP volume: 1 pitch: 1 team_kill: sound: ENTITY_PLAYER_LEVELUP volume: 1 pitch: 1 player_kill: sound: ENTITY_PLAYER_BIG_FALL volume: 1 pitch: 1 item_buy: sound: ENTITY_ITEM_PICKUP volume: 1 pitch: 1 upgrade_buy: sound: ENTITY_EXPERIENCE_ORB_PICKUP volume: 1 pitch: 1 respawn_cooldown_wait: sound: UI_BUTTON_CLICK volume: 1 pitch: 1 respawn_cooldown_done: sound: ENTITY_PLAYER_LEVELUP volume: 1 pitch: 1 game-effects: end: effects:

shop.yml

data:

- stack:

type: GOLDEN_APPLE

amount: 1

meta:

==: ItemMeta

meta-type: UNSPECIFIC

display-name: "Example category"

lore:

- "This is my category!"

- "Please buy things inside!"

items:

- price: 50

price-type: "bronze"

stack:

type: DIAMOND_SWORD

amount: 1

meta:

==: ItemMeta

meta-type: UNSPECIFIC

enchants:

DAMAGE_ALL: 2

repair-cost: 1

Damage: 99

Value 'applycolorbyteam' is used for automatic-coloring-in-shop.

See WarpPowder for more info.

iamceph commented 3 years ago

Update to latest version.