Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#3291] - PostgreSQL - modules\mod_articles_archive fails because there is no GROUP BY created_year DESC, created_month DESC

?
avatar vdespa
vdespa
13 Mar 2014

Steps to reproduce the issue

Activate the module mod_articles_archive (Archived Articles)

Expected result

No errors

Actual result

Syntax error. PostgreSQL does not accept GROUP BY followed by DESC, like MySQL DOES

System information (as much as possible)

PostgreSQL 9.3

Additional comments

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
4.00
avatar vdespa vdespa - open - 13 Mar 2014
avatar vdespa vdespa - change - 13 Mar 2014
Status New ⇒ Confirmed
avatar vdespa vdespa - reference | - 13 Mar 14
avatar zero-24 zero-24 - close - 13 Mar 2014
avatar Bakual
Bakual - comment - 13 Mar 2014

Closing since there is a PR #3292 (which automatically has its own issue).

avatar Bakual Bakual - change - 13 Mar 2014
Status New ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2014-03-13 07:50:50
avatar Bakual Bakual - close - 13 Mar 2014
avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?

Add a Comment

Login with GitHub to post a comment