[#17902] - [com_content] - category list/blog/featured sql error on postgresql
- Fixed in Code Base
- 25 Sep 2017
- Medium
- Build: staging
- # 17902
- Diff
- alikon:patch-94
- Pending hound Hound is busy reviewing changes... Details
User tests: Successful: Unsuccessful:
Pull Request for Issue #17901.
Summary of Changes
fix category list/blog/featured sql error on postgresql
you cannot ORDER BY on a field not selected
Testing Instructions
Go to frontpage and click on Article Category Blog or Article Category List
/index.php/article-category-list
/index.php/article-category-blog
/index.php/featured-articles
/index.php/content-modules
Expected result
no error
Actual result
sql error
Votes
joomla-cms-bot
- | Category | ⇒ | Front End com_content |
| Status | New | ⇒ | Pending |
| Labels |
Added:
?
|
||
| Title |
|
||||||
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17902.
@tormes You may be interested in testing this PR and you can mark it as success at https://issues.joomla.org/tracker/joomla-cms/17902
After two success tests it should be mark as ready to commit (RTC).
When I overwrite the file components/com_content/models/articles.php with the same file from @alikon (last commit 678e67c 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/17902.
I have tested this item
Tested overwriting the modified file over 3.8.0 stable.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17902.
| Status | Pending | ⇒ | Ready to Commit |
RTC after two successful tests.
mbabker
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-09-25 11:43:59 |
| Closed_By | ⇒ | mbabker | |
| Labels |
Added:
?
|
||
I have tested this item✅ successfully on e34d35f
Tested on postgresql and mysql.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17902.