Mailpoet broken after DB migration to utf8mb4

  • Resolved Palijn

    (@palijn)


    1 year, 10 months ago

    Hello,
    I’ve migrated my db to utf8mb4 after having discovered that the default mysql/mariadb “utf8” was indeed NOT UTF-8 . The broken “utf8” implementation resulted in all posts emojis not stored in db, hence not displayed correctly.
    The migration was done using WP’s own maybe_convert_table_to_utf8mb4() using this code snippet.

    Mailpoet does not seem to be happy with the result.


    When I want to display Forms, I get :

    The application Unknown application/component encountered an error
    Please report the following error to MailPoet support
    TypeError: Cannot read properties of undefined (reading 'filter')
    File name: No fileName reported
    Stack trace: TypeError: Cannot read properties of undefined (reading 'filter')
    at Object.onRenderItem (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/admin.js?ver=4.5.2:2:276919)
    at Object.onRenderItem (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:417735)
    at I.render (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:406778)
    at ja (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1408903)
    at Ra (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1408702)
    at js (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1449461)
    at xl (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1435679)
    at bl (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1435607)
    at wl (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1435470)
    at fl (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1432457)

    When I want to display Settings, the page is blank.

    The Subscriptions page throws this error :
    TypeError: Cannot read properties of undefined (reading 'forEach')
    File name: No fileName reported
    Stack trace: TypeError: Cannot read properties of undefined (reading 'forEach')
    at https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/admin.js?ver=4.5.2:2:34153
    at https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/admin.js?ver=4.5.2:2:34188
    at Array.forEach ()
    at Object.onRenderItem (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/admin.js?ver=4.5.2:2:34086)
    at Object.onRenderItem (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:417735)
    at I.render (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:406778)
    at ja (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1408903)
    at Ra (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1408702)
    at js (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1449461)
    at xl (https://ethiqueetchiens.fr/wp-content/plugins/mailpoet/assets/dist/js/commons.js?ver=4.5.2:9:1435679)

    And in my Emails, all my accented “é,à” letters are now “?”

    Do you have any suggestion on how to fix this ?

    Thanks a lot for your assistance !

Viewing 1 replies (of 1 total)
  • Thread Starter Palijn

    (@palijn)

    Hello,

    please forget about the above. I cleaned up a lot of mess and now I’m still encountering errors, but I will create a new, cleaner topic for this.

    Apologies for the time you spent.

Viewing 1 replies (of 1 total)
  • The topic ‘Mailpoet broken after DB migration to utf8mb4’ is closed to new replies.