So I have officially borked the image system. Sort of.
All the images (and their derivative thumbnails) are still in the system. They’re still in the database correctly. What they *aren’t* is associated with the proper nodes. Somehow when I uninstalled the imagecaching modules, the data that associates images with nodes was lost. Every image uploaded since then seems to be okay.
Here are our options:
- I could go back and try to associate image file ids with node ids in the database to repair the damage. But lord that’s a lot of work, since I would have to guess which image belonged to which node.
- Or I could go see if I could retrieve a snapshot of the database from yesterday from the hosting company, and selectively read the missing rows back into the database.
- Or I could re-import the old images into the system and make *new* nodes (which would be owned by Archivist, not the original author, and would therefore suck).
- Or we could just start over with new images, and me promising not to uninstall anything.
I would welcome any ideas.
I’m not sure I can retrieve a copy of the archived database from the hosting company without rolling everything in the system back. I’ll double-check.
Will you look at that. I think I did it. I dumped the node associations table from this morning’s backup, then re-imported it back into the table. 630 rows where there used to be 135.
Pages 3 and 4 of the Gallery are still erroring for me. Not sure why. But 1 and 2 work. And the slideshow is back. *whew*
Page three has a few dual image name errors and page four gives me a 500 internal error.
Looks better now.