[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