Title: Error after plugin update Last modified: November 8, 2022 --- # Error after plugin update * Resolved [mshoaibhussain](https://wordpress.org/support/users/mshoaibhussain/) * (@mshoaibhussain) * [3 years, 6 months ago](https://wordpress.org/support/topic/error-after-plugin-update-10/) * Hello, * After today’s update I get the following error in my WordPress backend with regard to MailPoet: * ``` MailPoet Error: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes in /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31 Stack trace: #0 /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(31): PDO->exec('\n CREATE T...') #1 /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(595): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->exec('\n CREATE T...') #2 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Migrator/Store.php(77): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement('\n CREATE T...') #3 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Migrator/Migrator.php(34): MailPoet\Migrator\Store->ensureMigrationsTable() #4 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(77): MailPoet\Migrator\Migrator->run() #5 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate() #6 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(345): MailPoet\Config\Activator->activate() #7 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(299): MailPoet\Config\Initializer->maybeDbUpdate() #8 /home/emststs/public_html/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('') #9 /home/emststs/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array) #10 /home/emststs/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #11 /home/emststs/public_html/wp-settings.php(617): do_action('init') #12 /home/emststs/public_html/wp-config.php(93): require_once('/home/emststs/...') #13 /home/emststs/public_html/wp-load.php(50): require_once('/home/emststs/...') #14 /home/emststs/public_html/wp-admin/admin.php(34): require_once('/home/emststs/...') #15 /home/emststs/public_html/wp-admin/edit.php(10): require_once('/home/emststs/...') #16 {main} Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes in /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10 Stack trace: #0 /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(35): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException)) #1 /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(595): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->exec('\n CREATE T...') #2 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Migrator/Store.php(77): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement('\n CREATE T...') #3 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Migrator/Migrator.php(34): MailPoet\Migrator\Store->ensureMigrationsTable() #4 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(77): MailPoet\Migrator\Migrator->run() #5 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate() #6 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(345): MailPoet\Config\Activator->activate() #7 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(299): MailPoet\Config\Initializer->maybeDbUpdate() #8 /home/emststs/public_html/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('') #9 /home/emststs/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array) #10 /home/emststs/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #11 /home/emststs/public_html/wp-settings.php(617): do_action('init') #12 /home/emststs/public_html/wp-config.php(93): require_once('/home/emststs/...') #13 /home/emststs/public_html/wp-load.php(50): require_once('/home/emststs/...') #14 /home/emststs/public_html/wp-admin/admin.php(34): require_once('/home/emststs/...') #15 /home/emststs/public_html/wp-admin/edit.php(10): require_once('/home/emststs/...') #16 {main} Next MailPoetVendor\Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ' CREATE TABLE IF NOT EXISTS wpuo_mailpoet_migrations ( id int(11) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, started_at timestamp NOT NULL, completed_at timestamp NULL, retries int(11) unsigned NOT NULL DEFAULT 0, error text NULL, PRIMARY KEY (id), UNIQUE KEY (name) ) Engine=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; ': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes in /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:102 Stack trace: #0 /home/emststs/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 /home/emststs/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 /home/emststs/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), '\n CREATE T...', Array) #3 /home/emststs/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(598): MailPoetVendor\Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception), '\n CREATE T...', Array, Array) #4 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Migrator/Store.php(77): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement('\n CREATE T...') #5 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Migrator/Migrator.php(34): MailPoet\Migrator\Store->ensureMigrationsTable() #6 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(77): MailPoet\Migrator\Migrator->run() #7 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate() #8 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(345): MailPoet\Config\Activator->activate() #9 /home/emststs/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(299): MailPoet\Config\Initializer->maybeDbUpdate() #10 /home/emststs/public_html/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('') #11 /home/emststs/public_html/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array) #12 /home/emststs/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #13 /home/emststs/public_html/wp-settings.php(617): do_action('init') #14 /home/emststs/public_html/wp-config.php(93): require_once('/home/emststs/...') #15 /home/emststs/public_html/wp-load.php(50): require_once('/home/emststs/...') #16 /home/emststs/public_html/wp-admin/admin.php(34): require_once('/home/emststs/...') #17 /home/emststs/public_html/wp-admin/edit.php(10): require_once('/home/emststs/...') #18 {main} ``` * Appreciate if you could help fix it. * I have disabled MailPoet for now. * Await your kind feedback. Viewing 4 replies - 1 through 4 (of 4 total) * [Elvira K.](https://wordpress.org/support/users/treibalen/) * (@treibalen) * [3 years, 6 months ago](https://wordpress.org/support/topic/error-after-plugin-update-10/#post-16177742) * Hi there [@mshoaibhussain](https://wordpress.org/support/users/mshoaibhussain/), * Thanks for reaching out! * Our devs are aware of the issue and preparing a fix as we speak. * Please keep an eye on the plugin’s updates. * Cheers! * Thread Starter [mshoaibhussain](https://wordpress.org/support/users/mshoaibhussain/) * (@mshoaibhussain) * [3 years, 6 months ago](https://wordpress.org/support/topic/error-after-plugin-update-10/#post-16178374) * I received the new update, the issue seems to be now resolved. Thank you! * Plugin Support [Dani F. a11n](https://wordpress.org/support/users/danielinhou/) * (@danielinhou) * [3 years, 6 months ago](https://wordpress.org/support/topic/error-after-plugin-update-10/#post-16179213) * Hey there [@mshoaibhussain](https://wordpress.org/support/users/mshoaibhussain/) 👋🏽, * Awesome, I am glad to hear that the new fix solved the issue for you. * Thanks for your patience, and sorry for the inconvenience. * Cheers! * [trbhicks](https://wordpress.org/support/users/trbhicks/) * (@trbhicks) * [3 years, 6 months ago](https://wordpress.org/support/topic/error-after-plugin-update-10/#post-16179590) * Hmm, my WordPress offered the update to 103.1 about half an hour ago. I tried it and go Internal Server Error again, which locks MailPoet and takes my website offline. Once again I have to delete the Mailpoet and upload the thousands of files again via FTP. Grrr. * Related? Error was about 7:05 p.m. PST. Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Error after plugin update’ is closed to new replies. * ![](https://ps.w.org/mailpoet/assets/icon-256x256.png?rev=3284564) * [MailPoet - Newsletters, Email Marketing, and Automation](https://wordpress.org/plugins/mailpoet/) * [Frequently Asked Questions](https://wordpress.org/plugins/mailpoet/#faq) * [Support Threads](https://wordpress.org/support/plugin/mailpoet/) * [Active Topics](https://wordpress.org/support/plugin/mailpoet/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/mailpoet/unresolved/) * [Reviews](https://wordpress.org/support/plugin/mailpoet/reviews/) * 4 replies * 4 participants * Last reply from: [trbhicks](https://wordpress.org/support/users/trbhicks/) * Last activity: [3 years, 6 months ago](https://wordpress.org/support/topic/error-after-plugin-update-10/#post-16179590) * Status: resolved