Results 1 to 6 of 6

Thread: WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT)

  1. #1
    Thread Starter
    Member apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    65
    Thanks
    17
    Thanked 1 Time in 1 Post

    WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT)

    Hi, I am getting below error log in the server from last couple of days. Kindly help why i am getting this error ?

    [04-Sep-2019 17:38:56 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_content_filtered LIKE '%হুমীীীজীবনেৃৃশেষসবচেয়েঊূূূাঊূূীূীূূূূীঊসূূূীূূূূ ূূূূূঊঊঊীীূীূঊঊঊঊ😁😁😁😁😁😎🥴😝😝😝👨*❤️*👨👨*❤️*👨%'))) AND (wp_posts.post_status = 'publish') AND (wp_posts.post_type IN ('ad_listing','post')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title LIKE '%হুমীীীজীবনেৃৃশেষসবচেয়েঊূূূাঊূূীূীূূূূীঊসূূূীূূূূ ূূূূূঊঊঊীীূীূঊঊঊঊ😁😁😁😁😁😎🥴😝😝😝👨*❤️*👨👨*❤️*👨%' DESC, wp_posts.post_date DESC LIMIT 0, 40 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts


    My WP version: Version 5.2.2
    ClassiPress v3.6.3
    PHP version: 7.2.18

  2. #2
    Moderator ovidiubica's Avatar
    Join Date
    Mar 2011
    Posts
    3,863
    Thanks
    100
    Thanked 658 Times in 623 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. The Following User Says Thank You to ovidiubica For This Useful Post:

    apnardeal (4 Weeks Ago)

  4. #3
    Thread Starter
    Member apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    65
    Thanks
    17
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #4
    Moderator ovidiubica's Avatar
    Join Date
    Mar 2011
    Posts
    3,863
    Thanks
    100
    Thanked 658 Times in 623 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. The Following User Says Thank You to ovidiubica For This Useful Post:

    apnardeal (4 Weeks Ago)

  7. #5
    Thread Starter
    Member apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    65
    Thanks
    17
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!

  8. #6
    Thread Starter
    Member apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    65
    Thanks
    17
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!

  9. The Following User Says Thank You to apnardeal For This Useful Post:

    ovidiubica (4 Weeks Ago)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error Wordpress database Table .wp_p2pmeta' doesn't exist
    By ncti in forum Help Using ClassiPress
    Replies: 18
    Last Post: August 1st, 2019, 04:46 PM
  2. [SOLVED] Registration Error - Illegal characters?
    By talkwadstudios in forum Help Using Vantage (Legacy)
    Replies: 2
    Last Post: October 14th, 2014, 10:37 AM
  3. "Illegal string offset" Error
    By vawebsitesoutions in forum Vantage General Discussion (Legacy)
    Replies: 1
    Last Post: May 13th, 2014, 09:53 PM
  4. WordPress database error: [Query was empty]
    By luehning in forum Report ClassiPress Bugs
    Replies: 5
    Last Post: July 31st, 2011, 08:48 AM
  5. ERROR: This username is invalid because it uses illegal characters.
    By rpedersen in forum Report ClassiPress Bugs
    Replies: 5
    Last Post: August 17th, 2010, 02:19 PM