Sorting Discussions by date created doesn't work

mye · September 2014

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 · September 2014

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

mye · September 2014

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 · September 2014

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);

Sorting Discussions by date created doesn't work

Comments