Jump to content


Photo

acp listing of articles - old dates first?


when viewing via "manage articles" in the acp

it lists any article with a published date at the top - before june 30th 2001 before the most current  ones

Status: Fixed
Version: 2.3.1
Fixed In: 2.3.2


2 Comments

looks like this is due to the ipcontent article publishing date field

it doesn't seem to add a leading 0 to dates in this field to unix timestamps starting with a leading 9 or 8
which then throws the sort by published dates order

have just confirmed by editing such a published date and no 0

to resolve for now you need to goto the database and enter a leading 0 in front of all the "old" unix dates
eg dates bit starting with a 9 0r 8
eg change manually 933919233 to 0933919233
UPDATE ccs_database_fields SET field_is_numeric = '1' WHERE field_key='article_date';