OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums Forums OroCommerce utf8mb4 modification on table oro_search_item and still errors in prod.log

This topic contains 2 replies, has 2 voices, and was last updated by  Tom Van Overbeke 1 year, 8 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
  • #37780

    Tom Van Overbeke


    When I found errors with high ascii characters in the oro_email table, I managed to correct the problem by changing the table to utf8mb4 collation.
    Recently, I noticed the same type of errors with the oro_search_item table. I changed the table the same way I did as with oro_email, but for this table, the problem persists.

    Is there anything else I can do to get rid of these errors? They come up every second almost:

    This is the config of the table:

    This is the offending error message:

    When I run show variables in mysql cli:

    and in config.yml I have:

    • This topic was modified 1 year, 9 months ago by Michael Michael. Reason: updated formatting for readability
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The forum ‘OroCommerce’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No