Sorting Discussions by date created doesn't work

mye

I've got that lines in my config.php but sorting doesn't work

$Configuration['Vanilla']['Discussions']['SortField'] = 'd.DateInserted';
$Configuration['Vanilla']['Discussions']['SortDirection'] = 'desc';

Vanilla 2.1.3

Bleistivt

See http://vanillaforums.org/discussion/comment/215807/#Comment_215807

mye

My greedy namecheap.com hosting provider using PHP ver 5.3.28 all plugin code injection require 5.4

I tried to modify core but all I got is Fatal error.

I thought sorting options is something that should be implemented by default in a core...

mye

OK Solved. Modification of core vanilla 2.1.3
/applications/vanilla/models/class.discussionmodel.php

starting line 278 should be look like that

     // Build up the base query. Self-join for optimization.
      $Sql->Select('d2.*')
         ->From('Discussion d')
         ->Join('Discussion d2', 'd.DiscussionID = d2.DiscussionID')
         ->OrderBy('d.DateInserted', 'desc')
         ->Limit($Limit, $Offset);