Causing critical error on site

  • Resolved jayPEG

    (@jaypeg)


    9 months ago

    Hello, I recently took over a site that I’m working with and when updating the MailPoet Plugin and also updating to PHP 8, the Plugin is causing a critical error. Looking at the error logs, it looks like there was likely some new columns added to the database that don’t exist. How can I address this? Is there an older version of the Plugin I can install that will attempt to re-run the database updates or something I can run manually in phpMyAdmin?

    Here’s from the error logs…


    WordPress database error Unknown column ‘z0_.status’ in ‘field list’
    WordPress database error Unknown column ‘t0.unsubscribe_token’ in ‘field list’
    …
    PHP Fatal error: Uncaught MailPoet\Doctrine\WPDB\Exceptions\QueryException

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

    (@bruberries)

    8 months, 3 weeks ago

    Hi @jaypeg! Sorry to hear you’re experiencing this issue.

    It seems that during an update of the plugin, while it run DB migrations to add/alter columns, those migrations didn’t complete for some reason (timeouts, perms, crashed update, object cache, etc.). So the new code is expecting columns that aren’t there, hence the “Unknown column …” and the fatal error.

    I’d recommend downloading an older MailPoet version from the Advanced View / older versions section on the plugin repo and installing it through FTP. Can you please try that and let us know if the error persists?

    Thread Starter jayPEG

    (@jaypeg)

    8 months, 3 weeks ago

    Thank you Bruna. I set the PHP version back to 7.4 and went back all the way to version 4.0.1 before being able to activate it successfully. I then ran the update and it caused a critical site error. I changed PHP back up to 8.2 to ensure that it wasn’t that.

    Thread Starter jayPEG

    (@jaypeg)

    8 months ago

    Hello, I hadn’t heard back and wanted to follow back up. Do you have any other suggestions? I can create DB tables manually if needed if you think that might work.

    Plugin Author Bruna a11n

    (@bruberries)

    7 months, 2 weeks ago

    Hi @jaypeg,

    Sorry for the delayed reply here. Yes, usually, I would tell you to install the plugin on a different website to export the table structure from the DB (I suspect this is related to the _mailpoet_subscribers table, by the columns mentioned in the error) and re-import it empty to replace your current table. This would not affect data, just the structure of the table. Can you try that?

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

The topic ‘Causing critical error on site’ is closed to new replies.