No Code Attached Yet
avatar tormes
tormes
22 Sep 2017

Steps to reproduce the issue

Fresh new install of Joomla_3.8.0-Stable-Full_Package.zip on localhost

  • Database Type: PostgreSQL
  • Install Sample Data: None
  • Pre-Installation Check: All Yes
  • Recommended settings: All Ok
    Finished OK with message "Congratulations! Joomla! is now installed."

The Administration site is OK. The front-site gives error at "Home" page
(As default the page "Home" is --> Articles » Featured Articles)

ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 9: ORDER BY c.lft, a.featured DESC, fp.ordering, CASE WHEN a.p... ^

And after creating an Article with "Feature status", the error changes to:

ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 8: ORDER BY c.lft, CASE WHEN a.publish_up = '1970-01-01 00:00:... ^

If I change the "Home" to --> Articles » Single Article, then the front-site is OK.

If I create a new category and configure "Home" to --> Articles » Category Blog, then the front-site gives ERROR:

500 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 8: ORDER BY c.lft, CASE WHEN a.publish_up = '1970-01-01 00:0... ^

Expected result

In a new empty fresh install of 3.8.0 version:
Home configured as Articles » Single Article OK
Home configured as Articles » Featured Articles OK
Home configured as Articles » Category Blog OK

Actual result

In a new empty fresh install of 3.8.0 version:
Home configured as Articles » Single Article OK
Home configured as Articles » Featured Articles ERROR
Home configured as Articles » Category Blog ERROR

System information (as much as possible)

Fresh new install of Joomla_3.8.0-Stable-Full_Package.zip on:

  • Apache 2.4.10 (Devuan)
  • PHP Version 5.6.30-0+deb8u1
  • PostgreSQL 9.6.1
  • No sample data, no extensions, no other languages, no templates

Additional comments

May be it could be related to using PostgreSQL ?

avatar tormes tormes - open - 22 Sep 2017
avatar joomla-cms-bot joomla-cms-bot - labeled - 22 Sep 2017
avatar wojsmol
wojsmol - comment - 22 Sep 2017

@alikon @csthomas Please check this.
@tormes Issue is related to using PostgreSQL.

avatar tormes
tormes - comment - 22 Sep 2017

Using Joomla_3.7.5-Stable-Full_Package.zip on the same machine with the same stack, and doing the same steps, works OK.


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

avatar alikon
alikon - comment - 22 Sep 2017

look at #17891 , #17902

avatar joomla-cms-bot joomla-cms-bot - change - 22 Sep 2017
Status Duplicate Report Closed
Closed_Date 2017-09-22 06:05:44 2017-09-22 06:05:45
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 22 Sep 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 22 Sep 2017
Status New Duplicate Report
Closed_Date 0000-00-00 00:00:00 2017-09-22 06:05:44
Closed_By franz-wohlkoenig
avatar joomla-cms-bot
joomla-cms-bot - comment - 22 Sep 2017
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 22 Sep 2017

closed as duplicated Report.


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

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 22 Sep 2017

@tormes please test #17902

avatar tormes
tormes - comment - 22 Sep 2017

When I overwrite the file components/com_content/models/articles.php with the same file from @alikon (last commit of Pull Request #17902), all errors reported are fixed. Note that this file has another difference in line 270 from the original in 3.8.0


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

Add a Comment

Login with GitHub to post a comment