Error in the Emails Database

  • Resolved Chris

    (@munch40)


    2 years, 11 months ago

    Hi Team,

    Background: Recently we had an issue with some Malware on the site which we dealt with, however, we had to perform a data restoration.

    Issue: In MailPoet when viewing emails, the following error displays and you can’t see the emails as MailPoet throws the following error:

    An exception occurred while executing ‘SELECT DISTINCT r0_.raw_message AS raw_message_0 FROM RNLdBMEK2x_mailpoet_log r0_ WHERE r0_.name = ? AND r0_.context LIKE ? ORDER BY r0_.created_at ASC’ with params [“coupons”, “{\”newsletter_id\”:640}”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘r0_.raw_message’ in ‘field list’

    Any insight or assistance would be greatly appreciated.

    TIA

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

    (@munch40)

    2 years, 11 months ago

    After doing some searching, I found a solution that resolved my issue.

    Note ** If you’re not comfortable working in phpMyadmin, then I suggest reaching out to someone who can assist you who knows their way around phpMyadmin.

    Here’s what we did

    It requires you going into control panel or equivalent of your web hosting.

    Go to phpMYadmin > select the database for your WordPress installation in the left hand pane of the page.

    Open the database table and expand it so you can see all the tables in a hierarchical tree branch.

    Locate the table ‘mailpoet_migrations’. One click and select the table.

    In the right hand pane of the page you should have displayed all the entries.

    Locate the entry where the last migration date was performed and delete the entry.

    Disable the MailPoet plugin and re-enable it. (If you have MailPoet Pro I would also do the same, disable and re-enable)

    This should perform the migration again.

    Go to MailPoet, check to see if the functionality has returned and is working. In my case I now see the MailPoet >Email >Post Notifications.

    Note! For us… After deleting several entries it still didn’t fix the problem, however, when we deleted ‘all’ the entries it worked. This was probably due to me thinking that the date I had chosen was the correct date whereas Mailpoet plugin had been updated several versions beforehand.

    Due to having a backup, we took the risk and deleted all entries, disabled and re-enabled the plugin and it worked.

    I hope this makes sense and is useful.

Viewing 1 replies (of 1 total)

The topic ‘Error in the Emails Database’ is closed to new replies.