MailPoet Error: PDOException: SQLSTATE[*****]

  • ZAAAX

    (@stevenjram)


    7 months, 1 week ago

    Ok, so this is new as of today ….

    MailPoet Error:?PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '***************_mailpoet_subscriber_segment' doesn't exist in /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/PDO/Connection.php:26
    Stack trace:
    #0 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/PDO/Connection.php(26): PDO->exec('INSERT IGNORE I...')
    #1 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(473): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Connection->exec('INSERT IGNORE I...')
    #2 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/lib/Doctrine/SerializableConnection.php(70): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement('INSERT IGNORE I...', Array, Array)
    #3 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(399): MailPoet\Doctrine\SerializableConnection->executeStatement('INSERT IGNORE I...')
    #4 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(266): MailPoet\Segments\WP->insertUsersToSegment()
    #5 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(365): MailPoet\Segments\WP->synchronizeUsers()
    #6 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(175): MailPoet\Config\Populator->createDefaultSegment()
    #7 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #8 /home/customer/www/***********/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #9 /home/customer/www/zaaax.com.au/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(445): MailPoet\Config\Activator->activate()
    #10 /home/customer/www/zaaax.com.au/public_html/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator('')
    #11 /home/customer/www/zaaax.com.au/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array)
    #12 /home/customer/www/**mydomainname/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #13 /home/customer/www/**mydomainname/public_html/wp-settings.php(700): do_action('init')
    #14 /home/customer/www/**mydomainname/public_html/wp-config.php(94): require_once('/home/customer/...')
    #15 /home/customer/www/**mydomainname/public_html/wp-load.php(50): require_once('/home/customer/...')
    #16 /home/customer/www/**mydomainname/public_html/wp-admin/admin.php(34): require_once('/home/customer/...')
    #17 /home/customer/www/**mydomainname/public_html/wp-admin/plugins.php(10): require_once('/home/customer/...')
    #18 {main}

    Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbwcccjuyh3gpr.nh3m7bf6a_mailpoet_subscriber_segment' doesn't exist in /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/PDO/Exception.php:18
    Stack trace:
    #0 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/PDO/Connection.php(30): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
    #1 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(473): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Connection->exec('INSERT IGNORE I...')
    #2 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Doctrine/SerializableConnection.php(70): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement('INSERT IGNORE I...', Array, Array)
    #3 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(399): MailPoet\Doctrine\SerializableConnection->executeStatement('INSERT IGNORE I...')
    #4 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(266): MailPoet\Segments\WP->insertUsersToSegment()
    #5 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(365): MailPoet\Segments\WP->synchronizeUsers()
    #6 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(175): MailPoet\Config\Populator->createDefaultSegment()
    #7 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #8 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #9 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(445): MailPoet\Config\Activator->activate()
    #10 /home/customer/www/**mydomainname/public_html/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator('')
    #11 /home/customer/www/**mydomainname/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array)
    #12 /home/customer/www/**mydomainname/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #13 /home/customer/www/**mydomainname/public_html/wp-settings.php(700): do_action('init')
    #14 /home/customer/www/**mydomainname/public_html/wp-config.php(94): require_once('/home/customer/...')
    #15 /home/customer/www/**mydomainname/public_html/wp-load.php(50): require_once('/home/customer/...')
    #16 /home/customer/www/**mydomainname/public_html/wp-admin/admin.php(34): require_once('/home/customer/...')
    #17 /home/customer/www/**mydomainname/public_html/wp-admin/plugins.php(10): require_once('/home/customer/...')
    #18 {main}

    Next MailPoetVendor\Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbwcccjuyh3gpr.nh3m7bf6a_mailpoet_subscriber_segment' doesn't exist in /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:37
    Stack trace:
    #0 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(821): MailPoetVendor\Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception), Object(MailPoetVendor\Doctrine\DBAL\Query))
    #1 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(793): MailPoetVendor\Doctrine\DBAL\Connection->handleDriverException(Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception), Object(MailPoetVendor\Doctrine\DBAL\Query))
    #2 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(475): MailPoetVendor\Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception), 'INSERT IGNORE I...', Array, Array)
    #3 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Doctrine/SerializableConnection.php(70): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement('INSERT IGNORE I...', Array, Array)
    #4 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(399): MailPoet\Doctrine\SerializableConnection->executeStatement('INSERT IGNORE I...')
    #5 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Segments/WP.php(266): MailPoet\Segments\WP->insertUsersToSegment()
    #6 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(365): MailPoet\Segments\WP->synchronizeUsers()
    #7 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Populator.php(175): MailPoet\Config\Populator->createDefaultSegment()
    #8 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #9 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #10 /home/customer/www/**mydomainname/public_html/wp-content/plugins/mailpoet/lib/Config/Initializer.php(445): MailPoet\Config\Activator->activate()
    #11 /home/customer/www/**mydomainname/public_html/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator('')
    #12 /home/customer/www/**mydomainname/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array)
    #13 /home/customer/www/**mydomainname/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #14 /home/customer/www/**mydomainname/public_html/wp-settings.php(700): do_action('init')
    #15 /home/customer/www/**mydomainname/public_html/wp-config.php(94): require_once('/home/customer/...')
    #16 /home/customer/www/**mydomainname/public_html/wp-load.php(50): require_once('/home/customer/...')
    #17 /home/customer/www/**mydomainname/public_html/wp-admin/admin.php(34): require_once('/home/customer/...')
    #18 /home/customer/www/**mydomainname/public_html/wp-admin/plugins.php(10): require_once('/home/customer/...')
    #19 {main}

    So what would this be then?

    Anyone with an idea please drop a line.

    Thank you, have a beaut day.

    The page I need help with: [log in to see the link]

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

    (@geraltrivia)

    Hello there @stevenjram ,

    These types of?errors are most often caused by either missing or corrupted files, which can happen if there’s some type of glitch while updating WordPress plugins/themes and something doesn’t go as expected.

    From the error you shared with us, it appears the “_mailpoet_subscriber_segment“table wasn’t created successfully.

    I can also see that it’s trying to search for this table by using your database prefix + the table name: “dbwcccjuyh3gpr.nh3m7bf6a_mailpoet_subscriber_segment”

    As a first step here, I’d recommend re-installing the plugin and then checking to see if the issue is resolved. You can remove the plugin and re-install it from your admin dashboard’s Plugins page, or alternatively we have a guide for re-installing via FTP here:

    Re-installing / Updating the Plugin via FTP

Viewing 1 replies (of 1 total)
  • The topic ‘MailPoet Error: PDOException: SQLSTATE[*****]’ is closed to new replies.