When i set a date to auto UN-PUBLISH its very hard to republish you have to go into back end and do a lot of searching then you need to open the article and remove the date to republish.

Just to be clear the state of these articles is "published but expired"

I have 40,000 articles so this is a nightmare.


Anyone know a better way to clear the dates from the un-publish date selectors in bulk. ?

If this needs a database fix (Im pretty sure it does) can you pleas tell me in a REALLY STUPID SIMPLE WAY...... :)

You need to check the publish_down cell of the #_k2_items table.

If the date is in the past then that item is published but expired.

OK I got into myphp, I see the pub down dates.


Ho do I remove all published down dates in one go ? I dont want to mess this up lol :)

You can set the cell's value to 0000-00-00 00:00:00 which is the default value.

I tried a few things changing to NULL etc, adding date to cell and saving does not seem to do anything, I see no change.

Its 404 central on my site :( thanks for trying.... 30,000 articles to fix one by one so DELETE IS MY ONLY OPTION :(

Restore a backup of your DB. It is quicker than deleting.
NULL will not work, did you try with 0000-00-00 00:00:00 ?
Also the date has to be in the same format.