Duplicate Last Update Date Incorrect After Import

[Movie Prop Sites]

Title pretty much says it all. We just imported from vb4 and everything looks good except the Last Update date:

https://www.thedentedhelmet.com/forums/media/albums/my-new-helmet.612/

Is there a way to recalculate these?

 

[Chris D]

That must be a bug.

We must have gotten an update date of 0 from the vB database in these cases. In which case, it should be fine to run the following query:

UPDATE xengallery_album
SET last_update_date = album_create_date
WHERE last_update_date = 0

That will set the last update date to be the same as the album creation date on all albums where the last update date is 0 (a value of 0 produces a date at around 1st January 1970).

 

[Movie Prop Sites]

Once again, thanks @Chris D. That does look a lot better than all those 1970 dates!

 

[Chris D]

This already seems like it was fixed over 2 years ago.

When you imported, could you have been using XFMG 1.0.x rather than 1.1.x?

If not then it could be that you somehow had files on the server which weren't up to date.

Either way, it does appear to be fixed:
https://xenforo.com/community/threa...lbum-last-updated-to-jan-1-1970-epoch.102555/