Changeset 14100

Timestamp:

02/16/2025 04:13:47 PM (10 months ago)

Author:

espellcaste

Message:

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

File:

• trunk/src/bp-core/admin/bp-core-admin-schema.php (modified) (1 diff)

trunk/src/bp-core/admin/bp-core-admin-schema.php

@@ -576 +576 @@
         secondary_item_id bigint(20) DEFAULT NULL,
         type varchar(12) NOT NULL DEFAULT 'invite',
-        content longtext DEFAULT '',
+        content longtext DEFAULT NULL,
         date_modified datetime NOT NULL,
         invite_sent tinyint(1) NOT NULL DEFAULT '0',