Subject: lib-syndication.php for same date

Posted on: 06/06/21 11:08am
By: Anonymous

On my site, there are articles with same date in same topic.
This caused an issue.

ref.
https://github.com/Geeklog-Core/geeklog/blob/master/public_html/lib-common.php
https://github.com/Geeklog-Core/geeklog/blob/master/system/lib-syndication.php

SYND_feedUpdateCheck() is called in line 2258, and SYND_updateFeed() is called in line2268.
SYND_feedUpdateCheck() calls SYND_feedUpdateCheckTopic() in which sql is sorted by date in line 149. In the same way, SYND_updateFeed() calls SYND_getFeedContentPerTopic() in which sql is sorted by date in 254.

For the Sid with exactly same date, those two returns different order.
So this should be ordered by date AND SID like the following, to fix this issue.
PHP Formatted Code
ORDER BY date DESC, sid


If Geeklog doesn't allow post articles with same date for same topic, it doesn't occur. My site is customized a lot, and there are articles with same date, so it happens.

Re: lib-syndication.php for same date

Posted on: 06/06/21 03:50pm
By: Laugh

Thanks for the report.

Add it to github:

https://github.com/Geeklog-Core/geeklog/issues/1091

By the way you are more than welcome to add the issues as well to github.

Thanks

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=97425