Press "Enter" to skip to content

Unborking Images

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:

  1. 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.
  2. 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.
  3. 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).
  4. Or we could just start over with new images, and me promising not to uninstall anything.

I would welcome any ideas.

Spread the love

4 Comments

  1. archivist archivist August 12, 2010

    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.

    • archivist archivist August 12, 2010

      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*

      • Cyan Icewolf Cyan Icewolf August 12, 2010

        Page three has a few dual image name errors and page four gives me a 500 internal error.

Leave a Reply