An error popped up on updating mailpoet to its latest version

Resolved

(@ahanastorepro)

The following error was popped up on updating the plugin to its latest version. Currently we do not face any other issue in our website other than this error.We have gone through basic trouble shooting and couldn’t find a conflict.

MailPoet Error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.display_in_manage_subscription_page’ in ‘field list’ in /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
Stack trace:

0 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute(NULL)

1 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()

2 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery(‘SELECT t0.name …‘, Array, Array)

3 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)

4 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)

5 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(56): MailPoet\Doctrine\Repository->findOneBy(Array)

6 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()

7 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()

8 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()

9 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()

10 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Initializer.php(381): MailPoet\Config\Activator->activate()

11 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Initializer.php(315): MailPoet\Config\Initializer->maybeDbUpdate()

12 /nas/content/live/artisanfcdev/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize(‘’)

13 /nas/content/live/artisanfcdev/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)

14 /nas/content/live/artisanfcdev/wp-includes/plugin.php(517): WP_Hook->do_action(Array)

15 /nas/content/live/artisanfcdev/wp-settings.php(623): do_action(‘init’)

16 /nas/content/live/artisanfcdev/wp-config.php(119): require_once(‘/nas/content/li…‘)

17 /nas/content/live/artisanfcdev/wp-load.php(50): require_once(‘/nas/content/li…‘)

18 /nas/content/live/artisanfcdev/wp-admin/admin.php(34): require_once(‘/nas/content/li…’)

19 {main}

Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.display_in_manage_subscription_page’ in ‘field list’ in /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
Stack trace:

0 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(61): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))

1 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()

2 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery(‘SELECT t0.name …‘, Array, Array)

3 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)

4 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)

5 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(56): MailPoet\Doctrine\Repository->findOneBy(Array)

6 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()

7 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()

8 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()

9 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()

10 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Initializer.php(381): MailPoet\Config\Activator->activate()

11 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Initializer.php(315): MailPoet\Config\Initializer->maybeDbUpdate()

12 /nas/content/live/artisanfcdev/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize(‘’)

13 /nas/content/live/artisanfcdev/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)

14 /nas/content/live/artisanfcdev/wp-includes/plugin.php(517): WP_Hook->do_action(Array)

15 /nas/content/live/artisanfcdev/wp-settings.php(623): do_action(‘init’)

16 /nas/content/live/artisanfcdev/wp-config.php(119): require_once(‘/nas/content/li…‘)

17 /nas/content/live/artisanfcdev/wp-load.php(50): require_once(‘/nas/content/li…‘)

18 /nas/content/live/artisanfcdev/wp-admin/admin.php(34): require_once(‘/nas/content/li…’)

19 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘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 = ? LIMIT 1’ with params [“wp_users”]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.display_in_manage_subscription_page’ in ‘field list’ in /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
Stack trace:

0 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(77): MailPoetVendor\Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception))

1 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(65): MailPoetVendor\Doctrine\DBAL\DBALException::wrapException(Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception), ‘An exception oc…’)

2 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(936): MailPoetVendor\Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT t0.name …’, Array)

3 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(503): MailPoetVendor\Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT t0.name …’, Array, Array)

4 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery(‘SELECT t0.name …‘, Array, Array)

5 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)

6 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)

7 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(56): MailPoet\Doctrine\Repository->findOneBy(Array)

8 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()

9 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()

10 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()

11 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()

12 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Initializer.php(381): MailPoet\Config\Activator->activate()

13 /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/lib/Config/Initializer.php(315): MailPoet\Config\Initializer->maybeDbUpdate()

14 /nas/content/live/artisanfcdev/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize(‘’)

15 /nas/content/live/artisanfcdev/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)

16 /nas/content/live/artisanfcdev/wp-includes/plugin.php(517): WP_Hook->do_action(Array)

17 /nas/content/live/artisanfcdev/wp-settings.php(623): do_action(‘init’)

18 /nas/content/live/artisanfcdev/wp-config.php(119): require_once(‘/nas/content/li…‘)

19 /nas/content/live/artisanfcdev/wp-load.php(50): require_once(‘/nas/content/li…‘)

20 /nas/content/live/artisanfcdev/wp-admin/admin.php(34): require_once(‘/nas/content/li…’)

21 {main}

The page I need help with: [log in to see the link]

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

Plugin Author Bruna a11n
(@bruberries)

3 years, 1 month ago

Hi @ahanastorepro,

MailPoet Error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.display_in_manage_subscription_page’ in ‘field list’ in /nas/content/live/artisanfcdev/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59

This error means that there’s missing data in your database related to the MailPoet plugin, and it may have happened during an upgrade or any recent changes/migrations you may have done in your database.

Have you tried to re-install the plugin via FTP to see if the error persists?

For reference: https://kb.mailpoet.com/article/258-re-installing-updating-the-plugin-via-ftp

Thread Starter ahanastorepro
(@ahanastorepro)

3 years ago

Yres. I have tried re-installing it via ftp and still the error is shown. The plugin does not show the error from the version 4.0.0. I have tryed rolling back to all those versions as well. There was no changes made in website recenlty.

Plugin Author Bruna a11n
(@bruberries)

3 years ago

Hi @ahanastorepro,

It’s possible there’s some migration task stuck in your database, or something was corrupted when upgrading the plugin. Would you mind sharing access to your website by following this guide and contacting us here?

Thank you!

Thread Starter ahanastorepro
(@ahanastorepro)

2 years, 8 months ago

I am trying to send a mail in https://www.mailpoet.com/support/sales-pre-sales-questions/ , but i think they do not provide any tickt number. Please provide me a solution ASAP.

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

The topic ‘An error popped up on updating mailpoet to its latest version’ is closed to new replies.