Fixed Likes You've Received

[whynot]

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

Clicking on the last page number:

Unfortunately, none of your content has received any likes yet. You'll need to keep posting!

 

[Paul B]

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

 

[Martok]

Mine's as it should be.

Strange that it's not for you two, I wonder what's causing that?

 

[Amaury]

Mine's as it should be.

Strange that it's not for you two, I wonder what's causing that?

Same here. All 19 pages are full with content.

 

[Paul B]

It could be related to banned members.

 

[whynot]

Strange that it's not for you two, I wonder what's causing that?

It could be related to banned members.

Removed likes? ("Unlike")

 

[Jeremy]

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

 

[whynot]

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

 

[Eagle]

http://xenforo.com/community/account/likes?page=1000000

 

[Daniel Hood]

It could be related to banned members.

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:

XenForo_Model_Like::countLikesForContentUser($userId)

SELECT COUNT(*)
            FROM xf_liked_content
            WHERE content_user_id = ?

XenForo_Model_Like::getLikesForContentUser($userId, array $fetchOptions = array())

SELECT liked_content.*,
                    user.*
                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

http://xenforo.com/community/account/likes?page=1000000

That's not related to the issue although that should have a different phrase.

 

[Eagle]

@whynot http://xenforo.com/community/thread...t-profile-post-like-caches.42384/#post-457352 Probably this will solve your problem.

@Daniel Hood Yes that is correct but that's interesting to me.

 

[Mike]

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

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.