Forum OpenACS Q&A: Forum "Last Post" date is incorrect

Collapse
Posted by Vlad Seryakov on
New site's forum shows incorrect Last Post date,
it is not the date of last posted message.
Is it supposed to be this way?
Is there a possibility to ask for recent postings as in old forum?
Thanks
Collapse
Posted by Jeff Davis on
The problem is that it uses the "acs_objects.last_modified" for the parent thread to get the last_modified date and either we need a trigger to update the parent last modified date or we have to rewrite the query.

It looks like it is wrong for both oracle and postgresql.