• Resolved flyingjillio

    (@flyingjillio)


    Hello, Updating a website and I can't get past this error. MailPoet Error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /home2/blackhills/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
    (I will post the whole error below.) 
    
    After the error, I tried rolling back and reinstalling the backup of the site I had just made, but the error is still there, even with the older version and all the older plugin versions and older WordPress.   I tried then rolling forward to the latest version of Mailpoet to see if that would fix it, but I still have the error.  I tried rolling back to PHP 7.4 and that didn't work. Any help would be appreciated. We have been using Mailpoet on this site for years and love it.   
    
    Full Error:
    
    MailPoet Error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /home2/blackhills/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
    Stack trace:
    #0 /home2/blackhills/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute(NULL)
    #1 /home2/blackhills/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
    #2 /home2/blackhills/public_html/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 /home2/blackhills/public_html/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 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
    #5 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy(Array)
    #6 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #7 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
    #8 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #9 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #10 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(359): MailPoet\Config\Activator->activate()
    #11 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(299): MailPoet\Config\Initializer->maybeDbUpdate()
    #12 /home2/blackhills/public_html/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('')
    #13 /home2/blackhills/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
    #14 /home2/blackhills/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #15 /home2/blackhills/public_html/wp-settings.php(617): do_action('init')
    #16 /home2/blackhills/public_html/wp-config.php(77): require_once('/home2/blackhil...')
    #17 /home2/blackhills/public_html/wp-load.php(50): require_once('/home2/blackhil...')
    #18 /home2/blackhills/public_html/wp-admin/admin.php(34): require_once('/home2/blackhil...')
    #19 /home2/blackhills/public_html/wp-admin/plugins.php(10): require_once('/home2/blackhil...')
    #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 /home2/blackhills/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
    Stack trace:
    #0 /home2/blackhills/public_html/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 /home2/blackhills/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
    #2 /home2/blackhills/public_html/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 /home2/blackhills/public_html/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 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
    #5 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy(Array)
    #6 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #7 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
    #8 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #9 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #10 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(359): MailPoet\Config\Activator->activate()
    #11 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(299): MailPoet\Config\Initializer->maybeDbUpdate()
    #12 /home2/blackhills/public_html/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('')
    #13 /home2/blackhills/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
    #14 /home2/blackhills/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #15 /home2/blackhills/public_html/wp-settings.php(617): do_action('init')
    #16 /home2/blackhills/public_html/wp-config.php(77): require_once('/home2/blackhil...')
    #17 /home2/blackhills/public_html/wp-load.php(50): require_once('/home2/blackhil...')
    #18 /home2/blackhills/public_html/wp-admin/admin.php(34): require_once('/home2/blackhil...')
    #19 /home2/blackhills/public_html/wp-admin/plugins.php(10): require_once('/home2/blackhil...')
    #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 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 /home2/blackhills/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
    Stack trace:
    #0 /home2/blackhills/public_html/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 /home2/blackhills/public_html/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 /home2/blackhills/public_html/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 /home2/blackhills/public_html/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 /home2/blackhills/public_html/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 /home2/blackhills/public_html/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 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
    #7 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy(Array)
    #8 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(352): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #9 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(172): MailPoet\Config\Populator->createDefaultSegment()
    #10 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #11 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #12 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(359): MailPoet\Config\Activator->activate()
    #13 /home2/blackhills/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(299): MailPoet\Config\Initializer->maybeDbUpdate()
    #14 /home2/blackhills/public_html/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('')
    #15 /home2/blackhills/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
    #16 /home2/blackhills/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #17 /home2/blackhills/public_html/wp-settings.php(617): do_action('init')
    #18 /home2/blackhills/public_html/wp-config.php(77): require_once('/home2/blackhil...')
    #19 /home2/blackhills/public_html/wp-load.php(50): require_once('/home2/blackhil...')
    #20 /home2/blackhills/public_html/wp-admin/admin.php(34): require_once('/home2/blackhil...')
    #21 /home2/blackhills/public_html/wp-admin/plugins.php(10): require_once('/home2/blackhil...')
    #22 {main}

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

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘MailPoet Error: PDOException: SQLSTATE[42S22]:’ is closed to new replies.