MailPoet Error: PDOException: SQLSTATE[42S22]:
-
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.