[#30301] - [3.9.20 / 4.0.b4] Articles Category Module - Article Field to Order By (Descending Bug)
- New
- Medium
- Build: master
- # 30301
Steps to reproduce the issue
I noticed that if i set the option "Article Field to Order By" to "Descending" then it will sort the Articles with the database entries "0000-00-00 00:00:00" first before everything else. The correct way would be to filter this Articles out or sorted then at the very end.
Expected result
Sorting Descending:
Articles -> 2020-01-04 08:08:12
Articles -> 2020-01-03 13:34:52
OR:
Articles -> 2020-01-04 08:08:12
Articles -> 2020-01-03 13:34:52
Articles -> 0000-00-00 00:00:00
Actual result
Sorting Descending:
Articles -> 0000-00-00 00:00:00
Articles -> 2020-01-04 08:08:12
Articles -> 2020-01-03 13:34:52
System information (as much as possible)
PHP v7.4.8 and MySQL v5.5.5-10
Additional comments
Votes
joomla-cms-bot
- 
There was bug in an extensions that caused this 0000-00-00 problem.
Now Joomla writes the creating date into the modified date when their no date exists.
But this is even worse because now i can't even separate the Updated Articles from the Latest Articles.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/30301.
Hackwar
- | Labels |
Added:
No Code Attached Yet
bug
Removed: ? |
||
In 3.9.x this might be an issue. But in 4.0? There should not be any old 0000-00-00 dates anymore, they should have real null values instead, or if not nullable have a value not equal to this old null date.
@LuxLOL Have you really tested that on a 4.0 with a new installation or with an updated one from 3.10 (which might have been previously updated from 3.9.x)? I doubt there were really null dates.