[3.3.0.21] Category article order is inconsistent when sorting by publication date

Describe the issue or problem

We created a category for a special issue in an OJS journal. Articles in this category can only be sorted via the category’s preset sorting options.

Because the issue uses page numbers, the sorting option “Publication Date (oldest first)” is particularly important.
However, when using any sorting option other than Title (A–Z), unexpected and inconsistent behavior occurs.

Expected behavior:
Articles should consistently appear in the selected sorting order (especially by publication date, oldest first).

Actual behavior:

  • With three articles, sorting by Publication Date (oldest first) works as expected.

  • As soon as a fourth article is added, the order becomes incorrect and no longer reflects the publication dates.

  • For other non-alphabetical sorting options, the order changes unpredictably after reloading the page. Sometimes the selected sorting is applied, sometimes it resets or switches without any changes being made by the user (other than a page reload).


Steps I took leading up to the issue

  1. Create a category for a special issue.

  2. Add three published articles to the category.

  3. Set the category sorting to Publication Date (oldest first).

  4. Verify that the sorting works correctly.

  5. Add a fourth article to the same category.

  6. Reload the category page.

  7. Observe that the article order is no longer correct.

  8. Change the sorting to another option (other than Title A–Z).

  9. Reload the page multiple times and observe that the sorting order changes inconsistently.


What application are you using?

OJS 3.3.0.21

Hello @marcogronewold many of these sorting inconsistencies have been resolved in later versions. I couldn’t reproduce this one anymore. There were a few bugs involving the sorting order issue, one on OMP which looks closest to yours, one to deal with a race condidtion when reloading the page and some improvements to add drag and drop. I believe they added a new column in the DB to address these sorting issues. It may still have some quirks but if you could check some of these fixes and see if they resolve your issue that would be fantastic.

[OJS] | Issue page - Race conditions might lead to unexpected section sorting/data loss · Issue #11752 · pkp/pkp-lib · GitHub ← race condition one

[OMP Settings] | Catalog - Sorting for ascending order not working · Issue #11743 · pkp/pkp-lib · GitHub ← OMP sorting issue one