4.27 critical error

  • Resolved cannonfire

    (@cannonfire)


    10 months, 2 weeks ago

    Hello, the latest update 4.27 is causing a critical error, rolling back solved the issue but just wanted to update the developer. OceanWP/Elementor

    Message received in mail:

    Howdy!

    WordPress has a built-in feature that detects when a plugin or theme causes a fatal error on your site, and notifies you with this automated email.

    In this case, WordPress caught an error with one of your plugins, MailPoet.

Viewing 15 replies - 1 through 15 (of 18 total)
1 2
  • JohnnyJ

    (@johnnyj)

    10 months, 2 weeks ago

    I have the same problem.

    For some reason, I can’t seem to disable automatic updates of the plugin, so I have disabled it for now. It’s no use to roll it back if it will just auto update a short while after…

    More information:

    Howdy!

WordPress has a built-in feature that detects when a plugin or theme causes a fatal error on your site, and notifies you with this automated email.

In this case, WordPress caught an error with one of your plugins, MailPoet.

First, visit your website (https://crmdevelopershowto.com/) and check for any visible issues. Next, visit the page where the error was caught (https://crmdevelopershowto.com/wp-admin/plugins.php?activate=true&plugin_status=all&paged=1&s=) and check for any visible issues.

Please contact your host for assistance with investigating this issue further.

If your site appears broken and you can't access your dashboard normally, WordPress now has a special "recovery mode". This lets you safely login to your dashboard and investigate further.

https://crmdevelopershowto.com/wp-login.php?action=enter_recovery_mode&rm_token=GH6yFDci3TRzPhVNrLDBDa&rm_key=ODJPHByW3QwuDnhfKO3eUI

To keep your site safe, this link will expire in 1 day. Don't worry about that, though: a new link will be emailed to you if the error occurs again after it expires.

When seeking help with this issue, you may be asked for some of the following information:
    WordPress version 6.3.1
    Active theme: KnowHow (version 1.1.20)
    Current plugin: MailPoet (version 4.27.0)
    PHP version 8.1.20 Error Details

An error of type E_ERROR was caused in line 30 of the file /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/exceptions.php. Error message: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name 'wp_crmdevelopershowto_com_mailpoet_statistics_woocommerce_purchases' in /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
    Stack trace: 0 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->query('ALTER TABLE     wp…', NULL) 1 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(14): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->doQuery('ALTER TABLEwp…', NULL) 2 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->query('ALTER TABLE wp…') 3 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrations/Db/Migration_20230824_054259_Db.php(33): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('ALTER TABLEwp…') 4 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrations/Db/Migration_20230824_054259_Db.php(23): MailPoet\Migrations\Db\Migration_20230824_054259_Db->createStatusColumn() 5 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Runner.php(38): MailPoet\Migrations\Db\Migration_20230824_054259_Db->run() 6 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Migrator.php(53): MailPoet\Migrator\Runner->runMigration('Migration_20230…', 'db') 7 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(78): MailPoet\Migrator\Migrator->run() 8 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate() 9 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(399): MailPoet\Config\Activator->activate() 10 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(310): MailPoet\Config\Initializer->maybeRunActivator('') 11 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters('', Array) 12 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 13 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-settings.php(632): do_action('init') 14 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-config.php(96): require_once('/www/webvol22/p…') 15 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-load.php(50): require_once('/www/webvol22/p…') 16 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/admin.php(34): require_once('/www/webvol22/p…') 17 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/plugins.php(10): require_once('/www/webvol22/p…') 18 {main}

Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name 'wp_crmdevelopershowto_com_mailpoet_statistics_woocommerce_purchases' in /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
    Stack trace: 0 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_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 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(14): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->doQuery('ALTER TABLE wp…', NULL) 2 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->query('ALTER TABLEwp…') 3 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrations/Db/Migration_20230824_054259_Db.php(33): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `wp…') 4 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrations/Db/Migration_20230824_054259_Db.php(23): MailPoet\Migrations\Db\Migration_20230824_054259_Db->createStatusColumn() 5 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Runner.php(38): MailPoet\Migrations\Db\Migration_20230824_054259_Db->run() 6 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Migrator.php(53): MailPoet\Migrator\Runner->runMigration('Migration_20230…', 'db') 7 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(78): MailPoet\Migrator\Migrator->run() 8 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate() 9 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(399): MailPoet\Config\Activator->activate() 10 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(310): MailPoet\Config\Initializer->maybeRunActivator('') 11 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters('', Array) 12 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 13 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-settings.php(632): do_action('init') 14 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-config.php(96): require_once('/www/webvol22/p…') 15 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-load.php(50): require_once('/www/webvol22/p…') 16 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/admin.php(34): require_once('/www/webvol22/p…') 17 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/plugins.php(10): require_once('/www/webvol22/p…') 18 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE <code>wp_crmdevelopershowto_com_mailpoet_statistics_woocommerce_purchases</code><br>ADD COLUMN <code>status</code> VARCHAR(40) NOT NULL DEFAULT 'unknown',<br>ADD INDEX <code>status</code> (<code>status</code>)':

SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name 'wp_crmdevelopershowto_com_mailpoet_statistics_woocommerce_purchases' in /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:102<br>Stack trace: 0 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/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 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/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 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/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), 'ALTER TABLE <code>wp…', Array) 3 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/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), 'ALTER TABLE</code>wp…', Array, Array) 4 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrations/Db/Migration_20230824_054259_Db.php(33): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `wp…') 5 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrations/Db/Migration_20230824_054259_Db.php(23): MailPoet\Migrations\Db\Migration_20230824_054259_Db->createStatusColumn() 6 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Runner.php(38): MailPoet\Migrations\Db\Migration_20230824_054259_Db->run() 7 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Migrator.php(53): MailPoet\Migrator\Runner->runMigration('Migration_20230…', 'db') 8 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(78): MailPoet\Migrator\Migrator->run() 9 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate() 10 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(399): MailPoet\Config\Activator->activate() 11 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(310): MailPoet\Config\Initializer->maybeRunActivator('') 12 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters('', Array) 13 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 14 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-settings.php(632): do_action('init') 15 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-config.php(96): require_once('/www/webvol22/p…') 16 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-load.php(50): require_once('/www/webvol22/p…') 17 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/admin.php(34): require_once('/www/webvol22/p…') 18 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/plugins.php(10): require_once('/www/webvol22/p…') 19 {main}

Next MailPoet\Migrator\MigratorException: Migration "MailPoet\Migrations\Db\Migration_20230824_054259_Db" failed. Details: An exception occurred while executing 'ALTER TABLE wp_crmdevelopershowto_com_mailpoet_statistics_woocommerce_purchases
    ADD COLUMN status VARCHAR(40) NOT NULL DEFAULT 'unknown',
    ADD INDEX status (status)':

SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name 'wp_crmdevelopershowto_com_mailpoet_statistics_woocommerce_purchases' in /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/exceptions.php:30
    Stack trace: 0 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/MigratorException.php(49): MailPoet\Exception::create(Object(MailPoetVendor\Doctrine\DBAL\Exception\DriverException)) 1 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Runner.php(42): MailPoet\Migrator\MigratorException::migrationFailed('MailPoet\Migrat…', Object(MailPoetVendor\Doctrine\DBAL\Exception\DriverException)) 2 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Migrator/Migrator.php(53): MailPoet\Migrator\Runner->runMigration('Migration_20230…', 'db') 3 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(78): MailPoet\Migrator\Migrator->run() 4 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate() 5 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(399): MailPoet\Config\Activator->activate() 6 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(310): MailPoet\Config\Initializer->maybeRunActivator('') 7 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters('', Array) 8 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 9 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-settings.php(632): do_action('init') 10 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-config.php(96): require_once('/www/webvol22/p…') 11 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-load.php(50): require_once('/www/webvol22/p…') 12 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/admin.php(34): require_once('/www/webvol22/p…') 13 /www/webvol22/pd/6pcg1yfxnjjwi9n/crmdevelopershowto.com/public_html/wp-admin/plugins.php(10): require_once('/www/webvol22/p…') 14 {main}

thrown
    • This reply was modified 10 months, 2 weeks ago by JohnnyJ.
    Plugin Support Gui A. a11n

    (@guicmazeredo)

    10 months, 2 weeks ago

    Hi @cannonfire and @johnnyj .

    I’m sorry to hear your are experiencing this issue. Our devs are already investigating it.

    Would you two please check if your DB has the table mailpoet_statistics_woocommerce_purchases?

    That information might help us determine the cause of the issue. Thanks!

    Thread Starter cannonfire

    (@cannonfire)

    10 months, 2 weeks ago

    Hello, haven’t used Woocommerce personally, but did find these 2 in DB:

    wpstg0_mailpoet_statistics_woocommerce_purchases
    wpww_mailpoet_statistics_woocommerce_purchases

    JohnnyJ

    (@johnnyj)

    10 months, 2 weeks ago

    I didn’t have any tables like that

    Would have attached a screen dump of all tables, but apparently, I can’t… 🙁

    • This reply was modified 10 months, 2 weeks ago by JohnnyJ.
    harusan

    (@harusan)

    10 months, 2 weeks ago

    Hi, I have a very similar problem. Yesterday the system sent me a message saying MailPoet is causing a fatal error and the site became inaccessible. Disabling MailPoet through recovery mode is temporarily saving the situation, but with imminent inconveniences. Will uninstalling and re-installing MailPoet helps? Then will the settings and the list of mail receivers be lost? Here is the message from the system.

    WordPress バーション6.3.1
    現在のテーマ: High Responsive (バージョン 2.2.1)
    現在のプラグイン: MailPoet (バージョン 4.27.0)
    PHP バージョン7.4.33

    エラー詳細
    ===============
    エラータイプ E_ERROR が /home/holmes/www/kc/wp-content/plugins/mailpoet/lib/exceptions.php ファイルの 30 行目で発生しました。 エラーメッセージ: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name ‘katsuragawaclub_wp3cab49mailpoet_statistics_woocommerce_purchases’ is too long in /home/holmes/www/kc/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
    Stack trace:
    #0 /home/holmes/www/kc/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->query(‘ALTER TABLE ka...')<br>#1 /home/holmes/www/kc/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(22): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->doQuery('ALTER TABLEka…’)
    #2 /home/holmes/www/kc/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(500): MailPoetVendor\Doctrine\DBAL\Driver\PDOConnection->query(‘ALTER TABLE `ka…’)
    #3 /home/holmes/www/kc/wp-content/plugins/mailpoet/lib/Migrations/Db/Migration_20230824_054259_Db.php(33): MailPoetVendor\Doctrin

    harusan

    (@harusan)

    10 months, 2 weeks ago

    Hi, @guicmazeredo

    As for your tables query,
    >Would you two please check if your DB has the >table mailpoet_statistics_woocommerce_purchases?

    There was no such line in my DB.

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    10 months, 2 weeks ago

    Thank you all for the reports and for checking your DBs.

    @johnnyj and @harusan we were able to determine the issue you are experiencing.

    To give you more details of the issue, this last release has a query to alter the table mailpoet_statistics_woocommerce_purchases and the fatal errors you are seeing indicate the table was not found. That could happen if the name of the table is truncated or if the table was not created in a previous migration for being too long (name of that table + the prefix). Usually, the table_name_length limit is 64 characters.

    It seems that both of you have a pretty lengthy table prefix wp_crmdevelopershowto_com and katsuragawaclub_wp3cab49, respectively, would not fit the 64 limit. So the table wasn’t created and couldn’t be found which resulted in the fatal error above. There are a couple of things cn be done here:

    A temporary fix
    If you are not using WooCommerce, you can mark the latest migration as complete in the migrations table. We will also modify the migration in the plugin in future releases so that it does not generate a fatal error.

    A permanent fix
    This one is better, especially if you think you may use WooCommerce someday. You’d need to follow these steps:

    • Make sure their backups are working and create a full backup
    • Change the prefix to something shorter
    • On table mailpoet_migrations , on the row with name Migration_20221028_105818 set completed_at to NULL
    • Deactivate and reactivate the plugin to rerun the migrations

    Let us know if you have any questions.

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    10 months, 2 weeks ago

    @cannonfire can you please send us PHP errors so you can get more clues on what’s happening in your case?

    Thread Starter cannonfire

    (@cannonfire)

    10 months, 2 weeks ago

    @guicmazeredo

    Here’s the error:

    An error of type E_ERROR was caused in line 49 of the file /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/persistence/src/Persistence/Mapping/RuntimeReflectionService.php. Error message: Uncaught ReflectionException: Property MailPoet\Entities\StatisticsWooCommercePurchaseEntity::$status does not exist in /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/persistence/src/Persistence/Mapping/RuntimeReflectionService.php:49
    Stack trace: 0 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/persistence/src/Persistence/Mapping/RuntimeReflectionService.php(49): ReflectionProperty->__construct(‘MailPoet\Entiti…’, ‘status’) 1 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php(1565): MailPoetVendor\Doctrine\Persistence\Mapping\RuntimeReflectionService->getAccessibleProperty(‘MailPoet\Entiti…’, ‘status’) 2 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataInfo.php(300): MailPoetVendor\Doctrine\ORM\Mapping\ClassMetadataInfo->getAccessibleProperty(Object(MailPoetVendor\Doctrine\Persistence\Mapping\RuntimeReflectionService), ‘MailPoet\Entiti…’, ‘status’) 3 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Mapping/ClassMetadataFactory.php(435): MailPoetVendor\Doctrine\ORM\Mapping\ClassMetadataInfo->wakeupReflection(Object(MailPoetVendor\Doctrine\Persistence\Mapping\RuntimeReflectionService)) 4 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php(106): MailPoetVendor\Doctrine\ORM\Mapping\ClassMetadataFactory->wakeupReflection(Object(MailPoetVendor\Doctrine\ORM\Mapping\ClassMetadata), Object(MailPoetVendor\Doctrine\Persistence\Mapping\RuntimeReflectionService)) 5 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/lib/Doctrine/TablePrefixMetadataFactory.php(35): MailPoetVendor\Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor(‘MailPoet\Entiti…’) 6 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(135): MailPoet\Doctrine\TablePrefixMetadataFactory->getMetadataFor(‘MailPoet\Entiti…’) 7 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(36): MailPoetVendor\Doctrine\ORM\EntityManager->getClassMetadata(‘MailPoet\Entiti…’) 8 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/generated/FreeCachedContainer.php(4360): MailPoet\Doctrine\Repository->__construct(Object(MailPoetVendor\Doctrine\ORM\EntityManager)) 9 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/generated/FreeCachedContainer.php(5134): MailPoetGenerated\FreeCachedContainer->getStatisticsWooCommercePurchasesRepositoryService() 10 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/generated/FreeCachedContainer.php(2264): MailPoetGenerated\FreeCachedContainer->getWooCommercePurchasesService() 11 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/generated/FreeCachedContainer.php(2254): MailPoetGenerated\FreeCachedContainer->getHooksWooCommerceService() 12 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/generated/FreeCachedContainer.php(2282): MailPoetGenerated\FreeCachedContainer->getHooks2Service() 13 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/symfony/dependency-injection/Container.php(122): MailPoetGenerated\FreeCachedContainer->getInitializerService() 14 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/vendor-prefixed/symfony/dependency-injection/Container.php(110): MailPoetVendor\Symfony\Component\DependencyInjection\Container->make(‘MailPoet\Config…’, 1) 15 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/lib/DI/ContainerWrapper.php(39): MailPoetVendor\Symfony\Component\DependencyInjection\Container->get(‘MailPoet\Config…’) 16 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/mailpoet_initializer.php(89): MailPoet\DI\ContainerWrapper->get(‘MailPoet\Config…’) 17 /nas/content/live/beermoneygd/wp-content/plugins/mailpoet/mailpoet.php(194): require_once(‘/nas/content/li…’) 18 /nas/content/live/beermoneygd/wp-settings.php(415): include_once(‘/nas/content/li…’) 19 /nas/content/live/beermoneygd/wp-config.php(127): require_once(‘/nas/content/li…’) 20 /nas/content/live/beermoneygd/wp-load.php(50): require_once(‘/nas/content/li…’) 21 /nas/content/live/beermoneygd/wp-admin/admin-ajax.php(22): require_once(‘/nas/content/li…’) 22 {main}

    thrown

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    10 months, 2 weeks ago

    Thanks for sending the error, @cannonfire

    Please contact us via https://www.mailpoet.com/support/sales-pre-sales-questions/ and include a link to this thread.

    We’ll be able to provide you with more information there.

    Cheers!

    Thread Starter cannonfire

    (@cannonfire)

    10 months, 2 weeks ago

    @guicmazeredo

    Understood, message sent.

    harusan

    (@harusan)

    10 months, 2 weeks ago

    Thanks @guicmazeredo for your support. Will you be more specific about the fixing process? Being a novice admin, it is tough to find out the solution all myself.

    A temporary fix
    If you are not using WooCommerce, you can mark the latest migration as complete in the migrations table. We will also modify the migration in the plugin in future releases so that it does not generate a fatal error.

    Plugin Support kellymetal a11n

    (@kellymetal)

    10 months, 1 week ago

    Hi there @harusan,

    Will you be more specific about the fixing process? Being a novice admin, it is tough to find out the solution all myself.

    To mark the migration as complete, you would need to go into your site’s *_mailpoet_migrations database table and add a date in the completed_at column for that most recent migration row.

    Please note, if you are unsure about accessing or making changes in your site’s database directly, we would strongly recommend working with your hosting support to do this — accidentally making random edits in the database could cause other issues for the site. Also, please make sure you have a complete backup first just in case.

    JohnnyJ

    (@johnnyj)

    10 months, 1 week ago

    @kellymetal : My experience was that there was already a date in the completed_at column, but that I had to clear the error message column.
    Could be just my scenario, though?!?!
    I also reset a column with an attempt count to 0 or 1, can’t remember…

    • This reply was modified 10 months, 1 week ago by JohnnyJ.
    joesoes

    (@joesoes)

    10 months, 1 week ago

    Just changing the completed_at column did not solve the issue, I had to set the count to 0 as well, then it started to work again.

Viewing 15 replies - 1 through 15 (of 18 total)
1 2
  • The topic ‘4.27 critical error’ is closed to new replies.