Bug 192374

Version:           0.10.0-1ubuntu3 (using KDE 4.2.1)
OS:                Linux
Installed from:    Ubuntu Packages

I recently moved my pictures from iMatch to Digikam 0.10.0-1ubuntu3 (Ubuntu 9.04 Jaunty).

My digikam4.db is about 11MB and contains the following items:

- 1 albumroot
- 444 albums
- 15323 images (tiff, jpg, dng) with built-in tags
- 242 tags
- 574 tagtree items

I was adding some tags to some of the pictures when Digikam crashed. However this time when I restarted it back the library was empty...and I felt very bad!
I looked at the database content using an SQLite browser and found out that all the pictures data have been corrupted in a snap.

Here is the result of my investigation.

** AlbumRoots Table **
"id","label","status","type","identifier","specificPath"
"1","ORIGINALS-DNG","0","1","volumeid:?uuid=DCA8EED3A8EEAB6A","/PHOTOS/ORIGINALS-DNG"

--> No problem on this one.


** Albums table **
"id","albumRoot","relativePath","date","caption","collection","icon"
"1","0","1-/","2009-03-01","","",""
"2","0","1-/1999-12","2009-01-14","","",""
"3","0","1-/1999-12/Scans","2009-04-24","","",""
"4","0","1-/2000-10","2008-07-15","","",""
"5","0","1-/2000-10/Fly_Surf","2009-04-25","","",""
"6","0","1-/2000-10/Le_Luc","2009-04-24","","",""
...
--> "albumRoot" column is corrupted (all rows)... it should be "1" not "0"
--> "relativePath" is corrupted (all rows)... i.e. "1-/1999-12/Scan" should be "/1999-12/Scan"


** Images table **
"id","album","name","status","category","modificationDate","fileSize","uniqueHash"
"1","","1999-12_955_Noir.tif","3","1","2007-01-12T02:58:41","4328652","eaee50804f7ddfe244eebf2385c43a19"
"2","","1999-12_955_Rouge.tif","3","1","2007-01-12T02:58:43","4387788","8334c19a77cd95f56d7bebac262c5383"
"3","","1999-12_Bebe.tif","3","1","2009-04-25T22:46:20","5428320","4967c779c5f9fb63fcbf9e79c34ee07c"

--> "album" number has been wiped out for each image... how can this be recovered besides reimporting the pictures?
--> "status" column is corrupted (all rows)...it should be "1" and not "3"


 Restoring some of the table to their original content almost fixed the problem however the image table is still missing links to albums. I rescanned the album and the pictures appeared again but then the database needed some cleaning still contains orphaned entries.

I'm now so scared to use DigiKam again. Is there any way to have at least an automatic backup of the database?

I'm sorry but I don't have any backtrace to show, only the corrupted database. 
Thank you
Dany