Error after update

Hi there @hostsolutionslabs,

Thanks for reaching out!

I’m sorry to hear that. I couldn’t reproduce this issue on my site though. As you also couldn’t reproduce on other sites, I’m wondering if something went wrong during the plugin update and prevented some database tables from installing properly.

Could you please follow the instructions to?re-install the plugin via FTP?and let me know if it works?

Don’t worry,?you won’t lose any data from the plugin.

Let us know how that goes.

Hi, sorry for the late reply.
The error persists despite deleting the plugin and uploading via FTP.
How can I keep up with a new version?

Errore MailPoet: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'thumbnail_data' in 'field list' in /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->query()
#1 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(22): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->doQuery()
#2 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->query()
#3 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(932): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#4 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(196): MailPoet\Config\Populator->moveNewsletterTemplatesThumbnailData()
#5 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(53): MailPoet\Config\Populator->up()
#6 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(40): MailPoet\Config\Activator->processActivate()
#7 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(267): MailPoet\Config\Activator->activate()
#8 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(226): MailPoet\Config\Initializer->maybeDbUpdate()
#9 /home/fiocchi/public_html/wp-includes/class-wp-hook.php(307): MailPoet\Config\Initializer->initialize()
#10 /home/fiocchi/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters()
#11 /home/fiocchi/public_html/wp-includes/plugin.php(474): WP_Hook->do_action()
#12 /home/fiocchi/public_html/wp-settings.php(587): do_action()
#13 /home/fiocchi/public_html/wp-config.php(91): require_once('/home/fiocchi/p...')
#14 /home/fiocchi/public_html/wp-load.php(50): require_once('/home/fiocchi/p...')
#15 /home/fiocchi/public_html/wp-admin/admin.php(34): require_once('/home/fiocchi/p...')
#16 /home/fiocchi/public_html/wp-admin/plugins.php(10): require_once('/home/fiocchi/p...')
#17 {main}

Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'thumbnail_data' in 'field list' in /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
Stack trace:
#0 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(22): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->doQuery()
#2 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->query()
#3 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(932): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#4 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(196): MailPoet\Config\Populator->moveNewsletterTemplatesThumbnailData()
#5 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(53): MailPoet\Config\Populator->up()
#6 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(40): MailPoet\Config\Activator->processActivate()
#7 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(267): MailPoet\Config\Activator->activate()
#8 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(226): MailPoet\Config\Initializer->maybeDbUpdate()
#9 /home/fiocchi/public_html/wp-includes/class-wp-hook.php(307): MailPoet\Config\Initializer->initialize()
#10 /home/fiocchi/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters()
#11 /home/fiocchi/public_html/wp-includes/plugin.php(474): WP_Hook->do_action()
#12 /home/fiocchi/public_html/wp-settings.php(587): do_action()
#13 /home/fiocchi/public_html/wp-config.php(91): require_once('/home/fiocchi/p...')
#14 /home/fiocchi/public_html/wp-load.php(50): require_once('/home/fiocchi/p...')
#15 /home/fiocchi/public_html/wp-admin/admin.php(34): require_once('/home/fiocchi/p...')
#16 /home/fiocchi/public_html/wp-admin/plugins.php(10): require_once('/home/fiocchi/p...')
#17 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing '
UPDATE wp_mailpoet_newsletter_templates
SET thumbnail_data = thumbnail, thumbnail = NULL
WHERE thumbnail LIKE 'data:image%';':

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'thumbnail_data' in 'field list' in /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
Stack trace:
#0 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(77): MailPoetVendor\Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(65): MailPoetVendor\Doctrine\DBAL\DBALException::wrapException()
#2 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(936): MailPoetVendor\Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /home/fiocchi/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(503): MailPoetVendor\Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(932): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#5 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(196): MailPoet\Config\Populator->moveNewsletterTemplatesThumbnailData()
#6 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(53): MailPoet\Config\Populator->up()
#7 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(40): MailPoet\Config\Activator->processActivate()
#8 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(267): MailPoet\Config\Activator->activate()
#9 /home/fiocchi/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(226): MailPoet\Config\Initializer->maybeDbUpdate()
#10 /home/fiocchi/public_html/wp-includes/class-wp-hook.php(307): MailPoet\Config\Initializer->initialize()
#11 /home/fiocchi/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters()
#12 /home/fiocchi/public_html/wp-includes/plugin.php(474): WP_Hook->do_action()
#13 /home/fiocchi/public_html/wp-settings.php(587): do_action()
#14 /home/fiocchi/public_html/wp-config.php(91): require_once('/home/fiocchi/p...')
#15 /home/fiocchi/public_html/wp-load.php(50): require_once('/home/fiocchi/p...')
#16 /home/fiocchi/public_html/wp-admin/admin.php(34): require_once('/home/fiocchi/p...')
#17 /home/fiocchi/public_html/wp-admin/plugins.php(10): require_once('/home/fiocchi/p...')
#18 {main}

Hi there @hostsolutionslabs,

Thanks for getting back to us!

Can you please check if wp_mailpoet_newsletter_templates table is missing the thumbnail_data column indeed?

You can access it from your host’s cPanel or by installing a WordPress plugin: https://www.ads-software.com/plugins/wp-phpmyadmin-extension/

If it’s missing, please run this SQL query:

ALTER TABLE wp_mailpoet_newsletter_templates ADD COLUMN thumbnail_data longtext AFTER thumbnail;

Ensure to use the exact table name from your database.

Hope it helps!

• This reply was modified 3 years, 1 month ago by Elvira K..
• This reply was modified 3 years, 1 month ago by Elvira K..

Hi there,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.