Not seeing tags in 5.5
Locked
 
|
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 |
|
|
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 <[hidden email]>: > 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 |
|
|
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 <[hidden email]> wrote: At least, try with 5.6.0 pre-release appimage : |
|
|
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 <[hidden email]> wrote:
|
|
|
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 <[hidden email]> 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 <[hidden email]>: > 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 <[hidden email]> 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 <[hidden email]> 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 >>> <[hidden email]> 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 <[hidden email]>: >>>> > 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 >>> >>> >> > |
|
|
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 <[hidden email]> wrote: The error come from the database file. |
|
|
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 <[hidden email]> wrote:
|
«
Return to digikam-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |