[digikam] [Bug 508995] New: all album lost in collection

[Kane]

https://bugs.kde.org/show_bug.cgi?id=508995

            Bug ID: 508995
           Summary: all album lost in collection
    Classification: Applications
           Product: digikam
      Version First 8.3.0
       Reported In:
          Platform: macOS (DMG)
                OS: macOS
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: Database-Albums
          Assignee: digikam-bugs-null at kde.org
          Reporter: shikai.xu at hotmail.com
  Target Milestone: ---

SUMMARY
Hi Developers,

Sorry I don't know how to reproduce the issue, I don't even know how it
happened, is it caused by some of my action, or the program "randomly" made it
happen, below is the issue:

I've serveal Collections in SMB driver. Within each Collections, there're
Albums (subfoders)
One day, whithin one of my Collection, all Albums are gone, there's only one
"Album", the Trash, and it's empty.
All files still existed in the subfolders when I browse the SMB driver.

I opened digikam4.db by sqlite3 tool. Observed and managed to restore it as
below:
observed:
- in "AlbumRoots" table, collection is there, but the uuid in the "identifier"
field string content is slightly "wrong"
action:
- I fixed the uuid, by referencing the uuid after manually re-defined the
Collection folder path in Digikam

observed:
- in Albums table, all the entries, related to my missing albums, have null in
"albumRoot" field, and what is suppose to be in "albumRoot" is now appended in
"relativePath" field with dash. "Uncategorized Album" is in "collection" field.
example:
correct value:{
id:1170,
albumRoot:13
relativePath:"/albumA",
...,
collection:(null),
...
}
what I see:{
id:1170,
albumRoot:(null)
relativePath:"13-/albumA",
...,
collection:"Uncategorized Album",
...
}
action:
- by referencing other fine albums, I fixed these value
result:
- albums are now appear in DigiKam, but within it no photos are listed

observed:
in "images" table, entries related to my photos in missing albums, are having
null in "album" field and 4 in "status" field, example:
expected, correct data:{
id:20173,
album,13
name:ABC.JPG
status:1,
...
}
what I see{
id:20173,
album:(null)
name:ABC.JPG
status:4,
...
}
action:
- fix the "album" to correct value and set 1 to status
result:
- missing photos are now back in Digikam, with tags, everything looks good now.

I appreciate you take time reading my post. I have three questions:
1, do you have a clue what happened? If this is a known issue (as I'm not using
the latest released version), is it fixed now?
2, what does status:4 mean in images table? and what does "uncategorized album"
mean in "albums" table? This is my first time looking into the db and I see
many other photos with album:(null)/status:4, and other entries with
"uncategorized album", what do they mean?
3, Looks I "fixed" my db by what I observed and verified it by checking images
in Digikam, not sure if there're some more data I need to check and actions
need to do, that I missed?

Thanks you!

-- 
You are receiving this mail because:
You are watching all bug changes.