Problem suddenly appeared

  • Resolved rabox66

    (@rabox66)


    7 months, 1 week ago

    Hi,
    I am asking for a client that experienced suddenly problems. After doing preparing a new newsletter in the backend MP does not work anymore. The whole site is broken, I had to deactivate the plugin. He also has no more access to the PRO-Version, therefore I cannot retrieve his license. He does not remember his login to PRO. Sorry. ??

    I deactivated all other plugins and activated the twentytwentyfour theme. PHP was updated (WAS: 7.4, IS: 8.1) The problem still remains.

    There seems to be a bug in the database. How can I fix that?

    I am glad about any ideas. Thanks!
    Raphael

    Here is the information that MP displays:
    MailPoet Fehler: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.display_in_manage_subscription_page’ in ‘field list’ in /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
    Stack trace:
    #0 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute()
    #1 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
    #2 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
    #3 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load()
    #4 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
    #5 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(76): MailPoet\Doctrine\Repository->findOneBy()
    #6 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Populator.php(359): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #7 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Populator.php(175): MailPoet\Config\Populator->createDefaultSegment()
    #8 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #9 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #10 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Initializer.php(430): MailPoet\Config\Activator->activate()
    #11 /usr/www/users/atemkw/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator()
    #12 /usr/www/users/atemkw/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
    #13 /usr/www/users/atemkw/wp-includes/plugin.php(517): WP_Hook->do_action()
    #14 /usr/www/users/atemkw/wp-settings.php(695): do_action()
    #15 /usr/www/users/atemkw/wp-config.php(155): require_once(‘/usr/www/users/…’)
    #16 /usr/www/users/atemkw/wp-load.php(50): require_once(‘/usr/www/users/…’)
    #17 /usr/www/users/atemkw/wp-admin/admin.php(34): require_once(‘/usr/www/users/…’)
    #18 {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 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:10
    Stack trace:
    #0 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(61): MailPoetVendor\Doctrine\DBAL\Driver\PDO\Exception::new()
    #1 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
    #2 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
    #3 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load()
    #4 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
    #5 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(76): MailPoet\Doctrine\Repository->findOneBy()
    #6 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Populator.php(359): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #7 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Populator.php(175): MailPoet\Config\Populator->createDefaultSegment()
    #8 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #9 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #10 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Initializer.php(430): MailPoet\Config\Activator->activate()
    #11 /usr/www/users/atemkw/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator()
    #12 /usr/www/users/atemkw/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
    #13 /usr/www/users/atemkw/wp-includes/plugin.php(517): WP_Hook->do_action()
    #14 /usr/www/users/atemkw/wp-settings.php(695): do_action()
    #15 /usr/www/users/atemkw/wp-config.php(155): require_once(‘/usr/www/users/…’)
    #16 /usr/www/users/atemkw/wp-load.php(50): require_once(‘/usr/www/users/…’)
    #17 /usr/www/users/atemkw/wp-admin/admin.php(34): require_once(‘/usr/www/users/…’)
    #18 {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 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:59
    Stack trace:
    #0 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(77): MailPoetVendor\Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
    #1 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(65): MailPoetVendor\Doctrine\DBAL\DBALException::wrapException()
    #2 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(936): MailPoetVendor\Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
    #3 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(503): MailPoetVendor\Doctrine\DBAL\Connection->handleExceptionDuringQuery()
    #4 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
    #5 /usr/www/users/atemkw/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendor\Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load()
    #6 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Doctrine/Repository.php(69): MailPoetVendor\Doctrine\ORM\EntityRepository->findOneBy()
    #7 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Segments/SegmentsRepository.php(76): MailPoet\Doctrine\Repository->findOneBy()
    #8 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Populator.php(359): MailPoet\Segments\SegmentsRepository->getWPUsersSegment()
    #9 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Populator.php(175): MailPoet\Config\Populator->createDefaultSegment()
    #10 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Activator.php(80): MailPoet\Config\Populator->up()
    #11 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Activator.php(60): MailPoet\Config\Activator->processActivate()
    #12 /usr/www/users/atemkw/wp-content/plugins/mailpoet/lib/Config/Initializer.php(430): MailPoet\Config\Activator->activate()
    #13 /usr/www/users/atemkw/wp-includes/class-wp-hook.php(324): MailPoet\Config\Initializer->maybeRunActivator()
    #14 /usr/www/users/atemkw/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
    #15 /usr/www/users/atemkw/wp-includes/plugin.php(517): WP_Hook->do_action()
    #16 /usr/www/users/atemkw/wp-settings.php(695): do_action()
    #17 /usr/www/users/atemkw/wp-config.php(155): require_once(‘/usr/www/users/…’)
    #18 /usr/www/users/atemkw/wp-load.php(50): require_once(‘/usr/www/users/…’)
    #19 /usr/www/users/atemkw/wp-admin/admin.php(34): require_once(‘/usr/www/users/…’)
    #20 {main}

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Dani F. a11n

    (@danielinhou)

    Hi there @rabox66 ????!

    Thank you for reaching out to MailPoet Support!

    Can you try the solution proposed in this article: How to Fix General Error: 2006 MySQL Server has Gone Away

    Cheers!

    Thread Starter rabox66

    (@rabox66)

    Hi, thanks for the answer, but it does not help. ??

    The support of the hosting says, that I cannot change those informations as you suggested. The support suggested to reinstall the plugin. But that does not change the problem either.

    As the plugin completely destroys the frontend while it is activated, I cannot use it at all.

    The problem also remains, if all other plugins are deactivated and the theme twentytwentyfour is used.

    Sorry,. As far as I can see, I cannot use MP anymore. ??

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    Hi there,

    I’m sorry to hear the issue persists.

    The support of the hosting says, that I cannot change those informations as you suggested. The support suggested to reinstall the plugin. But that does not change the problem either.

    When you tried to re-install the plugin, did you do it via FTP as per these instructions. If not, can you give it a try?

    Thread Starter rabox66

    (@rabox66)

    Thanks for the answer. I installed it directly from the repository. Does it make a difference, if I install it via FTP? If so, I caqn try that.

    Plugin Support Dani F. a11n

    (@danielinhou)

    Hi again,

    Does it make a difference, if I install it via FTP? If so, I caqn try that.

    That would be great. Please give it a try and keep us posted afterward.

    Best

    Thread Starter rabox66

    (@rabox66)

    OK, I uploaded the plugin via FTP and there was no change. The problem remains. Sorry. It seems to be a problem of the database, not of the plugin itself.

    Plugin Support Dani F. a11n

    (@danielinhou)

    Hi again, thanks for giving that a try.

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

    Your request will be triaged accordingly when we receive it and we’ll be able to provide you with more information there.

    Cheers

    Thread Starter rabox66

    (@rabox66)

    Hi, I could find the bug. It is more than strange. ?? The website used Mailpoet PRO (or at least had it installed and activated) but had no licence. That is why the site owner did not know his login to the account. Very strange.

    I am happy that the problem is resolved. But please tell me one thing: How can he have the PRO-Plugin installed without having a licence? Does that mean, that he had a licence once, but it is now outdated?

    Thanks

    Raphael

    Thread Starter rabox66

    (@rabox66)

    Hi,
    it is stranger than strange. Today the error is back. I really have no idea what to so. I will now do as Dani F. a11n suggested.

    Thanks

    Plugin Support Dani F. a11n

    (@danielinhou)

    Hi @rabox66 ????

    How can he have the PRO-Plugin installed without having a licence?

    Yes, some of our legacy-free plans allowed users to install the MailPoet Premium version too. That’s good because they will allow the users with these plans to use the MailPoet Premium features. But it doesn’t mean they can access Premium support.
    ?
    As I said, we’ll contact you via email
    ?
    Best

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Problem suddenly appeared’ is closed to new replies.