[Brittany Vacchiano]

Copied production DB where connections is working well and imported it into our dev DB (changing the hostname to match the dev environment’s hostname)

In the entries below you’ll notice there’s a .jpg.jpg file extension in both instances. Even though that’s the case (thought it was weird, but could be because the image got uploaded twice), the links listed in both options entries return proper images.

I’ve included two entries for each DB.

DEV – NOT WORKING

Entry 1

a:3:{s:5:"entry";a:1:{s:4:"type";s:10:"individual";}s:5:"group";a:1:{s:6:"family";a:0:{}}s:5:"image";a:4:{s:6:"linked";b:1;s:7:"display";b:1;s:4:"name";a:1:{s:8:"original";s:28:"Missing-Equine-Photo.jpg.jpg";}s:4:"meta";a:1:{s:8:"original";a:8:{s:4:"name";s:28:"Missing-Equine-Photo.jpg.jpg";s:4:"path";s:107:"/app/wwwroot/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg";s:3:"url";s:127:"http://thewire-dev.subdomainommitted.org/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg";s:5:"width";i:200;s:6:"height";i:248;s:4:"size";s:24:"width="200" height="248"";s:4:"mime";s:10:"image/jpeg";s:4:"type";i:2;}}}}

Entry 2

a:3:{s:5:"entry";a:1:{s:4:"type";s:10:"individual";}s:5:"group";a:1:{s:6:"family";a:0:{}}s:5:"image";a:4:{s:6:"linked";b:1;s:7:"display";b:1;s:4:"name";a:1:{s:8:"original";s:20:"KEARNEY-John.jpg.jpg";}s:4:"meta";a:1:{s:8:"original";a:8:{s:4:"name";s:20:"KEARNEY-John.jpg.jpg";s:4:"path";s:92:"/app/wwwroot/thewire/wp-content/uploads/connections-images/john-kearney/KEARNEY-John.jpg.jpg";s:3:"url";s:112:"http://thewire-dev.subdomainommitted.org/thewire/wp-content/uploads/connections-images/john-kearney/KEARNEY-John.jpg.jpg";s:5:"width";i:200;s:6:"height";i:250;s:4:"size";s:24:"width="200" height="250"";s:4:"mime";s:10:"image/jpeg";s:4:"type";i:2;}}}}

PROD – WORKING

Entry 1

a:3:{s:5:"entry";a:1:{s:4:"type";s:10:"individual";}s:5:"group";a:1:{s:6:"family";a:0:{}}s:5:"image";a:4:{s:6:"linked";b:1;s:7:"display";b:1;s:4:"name";a:1:{s:8:"original";s:28:"Missing-Equine-Photo.jpg.jpg";}s:4:"meta";a:1:{s:8:"original";a:8:{s:4:"name";s:28:"Missing-Equine-Photo.jpg.jpg";s:4:"path";s:107:"/app/wwwroot/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg";s:3:"url";s:127:"http://thewire.subdomainommitted.org/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg";s:5:"width";i:200;s:6:"height";i:248;s:4:"size";s:24:"width="200" height="248"";s:4:"mime";s:10:"image/jpeg";s:4:"type";i:2;}}}}

Entry 2

a:3:{s:5:"entry";a:1:{s:4:"type";s:10:"individual";}s:5:"group";a:1:{s:6:"family";a:0:{}}s:5:"image";a:4:{s:6:"linked";b:1;s:7:"display";b:1;s:4:"name";a:1:{s:8:"original";s:20:"KEARNEY-John.jpg.jpg";}s:4:"meta";a:1:{s:8:"original";a:8:{s:4:"name";s:20:"KEARNEY-John.jpg.jpg";s:4:"path";s:92:"/app/wwwroot/thewire/wp-content/uploads/connections-images/john-kearney/KEARNEY-John.jpg.jpg";s:3:"url";s:112:"http://thewire.subdomainommitted.org/thewire/wp-content/uploads/connections-images/john-kearney/KEARNEY-John.jpg.jpg";s:5:"width";i:200;s:6:"height";i:250;s:4:"size";s:24:"width="200" height="250"";s:4:"mime";s:10:"image/jpeg";s:4:"type";i:2;}}}}

[Steven Zahm]

@ Brittany

For Entry 1 on Dev, update the options value in the database with this:

a:3:{s:5:"entry";a:1:{s:4:"type";s:10:"individual";}s:5:"group";a:1:{s:6:"family";a:0:{}}s:5:"image";a:4:{s:6:"linked";b:1;s:7:"display";b:1;s:4:"name";a:1:{s:8:"original";s:28:"Missing-Equine-Photo.jpg.jpg";}s:4:"meta";a:1:{s:8:"original";a:8:{s:4:"name";s:28:"Missing-Equine-Photo.jpg.jpg";s:4:"path";s:107:"/app/wwwroot/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg";s:3:"url";s:135:"http://thewire-dev.subdomainommitted.org/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg";s:5:"width";i:200;s:6:"height";i:248;s:4:"size";s:24:"width="200" height="248"";s:4:"mime";s:10:"image/jpeg";s:4:"type";i:2;}}}}

Does that entry work now?

[Trent]

I am working on the same issue. We noticed that making the absolute URL’s value be empty and setting the length to 0 causes the image to display properly. However this is not a fix we can feasibly apply to all data and would require a code change to ensure the value s:135:"http://thewire-dev.subdomainommitted.org/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg"; is set to s:0:"" in the options array.

Is there a way to make the data more portable by either of the following:

(A) Always set that specific element in the options array to be an empty string (i.e. s:0:"")

(B) Have the path be relative such that the length is consistent regardless of hostname

a:3:{s:5:"entry";a:1:{s:4:"type";s:10:"individual";}s:5:"group";a:1:{s:6:"family";a:0:{}}s:5:"image";a:4:{s:6:"linked";b:1;s:7:"display";b:1;s:4:"name";a:1:{s:8:"original";s:28:"Missing-Equine-Photo.jpg.jpg";}s:4:"meta";a:1:{s:8:"original";a:8:{s:4:"name";s:28:"Missing-Equine-Photo.jpg.jpg";s:4:"path";s:107:"/app/wwwroot/thewire/wp-content/uploads/connections-images/police-equine-teddy/Missing-Equine-Photo.jpg.jpg";s:3:"url";s:0:"";s:5:"width";i:200;s:6:"height";i:248;s:4:"size";s:24:"width="200" height="248"";s:4:"mime";s:10:"image/jpeg";s:4:"type";i:2;}}}}

We will have to modify the existing data for both approaches above, but we want to mitigate the possibility for data corruption and ease of use for future database imports.

Please advise.

Thanks!

[Steven Zahm]

@ Trent

The solution is actually even simpler… when you do the find/replace in the db (or whatever method you utilize), exclude the {wpdb-prefix}_connections table. Connections gracefully handles the hostname change. Doing a global find/replace in the {wpdb-prefix}_connections table corrupts the serialized data making it unreadable by PHP.

At some point I plan on making the data json encoded instead of serialize. That too would mitigate the issue. Making the path relative would also work. Doing both would be ideal I suppose.

Hope that helps, let me know.

[Author]

Posts