Not seeing tags in 5.5

[Gilles Caulier]

The error come from the database file.

To confirm, i recommend :

1/ create a new fresh account on the system.
2/ start digiKam and configure a new collection through First run
assistant. A new DB file will be created.
3/ copy the images from your old collection to the new one.
4/ check if all run fine.

If the problem disappear, the best way is to restore a backup of DB
sqlite file in your original account. Ig you write digiKam properties
of files in image metadata, you can recreate a new fresh DB from
scratch.

Gilles Caulier

2017-05-12 4:16 GMT+02:00 Jim Dory <james at dorydesign.com>:
> ok - found the error in the terminal output (again, this is for
> 5.6.0-appimage version and similar for regular 5.5.0 version):
>
> digikam.database: Attempt to create tag properties for tag id 0
> digikam.dbengine: Failure executing query:
> "INSERT INTO Tags (pid, name) VALUES( ?, ?);"
> Error messages: "Unable to fetch row" "UNIQUE constraint failed:
> TagsTree.id, TagsTree.pid" 19 1
> Bound values:  (QVariant(int, 0), QVariant(QString,
> "_Digikam_Internal_Tags_"))
> digikam.dbengine: Error while executing DBAction [ "InsertTag" ] Statement [
> "INSERT INTO Tags (pid, name) VALUES( :tagPID, :tagname);"
> ]
>
>
> On Thu, May 11, 2017 at 6:12 PM, Jim Dory <james at dorydesign.com> wrote:
>>
>> I restarted it and then it did a long scan and found the raw images so
>> that is not an issue. But no tags on any photos - those with sidecars and
>> those embedded tags are all missing. If I look at the IPTC info, some tags
>> are displayed there. If I do a search on a tag, some images are found but
>> not many of them. Still no tags displayed in the thumbnail view on any pics.
>>
>> The terminal output is extensive, but as it was scrolling by (when
>> scanning the albums) I could see a very similar error in my original post,
>> if it was the same. Something about line 19, etc.
>>
>> thx, Jim
>>
>>
>>
>> On Thu, May 11, 2017 at 1:57 PM, Jim Dory <james at dorydesign.com> wrote:
>>>
>>> Thanks Gilles,
>>>
>>> No luck there either.  No tags. Sure did fire up quick though... very
>>> fast.
>>> Doesn't seem to show any .cr2 raw files from my canon camera, either.
>>>
>>> On Thu, May 11, 2017 at 7:58 AM, Gilles Caulier
>>> <caulier.gilles at gmail.com> wrote:
>>>>
>>>> At least, try with 5.6.0 pre-release appimage :
>>>>
>>>> https://drive.google.com/drive/folders/0BzeiVr-byqt5Y0tIRWVWelRJenM
>>>>
>>>> Gilles Caulier
>>>>
>>>> 2017-05-11 17:52 GMT+02:00 Jim Dory <james at dorydesign.com>:
>>>> > I'm on Gentoo and 5.6 isn't available in the portage yet - and a
>>>> > routine
>>>> > upgrade installed 5.5. I had all sorts of trouble - taking a very long
>>>> > time
>>>> > - not seeing my photo albums, etc - until after an hour or so I got it
>>>> > to
>>>> > see my photos. But it has an error when trying to read tags, both raw
>>>> > and
>>>> > jpeg files. Here's a snip from the terminal:
>>>> >
>>>> > "digikam.database: Attempt to create tag properties for tag id 0
>>>> > digikam.dbengine: Failure executing query:
>>>> > "INSERT INTO Tags (pid, name) VALUES( ?, ?);"
>>>> > Error messages: "Unable to fetch row" "UNIQUE constraint failed:
>>>> > TagsTree.id, TagsTree.pid" 19 1
>>>> > Bound values:  (QVariant(int, 0), QVariant(QString,
>>>> > "_Digikam_Internal_Tags_"))
>>>> > digikam.dbengine: Error while executing DBAction [ "InsertTag" ]
>>>> > Statement [
>>>> > "INSERT INTO Tags (pid, name) VALUES( :tagPID, :tagname);"
>>>> > ]
>>>> > digikam.database: Attempt to create tag properties for tag id 0
>>>> > digikam.database: Image 29896 type QFlags(0x1|0x8)
>>>> > digikam.database: Image 29895 type QFlags(0x8)
>>>> > digikam.database: Graph with 2 vertices:
>>>> > "{ Id: 29902 UUID: 3ed50b... } -> { Id: 29901 UUID: dcf0eb... }"
>>>> >
>>>> > "
>>>> >
>>>> > I did try to mask this but I don't have any earlier ebuilds to install
>>>> > previous versions. Suppose I could create one, but maybe there is an
>>>> > easy
>>>> > fix for this in version 5.5?
>>>> >
>>>> > thx, Jim
>>>
>>>
>>
>