1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fixed Likes You've Received

Discussion in 'Resolved Bug Reports' started by whynot, Feb 22, 2014.

  1. whynot

    whynot Well-Known Member

    Personal details > Likes You've Received > 1 2 3 . . . x

    Clicking on the last page number:
    Amaury likes this.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Looks like I've got 8 phantom pages as page 1000 only has 6 entries:

    whynot likes this.
  3. Martok

    Martok Well-Known Member

    Mine's as it should be.

    Strange that it's not for you two, I wonder what's causing that?
    whynot likes this.
  4. Amaury

    Amaury Well-Known Member

    Same here. All 19 pages are full with content.
    whynot likes this.
  5. Brogan

    Brogan XenForo Moderator Staff Member

    It could be related to banned members.
  6. whynot

    whynot Well-Known Member

    Removed likes? ("Unlike")
  7. Jeremy

    Jeremy XenForo Moderator Staff Member

    Removing your like of a post would not cause that issue.
  8. whynot

    whynot Well-Known Member

    Not a browser fault because IE, FF and Chrome giving the same result.
  9. Eagle

    Eagle Well-Known Member

  10. Daniel Hood

    Daniel Hood Well-Known Member

    I think it has to do with deleted accounts. Banned users would probably still show fine because they still have a record in the users table, deleted accounts probably make these two queries return different results:

                FROM xf_liked_content
                WHERE content_user_id = ?
    XenForo_Model_Like::getLikesForContentUser($userId, array $fetchOptions = array())
    SELECT liked_content.*,
                    FROM xf_liked_content AS liked_content
                    INNER JOIN xf_user AS user ON (user.user_id = liked_content.like_user_id)
                    WHERE liked_content.content_user_id = ?
                    ORDER BY liked_content.like_date DESC
    That's not related to the issue although that should have a different phrase.
  11. Eagle

    Eagle Well-Known Member

    whynot likes this.
  12. Mike

    Mike XenForo Developer Staff Member

    Likes from deleted members do still count (they're not removed), so I've tweaked it to display those. It also checks the page number now so you can't go too big and get an unexpected message.
    Eagle likes this.
  13. Eagle

    Eagle Well-Known Member

    Yes page id problems solved now, thank you Mike. Note that's just a SQL Query by Jake and that is awesome. When run it will remove all deleted users with their likes on message or profile posts and recalculate all likes again. After run that query, problem will solve.

Share This Page