Support » Plugin: myCred - Points, Rewards, Gamification, Ranks, Badges & Loyalty Plugin » Errors retrieving user leaderboard position with shortcode

  • Resolved caitlinelysey


    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: 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.

    Any ideas?

    Also, the documentation link provided in the shortcode file ( leads to a 404.

    Site info:
    MyCred version: 2.1.1
    Wordpress version: 5.7.2

    • This topic was modified 11 months, 2 weeks ago by caitlinelysey.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Errors retrieving user leaderboard position with shortcode’ is closed to new replies.