romeon

@ryanhungate Thank you for the personal support and all you’ve done. As you stated, some weird thing is going on. First I toggled LiteSpeed off, nothing happened. Appearently it leaves caching-stuff in the .htaccess. I had to actually deactivate the liteSpeed plugin before it started running again. Why it’s affecting the scheduler is a big weirdo.

Anyway, all solved, I need to talk with the LS guys to see what’s happening.

It’s really weird. Its barely doing 1 each second, and running now 4-10 tasks untili run it again, but i have to run the command 4-5 times. See video for more explanation:

I updated how the cron is working to a more advanced way with fstop (thus only running one cron at a time). But it still not completing the ENTIRE order-part. When I run the cli command sometimes it doesnt find the task. Sometimes it does. Like now its running, this morning it ran too. But it gives aroun 700 tasks completed. So not quite sure how this is supposed to work. Does it split the tasks?

@ryanhungate Thanks, but it is yet not resolved =)

So it’s still barely syncinc. Running the CLI command gives 0 tasks. No Fatal errors. Cron set to 1 minute. I tried to run the &restart_order_sync=1 10 times. Now instead of 6000 orders, it found 14 000 order. And went from 2000 synced orders to 3400. but been stuck there the entire day. So something is really not working.

The &restart_order_sync=1, is it supposed to set it to 0? Cause it’s not.

One weird thing though: If i tried, say a few times a hour to run the cli command. Most of the times nothing happens. But sometimes it does.. So. What’s really wrong here? Here’s the list of the action scheduler:

View post on imgur.com

So got running schedules and pending.. But doesn’t seem to help to run the cli command. So my friend, what’s the next step?

@ryanhungate THanks for the reply.

No fatal errors. The sync is going.. SLOWLY, so stuck as in “barely movign”. the &restart_order_sync=1 does absolutely nothing. It just reloads the page.

Checking the scheduler, it seems as if Mailchimp however has done LOADS seee image:

View post on imgur.com

Also as mentioned in the first post, I have disapled wp-cron job and run a cronjob each hour, does that have anything that interfeers with this?

@ryanhungate Github issue solved the fatal error. But the sync is still not working.. Sometimes the wp cli command finds tasks.. and run like 400 things.. But there are 6000+ orders. Now it’s stuck at 2000 synced. No matter if I run the resunc, the resync order restart.. Still same thing. Help would be greatly appreciated.

@ryanhungate

MC: 3.3.5
WP latest of today
WC: Latest 3.x

Adding &restart_order_sync=1 gives a fatal error.

2020-03-19T11:31:19+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Incorrect table name '' in /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:74
Stack trace:
#0 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
#1 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#2 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/functions.php(30): ActionScheduler_ActionFactory->single('MailChimp_WooCo...', Array, 1584617479, 'mc-woocommerce')
#3 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/bootstrap.php(146): as_schedule_ i /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php p? rad 74

2020-03-19T11:31:31+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Incorrect table name '' in /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:74
Stack trace:
#0 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
#1 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#2 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/functions.php(30): ActionScheduler_ActionFactory->single('MailChimp_WooCo...', Array, 1584617491, 'mc-woocommerce')
#3 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/bootstrap.php(146): as_schedule_ i /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php p? rad 74

2020-03-19T11:32:49+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Incorrect table name '' in /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:74
Stack trace:
#0 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
#1 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#2 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/functions.php(30): ActionScheduler_ActionFactory->single('MailChimp_WooCo...', Array, 1584617569, 'mc-woocommerce')
#3 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/bootstrap.php(146): as_schedule_ i /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php p? rad 74

2020-03-19T11:32:50+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Incorrect table name '' in /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:74
Stack trace:
#0 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
#1 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#2 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/functions.php(30): ActionScheduler_ActionFactory->single('MailChimp_WooCo...', Array, 1584617570, 'mc-woocommerce')
#3 /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/bootstrap.php(146): as_schedule_ i /home/mywebsite/public_html/wp-content/plugins/mailchimp-for-woocommerce/includes/vendor/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php p? rad 74

No one has an answer from the team? Syncing is not working.. CLI is not working. We could really use some urgent help.

Additional info. So “815 scheduled taks completed”. After I ran cli. However, there should be more than that. Visiting the admin area, it shows as if it’s still syncing.. and not everything is synced. Please advice.

View post on imgur.com

Edit: addion: I have set the cron in the wp-config to disabled, and added the server cron to:

0 * * * * wp cron event run --due-now --path=/home/site/www/ --quiet

Can that be something that is holding it back?

• This reply was modified 5 years ago by romeon. Reason: Added cron code

@khungate Thank you for the swift reply, we’ve not upgraded yet, was just wondering if that could have the affect to why it’s not working. Maybe I need todo something prior before running the wp action scheduler? I just installed it, set my settings, then tried to run the command. No fatal errors.. It’s still syncing almost 47hrs later :S

Seem to be stuck. Can you somehow abort the sync from the admin panel?

@visibledeals Yep, same here. We’re getting loads

@khungate I am wondering the same thing. Been almost 12 hours and only 600 orders synced, so I thought I’d run cli. I tried the following, and as you see to no avail. What am I missing?

[core@site www]$ wp action-scheduler run --group="mc-woocommerce"
0 batches executed.
Success: 0 scheduled tasks completed.

Edit: and does it need WC 4.0 to work?

• This reply was modified 5 years ago by romeon.
• This reply was modified 5 years ago by romeon.

@yaniiliev Ok, so the answer is no then ??

@sixaxis In another thread you stated that Shortpixel does not server WebP to browsers that can not handle it. Problem is, with shortpixel activated, no images are showin on Safari if WebP is activated. Disable the display of WebP and its displayed. So, in other terms: Shortpixel is trying to show webP to all browsers?

@shortpixel @gerard
When I have the WebP option enabled – Safari see no images, no product images etc on my website. When I displabe WebP, then everything is fine. You say that it only serves to compatible browsers. My situation proves otherwise. Is there some weird setting I am missing?