Fixed Gallery Import

Affected version
2.2.1

Venthas

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


Importing from Invision Gallery 4.5.4.
 
Last edited:

Venthas

Member
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

Member
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

Member
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

XenForo bug fixer bot
Staff member
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.
 
Top