Error upgrading from Version 3.49.1 to Version: 3.89.3

  • When updating MailPoet from Version 3.49.1 to the current Version: 3.89.3 it presented several errors, following the Log presented in the WP Panel.

    
Erro no MailPoet: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'thumbnail_data' in 'field list' in /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
Stack trace:
#0 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->query('\n UPDATE w...')
#1 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(22): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->doQuery('\n UPDATE w...')
#2 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->query('\n UPDATE w...')
#3 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Populator.php(932): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('\n UPDATE w...')
#4 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Populator.php(196): MailPoet\Config\Populator->moveNewsletterTemplatesThumbnailData()
#5 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Activator.php(57): MailPoet\Config\Populator->up()
#6 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Activator.php(45): MailPoet\Config\Activator->processActivate()
#7 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(309): MailPoet\Config\Activator->activate()
#8 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(263): MailPoet\Config\Initializer->maybeDbUpdate()
#9 /var/www/html/wp-includes/class-wp-hook.php(307): MailPoet\Config\Initializer->initialize('')
#10 /var/www/html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#11 /var/www/html/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#12 /var/www/html/wp-settings.php(587): do_action('init')
#13 /var/www/wp-config.php(139): require_once('/var/www/html/w...')
#14 /var/www/html/wp-load.php(55): require_once('/var/www/wp-con...')
#15 /var/www/html/wp-admin/admin.php(34): require_once('/var/www/html/w...')
#16 /var/www/html/wp-admin/plugins.php(10): require_once('/var/www/html/w...')
#17 {main}

Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'thumbnail_data' in 'field list' in /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
Stack trace:
#0 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(80): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(22): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->doQuery('\n UPDATE w...')
#2 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->query('\n UPDATE w...')
#3 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Populator.php(932): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('\n UPDATE w...')
#4 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Populator.php(196): MailPoet\Config\Populator->moveNewsletterTemplatesThumbnailData()
#5 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Activator.php(57): MailPoet\Config\Populator->up()
#6 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Activator.php(45): MailPoet\Config\Activator->processActivate()
#7 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(309): MailPoet\Config\Activator->activate()
#8 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(263): MailPoet\Config\Initializer->maybeDbUpdate()
#9 /var/www/html/wp-includes/class-wp-hook.php(307): MailPoet\Config\Initializer->initialize('')
#10 /var/www/html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#11 /var/www/html/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#12 /var/www/html/wp-settings.php(587): do_action('init')
#13 /var/www/wp-config.php(139): require_once('/var/www/html/w...')
#14 /var/www/html/wp-load.php(55): require_once('/var/www/wp-con...')
#15 /var/www/html/wp-admin/admin.php(34): require_once('/var/www/html/w...')
#16 /var/www/html/wp-admin/plugins.php(10): require_once('/var/www/html/w...')
#17 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing '
UPDATE wp_T3j42CBnqgXC_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 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
Stack trace:
#0 /var/www/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 /var/www/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 /var/www/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), '\n UPDATE w...', Array)
#3 /var/www/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), '\n UPDATE w...', Array, Array)
#4 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Populator.php(932): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('\n UPDATE w...')
#5 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Populator.php(196): MailPoet\Config\Populator->moveNewsletterTemplatesThumbnailData()
#6 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Activator.php(57): MailPoet\Config\Populator->up()
#7 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Activator.php(45): MailPoet\Config\Activator->processActivate()
#8 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(309): MailPoet\Config\Activator->activate()
#9 /var/www/html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(263): MailPoet\Config\Initializer->maybeDbUpdate()
#10 /var/www/html/wp-includes/class-wp-hook.php(307): MailPoet\Config\Initializer->initialize('')
#11 /var/www/html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#12 /var/www/html/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#13 /var/www/html/wp-settings.php(587): do_action('init')
#14 /var/www/wp-config.php(139): require_once('/var/www/html/w...')
#15 /var/www/html/wp-load.php(55): require_once('/var/www/wp-con...')
#16 /var/www/html/wp-admin/admin.php(34): require_once('/var/www/html/w...')
#17 /var/www/html/wp-admin/plugins.php(10): require_once('/var/www/html/w...')
#18 {main}

    Could you help me?

    [ ]’s Robison
    @robisonweb

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Ojoma a11n

    (@geraltrivia)

    Hello @robisonweb ,

    Thank you for reaching out.

    > When updating MailPoet from Version 3.49.1 to the current Version: 3.89.3 it presented several errors, following the Log presented in the WP Panel

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

    If that doesn’t work,

    Can you please check if the 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 2 years, 9 months ago by Ojoma a11n.
    • This reply was modified 2 years, 9 months ago by Ojoma a11n.
    Plugin Author Bruna a11n

    (@bruberries)

    Hi @robisonweb,

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error upgrading from Version 3.49.1 to Version: 3.89.3’ is closed to new replies.