Hi all!
If a post deleted in a topic, then topics last message date is written wrong in db.
Please Change bold area
delete_post.asp
------------------------------------------------------------
If NOT rsCommon.EOF Then
'Place the date of the start date of the first message in the topic table
rsTopicDelete("Start_date") = CDate(rsCommon("Message_date"))
'Move to the last message in the topic to get the last message date
rsTopicDelete.MoveLast - Remove this Line
rsCommon.MoveLast - Add this Line
'Place the date of the last post in the last enry date
rsTopicDelete("Last_entry_date") = CDate(rsCommon("Message_date"))
rsTopicDelete.Update
...
...
...
Edited by AmorfeD