Caused by a typo in FinderModelSearch::getListQuery()
line 234 should instead of
$query->where('(l.publish_start_date = ' . $nullDate . ' OR l.publish_end_date <= ' . $nowDate . ')')
be
$query->where('(l.publish_start_date = ' . $nullDate . ' OR l.publish_start_date <= ' . $nowDate . ')')
(...start... instead of ...end...)
Test:
create articles with
(1) Publish up in past and Publish down in future
(2) Publish up and down in past
(3) Publish up and down in future
(4) Publish up in past, no Publish down
(5) Publish up in future, no Publish down
and let finder find them all.
It should show (1) and (4).
But it shows (4) and (5).
Labels |
Added:
?
|
Category | ⇒ | Search SQL |
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-01-22 18:56:19 |
Closed_By | ⇒ | zero-24 |
Set to "closed" on behalf of @zero-24 by The JTracker Application at issues.joomla.org/joomla-cms/5859
Thanks so i close here as we have a PR here: #5869 Thanks
@hoffi1 can you create a pull request against staging?
If you need help please have a look into this doc page:
https://docs.joomla.org/Using_the_Github_UI_to_Make_Pull_Requests
Thanks!
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/5859.