Feeling Lucky
?
[#16712] - [libraries] - legacy categories use group by when needed
- Fixed in Code Base
- 21 Jun 2017
- Medium
- Build: staging
- # 16712
- Diff
- alikon:patch-91
- Success hound No violations found. Woof! Details
User tests: Successful: Unsuccessful:
Summary of Changes
group by is necessary only when we have a function like COUNT() in the select
Testing Instructions
- enable debug plugin
- creat a menu item of type single article and set homepage
- go to the home page
- click on debug database tab
- look for this query #__categories
- apply th pr
you should see this one
no more group by
Expected result
no group by
Actual result
unneeded group by
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Libraries |
Quy
- comment
- 15 Jun 2017
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/16712.
Quy
- comment
- 15 Jun 2017
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/16712.
| Status | Pending | ⇒ | Ready to Commit |
franz-wohlkoenig
- comment
- 16 Jun 2017
RTC after two successful tests.
rdeutz
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-06-21 18:33:55 |
| Closed_By | ⇒ | rdeutz | |
| Labels |
Added:
?
|
||
I have tested this item✅ successfully on fb246b6
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/16712.