Wierd bug when viewing discussions.
so, i've been seeing this bug from time to time, and i finally figured out when it happens, (no idea why though).
when a page in a thread is full, i.e. it has the max. number of comments allowed (50) and i click on the link for the thread from the homepage, the page doesn't display ANY comments, like this:

but if i go back a page in the thread, and then click on the 'next page' link, it shows up normally.
has anyone else had this problem? is there a fix?
when a page in a thread is full, i.e. it has the max. number of comments allowed (50) and i click on the link for the thread from the homepage, the page doesn't display ANY comments, like this:

but if i go back a page in the thread, and then click on the 'next page' link, it shows up normally.
has anyone else had this problem? is there a fix?
0
This discussion has been closed.
Comments
the 3300 is comments. its a big thread
i am not using friendly urls.
not sure what version of mysql i am running, just sent an email to my server guy to ask, ill let you know.
Try comparing these queries, they should both come up equal:
SELECT COUNT(*) FROM LUM_Comment WHERE WhisperUserID = 0 AND DeleteUserID = 0 AND Discussion_ID = 123 SELECT CountComments FROM LUM_Discussion WHERE DiscussionID = 123
Where
123
is the offending discussion ID. If they are not equal, setCountComments
equal to the result from the first query.EDIT: It looks like I found the cause: If a user edits a post from public to a whisper, CountComments in the Discussion table is not decremented like it is when a post is deleted. This isn't normally a problem until the discussion grid tries to calculate which page is the last page in a discussion.
Edit: It looks like whispers are usually handled OK, except when you edit a deleted whisper to add/remove the 'whisper to' contents.
I've discovered that deleting a comment will re-sync the counts, so deleting then undeleting any comment in an affected discussion should fix any threads you see this happening in.