Unknown column ‘t0.display_in_manage_subscription_page’

  • Resolved asle

    (@asle)


    2 years, 5 months ago

    Mailpoet 4.0.1 and Mailpoet Premium 4.0.0
    Will not load and displays a long error about missing:

    PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.display_in_manage_subscription_page' in 'field list' in /var/www/biofokus/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59

    How do I fix it?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter asle

    (@asle)

    2 years, 5 months ago

    I fixed this myself. For any other frustrated users -> There is a migration file in
    mailpoet/lib/Migrations/Migration_20221108_140545.php

    This is supposed to check for the field and add it but it did not;
    // Add display_in_manage_subscription_page column in case it doesn't exist

    So I found the table “*prefix*_mailpoet_segments” which in my case was:
    wp_mailpoet_segments

    I ran this in mysql (You could do it in phpMyAdmin and use your own prefix of course)

    ALTER TABLE wp_mailpoet_segments
ADD display_in_manage_subscription_page tinyint(1) NOT NULL DEFAULT 0

    Voila, no more errors 🙂

    • This reply was modified 2 years, 5 months ago by