?
avatar twister65
twister65
17 Aug 2017

Steps to reproduce the issue

Clean install using Protostar without any 3rd-Party-Plugins -Components, with a postgreSQL database.
Administrator login.

Expected result

Administrator login

Actual result

Error displaying the error page
Error: 0 ERROR: column "m.language" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...E(SUM(m.home),0) WHEN 0 THEN "WHEN 1 THEN CASE m.language...^

System information (as much as possible)

PostgreSQL 9.5.6
PHP 7
Joomla-CMS-staging (17/08/2017)

Additional comments

This query appears in this file : administrator/components/com_menus/presets/joomla.xml (line 208).
https://github.com/joomla/joomla-cms/commits/staging/administrator/components/com_menus/presets/joomla.xml
sql_select="a.title, a.menutype, CASE COALESCE(SUM(m.home), 0) WHEN 0 THEN '' WHEN 1 THEN CASE m.language WHEN '*' THEN 'class:icon-home' ELSE CONCAT('image:mod_languages/', l.image, '.gif') END ELSE 'image:mod_languages/icon-16-language.png' END AS icon" sql_from="#__menu_types AS a" sql_where="a.client_id = 0" sql_leftjoin="#__menu AS m ON m.menutype = a.menutype AND m.home = 1 LEFT JOIN #__languages AS l ON l.lang_code = m.language" sql_group="a.id" sql_order="a.title ASC"

avatar twister65 twister65 - open - 17 Aug 2017
avatar joomla-cms-bot joomla-cms-bot - change - 17 Aug 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 17 Aug 2017
avatar wojsmol
wojsmol - comment - 17 Aug 2017

@izharaazmi Plese check this may be related to #17511

avatar franz-wohlkoenig franz-wohlkoenig - change - 17 Aug 2017
Category com_installer Postgresql
avatar franz-wohlkoenig franz-wohlkoenig - change - 17 Aug 2017
Priority Medium Urgent
Status New Information Required
avatar izharaazmi
izharaazmi - comment - 17 Aug 2017

Yeah right. I'll check it soon

avatar twister65 twister65 - change - 17 Aug 2017
The description was changed
avatar twister65 twister65 - edited - 17 Aug 2017
avatar alikon
alikon - comment - 17 Aug 2017

it fail on MySQLi 5.7.19 too
did'nt understand that query well 😢

avatar franz-wohlkoenig franz-wohlkoenig - change - 19 Aug 2017
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2017-08-19 10:15:31
Closed_By franz-wohlkoenig
avatar joomla-cms-bot joomla-cms-bot - change - 19 Aug 2017
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 19 Aug 2017
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 19 Aug 2017

closed as having Pull Request #17620


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

avatar joomla-cms-bot
joomla-cms-bot - comment - 19 Aug 2017

Add a Comment

Login with GitHub to post a comment