SQL query hanging, locking up php threads until site fails

[peteloaf]

Hi – o’ve tried to raise this on your support section of the plugin website but haven’t received an answer or an email confirmation of submitting my ticket.

I’m using popupmaker with the advanced targeting conditions extension. We use the combo on several sites and were looking to roll it out to more until this issue came up.
On lower traffic sites this isn’t noticeable but on some of our higher traffic sites, what happens is an SQL query i believe is coming form your plugin doesn’t complete- each time this happens it locks up a php thread until eventually the site falls over and starts serving 503 errors. The server has been upgraded to a high-end nginx solution, and caching + cloudflare are active
I’ve tried turning off the popup view count analytics and checking the ‘avoid menu conflicts’ option . SQL dump below- i can provide system report text and SQL dump if required, preferably privately so as not to disclose any DB info on public forums.
Thanks,
Pete

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

[peteloaf]

NB- to add some context, as i’ve found another support thread where you advised that loading content like videos in a popup means they load on every page rather than just where popup are active- we’re running two popups, as follows:
1: a standard popup loading across the site, serving a notice about cookies, with a normal trigger and close trigger, containing only text and some links. 2: a popup containing a subscription form which has an inline script call to the google recaptcha api and Js library. This popup also uses a custom Javascript trigger to close it on form submission, and uses the advanced targeting conditions extension to hide it from people with a specific referer (this is to stop existing subscribers seeing the popup when coming via the email newsletter)
Since you mentioned the content will be loaded individually on every page, is it possible this approach is slowing things down? it’d be feasible to call the script in the footer / in functions.php instead and just have the markup for the recaptcha box in the popup?

[Robert Gadon]

Hello @peteloaf:

I can follow along with everything you’ve written above. Without a specific site url to inspect, I can only speak in generalities.

You mentioned popup #2 in your thread above. I’ve observed on some sites that when site assets call the Google API to load a version of jQuery via AJAX, Google serves up a newer version of the jQuery library (v.3.2.1). Our plugin relies on the version of jQuery bundled with WordPress (jQuery v.1.12.4 as of WP Core v4.9.1). If Popup Maker can’t access WP’s jQuery library, then our plugin won’t work.

You also didn’t mention which form plugin you’re using. But if you’re using a custom JS trigger to set a cookie on form submission (presumably via the Manual JS cookie setting method), then you’re likely not using Gravity Forms. I mention GF because their forms will not process via AJAX when their forms contain a CAPTCHA element.

See our recent documentation article on this: http://docs.wppopupmaker.com/article/343-gravity-form-wont-submit-with-ajax-enabled

If my comments still don’t seem to address your issue directly, come on over our support forum at https://wppopupmaker.com/support and repost there. I can forward your support request to our plugin developer, Daniel Iser.

He’s crazy busy right now, trying to wrap up the version 1.7 release of Popup Maker. Of late, he does not typically post in this forum even when I nudge him. I can pull him into a conversation on a support request more easily in the other forum.

• This reply was modified 8 years, 5 months ago by Robert Gadon.
• This reply was modified 8 years, 5 months ago by Robert Gadon.