Can not edit subscriber

  • Resolved sofa1at

    (@sofa1at)


    2 years, 9 months ago

    Hi,

    since the update from MailPoet2 to 3 im unable to edit subscribers. When i click the “Edit” link under the subscriber it starts to redirect to the Edit-Page, but forwards me automatically back to the subscriber list (Without any error).

    But in the developer console i get this error

    Object { error: "bad_request", message: "An exception occurred while executing 'SELECT t0.source AS source_1, t0.meta AS meta_2, t0.method AS method_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.newsletter_id AS newsletter_id_6, t0.queue_id AS queue_id_7, t0.subscriber_id AS subscriber_id_8 FROM myprefix_mailpoet_statistics_unsubscribes t0 WHERE t0.subscriber_id = ? ORDER BY t0.created_at DESC' with params [471]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.method' in 'field list'" }

    It seems that the column method is missing in the mailpoet_statistics_unsubscribes table. But i have no idea how to fix that, since i don’t know whats the purpose or default content for this column.

    How can i fix that?

    with best regards,
    Chris

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Bruna a11n

    (@bruberries)

    2 years, 9 months ago

    Hi @sofa1at,

    This seems to be a migrating issue. We’ve seen a couple of similar reports and the team is already working on a fix to prevent this from happening.

    In your case, we suggest deactivating and reactivating the plugin in the WordPress > Plugins page (yes, the good old “turn it off and on again”!).

    Let us know if it does the trick!

    Thread Starter sofa1at

    (@sofa1at)

    2 years, 9 months ago

    Hi @bruberries,

    I tried it with your deactivate and active approach, but it doesn’t fixed the issue. I look forward to your fix. Could you let me know if there are any updates for that issue?

    Plugin Author Bruna a11n

    (@bruberries)

    2 years, 9 months ago

    Hi @sofa1at,

    In this case, you’ll need to manually run the query to add the missing column to the table:

    ALTER TABLE wp_mailpoet_statistics_unsubscribes ADD method varchar(40) NOT NULL DEFAULT ‘unknown’

    Please check the table prefix used in your installation first and change the query above accordingly if you are using something other than wp_.

    You can run this query by installing any database plugin, such as WP phpMyAdmin. Let me know how it goes!

    Thread Starter sofa1at

    (@sofa1at)

    2 years, 9 months ago

    Hi @bruberries ,

    Thank you very much for this sql statement, it fixed the issue.

    Now we are able again to change the subscribers without any problem.

    with best regards,
    Chris

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Can not edit subscriber’ is closed to new replies.