Duplicate Last Update Date Incorrect After Import

Chris D

XenForo developer
Staff member
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).