Making WordPress.org

Opened 8 months ago

Last modified 5 weeks ago

#5756 new defect

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

Reported by: bradparbs Owned by:
Milestone: Priority: normal
Component: Profiles Keywords:
Cc:

Description

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.

Attachments (5)

Screen Shot 2021-05-28 at 8.48.45 AM.png (37.9 KB) - added by bradparbs 8 months ago.
Posted topic
Screen Shot 2021-05-28 at 8.49.03 AM.png (14.5 KB) - added by bradparbs 8 months ago.
Activity log not showing entry
Screen Shot 2021-05-28 at 8.49.35 AM.png (16.5 KB) - added by bradparbs 8 months ago.
Replies with the content being emoji work fine
Screen Shot 2021-05-28 at 8.49.39 AM.png (38.8 KB) - added by bradparbs 8 months ago.
Replies with the content being emoji work fine
Screen Shot 2021-05-28 at 10.02.16 AM.png (32.8 KB) - added by bradparbs 8 months ago.

Download all attachments as: .zip

Change History (7)

@bradparbs
8 months ago

Activity log not showing entry

@bradparbs
8 months ago

Replies with the content being emoji work fine

@bradparbs
8 months ago

Replies with the content being emoji work fine

#1 @bradparbs
8 months ago

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.

Last edited 8 months ago by bradparbs (previous) (diff)

#2 @dd32
5 weeks ago

  • Component changed from Plugin Directory to Profiles

-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..

Note: See TracTickets for help on using tickets.