[BUG:] Crash MySQLBanList

[UnknownNull]

Bug: Crash

Informations

BetterBan Version: 4.2.2
Server-OS: Windows 2012 r2
PHP Version: 8.2
PocketMine-MP Version: 5.6.1

Error

[Console Error:]
2023-10-01 [06:19:26.203] [Server thread/EMERGENCY]: Crash occurred while handling a packet from session: 127.0.0.1 62267
2023-10-01 [06:19:26.213] [Server thread/CRITICAL]: mysqli_sql_exception: "Malformed packet" (2027) in "plugins/BetterBan_dev-104 (1).phar/src/supercrafter333/BetterBan/Permission/MySQLBanList" at line 76
--- Stack trace ---
#0 plugins/BetterBan_dev-104 (1).phar/src/supercrafter333/BetterBan/Permission/MySQLBanList(76): mysqli->ping()
#1 plugins/BetterBan_dev-104 (1).phar/src/supercrafter333/BetterBan/Permission/MySQLBanList(150): supercrafter333\BetterBan\Permission\MySQLBanList->reconnect()
#2 plugins/BetterBan_dev-104 (1).phar/src/supercrafter333/BetterBan/BetterBan(195): supercrafter333\BetterBan\Permission\MySQLBanList->isBanned(string[11] parham_king)
#3 plugins/BetterBan_dev-104 (1).phar/src/supercrafter333/BetterBan/EventListener(148): supercrafter333\BetterBan\BetterBan::isBanned(string[11] parham_king)
#4 pmsrc/src/event/RegisteredListener(61): supercrafter333\BetterBan\EventListener->onPreLogin(object pocketmine\event\player\PlayerPreLoginEvent#159782)
#5 pmsrc/src/event/Event(63): pocketmine\event\RegisteredListener->callEvent(object pocketmine\event\player\PlayerPreLoginEvent#159782)
#6 pmsrc/src/network/mcpe/handler/LoginPacketHandler(146): pocketmine\event\Event->call()
#7 pmsrc/vendor/arabskills/bedrock-protocol/src/LoginPacket(105): pocketmine\network\mcpe\handler\LoginPacketHandler->handleLogin(object pocketmine\network\mcpe\protocol\LoginPacket#185296)
#8 pmsrc/src/network/mcpe/NetworkSession(514): pocketmine\network\mcpe\protocol\LoginPacket->handle(object pocketmine\network\mcpe\handler\LoginPacketHandler#158784)
#9 pmsrc/src/network/mcpe/NetworkSession(452): pocketmine\network\mcpe\NetworkSession->handleDataPacket(object pocketmine\network\mcpe\protocol\LoginPacket#185296, string[596392] ....j..$....{"chain":["eyJ4NXUiOiJNSFl3RUFZSEtvWkl6ajBDQVFZRks0RUVBQ0lEWWdBRXVwX)
#10 pmsrc/src/network/mcpe/raklib/RakLibInterface(219): pocketmine\network\mcpe\NetworkSession->handleEncoded(string[26341] .....J.......|.o..O.....V..Q.j!H...C.z.J ..J..8.{...3...Z.............b....$..2)
#11 pmsrc/vendor/pocketmine/raklib-ipc/src/RakLibToUserThreadMessageReceiver(40): pocketmine\network\mcpe\raklib\RakLibInterface->onPacketReceive(int 0, string[26342] ......J.......|.o..O.....V..Q.j!H...C.z.J ..J..8.{...3...Z.............b....$..)
#12 pmsrc/src/network/mcpe/raklib/RakLibInterface(111): raklib\server\ipc\RakLibToUserThreadMessageReceiver->handle(object pocketmine\network\mcpe\raklib\RakLibInterface#157042)
#13 pmsrc/vendor/pocketmine/snooze/src/SleeperHandler(120): pocketmine\network\mcpe\raklib\RakLibInterface->pocketmine\network\mcpe\raklib{closure}()
#14 pmsrc/src/TimeTrackingSleeperHandler(58): pocketmine\snooze\SleeperHandler->processNotifications()
#15 pmsrc/vendor/pocketmine/snooze/src/SleeperHandler(79): pocketmine\TimeTrackingSleeperHandler->processNotifications()
#16 pmsrc/src/Server(1707): pocketmine\snooze\SleeperHandler->sleepUntil(float 1696141166.154)
#17 pmsrc/src/Server(1089): pocketmine\Server->tickProcessor()
#18 pmsrc/src/PocketMine(334): pocketmine\Server->__construct(object pocketmine\thread\ThreadSafeClassLoader#6, object pocketmine\utils\MainLogger#3, string[50] C:\Users\Administrator\Documents\MV - RL\5.Arcade, string[58] C:\Users\Administrator\Documents\MV - RL\5.Arcade\plugins)
#19 pmsrc/src/PocketMine(357): pocketmine\server()
#20 pmsrc(11): require(string[94] phar://C:/Users/Administrator/Documents/MV - RL/5.Arcade/PocketMine-MP.phar/src/)

[supercrafter333]

It will cost some time to work on this issue. I currently don't have so much time. But I'll work on it as soon as I have enough time again.

[xqwtxon]

Why not to use libasynql instead of using php native mysql library? Using this traditional method is may cause problems with queries specially when mysql connection is slow.