Error after plugin update

  • Resolved mshoaibhussain

    (@mshoaibhussain)


    2 years, 4 months ago

    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)

  • Hi there @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

    (@mshoaibhussain)

    I received the new update, the issue seems to be now resolved. Thank you!

    Plugin Support Dani F. a11n

    (@danielinhou)

    Hey there @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!

    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.