#796 Submissions can be displayed out of order

[Ahasuerus]

The "New Submissions" page and the "My Pending Edits" page can display submissions out of order. This is due to the fact that the query sorts submissions by "review_date", which is set to NULL on these two pages. Absent a meaningful sort order, the database engine uses an internal sorting algorithm, which happens to work as expected most of the time. We want to change the sort order to "by review date, then by submission ID", which will ensure that the order will always be what is expected.

[Ahasuerus]

Fixed in:

biblio/myrecent.py
mod/list.py

Installed in SVN 841 on 2022-02-09. Closing the Bug report.