New Product Feed stops on 0% processing

Hi,

Thanks for using our plugin and reaching out to us.

Did you already check the content of your WooCommerce fatal error logs of the last couple of days? Can you share the content of those logs with us? This is where you can find the WooCommerce fatal error logs: https://woo.com/document/finding-php-error-logs/

Hello,

Would be glad if you can help us out since new feeds and older feeds are not being updated.

Fatal Errors loggs;

2023-11-01T21:22:57+00:00 CRITICAL Uncaught RuntimeException: Unable to claim actions. Database error: Deadlock found when trying to get lock; try restarting transaction. in /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:942 Stack trace: #0 /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(799): ActionScheduler_DBStore->claim_actions() #1 /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(160): ActionScheduler_DBStore->stake_claim() #2 /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(139): ActionScheduler_QueueRunner->do_batch() #3 /var/www/html/wp-includes/class-wp-hook.php(310): ActionScheduler_QueueRunner->run() #4 /var/www/html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters() #5 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action() #6 /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AsyncRequest_QueueRunner.php(52): do_action() #7 /var/www/html/wp-content/plugins/woocommerce/includes/libraries/wp-async-request.php(147): ActionScheduler_AsyncRequest_QueueRunner->handle() #8 /var/www/html/wp-includes/class-wp-hook.php(310): WP_Async_Request->maybe_handle() #9 /var/www/html/wp-includes/class-wp-hook.php(334): WP_Hook->apply_filters() #10 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action() #11 /var/www/html/wp-admin/admin-ajax.php(188): do_action() #12 {main} thrown i /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php p? rad 942

Hi,

Thanks for your reply. The error message you shared is from November 1st, a month old, do you also have one for today or yesterday? Also, the error message you shared is not related to our plugin although it does indicate there might be an issue with your database.

Sorry for posting wrong logs.

See further down:

2023-12-01T11:46:16+00:00 CRITICAL Uncaught DivisionByZeroError: Division by zero in /var/www/html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php:2118 Stack trace: #0 /var/www/html/wp-includes/class-wp-hook.php(324): woosea_project_processing_status() #1 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #2 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action() #3 /var/www/html/wp-admin/admin-ajax.php(188): do_action() #4 {main} thrown i /var/www/html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php p? rad 2118 2023-12-01T11:46:26+00:00 CRITICAL Uncaught DivisionByZeroError: Division by zero in /var/www/html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php:2118 Stack trace: #0 /var/www/html/wp-includes/class-wp-hook.php(324): woosea_project_processing_status() #1 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #2 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action() #3 /var/www/html/wp-admin/admin-ajax.php(188): do_action() #4 {main} thrown i /var/www/html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php p? rad 2118 2023-12-01T11:46:36+00:00 CRITICAL Uncaught DivisionByZeroError: Division by zero in /var/www/html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php:2118 Stack trace: #0 /var/www/html/wp-includes/class-wp-hook.php(324): woosea_project_processing_status() #1 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #2 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action() #3 /var/www/html/wp-admin/admin-ajax.php(188): do_action() #4 {main} thrown i /var/www/html/wp-content/plugins/woo-product-feed-pro/woocommerce-sea.php p? rad 2118

Thanks for this, is this the entire content of the log of december first?

Yes, it’s the whole logg!

Hi,

Thanks for your reply. Can you try updating to version 13.1.4, released today, to see if that solves the issue at hand for you?

Hello,

I have updated to 13.1.4 and unfortunately the feeds stops refreshing at 33%. I can create new feeds but the changes will not be refreshed.

See logs before and after update of plugin..

AFTER UPDATE

12-03-2023 @ 15:26:32 – <!– Start new QUERY –> 12-03-2023 @ 15:26:32 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 0 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 15:26:32 – <!– START new QUERY –> 12-03-2023 @ 17:17:30 – <!– Start new QUERY –> 12-03-2023 @ 17:17:30 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 0 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:17:30 – <!– START new QUERY –> 12-03-2023 @ 17:19:47 – <!– Start new QUERY –> 12-03-2023 @ 17:19:47 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 711 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:19:47 – <!– START new QUERY –> 12-03-2023 @ 17:20:01 – <!– Start new QUERY –> 12-03-2023 @ 17:20:01 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 1422 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:20:01 – <!– START new QUERY –> 12-03-2023 @ 17:20:19 – <!– Start new QUERY –> 12-03-2023 @ 17:20:19 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 2133 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:20:19 – <!– START new QUERY –> 12-03-2023 @ 17:23:56 – <!– Start new QUERY –> 12-03-2023 @ 17:23:56 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 0 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:23:56 – <!– START new QUERY –> 12-03-2023 @ 17:26:11 – <!– Start new QUERY –> 12-03-2023 @ 17:26:11 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 711 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:26:11 – <!– START new QUERY –> 12-03-2023 @ 17:26:26 – <!– Start new QUERY –> 12-03-2023 @ 17:26:26 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 1422 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:26:26 – <!– START new QUERY –> 12-03-2023 @ 17:26:41 – <!– Start new QUERY –> 12-03-2023 @ 17:26:41 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 2133 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:26:41 – <!– START new QUERY –> 12-03-2023 @ 17:29:35 – <!– Start new QUERY –> 12-03-2023 @ 17:29:35 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 0 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:29:35 – <!– START new QUERY –> 12-03-2023 @ 17:31:47 – <!– Start new QUERY –> 12-03-2023 @ 17:31:47 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 711 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:31:47 – <!– START new QUERY –> 12-03-2023 @ 17:32:00 – <!– Start new QUERY –> 12-03-2023 @ 17:32:00 – Array ( [post_type] => Array ( [0] => product ) [posts_per_page] => 711 [offset] => 1422 [post_status] => publish [orderby] => date [order] => desc [fields] => ids [no_found_rows] => 1 [cache_results] => [update_post_term_cache] => [update_post_meta_cache] => ) 12-03-2023 @ 17:32:00 – <!– START new QUERY –>

BEFORE UPDATE

2023-12-02T17:02:18+00:00 CRITICAL Uncaught RuntimeException: Unable to claim actions. Database error: Deadlock found when trying to get lock; try restarting transaction. in /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:942 Stack trace: #0 /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(799): ActionScheduler_DBStore->claim_actions() #1 /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(160): ActionScheduler_DBStore->stake_claim() #2 /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(139): ActionScheduler_QueueRunner->do_batch() #3 /var/www/html/wp-includes/class-wp-hook.php(324): ActionScheduler_QueueRunner->run() #4 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #5 /var/www/html/wp-includes/plugin.php(565): WP_Hook->do_action() #6 /var/www/html/wp-cron.php(191): do_action_ref_array() #7 {main} thrown i /var/www/html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php p? rad 942

Hi,

The logs you shared “after the update” are not coming from your WooCommerce fatal error logs but from our plugin logs. Can you share the content of the fatal error logs?

Here comes newest fatal error logs.

2023-12-04T07:22:39+00:00 CRITICAL Uncaught Error: Call to undefined function WP_Rocket\Addon\Cloudflare\add_settings_error() in /var/www/html/wp-content/plugins/wp-rocket/inc/Addon/Cloudflare/Subscriber.php:661 Stack trace: #0 /var/www/html/wp-includes/class-wp-hook.php(326): WP_Rocket\Addon\Cloudflare\Subscriber->display_settings_notice() #1 /var/www/html/wp-includes/plugin.php(205): WP_Hook->apply_filters() #2 /var/www/html/wp-includes/option.php(773): apply_filters() #3 /var/www/html/wp-content/plugins/wp-rocket/inc/Engine/Optimization/DelayJS/Admin/SiteList.php(297): update_option() #4 /var/www/html/wp-content/plugins/wp-rocket/inc/Engine/Optimization/DelayJS/Admin/Subscriber.php(158): WP_Rocket\Engine\Optimization\DelayJS\Admin\SiteList->refresh_exclusions_option() #5 /var/www/html/wp-includes/class-wp-hook.php(324): WP_Rocket\Engine\Optimization\DelayJS\Admin\Subscriber->refresh_exclusions_option() #6 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #7 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action() #8 /var/www/html/wp-content/plugins/wp-rocket/inc/Engine/Optimization/DynamicLists/DynamicLists.php(157): do_action() #9 /var/www/html/wp-content/plugins/wp-rocket/inc/Engine/Optimization/DynamicLists/Subscriber.php(93): WP_Rocket\Engine\Optimization\DynamicLists\DynamicLists->update_lists_from_remote() #10 /var/www/html/wp-includes/class-wp-hook.php(324): WP_Rocket\Engine\Optimization\DynamicLists\Subscriber->update_lists() #11 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #12 /var/www/html/wp-includes/plugin.php(565): WP_Hook->do_action() #13 /var/www/html/wp-cron.php(191): do_action_ref_array() #14 {main} thrown i /var/www/html/wp-content/plugins/wp-rocket/inc/Addon/Cloudflare/Subscriber.php p? rad 661

Hello again!

The fatal error logs showed there was an issue with cache plugin that we have solved. It seems now we can create new feeds and refresh them with changes taking effect.

However, I noticed something new. If a product has a missing value for a column the plugin can take another value from next column.

For example, columns SKU and GTIN. If a product has missing value (like product bundle) it will take the next value (gtin) and place in under SKU.

Can I send you my feed to show you what I mean?

UPDATE:

I tried once again to make som changes to a feed by deleting few columns. The process runs through 100% and says ready but changes are not taking place if I download the file.

Settings are still saved but it will simple not refresh.

What’s your suggestions now?

Sounds like you might be looking at an old or cached version of your feed.

Can you share the following with us:

1. The product feed URL
2. The plugin debug.log URL so we can see how you configured your feed and if it indeed is updating properly. This is how you can retrieve the debug.log URL: https://adtribes.io/send-your-debug-log-to-support/

Can I email you the log and the url link?

Sure, please reach out to [email protected] and reference this topic / URL in your email so we know what it is about.