Hook woocommerce_run_product_attribute_lookup_update_callback
-
Hello everyone,
I am constantly having this issue with pas due actions that stay longer in pending status, even after 24 hours.
I always have to press the “run button” to make them work, otherwise they’ll just stay in pending status.
What may be solution for this?
I am attaching System Report of my webpage for reference.
Regards.
The page I need help with: [log in to see the link]
-
WordPress Environment<br><br>WordPress address (URL): https://edupecsoftware.com<br>Site address (URL): https://edupecsoftware.com<br>WC Version: 9.1.4<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: 6.6.1<br>WP Multisite: –<br>WP Memory Limit: 1 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: es_ES<br>External object cache: – Server Environment<br><br>Server Info: Apache<br>PHP Version: 8.0.30<br>PHP Post Max Size: 1 GB<br>PHP Time Limit: 600<br>PHP Max Input Vars: 1000<br>cURL Version: 7.81.0<br>OpenSSL/3.0.2<br><br>SUHOSIN Installed: –<br>MySQL Version: 8.0.39<br>Max Upload Size: 1 GB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 9.1.4<br>WC Database Prefix: wp_<br>Total Database Size: 21.73MB<br>Database Data Size: 17.45MB<br>Database Index Size: 4.28MB<br>wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 0.39MB + Index: 0.56MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 0.19MB + Index: 0.17MB + Engine InnoDB<br>wp_aws_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_aws_index: Data: 1.20MB + Index: 0.73MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_options: Data: 2.13MB + Index: 0.13MB + Engine InnoDB<br>wp_postmeta: Data: 1.52MB + Index: 0.69MB + Engine InnoDB<br>wp_posts: Data: 3.52MB + Index: 0.13MB + Engine InnoDB<br>wp_term_relationships: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 0.09MB + Index: 0.03MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.06MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfconfig: Data: 0.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilemods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wfhits: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY<br>wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfstatus: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_chatlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_chattokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_form_feedback: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_form_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_formtokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_image_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_imagetokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_prompt_feedback: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_promptbase_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_prompttokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpaicg_token_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB Post Type Counts<br><br>attachment: 49<br>customize_changeset: 148<br>nav_menu_item: 38<br>page: 10<br>post: 5<br>product: 66<br>product_variation: 356<br>revision: 28<br>shop_order_placehold: 1<br>wp_font_face: 33<br>wp_font_family: 12<br>wp_global_styles: 2<br>wp_navigation: 1<br>wpaicg_builder: 2 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (9)<br><br>Advanced Woo Search: by ILLID – 3.13<br>All-in-One WP Migration: by ServMask – 7.84<br>Blocksy Companion: by CreativeThemes – 2.0.61<br>Click to Chat: by HoliThemes – 4.6<br>ELEX WooCommerce Catalog Mode: by ELEXtensions – 1.4.6<br>UpdraftPlus - Backup/Restore: by UpdraftPlus.Com<br>DavidAnderson – 1.24.4<br><br>WooCommerce: by Automattic – 9.1.4<br>Wordfence Security: by Wordfence – 7.11.7<br>WP 2FA - Two-factor authentication for WordPress: by Melapress – 2.8.0 Inactive Plugins (6)<br><br>Jetpack: by Automattic – 13.7<br>Seraphinite Accelerator (Base, cache only): by Seraphinite Solutions – 2.22.3<br>Site Kit by Google: by Google – 1.132.0<br>Smartarget.online Integration: by Smartarget – 1.3<br>WP fail2ban: by Charles Lecklider – 5.3.2<br>Yoast SEO: by Team Yoast – 23.2 Settings<br><br>API Enabled: –<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 4 KB WC Pages<br><br>Shop base: #6 - /<br>Cart: ? Page ID is set<br>but the page does not exist<br><br>Checkout: ? Page visibility should be public<br>My account: ? Page ID is set<br>but the page does not exist<br><br>Terms and conditions: ? Page not set Theme<br><br>Name: Blocksy<br>Version: 2.0.61<br>Author URL: https://creativethemes.com<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme<br>WooCommerce Support: ? Templates<br><br>Overrides: blocksy/woocommerce/cart/cart.php<br>blocksy/woocommerce/cart/mini-cart.php<br>blocksy/woocommerce/content-widget-product.php<br>blocksy/woocommerce/content-widget-reviews.php<br>blocksy/woocommerce/myaccount/my-account.php<br>blocksy/woocommerce/product-searchform.php<br>blocksy/woocommerce/single-product/tabs/tabs.php Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>printful<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br><br>Daily Cron: ? Next scheduled: 2024-07-15 06:18:03 -05:00<br>Options: ?<br>Notes: 74<br>Onboarding: completed Action Scheduler<br><br>Complete: 1,190<br>Oldest: 2024-06-13 18:56:42 +0000<br>Newest: 2024-08-10 17:17:39 +0000<br><br>Failed: 1<br>Oldest: 2024-06-08 18:09:28 +0000<br>Newest: 2024-06-08 18:09:28 +0000<br><br>Pending: 25<br>Oldest: 2024-08-10 04:52:32 +0000<br>Newest: 2024-08-12 03:08:21 +0000 Status report information<br><br>Generated at: 2024-08-11 22:41:16 -05:00<br>
Hi @edupec
The issue you’re experiencing might be due to a problem with your WordPress Cron Jobs. These are scheduled tasks that run at certain intervals. If they are not functioning properly, it could cause tasks to remain in pending status. You can install the WP Crontol plugin to check whether your site’s cron is working properly or not.
Another possible solution is to use a real cron job instead of WordPress Cron. You can set this up in your web hosting control panel. This would ensure that tasks are run at the correct intervals.
However, if you’re not comfortable with setting up cron jobs, I would recommend reaching out to your hosting provider for assistance. They should be able to help you set up a real cron job or troubleshoot any issues with your current WordPress Cron setup.
I hope this helps! If you have any other questions, feel free to ask.
Hello @shameemreza
Thank you for your fast response.
Plugin that you suggested me helped me figure out that reason why those cron jobs were due because of geo-blocking.
I am using Cloudflare for my site, and I was geo-blocking all requests from the country where my website is hosted, not allowing Cron Jobs to work properly.
Solved issue by allowing requests from the country where my server is hosting my site.
Regards.
Hello @edupec,
Glad to know that we were able to help. Should you have further inquiries, kindly?create a new topic here.
Meanwhile, if it isn’t too much to ask for – would you mind leaving us a review here? It only takes a couple of minutes but helps us tremendously. It would mean so much to us and would go a long way.
Thanks!
- You must be logged in to reply to this topic.