[Julie Mowinski]

Hello,
I have migrated my site to another one and now everything works except that the images (photos) for the contacts are not displayed anymore.
I checked the new site, which contains the /wp-content/uploads/connection-images folders, containing the right images, for the 96 contacts.
However the system does not find them anymore. I didn’t find in the database where this information is stored.

The new site has another domain name, so this might have disrupted the links.

How can I recover ?
Many thanks indeed.

[Steven Zahm]

@ Jacques

Can you share a link to the directory page on the new site so I can take a look?

[Julie Mowinski]

Sure, herewith:

http://www.upboetendael.be/?page_id=233

the text is what I defined in the shortcut as alternate text in case of no image.

Thanks for your help

[Steven Zahm]

@ Jacques

Is the ../wp-content/uploads/connection-images/ permissions set to be readable and writeable. Generally folders should be 755 and files 644.

[Steven Zahm]

@ Jacques

When you edit an entry, what do you see for the image?

[Julie Mowinski]

Steven,

I changed folders permissions in …/connection-images/ to be 755 and files in it to be 644, as you recommend. But this doesn’t seem to change the issue.

A entry edit time, no image found. The edit panel says “No file selected”.

[Julie Mowinski]

Forgot to tell you another clue: when exporting the entries with the “export all” option, the resulting CSV has nothing in the “Photo URL” and in the “Logo URL” columns.

When doing the same on the old site, those columns contain the full path to the images.

[Julie Mowinski]

Steven,

I could partially fix the problem.
During the migration, the contractor who did the job replaced in the data base all occurrences of the old domain name (cluster007.ovh.net/~upboeten/) by the new one (www.upboetendael.be), so that internal links in articles are pointing to the new domain.

However, doing this on the wp-connections table caused probably the problem. I replaced back the new domain name by the old one in the “options” field of the wp-connections table and the pictures where showing back for individuals.

Unfortunately, it didn’t fix the problem for organizations and families. Maybe the way they refer to the pictures is different.

What do you think ?

[Steven Zahm]

@ Jacques

Ok, it sounds like a database migration issue. The best solution would have been to leave the URLs alone. Connections does not really care about the origin domain, only the relative path to the uploads folder. The URL will auto-adjust to new domains. My guess is because this data is saved in the entry option as a serialized array, that data was corrupted when the URL was changed from the old to the new. This would explain why changing the URL back worked and why you would not see the URL in the CSV export.

For the images for the entries which that did not fix, my guess is the serialized array is still corrupted, even with the change back to the old URL as the data for the image is saved exactly the same. The entry type does not matter. My suggestion is to look at the old db and compare that with the new on the entries which do not have an image and should to see what the difference is. You probably will be able to craft a query to fix the corrupted serialized array and restore those images too.

The only other option would be to reupload them.

Hope that helps. Let me know.

ps. I’ve found the best way to migrate a site is using BackupBuddy or Duplicator. And if moving just the Connections data, to do that manually by copying the connections-images folder to the new site and then exporting the as a SQL file the Connections tables and them importing the Connections tables on the new site. The only real change you would have to do is make sure the table prefixes WordPress uses match after the import.

[Julie Mowinski]

Many thanks Steven.

I exported the wp-connection table from the backup db from the old domain with the “empty table” option and imported it into the new domain db. So a complete replacement of that table as it was in the old domain and … everything works now as a charm.

Thank you for your explanations and support.

[Author]

Posts