Error when parsing JSON database value

  • Resolved richardb97

    (@richardb97)


    3 years, 2 months ago

    Our website was transferred to a new host (HostGator). Since the transfer, I get an error when accessing Mailpoet “Emails”, which are our newsletters. I can create a new newsletter, but after I save it, I still get the error when I return to the Mailpoet email tab. The host is running php 8.1 (I tried PHP 7.4, but still have the same issue).

    The error description is: Error when parsing JSON database value: “Control character error, possibly incorrectly encoded”.

    How do I get this corrected or what do I look for? Our newsletter and club emails have been rendered useless.

    Please help! Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Bruna a11n

    (@bruberries)

    3 years, 2 months ago

    Hi @richardb97,

    It seems that one of your newsletters may have been corrupted during migration, or the new host has different configurations that are preventing a newsletter from being properly rendered.

    If the Emails page loads as expected and you don’t have too many newsletters, one way to check which newsletter is the problematic one is:

    1 – Open each newsletter directly in the editor: /wp-admin/admin.php?page=mailpoet-newsletter-editor&id=1

    2 – Substitute 1 with actual newsletter IDs, starting from the latest to the earliest.

    The problematic one may display the same error in the editor.

    If the newsletter listing is not displaying at all, fixing it will require database access via a plugin such as WP phpMyAdmin. Either fix a character in the body, or, if the newsletter isn’t important, clear the whole body.

    Thread Starter richardb97

    (@richardb97)

    3 years, 2 months ago

    It appears that the database did get corrupted in some manner during the migration. I restored a backup of the database I made prior to the migration and that solved the problem.

    • This reply was modified 3 years, 2 months ago by richardb97.
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Error when parsing JSON database value’ is closed to new replies.

Tags