Title: Custom Collection causing plugin transient cache/504 error Last modified: April 16, 2020 --- # Custom Collection causing plugin transient cache/504 error * [reppie](https://wordpress.org/support/users/reppie/) * (@reppie) * [6 years, 1 month ago](https://wordpress.org/support/topic/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](https://wordpress.org/support/users/andrewmrobbins/) * (@andrewmrobbins) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12689386) * [@reppie](https://wordpress.org/support/users/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](https://docs.wpshop.io/#/getting-started/syncing?id=step-6) * Thread Starter [reppie](https://wordpress.org/support/users/reppie/) * (@reppie) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12690184) * 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](https://wordpress.org/support/users/reppie/) * (@reppie) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12690241) * If you mean is ‘Collection availability’ set to ‘WordPress Store’ then yes it is… * Plugin Author [andrewmrobbins](https://wordpress.org/support/users/andrewmrobbins/) * (@andrewmrobbins) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12703881) * [@reppie](https://wordpress.org/support/users/reppie/) * Thanks for the update! * Can you try going through the steps here? [https://docs.wpshop.io/#/getting-started/common-issues?id=syncing-issues](https://docs.wpshop.io/#/getting-started/common-issues?id=syncing-issues) * Let me know if none of those work. * Thread Starter [reppie](https://wordpress.org/support/users/reppie/) * (@reppie) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12708826) * 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](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](https://wordpress.org/support/users/andrewmrobbins/) * (@andrewmrobbins) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12708969) * [@reppie](https://wordpress.org/support/users/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](https://wordpress.org/support/users/reppie/) * (@reppie) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12709060) * Still an issue I’m afraid! * Thread Starter [reppie](https://wordpress.org/support/users/reppie/) * (@reppie) * [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12709361) * 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. * ![](https://ps.w.org/wpshopify/assets/icon.svg?rev=2740857) * [ShopWP](https://wordpress.org/plugins/wpshopify/) * [Frequently Asked Questions](https://wordpress.org/plugins/wpshopify/#faq) * [Support Threads](https://wordpress.org/support/plugin/wpshopify/) * [Active Topics](https://wordpress.org/support/plugin/wpshopify/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wpshopify/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wpshopify/reviews/) * 8 replies * 2 participants * Last reply from: [reppie](https://wordpress.org/support/users/reppie/) * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/custom-collection-causing-plugin-transient-cache-504-error/#post-12709361) * Status: not resolved