[Digikam-users] My Albums missing?

[Arnd Baecker]

On Thu, 3 Jan 2008, hex wrote:

> Hi all
>
> Well I did a rather drastic solution to this problem (I'm a linux newbie!) -
> which probably won't help anyone at all - but just in case there are others
> as impatient as me.......;-)
>
> I found the digikam database (I used
>
> find / -name digikam*.db* -type -f
>
> at a command line (which if I'm right means look everywhere for a FILE
> the -type f bit, named digikam-anything.db-anything)
>
>  which I discovered is a SQLite database and had a look using SQLiteman and it
> didn't seem to have all the albums there. (there must be something somewhere
> tricking it into thinking they are because digikam wouldn't let me create
> albums with the same name?) So not understanding SQLite databases I gave up!
> and simply renamed the digikam database (just in case!!!) and restarted
> digikam and digikam rebuilt all the albums (under it's album directory in the
> filesystem) with a new database.
>
> So now I can see all my albums again!

Great! (No idea what screwed up things though)

> I would obviously urge extreme caution using this approach! Having really just
> started in the world of digital photography and digikam I hadn't made any
> ratings, comments etc etc which I presume would all have been lost if I had
> any!!!

Yes, they would be lost (unless you configured
digikam to store tags and ratings in the files themselves, see
http://docs.kde.org/development/en/extragear-graphics/digikam/using-setup.html#setup-embeddedinfo

> If anyone knows of any links or manuals for the digikam SQLite database (or a
> handy query repository?) I'd be grateful.

The database scheme is documented in
  http://websvn.kde.org/branches/extragear/kde3/graphics/digikam/DBSCHEMA.ODS?view=log
(and for the upcoming 0.10 for KDE4 see
  http://websvn.kde.org/trunk/extragear/graphics/digikam/DBSCHEMA.ODS?view=log
 the release plan is here:
  http://www.digikam.org/?q=about/releaseplan
)

 cdigi: command line and service menu tool to extract data from Digikam
sqlite database and produce nice HTML galleries.
http://www.kde-apps.org/content/show.php?content=15103
might be helpful.

Concerning a collection of queries: we don't have such thing
right now, but I think it would be a very welcome addition
to the wiki,
  http://wiki.kde.org/tiki-index.php?page=digikam

Best, Arnd


> > Re: [Digikam-users] My Albums missing?
> > From:
> > hex <hex at blueyonder.co.uk>  (DIL23)
> >   To:
> > Mikolaj Machowski <mikmach at wp.pl>
> >   Date:
> > 2007-12-28 15:05
> > (...apologies - I sent my first reply from the wrong email account and it
> > came back rejected!)
> >
> > Hi
> >
> > Sorry should have been more clear!
> > Yes - they're all in sub-folders of ~/Pictures/
> >
> > ie
> > ~/Pictures/Holidays
> > ~/Pictures/Family/kids
> >
> > etc etc
> >
> > and if I import all the JPEGs (which appear in the filetype list) from
> > anywhere camera/folders/disk etc to a new album that digikam sets up eg
> > ~/Pictures/NewAlbum it creates it on hard disk but it doesn't show anywhere
> > in digikam!!??!!
> >
> >  Then if I try to create a new album from menu/taskbar and attempt to call
> > it NewAlbum digikam complains that the "Album" already exists and do I want
> > to replace it (I don't) but I would like to be able to see it!!!!
> >
> > Usually try to keep up to date with releases so will look out for 0.9.3
> > Thanks for taking time out to reply.
> > DIL23
> >
> > :)On Thursday 27 December 2007 21:54:38 you wrote:
>
> > > Wonder if anyone can help?
> > > I'm using v0.9.2-final. All files on camera are found and successfully
> > > downloaded to a new album of my choosing and the all go into
> > > ~/Pictures/*
> > > The weird thing is that it can find my 'old' albums there and display
> > > them in the My Albums sidebar list (by date, folder, whatever) the new
> > > files are there too but it never shows them in digikam only on the
> > > filesystem! If I try to import the folder it complains that it already
> > > exists, the same if I try re-downloading from camera etc.
> > >
> > > I've been thru all the settings and can't see anything obvious, tried
> > > rebuiding metadata, thumbnails etc but it doesn't seem to see the
> > > folders on the filesystem.
> > >
> > > So any help would be great - thanks in advance.
> > > DIL23
> >
> > If I understand correctly your root album is ~/Pictures and imported
> > pictures are like ~/Pictures/*.jpg ? digiKam doesn't see them. They have
> > to be in album one level "lower".
> >
> > If I didn't understand correctly what about file type, are they in list
> > of acceptable file extensions?
> >
> > Third: try to upgrade to 0.9.3, released on 23th.
> >
> > m.