Database error - all pics away

[studio-030]

I use Canon D5 Mark II with WFT 2 and Shutter Snitch v2.5.1 with iPad 3 64GB.
I made a day shooting and all works fine the whole day. At the last shooting after the pictures where transfered in ShutterSnitch I tried to open the app. It showed up a database error and the app shut down. After a restart of my iPad I get access to ShutterSnitch and it showed me all folder with the starting picture. When I tried to get into the folder, I couldn't find any picture in it. That happened with all folders.
Is it possible to get access to my pictures or whats with the database happened and can it repaired?

[TheBrew]

There are a couple of ways to get to your files. (Don't worry, they're not gone ..unless it's the flash RAM in your device that's gone bad)

ShutterSnitch Backup will not work in your case though. I'd use iPhone Explorer or go the iTunes File Sharing route.

Do you remember exactly what the error message was?

When you've rescued your photos, could you try getting the crash logs and attach it/them here - perhaps that'll give me an idea of what went wrong. If it's corruption of the database, it's an outside circumstance though, and then there's not really anything I could have done - but I'd like to be sure.

I'm going to look into implement functionality to restore a database from what's in the collection folders, but at the moment you're only way of getting back on track is from the links above and after the files are safe on your computer, delete the app and re-install it from the App Store. After that, you can create the collections manually and transfer the photos back via an FTP client.

That - or if you're not in a hurry, perhaps I can have a working restore-version up and running in a day or two. Let me know if you're interested in trying that out!

[TheBrew]

Wait.. I may have found a way to do a restore with the current version of ShutterSnitch. Give me an hour to test this and I'll write a how-to!

[TheBrew]

OK, here goes:

1. Install iExplorer if you don't already have it installed. Plug your iPad into your computer and open iExplorer. Navigate to the Apps -> ShutterSnitch -> Documents directory.



2. Select everything in there, except for the fileinfo.sqlite file. (Select the top file, hold down Shift, click the bottom file. Then let go of Shift and press Cmd (or Ctrl on a PC) and click the fileinfo.sqlite file).

3. Make a backup-folder on a drive on your computer that has enough space for all the files. Then drag the selected files from iExplorer to that folder.

4. Close iExplorer and go to the Home screen on your iPad and find ShutterSnitch. Press and hold the icon for a while until the icons start to wiggle. Tap the X on ShutterSnitch to delete it.

5. Press the Home button to stop wiggly-mode and go to the App Store. Find ShutterSnitch in the "Purchased" section and re-download it.

*** Important *** Do NOT open ShutterSnitch yet. Let it install, but don't touch it!

6. Open iExplorer and navigate to the Apps -> ShutterSnitch folder. You'll notice that the documents folder is empty. Select all the files from the backup directory on your computer and drag them back into the documents folder in iExplorer.

7. When the copying is done, you can open ShutterSnitch on your iPad. You'll get a couple of dialogs in your face. Don't touch the "Skip" button, but you can dispmiss the "Tip" dialog.
After a little while (or a long while, depending on the size of your collections), ShutterSnitch will start up and let you type in your "new" super user password - type in the original one you picked when you first installed SS. Go through the setup and you're done.

Note: doing this, has effectively wiped all your ShutterSnitch settings, so it would be wise to go through your normal use-cases to avoid surprises when it "really matters".

[studio-030]

Your're so fast, thats a greatly support. I took additionally a look at ShutterSnitch in my iTunes App and found a file named "fileinfo.sqlite". I attached this as a zip (because its not allowed to send a file with this extension), maybe it could help.

Attachement: fileinfo.sqlite

[TheBrew]

Thanks - got it!

[studio-030]

Thank you very much for your great and immediately support. It works now all fine again. I have all photos with star rating back and know the way, if that happens again (hope not!).
Sorry for my delay, but it needed time for 1650 pics wit 21MP each.

Best regards
Thomas

[TheBrew]

Good to hear!

Sorry that you were the one who had to take the bullet for this one. But thanks so much for reporting it - if the system should corrupt the database for others out there, this is how the dialog box will look from version 2.5.2:



Thanks!

[studio-030]

It does'nt matter. That happens once and you found the solution. That's development. You did a great job and I will write a review with a 5 star rating.

[TheBrew]

Thanks you so much. It means a lot!