Fixed Gallery Import

[Venthas]

Affected version

2.2.1

Having the same issues from this thread, except all images imported are set to this date.

Fixed - VB 4 importer incorrectly sets album 'Last Updated' to Jan 1, 1970 (epoch)

I did a test import of a VB 4.21 Gallery into XFMG 1.1.0 B2 Empty albums imported the correct 'Create Date', but 'Last Update' says "Jan 1, 1970" I haven't been able to test whether this is also a problem on albums with images as I ran into a bug with the importer not correctly importing...

xenforo.com

Importing from Invision Gallery 4.5.4.

 

[Venthas]

All of the column media_date in xf_mg_media_item are 0s. Looks like it never imported the dates at all from Invision gallery. Album dates did, but not image dates.

 

[Venthas]

I'm wondering if I can run a Join on the dates from invision gallery based on ID (the IDs were retained). If there's a possible merge between image_date from the Invision database to media_date in XF's database, then it should be possible based on IDs.

 

[Venthas]

Fixed with a simple query:

UPDATE XFdb.xf_mg_media_item, invisionDB.gallery_images
SET XFdb.xf_mg_media_item.media_date = invisionDB.gallery_images.image_date
WHERE XFdb.xf_mg_media_item.media_id = invisionDB.gallery_images.image_id;

This is missing somewhere in the conversion, not sure where.

 

[XF Bug Bot]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XFMG release (2.2.2).

Change log:

Fix an issue where media items imported from IPS Gallery did not retain the correct creation date.

There may be a delay before changes are rolled out to the XenForo Community.