MySQL: error when creating invitations API tables

[espellcaste]

It seems there is an issue when trying to install the Invitations API tables and the project uses mysql 8+ (I confirmed ​here with MySQL 8.4).

Here is the following error:

WordPress database error BLOB, TEXT, GEOMETRY or JSON column 'content' can't have a default value for query ALTER TABLE wp_bp_invitations ALTER COLUMN `content` SET DEFAULT '' made by

Specifically, this function bp_core_install_invitations. See code ​here.

After a bit of research, it seems that MySQL 8.0+ doesn't accept a string as the default value anymore.

See ​https://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql

See ​https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html#data-type-defaults-explicit