CMS MADE SIMPLE FORGE

CGBlog

 

[#9054] browsecat does not return correct number of posts

avatar
Created By: Lapinos (lapinos03)
Date Submitted: Thu Mar 14 05:32:31 -0400 2013

Assigned To:
Version: 1.9.12
CMSMS Version: None
Severity: Minor
Resolution: None
State: Open
Summary:
browsecat does not return correct number of posts
Detailed Description:
This bug has same origin as bug report #8935.

In file function.browsecat.php, line 68, where :
$query .= ' AND (('.$db->IfNull('end_time',$zerotime)." = $zerotime) OR
(end_time > $now))";

...clause does not take into account the case when end_time = '0000-00-00
00:00:00' (due to 'null' string value injection in table.

My workaround :
$query .= ' AND (('.$db->IfNull('end_time',$zerotime)." = $zerotime) OR
(end_time > $now) OR (end_time = '0000-00-00 00:00:00'))";


/Lapi


History

Comments
avatar
Date: 2013-09-04 13:45
Posted By: Robert Campbell (calguy1000)

the problem is... how does zerotime get into the database.  it should just be
null.
      
Updates

Updated: 2013-09-04 13:45
resolution_id: => 5
cmsms_version_id: 29887 => -1