Errors retrieving user leaderboard position with shortcode

I’ve done everything I could think of to try and troubleshoot this issue, but I’m stuck. I’m trying to get the leaderboard position based on balance for my users’ individual profiles using [mycred_leaderboard_position user_id=<put user id here>] but I’m getting this:

WordPress database error: 
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM ( SELECT s.*, @rank := @rank + 1 rank FROM ( SELECT l.user_i' at line 1]

I tried to use the args from this topic: https://www.ads-software.com/support/topic/how-to-get-user-leaderboard-position/ with no luck.

I’ve tried every variation of the shortcode I could think of (with quotes, without quotes, etc) and the most I’ve been able to generate is a dash which, I think, means the entry is “missing”, but the main leaderboard page shows everybody just fine.

https://wackywriters.com/leaderboards/

Any ideas?

Also, the documentation link provided in the shortcode file (https://codex.mycred.me/shortcodes/mycred_leaderboard_position) leads to a 404.

Site info:
URL: wackywriters.com
MyCred version: 2.1.1
Wordpress version: 5.7.2

• This topic was modified 3 years, 8 months ago by caitlinelysey.