Support » Plugin: MailPoet - Newsletters, Email Marketing, and Automation » Fatal error with WordPress 6.1.1

  • Resolved andycucca

    (@andycucca)


    Hello,

    after upgrade with the last version of WordPress, Mailpoet had a fatal error so I was obliged to deactivate the plugin. Thr error message was the following:

    MailPoet Error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
    Stack trace:
    #0 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute()
    #1 /web/htdocs/www.fishesinvasion.com/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.fishesinvasion.com/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.fishesinvasion.com/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.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
    #5 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy()
    #6 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(351): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #7 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(171): MailPoet\Config\Populator->createDefaultSegment()
    #8 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(79): MailPoet\Config\Populator->up()
    #9 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate()
    #10 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(334): MailPoet\Config\Activator->activate()
    #11 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(291): MailPoet\Config\Initializer->maybeDbUpdate()
    #12 /web/htdocs/www.fishesinvasion.com/home/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
    #13 /web/htdocs/www.fishesinvasion.com/home/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
    #14 /web/htdocs/www.fishesinvasion.com/home/wp-includes/plugin.php(517): WP_Hook->do_action()
    #15 /web/htdocs/www.fishesinvasion.com/home/wp-settings.php(617): do_action()
    #16 /web/htdocs/www.fishesinvasion.com/home/wp-config.php(91): require_once('/web/htdocs/www...')
    #17 /web/htdocs/www.fishesinvasion.com/home/wp-load.php(50): require_once('/web/htdocs/www...')
    #18 /web/htdocs/www.fishesinvasion.com/home/wp-admin/admin.php(34): require_once('/web/htdocs/www...')
    #19 /web/htdocs/www.fishesinvasion.com/home/wp-admin/plugins.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.fishesinvasion.com/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
    Stack trace:
    #0 /web/htdocs/www.fishesinvasion.com/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.fishesinvasion.com/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.fishesinvasion.com/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.fishesinvasion.com/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.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
    #5 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy()
    #6 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(351): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #7 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(171): MailPoet\Config\Populator->createDefaultSegment()
    #8 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(79): MailPoet\Config\Populator->up()
    #9 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate()
    #10 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(334): MailPoet\Config\Activator->activate()
    #11 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(291): MailPoet\Config\Initializer->maybeDbUpdate()
    #12 /web/htdocs/www.fishesinvasion.com/home/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
    #13 /web/htdocs/www.fishesinvasion.com/home/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
    #14 /web/htdocs/www.fishesinvasion.com/home/wp-includes/plugin.php(517): WP_Hook->do_action()
    #15 /web/htdocs/www.fishesinvasion.com/home/wp-settings.php(617): do_action()
    #16 /web/htdocs/www.fishesinvasion.com/home/wp-config.php(91): require_once('/web/htdocs/www...')
    #17 /web/htdocs/www.fishesinvasion.com/home/wp-load.php(50): require_once('/web/htdocs/www...')
    #18 /web/htdocs/www.fishesinvasion.com/home/wp-admin/admin.php(34): require_once('/web/htdocs/www...')
    #19 /web/htdocs/www.fishesinvasion.com/home/wp-admin/plugins.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 wp889_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.fishesinvasion.com/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
    Stack trace:
    #0 /web/htdocs/www.fishesinvasion.com/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.fishesinvasion.com/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(65): MailPoetVendor\Doctrine\DBAL\DBALException::wrapException()
    #2 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(936): MailPoetVendor\Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
    #3 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(503): MailPoetVendor\Doctrine\DBAL\Connection->handleExceptionDuringQuery()
    #4 /web/htdocs/www.fishesinvasion.com/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.fishesinvasion.com/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.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
    #7 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy()
    #8 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(351): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #9 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Populator.php(171): MailPoet\Config\Populator->createDefaultSegment()
    #10 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(79): MailPoet\Config\Populator->up()
    #11 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate()
    #12 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(334): MailPoet\Config\Activator->activate()
    #13 /web/htdocs/www.fishesinvasion.com/home/wp-content/plugins/mailpoet/lib/Config/Initializer.php(291): MailPoet\Config\Initializer->maybeDbUpdate()
    #14 /web/htdocs/www.fishesinvasion.com/home/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize()
    #15 /web/htdocs/www.fishesinvasion.com/home/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
    #16 /web/htdocs/www.fishesinvasion.com/home/wp-includes/plugin.php(517): WP_Hook->do_action()
    #17 /web/htdocs/www.fishesinvasion.com/home/wp-settings.php(617): do_action()
    #18 /web/htdocs/www.fishesinvasion.com/home/wp-config.php(91): require_once('/web/htdocs/www...')
    #19 /web/htdocs/www.fishesinvasion.com/home/wp-load.php(50): require_once('/web/htdocs/www...')
    #20 /web/htdocs/www.fishesinvasion.com/home/wp-admin/admin.php(34): require_once('/web/htdocs/www...')
    #21 /web/htdocs/www.fishesinvasion.com/home/wp-admin/plugins.php(10): require_once('/web/htdocs/www...')
    #22 {main}

    Can you fix this issue as soon as possible please?
    Thanks in advance for your help.
    Andrew

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Hi
    We have the same problem here !
    Anthony.

    Thread Starter andycucca

    (@andycucca)

    Surely a possible solution is to go back to the 6.0.3 version of wordpress, which has been tested with Mailpoet, but with a live e-commerce this is not an easy step to take.

    Hi
    You can install WP rollback and go back to version 4.0.0 which works with wordpress 6.1.1.

    https://fr.wordpress.org/plugins/wp-rollback/

    Best regards.

    Thread Starter andycucca

    (@andycucca)

    Hi,

    Nice to know (@ataubin)

    Thanks!

    Plugin Author MailPoet

    (@mailpoet)

    Hello,

    We’re very sorry for your inconvenience. We’ve identified an issue that may occur in some cases when multiple WordPress installations with MailPoet are sharing a single MySQL instance. We’ve resolved the issue, and the fix will be included in the upcoming release next week.

    In the meantime, we recommend downgrading to MailPoet 4.0.0 by downloading the plugin from the following URL: https://downloads.wordpress.org/plugin/mailpoet.4.0.0.zip

    Once again, apologies for your inconvenience. We hope this workaround resolves your issues.

    Best,
    Jan

    Thread Starter andycucca

    (@andycucca)

    Thank you for your suggestion,

    I will fix as suggested. However, for your information, my installation does not have the anomalies described by you, so the problem encountered should be caused by a different reason.

    Best regards
    Andrea

    Plugin Author MailPoet

    (@mailpoet)

    Hello,

    We released version 4.1.0, which contains a fix for this issue.

    Once again, apologies for your inconvenience.

    Best,
    Rosta

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Fatal error with WordPress 6.1.1’ is closed to new replies.