Unknown column ‘t0.display_in_manage_subscription_page’

  • Resolved asle

    (@asle)


    1 year, 8 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)

    1 year, 8 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 1 year, 8 months ago by asle.
    • This reply was modified 1 year, 8 months ago by asle.
    • This reply was modified 1 year, 8 months ago by asle.
    Plugin Author MailPoet

    (@mailpoet)

    1 year, 8 months ago

    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.wordpress.org/plugin/mailpoet.4.0.0.zip

    I’ve seen that, as a hotfix, you’ve added the missing column. However, that will not migrate the default values for that column, in case you have some. To be sure to have that fixed, you may delete the column before the next plugin update once we release the fix.

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

    Best,
    Jan

    born2webdesign

    (@born2webdesign)

    1 year, 8 months ago

    As mentioned in other threads (https://wordpress.org/support/topic/fatal-error-with-wordpress-6-1-1/, https://wordpress.org/support/topic/big-issue-afer-install-4-01/), this definitely happens on installations with separate databases, too!
    Will it still be safe to upgrade to 4.0.2, once that is released?

    Plugin Author MailPoet

    (@mailpoet)

    1 year, 8 months ago

    Hello,

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

    Once again, apologies for your inconvenience.

    Best,
    Rosta

    Thread Starter asle

    (@asle)

    1 year, 8 months ago

    I tried to delete the column and upgrade to 4.1.0. I got a critical error. Also tried to deactivate Mailpoet 4.1.0 and activate again. This should install the missing column? It did not.

    Now I added the column manually again in SQL like earlier and the error is gone. So it it did not help to remove the column and wait for the new version.

    • This reply was modified 1 year, 8 months ago by asle.
    born2webdesign

    (@born2webdesign)

    1 year, 8 months ago

    Thanks – though returning to the plugins page after the plugin upgrades (only MP and MP Premium, from 4.0 to 4.1), I got the “WP not quite white screen of death”, but on reloading /wp-admin/ it _seemed_ to be OK again … I _hope_ it stays that way, though a bit more certainty would feel better 😉

    mauryg

    (@mauryg)

    1 year, 7 months ago

    I just ran into the same problem. I upgraded MailPoet to v4.3.0 and it broke. Tried to use the PHPMySQL fix on the table, but no success. Downloaded MailPoet v4.0.0 and everything worked fine. Updated to v4.3.0 and it broke.

    Any hope of getting a real fix?

    Thread Starter asle

    (@asle)

    1 year, 7 months ago

    See my response above. MailPoet 4.1 crashed. I had to rerun the sql to create the field. Then it worked. Later I have upgraded and am now running 4.3.0 fine. Seems the field is not created on upgrade. Try my approach.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Unknown column ‘t0.display_in_manage_subscription_page’’ is closed to new replies.