Illegal mix of collations Database Error

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author BuddyBoss

    (@buddyboss)

    Hi mrjarbenne

    Can you please follow this steps to solve the issue:
    1. Use phpMyAdmin to edit the database
    2. ***Make sure that you have a backup of your database***
    3. Go to the table that is in different collation and click on its name.
    4. Go to “Alter table”
    5. Change the table and/or cells collation to utf8mb4 collate.
    6. Save

    BuddyPress tables also need to be updated with utf8mb4 for emoji support
    You can also take a look of this
    https://make.www.ads-software.com/core/2015/04/02/the-utf8mb4-upgrade/
    https://buddypress.trac.www.ads-software.com/ticket/6346

    Thread Starter mrjarbenne

    (@mrjarbenne)

    Because of the size and number of tables in my DB, I won’t be able to load them in the browser using phpmyadmin or adminer.

    Since BuddyPress DB tables do not support uf8mb4, I would think that the search plugin should not assume that BP’s tables supports utf8mb4.

    It’s been suggested to me that I could try using wp_encode_emoji() on the BP activity search string before using the content in a search, but I don’t have the chops to hack the plugin.

    Thanks

    Plugin Author BuddyBoss

    (@buddyboss)

    We have notified developers, it will be fixed in our coming updates.
    Support for uf8mb4 should be available inside BuddyPress 2.6

    Thread Starter mrjarbenne

    (@mrjarbenne)

    That’s awesome. Thanks so much for the support.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Illegal mix of collations Database Error’ is closed to new replies.