ssossossossosso

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 2 weeks, 6 days ago.

  • Creator
    Topic
  • #33329

    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
  • #33337

    mmiasnikov
    Moderator

    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.

    #33342

    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 ?

    #33348

    mmiasnikov
    Moderator

    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.

    #33457

    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)

You must be logged in to reply to this topic.