cjerrells

It seems to be just this Big award and the 4 related achievements. I don’t think I’ve seen any cases of achievements being awarded incorrectly apart from these 5.

What’s special about this Big award is that I think it’s the only achievement I have set up which has earning other achievements as its steps. My other achievements all use LearnDash or Community activities as their steps.

(I do have one other bizarre issue where a user’s BuddyPress profile is showing the wrong achievement. It shows the correct achievement type on the tab, and the user does have one achievement of that type, but the achievement shown is actually one from a different type which has its “shown to user” set to off! Viewing the page doesn’t trigger killed queries though, so I’m assuming that’s a separate issue to this one. Mentioning it in case I’m wrong!)

For some reason www.remarpro.com won’t let me post a reply with the queries in. Please see them here instead: https://pastebin.com/raw.php?i=Q0pf8vik

So I’ve found a way to reproduce this issue on demand, which helps. If I call badgeos_get_required_achievements_for_achievement_list() for the Big award, the 4 queries for its steps fire and get killed (and as a result the output from the function is lacking its normal hyperlinks to each step).

I’ve deleted the forum step from the BP award and set it to be Admin-awarded instead of earned by steps. But strangely I’m still getting the killed queries, and they all include the “FIND_IN_SET(wp_posts.post_type,’forum,topic,reply’)” and “FIND_IN_SET(wp_posts.ID,’6,7,8,9,10[…]” clauses! This seems a bit bizarre since now none of the awards the Big award is dependent on have a forum-related step… Could something other than that “post in forums” step be responsible for this long clause being generated?

Thanks Michael. In this case, manual awarding isn’t practical (it needs to be instant) but perhaps I could use an action on the bbPress post saving hook to call the BadgeOS API and award the relevant achievement.

I’m wondering if this would sidestep the problem, or cause the same steps-ui code to trigger anyway?

It might help to explain the setup a bit more. I have three types of award set up:

– “BP” awards are based on Community actions (one is a BuddyPress “set your profile”, the other a bbPress “Create a forum post”)
– “LD” awards are LearnDash actions (both are completing modules)
– “Big” awards are made up of earning BP and LD awards.

All of the killed SQL queries are being caused by the 4 steps of a particular Big award. Two are the BPs mentioned above and two are LDs. I’ve checked this by logging the requirements[‘achievement_type’] and step_id passed into the steps-ui.php code block mentioned earlier in this thread. All four of the steps are causing killed queries occasionally (not just the BP forum post one).

This seems to cause the Big award to be awarded incorrectly (sometimes not actually earned yet, sometimes not awarded once earned) as well as sometimes the actual BP and LD awards themselves not being awarded when earned.

So I have two questions:

1. Is it possible that the killed queries in that steps-ui.php block are indeed responsible for awards being (not) given incorrectly?

2. Will manually calling the BadgeOS API to award the BP “forum post” award actually solve this, or will the same SQL queries end up being generated anyway?

Thanks again for your help with this. If I can avoid changing hosting that would be a big relief – and I fear this problem is only going to get worse even if I switch host and increase the SQL query length limit. So I’m really keen to find a workaround if at all possible and I very much appreciate your advice!

I’ve just done a search across all this install’s files and I found the same occurrences as you. Perhaps it’s generated by a PHP library WordPress uses to generate its SQL queries?

I’m really stuck with this and not sure how to proceed. May have to re-host the site on a VPS rather than WPEngine, but that seems like a pretty drastic measure.

Any ideas?

Hi Frankie,

Thanks for the pointers to custom Connectors and Download Monitor. I’ll look into both options.

I actually had no idea the Wiki existed! Might be worth adding a link to it from the wp-stream.com Dashboard?

Hi Michael,

Thanks for the fast response.

It seems pretty surprising that WordPress would generate a query containing (I presume) every single Post ID! I can’t seem to turn up anybody else encountering an issue with this from get_posts to try to find a workaround or solution.

I can’t quite wrap my head around the mapping from the steps-ui.php code to that query to understand why there is even that FIND_IN_SET clause there. It seems like the problem would be mitigated somewhat if the two lengthy FIND_IN_SET expressions were in two successive queries, but I’m out of my depth to figure out how to make that happen.

From the name of the file, it seems like this should only cause problems in the backend UI anyway? Perhaps my problem with users being awarded badges they haven’t earned is actually unrelated to these error messages?

Hi Frankie,

Thank you for the explanation. Great to know this is under control and will be resolved soon.

Many thanks,

Christopher

P.S. I hope you’ve been enjoying your paternity leave!

I’m having this issue too, for the last week or so, on a “Pro” account.

The message I get is “Stream API Error: Operation timed out after 5000 milliseconds with 0 bytes received.”

Any explanation or help available?

That’s great to hear!

Very nice plugin by the way, thanks!

Okay, thanks. I’ll get in touch with their support and see if they have any ideas. Will report back if so!

Hi Michael,

Thanks for the suggestion. I replicated to a staging site, disabled all plugins (kept same theme), and the description then worked correctly.

Re-enabling the iMember360 plugin results in the problem reappearing. Any known compatibility issues with this plugin?

Excellent, thanks. On its way.

Hi Michael,

Thanks for the quick reply! I can provide an example, but it’s on a private/dev site so I’d rather not post the URL here. Will try to reach you directly to provide the link.

This is a serious issue for me too – any help would be very much appreciated!