You are here

4 posts / 0 new
Last post
Missing Projects. Help! Possibly after rebuild of database? #1
Susan S's picture
by Susan S
April 20, 2013 - 10:07am

I have “lost my Pictures, help me!” but I have also searched FAQ, and read many earlier posts looking for guidance.
How do I search for missing Projects and their many (hundreds) of files on my last Vault backup and on earlier Time Machine backups (stored on an external hard drive)? I tried posting on two earlier related threads late March, but no one has responded so… here is the tale:
(I use Aperture 2.1.4, Lion 10.7.5 on early 2008 Macbook Pro (2.6 GHz Intel Core 2 Duo) with added hard drive (350GB free.))

Several Projects of imported iphone 4s photos are missing from my current Aperture Library. (They are no longer on my phone as I clear up space on my phone when needed and import into Aperture.) Although I don’t know exactly WHEN they disappeared, it MAY have been after I did a rebuild of my database that was part of my problem solving from an earlier Post back on 2/27/13 (last added to on 3/24) about the appearance of orange/red file symbols indicating “unsupported file” and increasing unstable behavior by Aperture 2.1.4 (Yes, the plan is to update to Aperture 3 ASAP… once I find these missing files and it seems stable enough to proceed with caution.)
Before rebuilding the Aperture database, I tried repairing permissions on my HD. (see post for details). I THINK that I backed up via Time Machine onto an external HD BEFORE I did the rebuild. The latest TM back up is dated 3-4-13.
My last Vault back up is 3-5-13. I THINK that I did the Vault back up AFTER the rebuild. My Vault is 154.7 GB (I imported 19 more images from my DSLR after that vault back up.)
At present my Aperture Library is 180.28 GB, w/ 465 projects that show up and 27,578 images. When I open Aperture it says that 466 projects have NOT been backed up in Vault. (How can that be? There should be just one.) It also says that 19 files have not been updated to the Vault. (Those are that last import/new project, after the rebuild and Vault back up?) I searched my Library using keywords and Filenames and I checked the folder with Aperture Deleted Files on the same external hard drive w/ my Vault. There are some iphone pics there, but only a few and it appears that they were ones that I deleted as rejects when editing. They date to Sept 2012 Vault back up, which is the same size as the next Vault Back up 12-4-12. (I keep a log of Vault backups and sz.) In Dec. I added a small project (not iphone) that still appears today. Not sure if that Vault back up was before or after the small import, but because it is the exact same sz as Sept. Vault, I am guessing that it was before the addition. I think that I would have noticed the missing Projects in early Dec. since I was using files for holiday related projects.
How do I go back to Time Machine to find the missing projects? Although I doubt that they exist in the last Vault back up, is there a way to double check before updating Vaults again?
I keep my Projects for iPhone pics in a Library Level Folder. There are 3 Projects that still show up. One named 2010 (w/ 645 files), one named 2011 #1 (872 files) and one named 2011#2 with 0 files. I remember that I did not add to that empty project immediately. But the next time I needed space on my phone, I added to that project and then created several more Projects for 2012 as I imported from the phone. I think those imports probably occurred late summer 2012 and the last by early Nov. 2012.
I apologize for such a long post, but hope that all info is included. I am frozen and holding my breath that I have not lost these images for good. Thanks in advance.

Susan S

Walter Rowe's picture
by Walter Rowe
April 21, 2013 - 2:36am

Make sure to quit Aperture. Now rename your current Aperture Library in Finder. Then enter time machine and find the Library from a date you believe the missing projects existed. Tell time machine to restore that Library. Once restored, open that library in Aperture and confirm the missing projects are there. Once confirmed, select the missing projects and export them to a new library.

Exit Aperture. Rename the restored library to a different name. Rename the “current” library back to its original name. Open the current library in Aperture. Import the library of missing projecs into your current library.

This will be a lengthy process beginning to end. Do not get discouraged. Be patient. It should work. Once you are confident you have your missing projects back in your current library, you can delete the restored library.

Hope that helps. Let us know if this works. I believe it will.

Walter Rowe's picture
by Walter Rowe
April 24, 2013 - 11:56pm

Susan .. I’m curious if this helped you recover your lost projects.

Susan S's picture
by Susan S
April 27, 2013 - 3:47am

Thanks for checking in. I apologize for not answering sooner. I am having a hard time getting big enough chunks of time to deal with this.
I have not yet proceeded with your suggestion. It is the first time that I have restored anything from Time Machine so I want to make sure I know how to do this. Also trying to figure out when the last missing project was added and to determine if anything else is missing.
The way that I can tell what is missing is by viewing the contents of the package of the Aperture Library on my hard drive. (I have not moved anything, just “viewed package” for the first time.) I mentioned before that I can see 7 Projects, named for the iphone pics, listed with Sizes that indicate that that they are not empty. I can also see Albums (collections to be printed) that are also not showing up when I launch Aperture. Why are they listed in the package and do not appear when I open the same Library?

The last additions or changes to those projects were on Dec. 12, 2012. I had backed up to Time Machine on Dec. 5 and not again until March 4, just before I did the database rebuild because of the quirky behavior while editing. I hope that they exist in the March 4 Time Machine, but will I not know until I hit “restore”? Can I view the Library before restoring?

I was also reading Joseph’s article and the Comments: Aperture Vault’s File Extension Secret (9-14-12). It seems to address the issue of pulling out individual projects from Time Machine (in comments). But there are issues? Does it make a difference that I am using Aperture 2.14? Or is this a completely different way of using Time Machine?
When I enter Time Machine for one of those earlier dates, do I choose the Aperture Library from the Finder? By highighting and then hitting Restore?

Thanks again for your help.

Susan S

You may login with either your assigned username or your e-mail address.
Passwords are case-sensitive - Forgot your password?