extremeleadprogramcom

The query is coming from Woocommerce core so I’m not sure what else I can optimize there. The DB appears to have indexes in place but it also has about 2 million records in it ( and that is after de-duping and optimizing it the best I can for now ).

I looked through the WP Object Cache page. I understand just enough of it to roughly see how it works but not enough to know how to have it cache that query specifically ( or even if I should ).

I figured that was the case. Without having to hire a developer could you point me in the right direction on how to do that?

Hello @wfgerald , any further thoughts?

Any further thoughts?

Here is the screenshot of that: https://tinyurl.com/ybpr7xk6

I don’t have XML-RPC authentication disabled but the 2FA for that is on, maybe I should try clicking “skipped” and see if it works ok then.

The documentation for the Woocommerce/Zapier plugin doesn’t say anything about using XML-RPC that I can tell.

Ok, I clicked “skipped” there and hit save and tried again. Get this error in Zapier when I try to connect even though I know the username/password is correct: “authentication failed: The username and/or password you supplied is incorrect.”.

I enabled the debug log for the Zapier/Woo plugin and this is what I see in the log:
2020-06-05T12:55:05+00:00 NOTICE Authentication attempt failed for user: xxxxxx (redacted)
2020-06-05T12:55:05+00:00 NOTICE Error Code: wfls_twofactor_required
2020-06-05T12:55:05+00:00 NOTICE Error Message: CODE REQUIRED: Please provide your 2FA code when prompted.
2

Maybe I will also open a support ticket with them to see what they say but any further help is greatly appreciated.

Thank you for your reply. I did a manual update from 4.2.2 to 4.2.3. I don’t want to do that each time.

However, I did actually SOLVE this issue. I’m not 100% sure which of these steps made it work, but here’s what I did:

1) My site uses Cloudflare, so I cleared the cache on their control panel.

2) I disabled the “W3 Total Cache”, “SEO Ultimate”, and “Wordfence Security” plugins.

After doing those, I was able to update normally via the web interface. I wish I would have tried each one separately to know exactly which one worked, but at least this way if any one else runs in to this, there are options.

Mods, you can mark this as Solved.

Thanks again,