[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.