Popup Maker’s Subscription problem

  • Resolved atzimpourdakas

    (@atzimpourdakas)


    5 years, 10 months ago

    I have added a popups maker subscription form, all seems to be good. Subscription seems to be successful. But subscribers is not saved. I checked database and there is not a pum_subscribers table.

    Please help

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Maria T

    (@mariatogonon)

    5 years, 10 months ago

    Hello @atzimpourdakas – thanks for writing in and apologies for the inconvenience.

    Please be advised that ​the Popup Maker -> Subscribers section only applies when using our own Subscription Forms via the Popup Maker toolbar button.
    ​
    ​May I ask, did you set the Service Provider to Default as stated from this documentation? The ‘Subscription Form’ Box Option Settings

    If that helps, then we would very much appreciate it if you could quickly rate the plugin, just to help us spread the word.

    Otherwise, for us to assist you further with your issue, you will need to escalate it directly to our HelpScout support desk. Check out this link: https://wppopupmaker.com/support/ Thank you.

    Thread Starter atzimpourdakas

    (@atzimpourdakas)

    5 years, 10 months ago

    Yes I use popup makers subscription form via the popup maker toolbar button.

    Yes I have set the Service Provider to “Default”.

    And I have tried popup maker on two different wordpress sites.

    The plugin works fine, but subscribers are not saved and pum_subscribers table doesnt exist on my databases.

    Thanks

    Plugin Author Daniel Iser

    (@danieliser)

    5 years, 9 months ago

    @atzimpourdakas – Sorry for the delay. We have found this is not related to our plugin specifically,other plugins reporting similar issues and are trying to collect information that may be helpful. The only pattern we have discerned thus far is that sites running MySQL 5.7 specifically seem to be the only ones we see affected, but only in rare occassions..

    Alternatively the other possible issue is you set everything up on a staging site, then cloned the site + WP core db tables to the live server. Since we store the db table versions in WP options table, if you did that and didn’t copy the table that was already created on your staging site, our script wouldn’t know it wasn’t installed on the live site and would just try to insert new submissions.

    Please email us directly if you haven’t already and feel free to reference this topic if you feel you have more info that may be helpful: https://wppopupmaker.com/support/.

    poffer

    (@poffer)

    5 years, 9 months ago

    Hi,

    I also have the exact problem as atzimpourdakas. I am running MySQL 5.7.31. In the meantime we cannot do anything more than to wait for a bug fix regarding this?

    Thanks,
    Cristoffer
    Ohbabyposter.se

    • This reply was modified 5 years, 9 months ago by poffer.
    Thread Starter atzimpourdakas

    (@atzimpourdakas)

    5 years, 8 months ago

    I am sorry for my late reply, but I am too busy last month.

    The solution that I have found with author help of course, is to create manually the pum_subscribers table.
    I run this in mysql
    —————————
    CREATE TABLE XXXXXXXXX_pum_subscribers ( ID bigint(20) NOT NULL AUTO_INCREMENT, email_hash varchar(32) NOT NULL, popup_id bigint(20) NOT NULL, user_id bigint(20) NOT NULL, email varchar(191) NOT NULL, name varchar(255) NOT NULL, fname varchar(255) NOT NULL, lname varchar(255) NOT NULL,

    (add here a backtick) values (add here a backtick)

    longtext NOT NULL, uuid varchar(255) NOT NULL, consent varchar(255) NOT NULL, consent_args longtext NOT NULL, created datetime NOT NULL, PRIMARY KEY (ID), KEY email (email), KEY user_id (user_id), KEY popup_id (popup_id), KEY email_hash (email_hash) ) DEFAULT CHARACTER
    SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ——————————————
    The only difference with plugin is the word values needs backticks
    and of course change the XXXXXXXXX_pum_subscribers to YOURPREFIX_pum_subscribers

    They use a column with name “values” but my database says that it is sql’s reserved word and it needs backtick.

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

The topic ‘Popup Maker’s Subscription problem’ is closed to new replies.