markwill

With apologies for the delay, I think I found the problem. It turns out that another security-related service ALSO had an option to disable app passwords (but, unfortunately, doesn’t indicate when it has disabled them, like WordFence does). So, that’s the explanation and I am sorry for the false alarm.

Thank you for your help.

Thank you for your response, Kim. Since I am now relaying site-specific information in the form of a video, I have opened an official ticket.

The video I have sent shows my query working when WordFence is deactivated and failing (no rows returned) when it is activated.

I hope the video is help. Thank you again.

And here’s what I see when I disable that option – no ability to edit app passwords.

https://app.screencast.com/4216thADi88ad

Here is what I see when app passwords are disabled in WordFence. This is as expected.

https://app.screencast.com/zCDDw58a4KYps

As I look at WPGraphQL, I have the same concerns. I’ve been taking a look and like what I see but I see no other community and there are a good number of unanswered questions here, sometimes over months.

I’d be uncomfortable investing time and effort into a plugin where we can’t ger reasonably prompt responses (and a thriving community is a key part of that, to take the pressure of the developer).

Sadly, it doesn’t seem like it’s production-ready, at least from the support side.

I hope others can correct me in this assumption, since it does appear interesting.

• This reply was modified 1 year, 2 months ago by markwill.

@dblincoe I think I just (partially) figure this out.

Are you using WordFence? When I have this activated SQL queries fail, as described above. Deactivate WordFence and all is good.

I haven’t yet looked into whether I can configure WordFence to allow this, but I hope that is of help to you.

PS: Although I rarely use it, I also tried the Visual Query Builder and that too also produces no results (the Output tab is empty after execution).

Any further thoughts on this? At this point I am assuming the remote option isn’t going to work for me in the way I’d like (described above), but would love to be proved wrong on this.

Thank you for the reply, @kimmyx. I wasn’t aware of this feature so appreciate the pointer. However, I am still somewhat confused about a couple of aspects of this.

1. As I understand, I cannot host the .csv file on my own server? I need to create an account on the wpdafree.youniquedata.com and then upload my .csv file to that. Is that accurate?
2. It looks like the process of linking to a remote data service creates a new database on my server. My intent is to remotely edit an existing table in an existing database (a custom table in my WordPress database). Is there any way to associate an existing table with a remote .csv file?

Thank you.

• This reply was modified 1 year, 8 months ago by markwill.

Thank you for the response. I do have premium. I’m not in front of my PC to check, but I’ll highlight that your screenshot is for backup, not restore. Do you see these options on the restore dialog?

According to some discussions I have with one or two folks in the Oxygen Facebook group this SEEMS like it is related to how SEOPress is handling CPTs.

On a simple test page that creates a single instance of a lesson I see this call (1261 is the post ID for the lesson, which is a LifterLMS CPT)

SELECT * FROM wp_posts WHERE ID = 1261 LIMIT 1

That appears just once when either SEOPress or Oxygen are deactivated. However, when I activate both, that single query happens 13 times. Each call is associated with the SEOPress filter I mentioned above.

I asked another person to test on his own site. When he did so on a page that used a different CPT (nothing to do with LifterLMS) he saw the same i.e. the database query was called many times. So that seems like a big clue.

Thank you for the response, Benjamin. I do not have any of the options under Compatibility Mode checked.

At this stage and with tickets opened with LifterLMS, Oxygen and SEOPress, I think we can discount LifterLMS from our investigations. Use of the LifterLMS API reasonably often on a single page was where this was exposed, but I am seeing this across many aspects of my site, including on pages where LifterLMS is not involved.

The problem seems to be something to do with the interaction between Oxygen and SEOPress. As I mentioned, disabling either one resolves this issue. I have the option to deactivate SEOPress (that is what I have done for now) but not Oxygen, since my site is built with it.

The Oxygen team seems to think this is something to do with SEOPress’ support for Oxygen. They made this comment…

“I’ve seen something similar with SEOPress in the past where the number of calls was largely increased once it was activated, and I think it’s something to do with how their Oxygen integration works.”

The end result can be rather dramatic, with the number of database queries increasing by almost 10x (with both plugins running), compared to when SEOPress is deactivated.

I welcome your thoughts. Thank you.

• This reply was modified 3 years ago by markwill.
• This reply was modified 3 years ago by markwill.

A little more detail…

The extra / duplicated calls are initiated by a code path that includes the following…

apply_filters(‘seopress_titles_template_replace_array’)
include(‘/plugins/wp-seopress/inc/functions/variables/dynamic-variables.php’)

Note that, as far as I can tell, these extra calls ONLY happen when Oxygen is running at the same time as SEOPress. Deactivate either and I am back to a single query.

Thank you for the response, Benjamin. Yes, Query Monitor is how I noticed this issue.

I have opened a ticket for this and included further information. The following query is being made 13 times (in my test, at least) when I have BOTH SEOPress (free or Pro) and Oxygen. The post in question is a LifterLMS course.

SELECT * FROM wp_posts WHERE ID = 1261 LIMIT 1

Multiplied across a number of methods in my production code and I see hundreds/thousands of extra calls on a single page.

That does not happen if I disable either of those plugins – this query is made just once.

As I reported in my ticket, I narrowed this down to 2 lines of code (happy to share access via the ticket, if needed). I do not believe this is a LifterLMS issue though.

$new_course = new LLMS_Course(1261);
$course_sections = $new_course->get_sections(‘sections’);

Thank you.

• This reply was modified 3 years ago by markwill.

I have been trying to narrow this down and have it down to a single line of code, from my plugin. I used LifterLMS and a single call to this function results in 27 extra database calls when SEOPress is activated. If I simply deactivate SEOPress then those 27 database calls go away.

https://developer.lifterlms.com/reference/classes/llms_course/get_sections/

This behavior, likely replicated across a number of calls to the LifterLMS API, probably explains why the number of database calls increases by more than 500 on one of my key pages, merely by activating SEOPress (no other changes).

I am very eager to understand how activating SEOPress can have such an impact.

• This reply was modified 3 years ago by markwill.