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

[espellcaste]

In 14100:

MySQL: fix an error when creating the invitations API tables.

MySQL 8+ introduced a change where it no longer accepts a string as the default value for the TEXT data type. A literal default needs to be specified as expression instead.

To avoid breaking back-compat, we will default the data type to NULL, similar to how we do it in similar schema deta types in BuddyPress.

Fixes #9261
See ​https://github.com/buddypress/wp-cli-buddypress/pull/113