Activity log is not populated when a topic title consists of only emoji

[bradparbs]

Probably an edge case, but still.

Topics/Review consisting of only emoji in title does not show in the activity log.

This topic ​https://wordpress.org/support/topic/%f0%9f%8c%8a%ef%b8%8f%f0%9f%8c%8a%ef%b8%8f%f0%9f%8f%84%ef%b8%8f%f0%9f%8c%8a%ef%b8%8f/ does not show in ​https://profiles.wordpress.org/surfboards/

Replies consisting of only emoji do correctly show in the activity log, though.

[bradparbs]

Posted topic

[bradparbs]

Activity log not showing entry

[bradparbs]

Replies with the content being emoji work fine

[bradparbs]

Replies with the content being emoji work fine

[bradparbs]

Thinking about this some more and tweeting with @johnjamesjacoby this might actually be an issue for non-latin characters, because the plugin repo does reject plugins with slugs that contain those, although Cyrillic characters do seem to show correctly.

[dd32]

-1 Unable to save activity

Looks like this is caused by WPDB rejecting the DB Insert via wpdb->strip_invalid_text_from_query:

WPOrg_Profiles_Activity_Handler->handle_forum_activity, bp_activity_add, BP_Activity_Activity->save, hyperdb->query, wpdb->strip_invalid_text_from_query, wpdb->get_table_charset, wpdb->get_results, hyperdb->query

The fields in this case are CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci and the connection should be utf8mb4, so I'm not quite sure what the issue is.. unless it needs to be upgraded to utf8mb4_unicode_520_ci..