Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

DateLastComment not updated?

vizionaviziona New
edited September 2010 in Vanilla 2.0 - 2.8

I have v1 vanilla, updated to v2beta, and later i kind of installed new v2.0.6 (git clone) which i updated with old files (config etc)

when I write comment to old discussion, its DateLastComment field is not updated, so the sorting is not correct

does anyone else have this problem?
PHP 5.2.6
Mysql 5.0.51

check this:


  • Options
    vizionaviziona New
    edited December 2010
    anyone? :)
    I am still having this problem and I have up-to-date git version
    @Tim @Mark
  • Options
    I am continuing to have this problem
    temporarily solution is to run this sql via cronjob:

    "update GDN_Discussion as d
    set DateLastComment= (SELECT max(DateInserted) from GDN_Comment as c where c.DiscussionID=d.DiscussionID)
    where DateLastComment != (SELECT max(DateInserted) from GDN_Comment as c where c.DiscussionID=d.DiscussionID)"
  • Options
    LincLinc Detroit Admin
    It's updated by CommentModel->UpdateCommentCount(). Are you doing something outside the base app and not calling that method?
  • Options

    No, normal vanilla comments are used.
    I already looked into this method and found no reason for those discussions not to be updated
Sign In or Register to comment.