Custom Collection causing plugin transient cache/504 error

  • I’m just building a new store, and configuring everything. I’ve added a test product, and a test Smart Collection and assigned it a tag. Added that tag to the test product in Shopify. Sync works fine, but with the warning about there being no Custom Collections.

    When I add a manual collection and add that test product to it, when syncing I get the following error for Collects, Products, Custom collections, Smart collections and Shop after the sync times out after 5 minutes (they are stuck at 0% until the error):

    while calling undefined. Please clear the plugin transient cache and try again. Error status code: 504

    Syncing failed from client-side

    When I delete the Custom Collection from Shopify, sync works again.

    Can you help with this please? I’ve tried deactivating/reactivating, clearing the caches, etc.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author andrewmrobbins

    (@andrewmrobbins)

    @reppie

    Hey there. Which version of the plugin are you running? 2.2.4?

    Is your custom collection assigned to your custom sales channel? Also, have you double checked that your priate app has read and write access to all the collection scopes? See step 6 here: https://docs.wpshop.io/#/getting-started/syncing?id=step-6

    Thread Starter reppie

    (@reppie)

    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

    Thread Starter reppie

    (@reppie)

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

    Plugin Author andrewmrobbins

    (@andrewmrobbins)

    @reppie

    Thanks for the update!

    Can you try going through the steps here? https://docs.wpshop.io/#/getting-started/common-issues?id=syncing-issues

    Let me know if none of those work.

    Thread Starter reppie

    (@reppie)

    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?

    Plugin Author andrewmrobbins

    (@andrewmrobbins)

    @reppie

    Hmm thanks for the info.

    Just to rule out any database related issues, can you try deactivating the plugin, reactivating, and then attempting another resync?

    Thread Starter reppie

    (@reppie)

    Still an issue I’m afraid!

    Thread Starter reppie

    (@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 ??

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Custom Collection causing plugin transient cache/504 error’ is closed to new replies.