Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#15329] - [4.0] 500 when loading com_associations

?
avatar infograf768
infograf768
16 Apr 2017

Steps to reproduce the issue

Multilingual site (Install languages via package install). 2 languages is enough.

Create items in both languages.
Go to administrator/index.php?option=com_associations&view=associations

Choose item and language

500 - An error has occurred.

'joomla40.a.alias' isn't in GROUP BY 'joomla40.a.alias' isn't in GROUP BY

avatar infograf768 infograf768 - open - 16 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 16 Apr 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 16 Apr 2017
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 16 Apr 2017

Issue confirmed.

System information

Joomla! 4.0.0-dev (nightly Build)
macOS Sierra, 10.12.4
Firefox 52 (64-bit)

MAMP 4.1.1

  • PHP 7.0.15
  • MySQLi 5.6.35
avatar franz-wohlkoenig franz-wohlkoenig - change - 16 Apr 2017
Status New ⇒ Confirmed
avatar franz-wohlkoenig franz-wohlkoenig - change - 16 Apr 2017
Category ⇒ com_associations Multilanguage
avatar wilsonge
wilsonge - comment - 16 Apr 2017

Fixed with 327eee1

@alikon does this need to be backported to staging for postgres?

avatar wilsonge wilsonge - change - 16 Apr 2017
Status Confirmed ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2017-04-16 14:18:28
Closed_By ⇒ wilsonge
avatar wilsonge wilsonge - close - 16 Apr 2017
avatar infograf768
infograf768 - comment - 17 Apr 2017

@wilsonge
You missed menutype line 311

Add after

		if (!empty($fields['menutype']))
		{
			$query->select($db->qn($fields['menutype'], 'menutype'));

this
$groupby[] = 'menutype';

avatar alikon
alikon - comment - 17 Apr 2017

@wilsonge is not necessary in staging with postgresql it works well

avatar wilsonge
wilsonge - comment - 17 Apr 2017

Fixed JM :)

Add a Comment

Login with GitHub to post a comment