Update from Ghost 0.6 to 0.7

If you also happen to update your ghost blog from version 0.6 to 0.7, you might experience that your new posts are not showing up on the blog anymore.

The reason is that the time-stamps on the database changes in the new version but the previous posts keep the old format. Therefore all you need to do is to login to your database and issue the following command:

update posts set created_at=strftime('%s',created_at),
                  updated_at=strftime('%s',updated_at),
                  published_at=strftime('%s',published_at) 
                  where substr(created_at,1,2) == '20';

This is what I used in sqlite3. Similarly one can use the similar command for MySQL or PostgreSQL.

Have fun blogging.