[#1542] - Fixing articles and article model query. It was failing if there are mul...
- Closed
- 17 Jul 2013
- Medium
- Build: master
- # 1542
- Diff
- Bakual:ArticlesModels
- Success default The Travis CI build passed Details
User tests: Successful: Unsuccessful:
Fixing articles and article model query. It was failing if there are multiple contacts of different languages assigned to the same user, resulting in duplicated content shown.
There is also a huge performance loss if there are many articles due to the GROUP BY statement. According to the discussion on Google Groups:
https://groups.google.com/forum/?fromgroups=#!topic/joomla-dev-general/sVFw9reqGGw
concerning the GROUP BY part, see comments on tracker.
This PR will only remove the GROUP BY on the main query. There is still one GROUP BY in a subquery which searchs the parent categories for unpublished or trashed categories. I think that one is still needed.
I did not realize a release was pending. Definitely do not want to hold this performance and duplication fix back - it must go in for certain! We'll work on a fuller solution in next release. That'll give us a little time to play with your integration ideas, ;-) @Bakual
garyamort
-
Tracker for Joomla 3.1
http://joomlacode.org/gf/project/joomla/tracker/?action=TrackerItemEdit&tracker_item_id=31476