DB Issues after an update

(@vasilisweb)

Greetings, there seems to be an issue after updating both free and premium plugins
i updated the free plugin from 3.87.2 to 5.22.4 and the premium one from 3.87.0 to 5.22

And it throws db errors in debug.log and some fatals

[02-Apr-2026 07:00:39 UTC] WordPress database error Unknown column 't0.display_in_manage_subscription_page' in 'field list' for query SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.average_engagement_score AS average_engagement_score_4, t0.average_engagement_score_updated_at AS average_engagement_score_updated_at_5, t0.display_in_manage_subscription_page AS display_in_manage_subscription_page_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM wp_mailpoet_segments t0 WHERE t0.type = 'wp_users' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->maybeRunActivator, MailPoet\Config\Activator->activate, MailPoet\Config\Activator->processActivate, MailPoet\Config\Populator->up, MailPoet\Config\Populator->createDefaultSegment, MailPoet\Segments\SegmentsRepository->getWPUsersSegment, MailPoet\Doctrine\Repository->findOneBy, MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy, MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery
[02-Apr-2026 07:00:40 UTC] WordPress database error Unknown column 'w0_.cancelled_at' in 'field list' for query SELECT w0_.type AS type_0, w0_.status AS status_1, w0_.priority AS priority_2, w0_.scheduled_at AS scheduled_at_3, w0_.cancelled_at AS cancelled_at_4, w0_.processed_at AS processed_at_5, w0_.meta AS meta_6, w0_.in_progress AS in_progress_7, w0_.reschedule_count AS reschedule_count_8, w0_.id AS id_9, w0_.created_at AS created_at_10, w0_.updated_at AS updated_at_11, w0_.deleted_at AS deleted_at_12 FROM wp_mailpoet_scheduled_tasks w0_ INNER JOIN wp_mailpoet_sending_queues w1_ ON w0_.id = w1_.task_id WHERE w0_.deleted_at IS NULL AND w0_.status = 'scheduled' AND w0_.scheduled_at <= '2026-04-02 07:00:40' AND w0_.type = 'sending' ORDER BY w0_.updated_at ASC LIMIT 5 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->initialize, MailPoet\Config\Initializer->setupCronTrigger, MailPoet\Cron\CronTrigger->init, MailPoet\Cron\Triggers\WordPress->run, MailPoet\Cron\Triggers\WordPress->checkExecutionRequirements, MailPoet\Cron\Triggers\WordPress->isSendingQueueActive, MailPoet\Newsletter\Sending\ScheduledTasksRepository->findScheduledSendingTasks, MailPoetVendor\Doctrine\ORM\AbstractQuery->getResult, MailPoetVendor\Doctrine\ORM\AbstractQuery->execute, MailPoetVendor\Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache, MailPoetVendor\Doctrine\ORM\Query->_doExecute, MailPoetVendor\Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery
[02-Apr-2026 07:00:41 UTC] WordPress database error Unknown column 't0.display_in_manage_subscription_page' in 'field list' for query SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.average_engagement_score AS average_engagement_score_4, t0.average_engagement_score_updated_at AS average_engagement_score_updated_at_5, t0.display_in_manage_subscription_page AS display_in_manage_subscription_page_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM wp_mailpoet_segments t0 WHERE t0.type = 'wp_users' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->maybeRunActivator, MailPoet\Config\Activator->activate, MailPoet\Config\Activator->processActivate, MailPoet\Config\Populator->up, MailPoet\Config\Populator->createDefaultSegment, MailPoet\Segments\SegmentsRepository->getWPUsersSegment, MailPoet\Doctrine\Repository->findOneBy, MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy, MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery
[02-Apr-2026 07:00:41 UTC] WordPress database error Unknown column 'w0_.cancelled_at' in 'field list' for query SELECT w0_.type AS type_0, w0_.status AS status_1, w0_.priority AS priority_2, w0_.scheduled_at AS scheduled_at_3, w0_.cancelled_at AS cancelled_at_4, w0_.processed_at AS processed_at_5, w0_.meta AS meta_6, w0_.in_progress AS in_progress_7, w0_.reschedule_count AS reschedule_count_8, w0_.id AS id_9, w0_.created_at AS created_at_10, w0_.updated_at AS updated_at_11, w0_.deleted_at AS deleted_at_12 FROM wp_mailpoet_scheduled_tasks w0_ INNER JOIN wp_mailpoet_sending_queues w1_ ON w0_.id = w1_.task_id WHERE w0_.deleted_at IS NULL AND w0_.status = 'scheduled' AND w0_.scheduled_at <= '2026-04-02 07:00:41' AND w0_.type = 'sending' ORDER BY w0_.updated_at ASC LIMIT 5 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->initialize, MailPoet\Config\Initializer->setupCronTrigger, MailPoet\Cron\CronTrigger->init, MailPoet\Cron\Triggers\WordPress->run, MailPoet\Cron\Triggers\WordPress->checkExecutionRequirements, MailPoet\Cron\Triggers\WordPress->isSendingQueueActive, MailPoet\Newsletter\Sending\ScheduledTasksRepository->findScheduledSendingTasks, MailPoetVendor\Doctrine\ORM\AbstractQuery->getResult, MailPoetVendor\Doctrine\ORM\AbstractQuery->execute, MailPoetVendor\Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache, MailPoetVendor\Doctrine\ORM\Query->_doExecute, MailPoetVendor\Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery

[02-Apr-2026 07:00:58 UTC] PHP Fatal error:  Uncaught MailPoet\Doctrine\WPDB\Exceptions\QueryException: Unknown column 't0.last_sending_at' in 'field list' in /wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php:132
[02-Apr-2026 07:06:29 UTC] PHP Fatal error:  Uncaught Error: Class 'MailPoet\Premium\Automation\Engine\Endpoints\Automations\AutomationsPostEndpoint' not found in /wp-content/plugins/mailpoet/lib/API/REST/API.php:62
[02-Apr-2026 07:06:58 UTC] PHP Fatal error:  require(): Failed opening required '/wp-content/plugins/mailpoet/lib/Automation/Engine/Endpoints/Automations/AutomationsGetEndpoint.php' (include_path='.:/usr/local/share/pear') in /wp-content/plugins/jetpack/vendor/jetpack-autoloader/class-php-autoloader.php on line 102

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

Plugin Author

Bruna a11n

(@bruberries)

1 month, 3 weeks ago

Hi @vasilisweb,

Thanks for reporting this and for sharing the debug log.

The errors you’re seeing are caused by missing database columns (display_in_manage_subscription_page, cancelled_at, last_sending_at) that the updated plugin code expects but that don’t exist in your database yet. This typically happens when the database migration process doesn’t complete successfully, especially after a large version jump like 3.87.x → 5.22.x.

The Premium plugin fatals (AutomationsPostEndpoint not found, failed require()) suggest there may also be a version mismatch or an incomplete update of the Premium plugin files.

Here are some things to try:

Go to Plugins, deactivate MailPoet, then activate it again. This should trigger the activation routine and re-run any pending database migrations.
Re-install the Premium plugin: The class-not-found and failed-require errors suggest the Premium plugin files may be incomplete. Deactivate it, delete it, and install a fresh copy from your MailPoet account.
If the errors persist after the above, please let us know.

Thread Starter

vasilisweb

(@vasilisweb)

1 month, 3 weeks ago

If i deactivate and activate again it will not have any issue with the subscribed and unsubscribed users right? Like subscribe the ones that are not subscribed or maybe send email etc..

So i need to deactivate and activate the free plugin and reinstall the premium one right?

The only issue is that the license is linked to an old developer and will have issue getting this file. I dont think thats possible but i do have the license. Is there any change you can send me the file and reactivate the license i currently have?

Plugin Author

Bruna a11n

(@bruberries)

1 month, 3 weeks ago

Hi @vasilisweb,

Correct: deactivating and reactivating won’t affect your subscribers. It won’t change anyone’s subscription status (subscribed/unsubscribed), and it won’t trigger any email sending. The activation routine only runs database migrations and sets up default data structures.

And yes, that’s correct: deactivate and reactivate the free plugin, and reinstall the Premium one.

Regarding the Premium plugin file and license, you should be able to re-install it when activating your key in the MailPoet > Settings > Key Activation tab. For reference: https://kb.mailpoet.com/article/194-instructions-to-activate-your-mailpoet-key#installing-the-mailpoet-premium-plugin

Thread Starter

vasilisweb

(@vasilisweb)

1 month, 3 weeks ago

Ohh so i dont need to login the mailpoet website and download it from there, right?
Alright thank you very much if i have any issue doing that i will be right back otherwise i will let you know that all went as planned

Thread Starter

vasilisweb

(@vasilisweb)

1 month, 3 weeks ago

Greetings,

I deactivated the free plugin then activated it and updated it and i still get those errors bellow. I didn’t even had the chance to update the premium plugin.

Σφάλμα του MailPoet: MailPoet\Doctrine\WPDB\Exceptions\QueryException: Unknown column 't0.display_in_manage_subscription_page' in 'field list' in  wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php:132
Stack trace:
#0  wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php(123): MailPoet\Doctrine\WPDB\Connection->handleQueryError()
#1  wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php(35): MailPoet\Doctrine\WPDB\Connection->runQuery('SELECT t0.name ...')
#2  wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Statement.php(71): MailPoet\Doctrine\WPDB\Connection->query('SELECT t0.name ...')
#3  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(418): MailPoet\Doctrine\WPDB\Statement->execute()
#4  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(408): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('SELECT t0.name ...', Array, Array)
#5  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/src/EntityRepository.php(84): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#6  wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(71): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
#7  wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(88): MailPoet\Doctrine\Repository->findOneBy(Array)
#8  wp-content/plugins/mailpoet/lib/Config/Populator.php(354): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#9  wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
#10  wp-content/plugins/mailpoet/lib/Config/Activator.php(88): MailPoet\Config\Populator->up()
#11  wp-content/plugins/mailpoet/lib/Config/Activator.php(67): MailPoet\Config\Activator->processActivate()
#12  wp-content/plugins/mailpoet/lib/Config/Initializer.php(430): MailPoet\Config\Activator->activate()
#13  wp-includes/class-wp-hook.php(341): MailPoet\Config\Initializer->maybeRunActivator('')
#14  wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters('', Array)
#15  wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#16  wp-settings.php(742): do_action('init')
#17  wp-config.php(84): require_once('...')
#18  wp-load.php(50): require_once('...')
#19  wp-admin/admin.php(35): require_once('...')
#20  wp-admin/plugin-install.php(16): require_once('...')
#21 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: Unknown column 't0.display_in_manage_subscription_page' in 'field list' in  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:53
Stack trace:
#0  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(848): MailPoetVendor\Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(MailPoet\Doctrine\WPDB\Exceptions\QueryException), Object(MailPoetVendor\Doctrine\DBAL\Query))
#1  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(820): MailPoetVendor\Doctrine\DBAL\Connection->handleDriverException(Object(MailPoet\Doctrine\WPDB\Exceptions\QueryException), Object(MailPoetVendor\Doctrine\DBAL\Query))
#2  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(424): MailPoetVendor\Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(MailPoet\Doctrine\WPDB\Exceptions\QueryException), 'SELECT t0.name ...', Array, Array)
#3  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php(408): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('SELECT t0.name ...', Array, Array)
#4  wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/src/EntityRepository.php(84): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#5  wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(71): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
#6  wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(88): MailPoet\Doctrine\Repository->findOneBy(Array)
#7  wp-content/plugins/mailpoet/lib/Config/Populator.php(354): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#8  wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
#9  wp-content/plugins/mailpoet/lib/Config/Activator.php(88): MailPoet\Config\Populator->up()
#10  wp-content/plugins/mailpoet/lib/Config/Activator.php(67): MailPoet\Config\Activator->processActivate()
#11  wp-content/plugins/mailpoet/lib/Config/Initializer.php(430): MailPoet\Config\Activator->activate()
#12  wp-includes/class-wp-hook.php(341): MailPoet\Config\Initializer->maybeRunActivator('')
#13  wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters('', Array)
#14  wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#15  wp-settings.php(742): do_action('init')
#16  wp-config.php(84): require_once('...')
#17  wp-load.php(50): require_once('...')
#18  wp-admin/admin.php(35): require_once('...')
#19  wp-admin/plugin-install.php(16): require_once('...')
#20 {main}

[03-Apr-2026 06:28:34 UTC] WordPress database error Unknown column 't0.display_in_manage_subscription_page' in 'field list' for query SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.average_engagement_score AS average_engagement_score_4, t0.average_engagement_score_updated_at AS average_engagement_score_updated_at_5, t0.display_in_manage_subscription_page AS display_in_manage_subscription_page_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM wp_mailpoet_segments t0 WHERE t0.type = 'wp_users' LIMIT 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->maybeRunActivator, MailPoet\Config\Activator->activate, MailPoet\Config\Activator->processActivate, MailPoet\Config\Populator->up, MailPoet\Config\Populator->createDefaultSegment, MailPoet\Segments\SegmentsRepository->getWPUsersSegment, MailPoet\Doctrine\Repository->findOneBy, MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy, MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery
[03-Apr-2026 06:28:34 UTC] WordPress database error Unknown column 'w0_.cancelled_at' in 'field list' for query SELECT w0_.type AS type_0, w0_.status AS status_1, w0_.priority AS priority_2, w0_.scheduled_at AS scheduled_at_3, w0_.cancelled_at AS cancelled_at_4, w0_.processed_at AS processed_at_5, w0_.meta AS meta_6, w0_.in_progress AS in_progress_7, w0_.reschedule_count AS reschedule_count_8, w0_.id AS id_9, w0_.created_at AS created_at_10, w0_.updated_at AS updated_at_11, w0_.deleted_at AS deleted_at_12 FROM wp_mailpoet_scheduled_tasks w0_ INNER JOIN wp_mailpoet_sending_queues w1_ ON w0_.id = w1_.task_id WHERE w0_.deleted_at IS NULL AND w0_.status = 'scheduled' AND w0_.scheduled_at <= '2026-04-03 06:28:34' AND w0_.type = 'sending' ORDER BY w0_.updated_at ASC LIMIT 5 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->initialize, MailPoet\Config\Initializer->setupCronTrigger, MailPoet\Cron\CronTrigger->init, MailPoet\Cron\Triggers\WordPress->run, MailPoet\Cron\Triggers\WordPress->checkExecutionRequirements, MailPoet\Cron\Triggers\WordPress->isSendingQueueActive, MailPoet\Newsletter\Sending\ScheduledTasksRepository->findScheduledSendingTasks, MailPoetVendor\Doctrine\ORM\AbstractQuery->getResult, MailPoetVendor\Doctrine\ORM\AbstractQuery->execute, MailPoetVendor\Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache, MailPoetVendor\Doctrine\ORM\Query->_doExecute, MailPoetVendor\Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery
[03-Apr-2026 06:28:34 UTC] WordPress database error Unknown column 't0.display_in_manage_subscription_page' in 'field list' for query SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.average_engagement_score AS average_engagement_score_4, t0.average_engagement_score_updated_at AS average_engagement_score_updated_at_5, t0.display_in_manage_subscription_page AS display_in_manage_subscription_page_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM wp_mailpoet_segments t0 WHERE t0.type = 'wp_users' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->maybeRunActivator, MailPoet\Config\Activator->activate, MailPoet\Config\Activator->processActivate, MailPoet\Config\Populator->up, MailPoet\Config\Populator->createDefaultSegment, MailPoet\Segments\SegmentsRepository->getWPUsersSegment, MailPoet\Doctrine\Repository->findOneBy, MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy, MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery
[03-Apr-2026 06:28:34 UTC] WordPress database error Unknown column 'w0_.cancelled_at' in 'field list' for query SELECT w0_.type AS type_0, w0_.status AS status_1, w0_.priority AS priority_2, w0_.scheduled_at AS scheduled_at_3, w0_.cancelled_at AS cancelled_at_4, w0_.processed_at AS processed_at_5, w0_.meta AS meta_6, w0_.in_progress AS in_progress_7, w0_.reschedule_count AS reschedule_count_8, w0_.id AS id_9, w0_.created_at AS created_at_10, w0_.updated_at AS updated_at_11, w0_.deleted_at AS deleted_at_12 FROM wp_mailpoet_scheduled_tasks w0_ INNER JOIN wp_mailpoet_sending_queues w1_ ON w0_.id = w1_.task_id WHERE w0_.deleted_at IS NULL AND w0_.status = 'scheduled' AND w0_.scheduled_at <= '2026-04-03 06:28:34' AND w0_.type = 'sending' ORDER BY w0_.updated_at ASC LIMIT 5 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->initialize, MailPoet\Config\Initializer->setupCronTrigger, MailPoet\Cron\CronTrigger->init, MailPoet\Cron\Triggers\WordPress->run, MailPoet\Cron\Triggers\WordPress->checkExecutionRequirements, MailPoet\Cron\Triggers\WordPress->isSendingQueueActive, MailPoet\Newsletter\Sending\ScheduledTasksRepository->findScheduledSendingTasks, MailPoetVendor\Doctrine\ORM\AbstractQuery->getResult, MailPoetVendor\Doctrine\ORM\AbstractQuery->execute, MailPoetVendor\Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache, MailPoetVendor\Doctrine\ORM\Query->_doExecute, MailPoetVendor\Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery
[03-Apr-2026 06:28:34 UTC] WordPress database error Unknown column 't0.last_sending_at' in 'field list' for query SELECT t0.wp_user_id AS wp_user_id_1, t0.is_woocommerce_user AS is_woocommerce_user_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.status AS status_6, t0.subscribed_ip AS subscribed_ip_7, t0.confirmed_ip AS confirmed_ip_8, t0.confirmed_at AS confirmed_at_9, t0.last_subscribed_at AS last_subscribed_at_10, t0.unconfirmed_data AS unconfirmed_data_11, t0.source AS source_12, t0.count_confirmations AS count_confirmations_13, t0.unsubscribe_token AS unsubscribe_token_14, t0.link_token AS link_token_15, t0.engagement_score AS engagement_score_16, t0.engagement_score_updated_at AS engagement_score_updated_at_17, t0.last_engagement_at AS last_engagement_at_18, t0.last_sending_at AS last_sending_at_19, t0.last_open_at AS last_open_at_20, t0.last_click_at AS last_click_at_21, t0.last_purchase_at AS last_purchase_at_22, t0.last_page_view_at AS last_page_view_at_23, t0.woocommerce_synced_at AS woocommerce_synced_at_24, t0.email_count AS email_count_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.deleted_at AS deleted_at_29 FROM wp_mailpoet_subscribers t0 WHERE t0.wp_user_id = 5985 LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\Config\Initializer->initialize, MailPoet\Statistics\Track\SubscriberActivityTracker->trackActivity, MailPoet\Statistics\Track\SubscriberActivityTracker->getSubscriber, MailPoet\Doctrine\Repository->findOneBy, MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy, MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load, MailPoetVendor\Doctrine\DBAL\Connection->executeQuery, MailPoet\Doctrine\WPDB\Statement->execute, MailPoet\Doctrine\WPDB\Connection->query, MailPoet\Doctrine\WPDB\Connection->runQuery

Plugin Support

Gui A. a11n

(@guicmazeredo)

1 month, 2 weeks ago

Hi @vasilisweb,

Thanks for trying that and for sharing the updated logs. Since the deactivate/reactivate didn’t resolve the database errors, let’s try a fresh reinstall of the free plugin via FTP. This can help when the migration process gets stuck, especially after a large version jump like yours (3.87.x → 5.22.x).

Don’t worry — this won’t affect your data. All your subscribers, lists, newsletters, and settings are stored in the database, not in the plugin files, so they’ll remain intact.

Step 1: Reinstall the free plugin via FTP

Connect to your site via FTP (or your hosting file manager).
Navigate to /wp-content/plugins/.
Delete the mailpoet folder entirely.
Download the latest version of MailPoet from here: https://ww.wp.xz.cn/plugins/mailpoet/
Upload the freshly downloaded mailpoet folder to /wp-content/plugins/.
Go to your WordPress dashboard → Plugins and activate MailPoet.

After activating, check whether the database errors are gone. You can verify by visiting MailPoet → Help → System Status.

Step 2: Update the Premium plugin

Once the free plugin is working without errors:

Log in to your MailPoet account at https://account.mailpoet.com/.
Download the latest Premium plugin zip file from there.
In your WordPress dashboard, go to Plugins → Add New → Upload Plugin.
Upload the zip file you just downloaded and activate it.

If you’re unable to access your MailPoet account because it’s linked to the previous developer, you can also try entering your license key in MailPoet → Settings → Key Activation — the Premium plugin should be installable from there as well.

Please let us know how it goes!

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

You must be logged in to reply to this topic.

Tags