Post sort order about chyrp-lite HOT 10 CLOSED

from chyrp-lite.

This is the front page of the blog. As loaded by default.
Note recent posts list the two "what is backup software" posts (this is correct) - but the blog itself shows "Volume Shadow Copy" as the first post, while it should be third:

from chyrp-lite.

Perhaps your post "Volume Shadow Copy" is pinned? This would cause it to appear above other posts in the blog index and the admin area. The usual sort order for both blog and admin area is pinned DESC, created_at DESC, id DESC.

What happens to the sort order if you edit some of the other posts?

from chyrp-lite.

Thanks for your reply - nothing is pinned.

Here's an extract of the database:

and the rest of the lines:

The updated_at is only filled for the posts I modified...don't know if this is linked to the fact that everything was imported.

from chyrp-lite.

....or maybe the sort problem is that the pinned field was not updated when the data was imported, and hence is null...and the update sets it to 0, and null comes before 0 in a sort

from chyrp-lite.

Yes I think that may be the answer. Chyrp Lite will consider any “falsey” value as unpinned, but the database is prioritising null above 0 when it sorts the query results. The recent posts in the blog sidebar are not affected because the sort order for those results does not consider pinned status.

from chyrp-lite.

I'll update the DB manually, setting 'pinned' to 0 everywhere. Might be an idea (if possible) to set pinned to 0 on import, if not specified in the import file.

Thanks again

from chyrp-lite.

Confirmed, with a 0 in all lines, the sort is correct

from chyrp-lite.

Yes, I’m going to look into this later today. The import method is casting the pinned value from the XML document to boolean but the normal behaviour for added/updated posts is to cast the value to integer, and I think this is causing different handling when sent to the database. Thanks for the report!

from chyrp-lite.

The thanks are mine ;)

from chyrp-lite.