OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums Forums OroCommerce Email Synchronization failed on Orocommerce 1.5.0

This topic contains 4 replies, has 2 voices, and was last updated by  Rio 6 years, 3 months ago.

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

  • Creator
    Topic
  • #32528

    Rio
    Participant

    Hello Masters,

    I tried install orocommerce 1.5.0 and it’s work as well but when hit the sync emails
    the message queue got an error and the message is

    Here the error logs from php app/console oro:message-queue:consume –env=prod

    Does anybody ever face the issue, Please kindly give some an advice how to solve it :)

    Thanks in Advance

Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
    Replies
  • #32529

    mmiasnikov
    Participant

    Hello, Rio.

    What type of database do you use? Is it Postgres or MySQL?

    Anyway, probably there is a problem with encoding oro_email.subject column, that can’t manage with Unicode characters \ud83c \udf84. If you remove this characters from the subject of this letter – synchronization, probably, will be performed successfully.

    I’ll try to reproduce your case – probably there is a place for an improvement in Oro platform. Thank you for the question.

    #32530

    Rio
    Participant

    Hello mmiasnikov,

    Thanks for replying, actually I use mysql database. Could you give the following steps to resolve this issue?
    I also read on https://github.com/oroinc/crm/issues/291
    and the response said that there is a bug on related issue. Is that similiar with my issue ?

    #32531

    mmiasnikov
    Participant

    Hello, Rio.

    To solve your problem, please, change the encoding of your tables and columns from UTF8 to UTF8MB4. You can follow the guidance of the article How to support full Unicode in MySQL databases.

    Also, probably the article In MySQL, never use “utf8”. Use “utf8mb4” either will be interesting for you.

    #32532

    Rio
    Participant

    Hello mmiasnikov,

    I already upgrade mysql to 5.7.20, and I trying to follow the link https://oroinc.com/doc/orocrm/2.4/install-upgrade/installation-quick-start-dev/commerce-crm-ee In order to change utf8 into utf8mb4. I just put doctrine dbal code on my app/config/config.yml and did the migration but the result only the tables with the prefix acl_ are change into utf8mb4

    Should we set the charset and collate into utf8mb4 manually all tables ? :(

    Thanks In Advance

Viewing 4 replies - 1 through 4 (of 4 total)

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

Back to top