And after page reload, the notification changed to ‘BeRocket AJAX Product Filters Additional tables are generating. They will be used after generation is completed. Current status is 4%‘
The percentage went up, and after getting to 100%, the notification changed to: ‘BeRocket AJAX Product Filters ADditional tables was successfully generated. They will be used automatically when needed. — Got it.’
After this I changed the plugin code back to the default one, just to be sure the files are the same whenever there will be a plugin update.
I don’t think it is still regenerating. I am looking at ‘scheduled events’ and there is no event. Also not at the ‘tools’ tab and not in logs. Is there somewhere else I can look?
@serafinnyc Thanks, I might try to do that in the late evening so there will be less customers on the shop. I’ll let you know if I get any results.
@doublezed2 in WP Crontrol the ‘fetch_patterns’ hook is not displayed at all. It’s recurrence is also ‘non-repeating’ so it might not be triggered by an actual cron but via another function perhaps? I’ve had Query monitor installed once before but I don’t really know where to look to be honest.
I’ve included the code to my functions.php and reloaded the admin. (I also disabled caching for this). Unfortunately, this doesn’t appear to change anything in the Scheduled Actions tab.
I’ve tried the SQL queries in the thread you posted:
To stop the bloat, you can safely delete the stuck fetch_patterns actions. Here’s the SQL:
DELETE FROM wp_actionscheduler_actionsWHERE hook = 'fetch_patterns' AND status = 'pending';
After that you’ll clean up the orphan log:
DELETE FROM wp_actionscheduler_logsWHERE action_id NOT IN ( SELECT action_id FROM wp_actionscheduler_actions);
The first query deleted 1 row, the second query deleted 321934 rows. However when I look at the WooCommerce ‘scheduled actions’, it sadly didn’t fix it, the ‘fetch_patterns’ hook still runs every few seconds.
I see the final solution in the thread is uninstalling WooCommerce, this is something I’d like to avoid if possible.
My status report: https://pastebin.com/uXwYZvtH I’ve emptied the ‘completed’ action scheduler items this morning, so that’s why you don’t see the 100.000+ in the status report.
This is a screenshot of the current state (we didn’t do all styling yet, but functionality stays the same)
This product is a ‘free sample’, where the customer only has to pay for the shipping. They should be able to choose a minimum of 1 and a maximum of 3 colors/samples. Because this sample is free, they should only be able to order 1 product per order, no matter what samples they’ve chosen.
We currently use the ‘multi checkbox’ field. We’d actually prefer to be able to use this field with images (like the ‘radio with images’, but ‘multi checkbox with images’). I’m also wondering why this isn’t possible? 🙂
So we activated the ‘Limit purchases to 1 item per order’ option in WooCommerce (it’s a default option, no plugins). But the following happens:
If I choose a product with the exact same options, I can only add it once;
If I change the options (fill in another checkbox), I can add it multiple times, as long as the exact combination of samples is not chosen yet;
I’m wondering why this is happening because officially it’s not a variable product.
