Number of Topics and Posts is not updated when they are deleted in a forum

Welcome Guest! To enable all features please Login or Register

continienzo
100% (Exalted)
YAF MVP Topic Starter

16 years ago

When, from the admin account, some Topics and/or Posts are deleted, the page of the forum list doesn't is not update the number of Topics/Posts and it continues to show the same numbers it shows before the deletion.

Moreover, the last post information showed is not updated too (if it is the last post that was cancelled, the link to it remains but it is obviously broken).

Kind regards

Enzo Contini

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Jaben
100% (Exalted)
YAF Developer

16 years ago

Thanks for the bug report. The first problem has been fixed and committed. (Update Topics/Posts count)

Second issue is just related to the active discussions cache. To turn it off just go into Admin->Host Settings->Cache and set the Active Discussions cache to 0 timeout.

billv
51.8% (Neutral)
YAF Forumling

14 years ago

This bug appears to be back in 1.9.4 Beta 3. If an admin deletes topics the post counter does not update. I've currently got a forum that is displaying "There are 17 posts in 0 topics in 2 forums".

Ederon
100% (Exalted)
YAF Developer

14 years ago

This bug appears to be back in 1.9.4 Beta 3. If an admin deletes topics the post counter does not update. I've currently got a forum that is displaying "There are 17 posts in 0 topics in 2 forums".

billv wrote:

Are you sure it's not related to caching? Try to disable cache as Jaben describes above.

When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.

billv
51.8% (Neutral)
YAF Forumling

14 years ago

I've set the value set to 0 as described and the values are still showing incorrectly.

Ederon
100% (Exalted)
YAF Developer

14 years ago

Ok, I did little test. Deleting topic indeed doesn't update stats, but only because it's cached. Go to Admin -> Host Settings -> Cache and "Clear Cache". And check your correct stats.

When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.

billv
51.8% (Neutral)
YAF Forumling

14 years ago

Thanks Ederon, that was part of the problem.

I did a 'Cleared Cache' and set the 'Forum Statistics Cache Timeout' to 0, which still had incorrect counts. After a little digging around I found that entries in the message table do not get marked with IsDeleted=True when a topic is deleted. Rather than figure out why they were not getting set I chose to add a line of code 'SET @EraseTopic = 1' at the top of sql proc 'yaf_topic_delete'. Now everything is good.

Ederon
100% (Exalted)
YAF Developer

14 years ago

EDIT: Jaben rules

Edited by user 14 years ago | Reason: Not specified

When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.

Jaben
100% (Exalted)
YAF Developer

14 years ago

Thanks Ederon... But, I already updated the procedure to set Messages to IsDeleted.

Hopefully that will fix.

Edited by user 14 years ago | Reason: Not specified

Ederon
100% (Exalted)
YAF Developer

14 years ago

#10

Thanks Ederon... But, I already updated the procedure to set Messages to IsDeleted.

Hopefully that will fix.

Jaben wrote:

Great! I just didn't have time for it atm, so I FP'ed.

Sidenote: Please do not quote FP's, it compromises their effectivity. Thx

When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.

Important Information: