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

[WordPress Trac]

#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:
--------------------------+------------------------------
Changes (by audrasjb):

 * version:  5.8.3 =>


Comment:

 Hello @jh20001 welcome to WordPress Core Trac and thank you for opening
 this ticket,

 Based on the error logs you shared, it looks like you have different types
 of collations in your database. I think it is not something you should
 have on a default and recent WordPress install.

 However, I’ll let WP DB component maintainers give a detailed answer on
 the issue and the related fix, and for now I'll just remove the `5.8.3`
 version as this wasn't introduced in the last version of WordPress.

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