Not seeing tags in 5.5

[Jim Dory]

I also noticed now that the tag hierarchy is completely jumbled and I think
has missing tags as well.

On Fri, May 12, 2017 at 7:59 AM, Jim Dory <james at dorydesign.com> wrote:

> I did steps 1-3 with the exception of only copying one folder of images as
> I've got thousands. Step 4: I think most of the tags were there - there
> were a couple suspect images but don't know if they were ones that weren't
> tagged originally. I had some permission issues on the images so many
> weren't loaded in the new profile but the ones that did seemed mostly to
> work.
>
> So not really sure what you meant in #4 but I moved my old DB away and let
> DK build a new one with the images. I didn't see the tag error though it
> may have been there in the scrolling of the console, because it looks like
> I only got back about half my tags- give or take. In the Metadata settings
> I had "write to metadata" set.
>
> Not much rhyme or reason - one DNG raw file can have tags and date created
> in IPTC tab (right side) and the next image is blank there and no tag. Same
> with jpegs and cr2 files.
>
> thx, Jim
>
> On Thu, May 11, 2017 at 7:05 PM, Gilles Caulier <caulier.gilles at gmail.com>
> wrote:
>
>> 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
>> >>>
>> >>>
>> >>
>> >
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170512/fe3dcbce/attachment.html>