ERREUR

  • Resolved duretlaurent

    (@duretlaurent)


    2 years, 4 months ago

    Bonjour,
    ci-dessous le code d’erreur.
    J’utisite mailpoet depuis des années.
    Merci par avance pour votre aide.

    Erreur MailPoet : PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
Stack trace:
#0 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute(NULL)
#1 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('SELECT t0.name ...', Array, Array)
#3 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#4 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
#5 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy(Array)
#6 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Populator.php(351): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#7 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Populator.php(171): MailPoet\Config\Populator->createDefaultSegment()
#8 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Activator.php(79): MailPoet\Config\Populator->up()
#9 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate()
#10 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Initializer.php(334): MailPoet\Config\Activator->activate()
#11 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Initializer.php(291): MailPoet\Config\Initializer->maybeDbUpdate()
#12 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('')
#13 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
#14 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#15 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-settings.php(617): do_action('init')
#16 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-config.php(101): require_once('/home/clients/6...')
#17 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-load.php(50): require_once('/home/clients/6...')
#18 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-admin/admin.php(34): require_once('/home/clients/6...')
#19 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-admin/plugins.php(10): require_once('/home/clients/6...')
#20 {main}

Next MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
Stack trace:
#0 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(61): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('SELECT t0.name ...', Array, Array)
#3 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#4 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
#5 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy(Array)
#6 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Populator.php(351): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#7 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Populator.php(171): MailPoet\Config\Populator->createDefaultSegment()
#8 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Activator.php(79): MailPoet\Config\Populator->up()
#9 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate()
#10 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Initializer.php(334): MailPoet\Config\Activator->activate()
#11 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Initializer.php(291): MailPoet\Config\Initializer->maybeDbUpdate()
#12 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('')
#13 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
#14 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#15 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-settings.php(617): do_action('init')
#16 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-config.php(101): require_once('/home/clients/6...')
#17 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-load.php(50): require_once('/home/clients/6...')
#18 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-admin/admin.php(34): require_once('/home/clients/6...')
#19 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-admin/plugins.php(10): require_once('/home/clients/6...')
#20 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.average_engagement_score AS average_engagement_score_4, t0.average_engagement_score_updated_at AS average_engagement_score_updated_at_5, t0.display_in_manage_subscription_page AS display_in_manage_subscription_page_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM wp_mailpoet_segments t0 WHERE t0.type = ? LIMIT 1' with params ["wp_users"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
Stack trace:
#0 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/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/clients/635b952a4801e26b05fae43e0b8d002d/oreille/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/clients/635b952a4801e26b05fae43e0b8d002d/oreille/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), 'SELECT t0.name ...', Array)
#3 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/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), 'SELECT t0.name ...', Array, Array)
#4 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery('SELECT t0.name ...', Array, Array)
#5 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#6 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
#7 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(55): MailPoet\Doctrine\Repository->findOneBy(Array)
#8 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Populator.php(351): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
#9 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Populator.php(171): MailPoet\Config\Populator->createDefaultSegment()
#10 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Activator.php(79): MailPoet\Config\Populator->up()
#11 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Activator.php(59): MailPoet\Config\Activator->processActivate()
#12 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Initializer.php(334): MailPoet\Config\Activator->activate()
#13 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-content/plugins/mailpoet/lib/Config/Initializer.php(291): MailPoet\Config\Initializer->maybeDbUpdate()
#14 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/class-wp-hook.php(308): MailPoet\Config\Initializer->initialize('')
#15 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters(NULL, Array)
#16 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
#17 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-settings.php(617): do_action('init')
#18 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-config.php(101): require_once('/home/clients/6...')
#19 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-load.php(50): require_once('/home/clients/6...')
#20 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-admin/admin.php(34): require_once('/home/clients/6...')
#21 /home/clients/635b952a4801e26b05fae43e0b8d002d/oreille/wp-admin/plugins.php(10): require_once('/home/clients/6...')
#22 {main}
Viewing 6 replies - 1 through 6 (of 6 total)

  • Same error occurred on one of my Mailpoet installations this morning. I’ve got Mailpoet running on 2 other sites and they’re fine. I tried reinstalling, no help.

    Thread Starter duretlaurent

    (@duretlaurent)

    Thank you.
    All my sites out.
    I’m looking for another solution.

    Plugin Author MailPoet

    (@mailpoet)

    Hello,

    We’re very sorry for your inconvenience. We’ve identified an issue that may occur in some cases when multiple WordPress installations with MailPoet are sharing a single MySQL instance. We’ve resolved the issue, and the fix will be included in the upcoming release next week.

    In the meantime, we recommend downgrading to MailPoet 4.0.0 by downloading the plugin from the following URL: https://downloads.www.ads-software.com/plugin/mailpoet.4.0.0.zip

    Once again, apologies for your inconvenience. We hope this workaround resolves your issues.

    Best,
    Jan

    Thread Starter duretlaurent

    (@duretlaurent)

    Merci beaucoup pour votre réponse.
    Tout est ok maintenant.
    Bon week-end.
    Laurent

    Thanks Mailpoet!

    Plugin Author MailPoet

    (@mailpoet)

    Hello,

    We released version 4.1.0, which contains a fix for this issue.

    Once again, apologies for your inconvenience.

    Best,
    Rosta

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘ERREUR’ is closed to new replies.