J4 Issue ?
avatar infograf768
infograf768
9 Aug 2018

Steps to reproduce the issue

Install 4.0-dev. Install some languages. Install the multilingual sample data.

Bug

500 'v40_multi.wa.state_id' isn't in GROUP BY
articles Manager
0 Argument 1 passed to Joomla\Utilities\ArrayHelpergetColumn() must be of the type array, boolean given, called in /administrator/components/com_content/Model/ArticlesModel.php on line 483

basic solution proposed by @rdeutz

in ArticlesModel line 286ff (I love the $bingo variable ? )

		// Join over the associations.
		if (Associations::isEnabled())
		{
			$bingo = $associationsGroupBy;
   			$bingo[] = 'wa.state_id';
   			$bingo[] = 'ws.title';
   			$bingo[] = 'ws.condition';
   			$bingo[] = 'ws.workflow_id';
			
			$query->select('COUNT(asso2.id)>1 as association')
				->join('LEFT', '#__associations AS asso ON asso.id = a.id AND asso.context=' . $db->quote('com_content.item'))
				->join('LEFT', '#__associations AS asso2 ON asso2.key = asso.key')
				->group($db->quoteName($bingo));
		}

It works here.

Additional comments

I do not understand the new Table Options: Select State and Select Condition.

@bembelimen

avatar infograf768 infograf768 - open - 9 Aug 2018
avatar joomla-cms-bot joomla-cms-bot - change - 9 Aug 2018
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 9 Aug 2018
avatar brianteeman
brianteeman - comment - 9 Aug 2018

Workflow is simply not ready - see #21476

avatar franz-wohlkoenig franz-wohlkoenig - change - 9 Aug 2018
Status New Discussion
avatar franz-wohlkoenig franz-wohlkoenig - change - 9 Aug 2018
Category com_content Multilanguage
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 9 Aug 2018

After clean Install and Multilanguage Sample Data get: Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column '.wa.state_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

avatar rdeutz
rdeutz - comment - 9 Aug 2018

@franz-wohlkoenig its the same problem

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 9 Aug 2018

@rdeutz wrote this because of Comment and haven't linked back but will do.

avatar wilsonge wilsonge - change - 9 Aug 2018
Title
[4.0] New Workflow breaks articles when multilingual and associations ON
[4.0] [Workflow] New Workflow breaks articles when multilingual and associations ON
avatar wilsonge wilsonge - edited - 9 Aug 2018
avatar infograf768 infograf768 - change - 9 Aug 2018
Labels Added: J4 Issue
avatar infograf768 infograf768 - labeled - 9 Aug 2018
avatar franz-wohlkoenig franz-wohlkoenig - change - 10 Aug 2018
Status Discussion Closed
Closed_Date 0000-00-00 00:00:00 2018-08-10 04:15:06
Closed_By franz-wohlkoenig
avatar joomla-cms-bot joomla-cms-bot - change - 10 Aug 2018
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 10 Aug 2018
avatar joomla-cms-bot
joomla-cms-bot - comment - 10 Aug 2018
avatar franz-wohlkoenig franz-wohlkoenig - change - 10 Aug 2018
Category com_content Multilanguage com_content com_workflow Multilanguage
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 10 Aug 2018

closed as having Pull Request #21512

Add a Comment

Login with GitHub to post a comment