[#18208] - [4.0] 500 on frontend
- Closed
- 3 Oct 2017
- Medium
- Build: staging
- # 18208
Steps to reproduce the issue
Do a NEW install of current 4.0 branch without the sample data
Expected result
Front end works
Actual result
500 Expression #1 of ORDER BY clause is not in SELECT list, references column 'nmmtest1.c.lft' which is not in SELECT list; this is incompatible with DISTINCT
Votes
| Labels |
Added:
?
|
||
| Category | ⇒ | Front End |
If joomla use DISTINCT or GROUP BY in query then you can order by column that is included in SELECT statement.
You can go to home menu and set new order that column exists in select statement like:
or you can delete DISTINCT from https://github.com/joomla/joomla-cms/blob/4.0-dev/components/com_content/Model/ArticlesModel.php#L197
I do not know why someone add DISTINCT but this slow down very much this view.
The query has to be designed in a better way without using DISTINCT or GROUP BY.
IMO joomla 4.0 could try to find a better way to build query or I should say queries per model.
closed as having Pull Request #18215
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18208.
closed as having Pull Request #18215
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18208.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-10-03 18:25:32 |
| Closed_By | ⇒ | franz-wohlkoenig |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/18208
no please reopeon, it fix only some of the archive bugs
| Status | Discussion | ⇒ | New |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ |
| Status | Closed | ⇒ | Discussion |
| Closed_Date | 2017-10-03 18:25:32 | ⇒ | |
| Closed_By | franz-wohlkoenig | ⇒ |
Set to "open" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/18208
reopen as stated above.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18208.
now should fix when installing without sample data too
@franz-wohlkoenig can be closed now
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-10-03 19:36:38 |
| Closed_By | ⇒ | franz-wohlkoenig |
| Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/18208
closed as stated above.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/18208.
Also get the following when clicking on Archived Articles: