The selected data provider crashed. JSON will be used instead.

[BenasPaulikas]

Issue description

• Expected result: What were you expecting to happen?
• Sucessful mysql connection and tables to be created
• Actual result: What actually happened?
• nothing happens. log above

Steps to reproduce the issue

1. ... Instal newest plugin version
2. ... Enable mysql in config

OS and versions

• Plugin Version: 2.12
• PocketMine-MP:4.4.0
• PHP:PHP 8.0.19 (cli) (built: May 13 2022 18:29:39) ( ZTS )
• Using JIT: no (delete as appropriate)
• Server OS: ubuntu 20.04
• Game version: Not the game issue.

Other Plugins

no other plugins.

• If you remove all other plugins, does the issue still occur?
• yes

Crashdump, backtrace or other files

[17:11:01.419] [Server thread/INFO]: Loading MyPlot v2.1.2
[17:11:01.427] [Server thread/DEBUG]: [MyPlot] Loading Configs
[17:11:01.428] [Server thread/DEBUG]: [MyPlot] Loading MyPlot Generator
[17:11:01.431] [Server thread/DEBUG]: [MyPlot] Loading Languages
[17:11:01.431] [Server thread/DEBUG]: [MyPlot] Loading Data Provider settings
[17:11:01.436] [Server thread/ERROR]: [MyPlot] The selected data provider crashed. JSON will be used instead.

[BenasPaulikas]

I also tried using following command in mysql directly

mysql> CREATE TABLE IF NOT EXISTS plotsV2 (level TEXT, X INT, Z INT, name TEXT, owner TEXT, helpers TEXT, denied TEXT, biome TEXT, pvp INT, price FLOAT, PRIMARY KEY (level, X, Z));

Result was

ERROR 1170 (42000): BLOB/TEXT column 'level' used in key specification without a key length

maybe related

[jasonw4331]

ah I didn't specify the max varchar length for the world name

[BenasPaulikas]

@jasonwynn10 yes. Is this fixable ? Could you also include more logging if next sql statement will throw error ? This way I won't need to manually execute statements.