[wp-trac] [WordPress Trac] #54836: Huge error logs filled with "WordPress database error Illegal mix of collations" errors caused by spammers

WordPress Trac noreply at wordpress.org
Mon Aug 12 18:03:56 UTC 2024


#54836: Huge error logs filled with "WordPress database error Illegal mix of
collations" errors caused by spammers
--------------------------+------------------------------
 Reporter:  jh20001       |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:
 Severity:  critical      |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by drzraf):

 If it ends up cluttering the logs, then it's a problem and in this case,
 not a problem a webmaster/sysadmin is expected to resolve on its own since
 its due to a mismatch between unfiltered query-string input provided as-is
 to MySQL by WP core.

 The least WP could do is to provide a filter with a `preg_replace` /
 `mb_convert_encoding` logic so that characters passed down to `$wpdb` are
 compatible with the **current** MySQL charset/schema.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/54836#comment:8>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list