Using Mysql crash

[benda95280]

Issue description

• Expected result: What were you expecting to happen? Using MYSQL do not work
• Actual result: What actually happened? Switch to json

Steps to reproduce the issue

Set MYSQL Launch server

OS and versions

• Plugin Version:
• PocketMine-MP: 3.25.6
• PHP: 8
• Using JIT: no (delete as appropriate)
• Server OS: W10
• Game version: Win10 (delete as appropriate)

Other Plugins

Too much to list

• If you remove all other plugins, does the issue still occur? Yep
• If the issue is not reproducible without other plugins:
  • Have you asked for help in the community discord before creating an issue?
  • Can you provide sample, minimal reproducing code for the issue? If so, paste it in the bottom section.

Crashdump, backtrace or other files

[11:15:14] [Server thread/ERROR]: [MyPlot] The selected data provider crashed. JSON will be used instead.

Correction ?

MySQLProvider => L48 : Level cannot be index if using TEXT MySQLProvider => L52 : Level cannot be index if using TEXT MySQLProvider => In prepare() 'colon' should not be used

(VARCHAR 255 should be enought ?) (How about Name/ Owner / Helpers / Biome ... ?)

Could you add too :

• Include message in Exception inside function prepare()
• In Myplot.php L1387, add under : $this->getLogger()->error("Error: ".$e->getMessage());

[benda95280]

I've try to fix by Myself, and i've been able to create and join a plotWorld. But when i ran /p outside a plot, it's fine, but inside a plot, i've the error below :

[11:52:01] [Server thread/CRITICAL]: ErrorException: "Attempt to read property "helpers" on null" (EXCEPTION) in "plugins/MyPlot-master/src/MyPlot/forms/subforms/RemoveHelperForm" at line 21
[11:52:01] [Server thread/CRITICAL]: #0 plugins/MyPlot-master/src/MyPlot/forms/subforms/RemoveHelperForm(21): pocketmine\utils\Utils::errorExceptionHandler(integer 2, string[42] Attempt to read property "helpers" on null, string[107] C:\Users\Benjamin\Documents\PMMP-Rapto\plugins\MyPlot-master\src\MyPlot\forms\su, integer 21)
[11:52:01] [Server thread/CRITICAL]: #1 plugins/MyPlot-master/src/MyPlot/subcommand/RemoveHelperSubCommand(52): MyPlot\forms\subforms\RemoveHelperForm->__construct()
[11:52:01] [Server thread/CRITICAL]: #2 plugins/MyPlot-master/src/MyPlot/forms/MainForm(31): MyPlot\subcommand\RemoveHelperSubCommand->getForm(object pocketmine\Player)
[11:52:01] [Server thread/CRITICAL]: #3 plugins/MyPlot-master/src/MyPlot/Commands(205): MyPlot\forms\MainForm->__construct(object pocketmine\Player, array[25])
[11:52:01] [Server thread/CRITICAL]: #4 pmsrc/src/pocketmine/command/SimpleCommandMap(248): MyPlot\Commands->execute(object pocketmine\Player, string[1] p, array[1])
[11:52:01] [Server thread/CRITICAL]: #5 pmsrc/src/pocketmine/Server(1809): pocketmine\command\SimpleCommandMap->dispatch(object pocketmine\Player, string[1] p)
[11:52:01] [Server thread/CRITICAL]: #6 pmsrc/src/pocketmine/Player(2351): pocketmine\Server->dispatchCommand(object pocketmine\Player, string[1] p)
[11:52:01] [Server thread/CRITICAL]: #7 pmsrc/src/pocketmine/network/mcpe/PlayerNetworkSessionAdapter(239): pocketmine\Player->chat(string[2] /p)
[11:52:01] [Server thread/CRITICAL]: #8 pmsrc/src/pocketmine/network/mcpe/protocol/CommandRequestPacket(54): pocketmine\network\mcpe\PlayerNetworkSessionAdapter->handleCommandRequest(object pocketmine\network\mcpe\protocol\CommandRequestPacket)

[MonoAdrian23]

In PlotSquaredPM by Noteland, this Bug ist fixed