Continuous errors after upgrade, 4.20.1

Resolved

(@raccontideiros)

Salta al contenuto principaleVai 

Error MailPoet: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
Stack trace:
#0 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute()
#1 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#3 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load()
#4 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
#5 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(69): MailPoet\Doctrine\Repository->findOneBy()
#6 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#7 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
#8 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
#9 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
#10 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(381): MailPoet\Config\Activator->activate()
#11 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(315): MailPoet\Config\Initializer->maybeDbUpdate()
#12 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
#13 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#14 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/plugin.php(517): WP_Hook->do_action()
#15 /web/htdocs/www.raccontideirosartjewels.it/home/wp-settings.php(623): do_action()
#16 /web/htdocs/www.raccontideirosartjewels.it/home/wp-config.php(96): require_once('/web/htdocs/www...')
#17 /web/htdocs/www.raccontideirosartjewels.it/home/wp-load.php(50): require_once('/web/htdocs/www...')
#18 /web/htdocs/www.raccontideirosartjewels.it/home/wp-admin/admin.php(34): require_once('/web/htdocs/www...')
#19 /web/htdocs/www.raccontideirosartjewels.it/home/wp-admin/index.php(10): require_once('/web/htdocs/www...')
#20 {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 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
Stack trace:
#0 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(61): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#3 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load()
#4 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
#5 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(69): MailPoet\Doctrine\Repository->findOneBy()
#6 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#7 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
#8 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
#9 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
#10 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(381): MailPoet\Config\Activator->activate()
#11 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(315): MailPoet\Config\Initializer->maybeDbUpdate()
#12 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
#13 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#14 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/plugin.php(517): WP_Hook->do_action()
#15 /web/htdocs/www.raccontideirosartjewels.it/home/wp-settings.php(623): do_action()
#16 /web/htdocs/www.raccontideirosartjewels.it/home/wp-config.php(96): require_once('/web/htdocs/www...')
#17 /web/htdocs/www.raccontideirosartjewels.it/home/wp-load.php(50): require_once('/web/htdocs/www...')
#18 /web/htdocs/www.raccontideirosartjewels.it/home/wp-admin/admin.php(34): require_once('/web/htdocs/www...')
#19 /web/htdocs/www.raccontideirosartjewels.it/home/wp-admin/index.php(10): require_once('/web/htdocs/www...')
#20 {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 wp206_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 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
Stack trace:
#0 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(77): MailPoetVendor\Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(65): MailPoetVendor\Doctrine\DBAL\DBALException::wrapException()
#2 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(936): MailPoetVendor\Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(503): MailPoetVendor\Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#5 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load()
#6 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
#7 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(69): MailPoet\Doctrine\Repository->findOneBy()
#8 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#9 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
#10 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
#11 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
#12 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(381): MailPoet\Config\Activator->activate()
#13 /web/htdocs/www.raccontideirosartjewels.it/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(315): MailPoet\Config\Initializer->maybeDbUpdate()
#14 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
#15 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#16 /web/htdocs/www.raccontideirosartjewels.it/home/wp-includes/plugin.php(517): WP_Hook->do_action()
#17 /web/htdocs/www.raccontideirosartjewels.it/home/wp-settings.php(623): do_action()
#18 /web/htdocs/www.raccontideirosartjewels.it/home/wp-config.php(96): require_once('/web/htdocs/www...')
#19 /web/htdocs/www.raccontideirosartjewels.it/home/wp-load.php(50): require_once('/web/htdocs/www...')
#20 /web/htdocs/www.raccontideirosartjewels.it/home/wp-admin/admin.php(34): require_once('/web/htdocs/www...')
#21 /web/htdocs/www.raccontideirosartjewels.it/home/wp-admin/index.php(10): require_once('/web/htdocs/www...')
#22 {main}

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

Plugin Author Bruna a11n
(@bruberries)

2 years, 10 months ago

Hi @raccontideiros,

As the error mentions “Column not found”, it seems something went wrong during the update of the plugin or any previous migration you’ve done in your database.

Would you mind try re-installing the plugin via FTP and let us know if the problem persists?

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

Thread Starter raccontideiros
(@raccontideiros)

2 years, 10 months ago

Hi Bruna,
I’ve already tried uninstalling and then reinstalling the plugin from the WordPress platform, but unfortunately nothing has changed. Could anything change if you did it via FTP instead?
Thank you.

Plugin Author Bruna a11n
(@bruberries)

2 years, 10 months ago

Hi @raccontideiros,

I’d recommend trying to follow the steps to re-install it via FTP as you’ll set the folder to _old and re-install the plugin again. If it doesn’t work, please contact us through this form and link to this thread.

Thread Starter raccontideiros
(@raccontideiros)

2 years, 10 months ago

Hi Bruna,
unfortunately also with the FTP procedure nothing has changed.
Same errors and same unusable plugin.
The absurd thing is that if I restore your old version it doesn’t give me any problems, but if I update all the errors come out.

Elvira K.
(@treibalen)

2 years, 10 months ago

Hi there @raccontideiros,

Thanks for getting back to us!

Please contact us via https://www.mailpoet.com/support/sales-pre-sales-questions/ and include a link to this thread.

We’ll be able to provide you with more information there.

Cheers!

Elvira K.
(@treibalen)

2 years, 9 months ago

Hi there @raccontideiros,

I’m going to mark this as resolved since we asked you to contact us via another support channel.

Enjoy the rest of your day!

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

The topic ‘Continuous errors after upgrade, 4.20.1’ is closed to new replies.