Problem with sort order, possibly linked to Smart Collections

Server Version#: 4.147.1
Player Version#: all

Hello all

I should be very grateful if someone could help. I had smart collections for movies by decade. These movies were in the smart collection, and also shown in the main library. The smart collections had a sort order so that they would be the first things in the movie library, and each collection was sorted by date, earliest first.

Following no changes that I intentionally made, the movies in these collections were the first thing in my library, in the order in which they appeared in the smart collection. I deleted the smart collections, and the problem persisted.

If I edit the “sort order” field, the problem is fixed. So it seems to be a problem in there. If the sort field is empty, the problem comes back.

Using my few skills and ChatGPT I have rummaged about the database, and it does not seem to be a problem there. I am at a bit of a loss.

If anyone can help, it would be appreciated.