reppie

I’ve dug around a bit and I’ve found this could be related to a php-fpm error:

[21-Apr-2020 16:28:42] WARNING: [pool wordpress] server reached pm.max_children setting (5), consider raising it

I’ve raised it to 20 in 2304923498792304920348234802384 different places and it seems to have resolved the problem ??

Still an issue I’m afraid!

Nothing has worked as yet. Here’s the debug log:

[21-Apr-2020 15:13:46 UTC] WordPress database error Unknown column ‘syncing_current_amounts_’ in ‘field list’ for query UPDATE wp_wps_settings_syncing SET syncing_current_amounts_ = syncing_current_amounts_ + 2 made by do_action(‘wp_ajax_wp_wps_background_processing_posts_products’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Shopify\Processing\Vendor_Background_Process->maybe_handle, WP_Shopify\Processing\Vendor_Background_Process->handle, WP_Shopify\Processing\Posts->after_queue_item_removal, WP_Shopify\DB\Settings_Syncing->increment_current_amount
[21-Apr-2020 15:13:48 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘wp_shopify_table_exists_wp_wps_settings_connection’, ‘1’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_Shopify\API\Items\Collections->get_all_collections, WP_Shopify\Shopify_API->get_smart_collections_per_page, WP_Shopify\HTTP->get, WP_Shopify\HTTP->get_request_url, WP_Shopify\DB->get, WP_Shopify\DB->table_exists, WP_Shopify\Options::update, update_option, add_option
[21-Apr-2020 15:20:05 UTC] WordPress database error Unknown column ‘syncing_current_amounts_’ in ‘field list’ for query UPDATE wp_wps_settings_syncing SET syncing_current_amounts_ = syncing_current_amounts_ + 1 made by do_action(‘wp_ajax_wp_wps_background_processing_posts_collections_smart’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Shopify\Processing\Vendor_Background_Process->maybe_handle, WP_Shopify\Processing\Vendor_Background_Process->handle, WP_Shopify\Processing\Posts->after_queue_item_removal, WP_Shopify\DB\Settings_Syncing->increment_current_amount

There are server errors relating to timeout, but that’s set to 300 which is the point at which the plugin gives me the error mentioned in the original post:

[Tue Apr 21 15:13:44.259681 2020] [proxy_fcgi:error] [pid 26449:tid 140302589343488] (70007)The timeout specified has expired: [client x.xx.xxx.xxx:58665] AH01075: Error dispatching request to : (polling), referer: https://domain.com/wp-admin/admin.php?page=wps-connect&activetab=tab-tools&activesubnav=wps-admin-section-syncing

There are a few different URLs but I don’t think these are the problem, it looks like the PHP errors are the issue?

If you mean is ‘Collection availability’ set to ‘WordPress Store’ then yes it is…

Hi, yes 2.2.4.

Sorry what do you mean by custom sales channel? I’ve just set up a manual collection in admin where you add specific products to the collection. I’m not sure what you mean by assigning that collection to something. I assume that’s what a custom collection is?

I’ve just gone through and given read/write access to everything except for the payments (as per docs) and the problem is still there.

Thanks

Actually it doesn’t, but that’s the recaptcha not your pop-up…

That option works well, thanks!

The site is live now so help would be appreciated, or I’ll have to look at a different form than CF7: https://www.go2grocery.com

Thanks

Thanks Philipp

Fix available in another ticket.

In front.js replace:

jQuery(window).setInterval(a,750)

With:

jQuery(window.setInterval(a,750))

Ooh, this works. Thanks Glenn

Hi,

I think there is a problem with the theme pagination as far as the category archive title goes – but I would still expect ‘page 1’ to be in the title with these settings?

%%term_title%% Archives %%page%% %%sep%% %%sitename%%

As for the second link, as I said it’s a portfolio post and I’ve used a custom slug for it to replace ‘portfolio_category’ with ‘join’ in the standard permalink settings page. In SEO > Search Appearance > Content Types > Portfolio, it calls it avada_portfolio. Under Portfolio archive there, I’ve added %%pt_plural%% Archive %%page%% %%sep%% %%sitename%% and that’s not being obeyed.

Thanks

I completely forgot that this was an issue haha. I will try and investigate as per your checklist

Ah, I’ve just found the settings and info on the site settings pages. Thanks! Worked great out the box.

A combination of disabling xml-rpc.php, hiding the log-in, throttling and adding that block list has brought attack volume right down ??