Results 1 to 6 of 6

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

  1. September 4th, 2019 #1
    apnardeal
    apnardeal is offline
    Thread Starter
    apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    82
    Thanks
    20
    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
    Reply With Quote Reply With Quote
  2. September 4th, 2019 #2
    ovidiubica
    ovidiubica is offline
    Moderator ovidiubica's Avatar
    Join Date
    Mar 2011
    Posts
    5,749
    Thanks
    240
    Thanked 1,062 Times in 1,000 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote

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

    apnardeal (September 12th, 2019)
  4. September 10th, 2019 #3
    apnardeal
    apnardeal is offline
    Thread Starter
    apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    82
    Thanks
    20
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  5. September 11th, 2019 #4
    ovidiubica
    ovidiubica is offline
    Moderator ovidiubica's Avatar
    Join Date
    Mar 2011
    Posts
    5,749
    Thanks
    240
    Thanked 1,062 Times in 1,000 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote

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

    apnardeal (September 12th, 2019)
  7. September 11th, 2019 #5
    apnardeal
    apnardeal is offline
    Thread Starter
    apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    82
    Thanks
    20
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  8. September 12th, 2019 #6
    apnardeal
    apnardeal is offline
    Thread Starter
    apnardeal's Avatar
    Join Date
    Mar 2013
    Location
    Canada
    Posts
    82
    Thanks
    20
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote

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

    ovidiubica (September 14th, 2019)
« Some alignments (CSS?) in the topright corner | Author page listing - How to change slider view to list view? »

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, 05:46 PM
  2. [SOLVED] Registration Error - Illegal characters?
    By talkwadstudios in forum Help Using Vantage (Legacy)
    Replies: 2
    Last Post: October 14th, 2014, 11:37 AM
  3. "Illegal string offset" Error
    By vawebsitesoutions in forum Vantage General Discussion (Legacy)
    Replies: 1
    Last Post: May 13th, 2014, 10:53 PM
  4. WordPress database error: [Query was empty]
    By luehning in forum Report ClassiPress Bugs
    Replies: 5
    Last Post: July 31st, 2011, 09: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, 03:19 PM