Popup Maker’s Subscription problem

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.

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

@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/.

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 4 years, 6 months ago by poffer.

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.

• This reply was modified 4 years, 6 months ago by atzimpourdakas.
• This reply was modified 4 years, 6 months ago by atzimpourdakas.
• This reply was modified 4 years, 6 months ago by atzimpourdakas.