12 Responses to “The Case of the Ever Changing Status”

  1. SĂ©rgio Ceroni da Silva Says:

    This must be a bug (or defect :)) in the SQL database. I’ve noticed a similar problem concerning metadata. Some of my photos display unexpectedly a “sidecar file missing” warning (I’m not using the option to “automatically write changes to XMP” and I did not write the metadata manually to a sidecar file). Interestingly enough, if one opens the Lr database using SQLite (got this tip from here: http://forums.adobe.com/message/1908212) there is no information whatsoever about any xmp sidecar file. In some of the photos it is possible to manually save the xmp file. In some other photos the xmp file never gets written even after many attempts (I’ve got around this by creating an empty xmp file from outside Lr and then overwriting it). The only way I found to get rid of the “sidecar file missing” was to manually (ctrl+s) saving the xmp sidecar file, deleting it from disk and then opening the Lr database with SQLite and deleting the corresponding xmp field (in AgLibraryFile) from the photos.

  2. BKKPhotographer Says:

    Why don’t you like to write changes to the XMP of the images files? I have found it works well. Apart from the ever-changing status which continues for me.

    That link to Adobe goes to an error page: “The specified thread was not found.”

    I tried to find the right tool to open the Lightroom Catalog directly but wasn’t successful. See https://bkkphotographer.wordpress.com/2009/07/06/what-ive-been-working-on/. The SQLLite browser I found wasn’t very useful.

    Can you point me at a better tool for the PC? Ideally I want an ODBC Driver so I can attach the catalog to MS Access and do database reports. I found one but it did not work properly.

    I see Chrome is animating my GIF without opening it now. It was not doing that before. Google do silent updates to Chrome so I guess it was a known defect.

  3. SĂ©rgio Ceroni da Silva Says:

    I don’t like sidecar files because of this: . I prefer to make catalog backups once a week, using Lr. These backups are then compressed with 7zip (97% compression ratio!). I also make regular backups (mirroring) of the entire catalog+photos to a second HD. So I think I’m quite safe (I hope!).

    The problem with the link is an extra “)” added at the end. Try http://forums.adobe.com/message/1908212/.

    I’m using SQLiteSpy to open the Lr catalog directly: http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

    Yesterday I made a post about my problem (and mentioned yours) at the Lr Forums http://www.lightroomforums.net/index.php
    Let’s see if someone has any suggestions or similar complaints.

    My FF 3.5.3 shows you gif just fine.

  4. SĂ©rgio Ceroni da Silva Says:

    It appears that my last reply got lost so I’ll write it again.

    The reasons I don’t like sidecar files are these: http://blogs.oreilly.com/lightroom/2008/12/xmp-sidecar-files—whats-miss.html
    Currently I make catalog backups using Lr and then I compress the file with 7zip to save space (97% compression ratio!). Besides that I make regular backups (mirroring) of the entire catalog+raw files on a second HD. This way I think (hope!) I’m quite safe.

    The problem with the link is an extra “)” at the end. This one works: http://forums.adobe.com/message/1908212

    I’ve been using SQLiteSpy to open the Lr catalog: http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

    I’ve posted in the Lightroom Forums ( http://www.lightroomforums.net/ ) detailing my problem and pointing to your blog. Let’s see if anyone has something interesting to say about this.

  5. BKKPhotographer Says:

    Sorry, your first reply got stuck in the WordPress spam filter and my internet connection stopped working last night.

    Your backup scheme should work fine as long as you have an offisite backup copy. I started using MozyHome remote backup as I do not have anywhere offsite to store my data. I also ZIP my Lightroom catalog and find my 1GB catalog is about 78MB compressed. I’ve been using The Photo Geek’s plugin that also backs up yout LR config files that are not in the catalog database. See https://bkkphotographer.wordpress.com/2009/07/04/lightroom-database-backups/

    Thanks for the pointer to the SQLiteSpy. I will try it.

    Sorry I cannot help with your other problem.

  6. SĂ©rgio Says:

    Thanks for the tip about Photo Geek’s plugin. It works fine indeed.

  7. BKKPhotographer Says:

    This is still happening and I don’t know why. I tried posting about it on the Adobe Forums / Photoshop Lightroom / Discussions forum at http://forums.adobe.com/thread/523877

  8. Installed Lightroom 2.5 « Bkkphotographer's Blog Says:

    […] hope it will fix the “ever-changing metadata status” problem. I found it has not fixed the “exploding keyword tree” […]

  9. BKKPhotographer Says:

    There’s a related discussion at http://forums.adobe.com/thread/507381. A filter on Metadata Status would be confusing because it changes constantly.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: