search

Culley-Studios / ProQuests-Documentation

The most customizable and immersive quest plugin.
1 stars 2 forks source link

Row size too large #164

Closed valenvaio closed 6 years ago

valenvaio commented 6 years ago

ProQuest can not create any table. Config MySQL is default.

MariaDB >= 10.1.x Debian 9.2

[mysqld] innodb_large_prefix = ON innodb_file_format = Barracuda

Do you create tables with a parameter? ENGINE=InnoDB ROW_FORMAT=DYNAMIC CHARSET=utf8mb4

[23:13:26] [Server thread/INFO]: [ProQuests] Enabling ProQuests v2.0.7
[23:13:27] [Server thread/INFO]: [ProQuests] Running build #303725
[23:13:27] [Server thread/WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
[23:13:27] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
JCulley commented 6 years ago

I already explained your situation in the exact same other issue you already opened. In addition you are still not following the guidelines. If you open another issue regarding this you will be blocked from the repository.

valenvaio commented 6 years ago

https://www.spigotmc.org/members/solder.303725/

Can you provide a script that creates tables? Or the working config MySQL? Installed all the features in SQL but no tables are created. Without tables, i can not catch the reason. All the recommendations for this SQL problem are reduced to working with tables. But the plugin can not create them.