MyPlot
MyPlot copied to clipboard
jasonw4331
Using Mysql crash
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());
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)
