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

  • Resolved caitlinelysey

    (@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: https://wordpress.org/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 (http://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 4 months, 3 weeks ago by caitlinelysey.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.