CMS MADE SIMPLE FORGE

News Module

 

[#9813] parameter sortby='start_time' gives SQL error

avatar
Created By: Jos (josvd)
Date Submitted: Tue Feb 04 19:41:38 -0500 2014

Assigned To:
Version: 2.14.1
CMSMS Version: 1.11.10
Severity: Minor
Resolution: Fixed
State: Closed
Summary:
parameter sortby='start_time' gives SQL error
Detailed Description:
When using parameter {news sortby='start_time'} no result is shown because of a
SQL error.

Solution:
in file action.default.php change line 148
from:
      $query1 .= "ORDER BY mn.".$sortby;
to:
      $query1 .= "ORDER BY mn.".$sortby." ";


History

Comments
avatar
Date: 2014-02-11 15:46
Posted By: Reto Hugi (reto)

I can confirm this bug and tested the suggested fix. Works like expected again.
Thanks Jos.
      
avatar
Date: 2014-02-11 15:54
Posted By: Robert Campbell (calguy1000)

Fixed in svn. thanks.
      
avatar
Date: 2015-09-06 13:12
Posted By: Rolf (rolf1)

CMS Made Simple 1.12.1 and 2.0 are released
      
Updates

Updated: 2015-09-06 13:12
state: Open => Closed

Updated: 2014-02-11 15:54
resolution_id: => 7