Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#21436] - [postgresql] - wrong GROUP BY in multilanguage site

? Pending

User tests: Successful: Unsuccessful:

avatar alikon
alikon
7 Aug 2018

yet another one wrong GROUP BY - redo of #21378 in the correct 3.9-dev branch

Summary of Changes

fixed wrong GROUP BY

Testing Instructions

install a multilanguage site with postgresql
simply open Control Panel or Articles

Expected result

works as it should

Actual result

screenshot from 2018-08-03 10-38-25

avatar alikon alikon - open - 7 Aug 2018
avatar alikon alikon - change - 7 Aug 2018
Status New ⇒ Pending
avatar joomla-cms-bot joomla-cms-bot - change - 7 Aug 2018
Category ⇒ Administration com_content
8a2504f 1 Sep 2018 avatar alikon cs
avatar alikon alikon - change - 1 Sep 2018
Labels Added: ?
avatar csthomas
csthomas - comment - 2 Sep 2018

I tested it and it works, but

$assogroup = 'a.id, l.title, l.image, uc.name, ag.title, c.title, ua.name, c.created_user_id, c.level, parent.id';

also works and it is a short list.

It works because parent.id is a primary key, the same as a.id.

Could you change it?

avatar alikon
alikon - comment - 3 Sep 2018

sure, done
thanks

avatar csthomas csthomas - test_item - 3 Sep 2018 - Tested successfully
avatar csthomas
csthomas - comment - 3 Sep 2018

I have tested this item ✅ successfully on 807116e

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

avatar csthomas csthomas - test_item - 3 Sep 2018 - Tested successfully
avatar mbabker mbabker - close - 9 Sep 2018
avatar mbabker mbabker - merge - 9 Sep 2018
avatar mbabker mbabker - change - 9 Sep 2018
Status Pending ⇒ Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 ⇒ 2018-09-09 17:13:20
Closed_By ⇒ mbabker

Add a Comment

Login with GitHub to post a comment