Clean install using Protostar without any 3rd-Party-Plugins -Components, with a postgreSQL database.
Administrator login.
Administrator login
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...^
PostgreSQL 9.5.6
PHP 7
Joomla-CMS-staging (17/08/2017)
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"
Labels |
Added:
?
|
Category | ⇒ | com_installer Postgresql |
Priority | Medium | ⇒ | Urgent |
Status | New | ⇒ | Information Required |
Yeah right. I'll check it soon
it fail on MySQLi 5.7.19 too
did'nt understand that query well
Status | Information Required | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-08-19 10:15:31 |
Closed_By | ⇒ | franz-wohlkoenig |
Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
closed as having Pull Request #17620
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/17582
@izharaazmi Plese check this may be related to #17511