Feeling Lucky
?
[#17901] - Article category list does not work on postgresql installed with sample testing data
- Closed
- 9 Sep 2017
- Medium
- Build: staging
- # 17901
Steps to reproduce the issue
Install Joomla staging on postgresql with sample data - testing
Go to frontpage and click on Article Category Blog or Article Category List
/index.php/article-category-list
/index.php/article-category-blog
Expected result
Without errors
Actual result
500 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 8: ORDER BY c.lft, a.title, a.created LIMIT 10 ^
or
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... ^
System information (as much as possible)
PostgreSQL 9.5.8
Additional comments
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-09-09 06:08:04 |
| Closed_By | ⇒ | franz-wohlkoenig |
| Closed_Date | 2017-09-09 06:08:04 | ⇒ | 2017-09-09 06:08:05 |
| Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
franz-wohlkoenig
- comment
- 9 Sep 2017
closed as having Pull Request #17902
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17901.
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/17901