?
Referenced as Pull Request for: # 6263
avatar wolm
wolm
1 Mar 2015

Steps to reproduce the issue

Place a standard Articles - Archive module, set it to show 10 months

Expected result

List of 10 year/month Links to the archive component

Actual result

List of 10 links to february 2015.

System information (as much as possible)

Joomla 3.4.0
MySQL 5.6.21

Additional comments

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');
avatar wolm wolm - open - 1 Mar 2015
avatar brianteeman brianteeman - change - 1 Mar 2015
Labels Added: ?
avatar Erftralle
Erftralle - comment - 2 Mar 2015

Confirmed. Opened pull request #6263.

avatar zero-24 zero-24 - change - 2 Mar 2015
Status New Closed
Closed_Date 0000-00-00 00:00:00 2015-03-02 20:29:00
Closed_By zero-24
avatar joomla-cms-bot joomla-cms-bot - change - 2 Mar 2015
Status New Closed
Closed_Date 0000-00-00 00:00:00 2015-03-02 20:29:00
avatar joomla-cms-bot joomla-cms-bot - close - 2 Mar 2015
avatar joomla-cms-bot
joomla-cms-bot - comment - 2 Mar 2015

Set to "closed" on behalf of @zero-24 by The JTracker Application at issues.joomla.org/joomla-cms/6246

avatar joomla-cms-bot joomla-cms-bot - close - 2 Mar 2015
avatar zero-24
zero-24 - comment - 2 Mar 2015

Closing as we have a PR Thanks!


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6246.

Add a Comment

Login with GitHub to post a comment