• Resolved jd-fb

    (@jd-fb)


    I currently have MailPoet running on WordPress multisite. On one of the sites (the main domain name where the other sites are held), I try to add a subscriber but I get a simple error message. (A simple “Cannot save” type of notice.)

    I can’t add subscribers either using the Dashboard back-end or the front-end.

    Also, when I go to the MailPoet > Subscriber screen, the counter at the top says All(3) Subscribers(3) (which I believe represents the subscribers I added a while ago for testing), but the table itself is empty.

    I’ve checked these forums, and the only way I’ve seen to fix this is to contact the MailPoet team. Their website points me back to here…

    Can somebody point me in the right direction to fix this?

    My current system info:
    MailPoet 2.6.16
    WordPress 4.2.2, running on Multisite
    WP Theme: Customizer
    MySQL 5.6.23-log
    PHP 5.4.43

    https://wordpress.org/plugins/wysija-newsletters/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Try disabling all your other plugins temporarily and then try to add a subscriber again. Or try to switch your theme to a default WordPress theme (2011, 2012..), something is creating a conflict with your MailPoet that is preventing it to properly work. You will just have to find out who is the culprit for that.

    Thread Starter jd-fb

    (@jd-fb)

    No success…

    I’ve tried changing themes from Customizr to Twenty Fifteen and Twenty Twelve.

    I de-activated all plug-ins running on the site specifically, and that didn’t work.

    I also de-activated most of the “Network Activated” plug-ins, running on all the sites on multi-site, and that didn’t work. Exception, I didn’t turn off these ones, because I didn’t want to make the various sites go “ka-blooey”:

    • WordPress MU Domain Mapping
    • sunrise.php (running as a drop-in’

    Is there anything else I can try?

    Thread Starter jd-fb

    (@jd-fb)

    Here’s an update:
    – I set MailPoet > Settings > Advanced Settings > Geeky Options > Debug Mode, to +safe PHP.

    I get a Wysija query error:

    $mixed (array)
    query: INSERT INTO <code>wpjbd_wysija_user</code> (<code>email</code>, <code>firstname</code>, <code>lastname</code>, <code>status</code>, <code>ip</code>, <code>created_at</code>, <code>keyuser</code>, <code>domain</code>) VALUES ('test@bureaudisco.com', 'JD', 'test', 1, '142.###.###.###', '1437089686', '604acb4b6536cadc7fbc3d3af6ca1e2f', 'bureaudisco.com')
    
    error: Unknown column 'domain' in 'field list'

    (The ### signs above are my IP address.)

    Does this help?

    It does, you have run into a problem while updating some older versions of MailPoet.

    Can you please install MailPoet on a test website, and check its database. Look at the table wysija_user, check the way that domain column is created. Then manually add that column to your faulty installation, it should work.

    Thread Starter jd-fb

    (@jd-fb)

    This worked!

    I added the “domain” column, and then ran into additional problems when viewing the “Subscribers” page. I repeated the process with the “confirmed_at”, “confirmed_ip”, “last_opened” and “last_clicked” columns, and it all appears to work now.

    Is there anything I can do to prevent this issue in the future?

    (My original issue is resolved, but I’ll leave this open for a bit, to see if there’s an answer to my question about preventing this in the future.)

    Unfortunately we’ve tried to fix this update issue, but looks like we couldn’t completely get around it. We hope it doesn’t show up again for you. Sorry about that!

    Thread Starter jd-fb

    (@jd-fb)

    Thanks for confirming, MailPoet folks. May the Force be with you to solve this little bug 🙂

    (Side note: I envjoy using your plug-in! Works quite well.)

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Unable to add subscribers’ is closed to new replies.