/unpunish, /unnote, and /change-reason "cannot find the punishment/note"

[SiuanSong]

Re-creating this issue ticket

What version of AdvancedBan (/AdvancedBan) are you using?
2.3.0

What kind of server do you have (Bungeecord/single server)?
single server

What server version (/version) are you using?
Purpur 1.21.1 #2306

Please provide the EXACT steps required to reproduce the problem...
1. Attempt to unpunish, unnote, or change-reason
2. It cannot find punishment

Any error/log post it through pastebin.com and link it here. (Also include /plugins/AdvancedBan/logs/latest.log)
No errors what so ever in logs.

Add any additional information below.

New image to show that this is still indeed broken.

[Hopefuls]

Do you have some insights regarding your database size? Might help look into this further.

[Hopefuls]

I am unable to reproduce this on Version 2.3.0 using Spigot 1.21.1. Since you've mentioned using Purpur, I'll try to reproduce it there.

using ID-based management of punishments mostly relies on the database, that's why I've previously asked about your database size (if using mysql or hsqldb).

This server is running CraftBukkit version 4344-Spigot-a759b62-19bf846 (MC: 1.21.1) (Implementing API version 1.21.1-R0.1-SNAPSHOT)

[16:10:35] [Craft Scheduler Thread - 1/INFO]: Dev • Leoko
[16:10:35] [Craft Scheduler Thread - 1/INFO]: Status • Stable
[16:10:35] [Craft Scheduler Thread - 1/INFO]: Version • 2.3.0
[16:10:35] [Craft Scheduler Thread - 1/INFO]: License • Public
[16:10:35] [Craft Scheduler Thread - 1/INFO]: Storage • HSQLDB (local)
[16:10:35] [Craft Scheduler Thread - 1/INFO]: Server • Spigot/Bukkit
[16:10:35] [Craft Scheduler Thread - 1/INFO]: UUID-Mode • INTERN
[16:10:35] [Craft Scheduler Thread - 1/INFO]: Prefix • AdvancedBan »

[Hopefuls]

I am also unable to reproduce the issue you're experiencing with purpur, using the final version of 1.21.1 purpur

[16:20:04 INFO]: Current Purpur Version: 1.21.1-2329-803bf62 (MC: 1.21.1)*
You are running the latest version
Previous: 1.21.4-2412-9249a2c (MC: 1.21.4)

Could you further describe your usage? Such as what plugins may use AdvancedBan, further describing your setup, once again your database.

Thank you!

[SiuanSong]

Heyo, we are using MySQL and the size is at 7.37 MB. We've used this plugin continuously since 2017 so our database is 8 years old and has easily 30k rows of data.

[Hopefuls]

If you're able to take a look at the database, do you see any anomalies around the ban ids for example?

Like I said, couldn't really reproduce the issue you're facing.