I'm seriously stuck with an issue on WordPress. It appears my serialised data has gotten messed up, I think, in the postmeta table where meta_key = _wp_attachment_metadata
I'm totally baffled.
The issue is essentially the same as this thread:
but the answers there don't seem to be working for me.
So I've got devel.pixelapes.com/alex.leonard.ie/ where I was working on the new design for my site. All good there.
I moved, in my standard way, everything back over to http://alex.leonard.ie and now none of my image thumbnails are loading. It's only loading the full size images.
I've compared the most recent photoblog upload in the two databases and can't see anything wrong.
I've tried changing paths in options, I've tried this serialisation fixer: http://davidcoveney.com/575/php-serialization-fix-for-wordpress-migrations/
I've tried rebuilding my thumnails.
I've re-exported the database, redone the standard find and replace on devel.pixelapes.com/alex.leonard.ie -> http://alex.leonard.ie
I'm completely at a loss, and the idea of deleting all these images and reuploading them is painful.
The only thing that looks unusual to me is that on devel.pixelapes.com/alex.leonard.ie, the postmeta->meta_key->_wp_attachment_metadata actually contains references to /server/path/to/alex.leonard.ie/wp-content/uploads/
Obviously when I do a search and replace on the database of devel.pixelapes.com/alex.leonard.ie -> http://alex.leonard.ie this doesn't affect those serialised entries. Both devel and live versions are living on the same server, so I assume that's why devel.pixelapes.com/alex.leonard.ie works even though it's referencing the /server/path/to/alex.leonard.ie instead of /server/path/to/devel.pixelapes.com/alex.leonard.ie/ but I don't understand why, when moving it back to the live domain it suddenly loses the ability to connect to the thumbnail sizes of those images.
I'm really stuck on this and can't see how to fix this. And now my live domain is loading these huge original sized images which looks awful.
Any help would be hugely appreciated.