Place a standard Articles - Archive module, set it to show 10 months
List of 10 year/month Links to the archive component
List of 10 links to february 2015.
Joomla 3.4.0
MySQL 5.6.21
Seems to be a problem in modules/mod_articles_archive/helper.php
The query has been changed from
$query->select($query->month($db->quoteName('created')) . ' AS created_month')
->select('created, id, title')
->select($query->year($db->quoteName('created')) . ' AS created_year')
->from('#__content')
->where('state = 2 AND checked_out = 0')
->group('created_year DESC, created_month DESC');
to
$query->select($query->month($db->quoteName('created')) . ' AS created_month')
->select('created, id, title')
->select($query->year($db->quoteName('created')) . ' AS created_year')
->from('#__content')
->where('state = 2 AND checked_out = 0')
->group('created_year, created_month, created, id, title')
->order('created_year DESC, created_month DESC');
Labels |
Added:
?
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-03-02 20:29:00 |
Closed_By | ⇒ | zero-24 |
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-03-02 20:29:00 |
Set to "closed" on behalf of @zero-24 by The JTracker Application at issues.joomla.org/joomla-cms/6246
Closing as we have a PR Thanks!
Confirmed. Opened pull request #6263.