I'm trying to understand this. Once you post a text comment under a video, it adds a row in bx_videos_cmts. Correct? I see that and the number on my video home page shows "1" perfectly fine. Now, the strange thing is if i remove the row from bx_vidoes_cmts, it doesn't change from "1" to "0" after I refresh the video page. It's just stuck with "1". I check there and there is no comments at all.. If i type something there.. it still shows "1". (I guess now that's the real number) If i remove the comment from the video page, not from bx_video_cmts, it changes to "0". If I insert 2 rows in bx_video_cmts, i see 2 comments there but it shows "0". If i add another comment there, not in bx_video_cmts, it shows "3".
I don't get it! How does this whole comment count works!? Once I understand this, i want to find a way to fix the video comment count. It makes NO sense.
Anyone care to help. :(