People > Unknown not working

[daniel bip]

Hi there,

I'm running:

. DK 5.5.0 from Philip Johnsson's repository
. Ubuntu: 16.04 running in a VirtualBox windows-host

My problem:

Some days ago the Unknown label stopped working. When I run "Scan
collection for faces" those faces are detected, but when I go to Unknown I
see nothing, and DK displays a little window at right bottom with just the
logo inside.

These are the lines displayed at console:

digikam.database: " ( ( (ImageTagProperties.tagid=? OR
ImageTagProperties.tagid IN (SELECT id FROM TagsTree WHERE pid=?)) AND
ImageTagProperties.property=?  ) OR ( (ImageTagProperties.tagid=? OR
ImageTagProperties.tagid IN (SELECT id FROM TagsTree WHERE pid=?)) AND
ImageTagProperties.property=?  ) OR ( (ImageTagProperties.tagid=? OR
ImageTagProperties.tagid IN (SELECT id FROM TagsTree WHERE pid=?)) AND
ImageTagProperties.property=?  ) ) "
digikam.database: Search query:
 "SELECT DISTINCT Images.id, Images.name, Images.album,
Albums.albumRoot,        ImageInformation.rating, Images.category,
ImageInformation.format, ImageInformation.creationDate,
Images.modificationDate, Images.fileSize,        ImageInformation.width,
ImageInformation.height,        ImageTagProperties.value,
ImageTagProperties.property, ImageTagProperties.tagid  FROM Images
INNER JOIN ImageTagProperties ON
ImageTagProperties.imageid=Images.id        LEFT JOIN ImageInformation ON
Images.id=ImageInformation.imageid        INNER JOIN Albums           ON
Albums.id=Images.album WHERE Images.status=1 AND (  ( (
(ImageTagProperties.tagid=? OR ImageTagProperties.tagid IN (SELECT id FROM
TagsTree WHERE pid=?)) AND ImageTagProperties.property=?  ) OR (
(ImageTagProperties.tagid=? OR ImageTagProperties.tagid IN (SELECT id FROM
TagsTree WHERE pid=?)) AND ImageTagProperties.property=?  ) OR (
(ImageTagProperties.tagid=? OR ImageTagProperties.tagid IN (SELECT id FROM
TagsTree WHERE pid=?)) AND ImageTagProperties.property=?  ) )  );"
 (QVariant(int, 355), QVariant(int, 355), QVariant(QString,
"autodetectedPerson"), QVariant(int, 355), QVariant(int, 355),
QVariant(QString, "autodetectedFace"), QVariant(int, 355), QVariant(int,
355), QVariant(QString, "tagRegion"))
digikam.dbengine: Failure executing query:
 "SELECT DISTINCT Images.id, Images.name, Images.album,
Albums.albumRoot,        ImageInformation.rating, Images.category,
ImageInformation.format, ImageInformation.creationDate,
Images.modificationDate, Images.fileSize,        ImageInformation.width,
ImageInformation.height,        ImageTagProperties.value,
ImageTagProperties.property, ImageTagProperties.tagid  FROM Images
INNER JOIN ImageTagProperties ON
ImageTagProperties.imageid=Images.id        LEFT JOIN ImageInformation ON
Images.id=ImageInformation.imageid        INNER JOIN Albums           ON
Albums.id=Images.album WHERE Images.status=1 AND (  ( (
(ImageTagProperties.tagid=? OR ImageTagProperties.tagid IN (SELECT id FROM
TagsTree WHERE pid=?)) AND ImageTagProperties.property=?  ) OR (
(ImageTagProperties.tagid=? OR ImageTagProperties.tagid IN (SELECT id FROM
TagsTree WHERE pid=?)) AND ImageTagProperties.property=?  ) OR (
(ImageTagProperties.tagid=? OR ImageTagProperties.tagid IN (SELECT id FROM
TagsTree WHERE pid=?)) AND ImageTagProperties.property=?  ) )  );"
Error messages: "Unable to fetch row" "database disk image is malformed" 11
1
Bound values:  (QVariant(int, 355), QVariant(int, 355), QVariant(QString,
"autodetectedPerson"), QVariant(int, 355), QVariant(int, 355),
QVariant(QString, "autodetectedFace"), QVariant(int, 355), QVariant(int,
355), QVariant(QString, "tagRegion"))
digikam.general: Data From DBJobsThread is null:  true
digikam.general: Failed to list url:  " "
No summary specified.
digikam.general: Event is dispatched through a passive pop-up
QLayout: Attempting to add QLayout "" to QWidget "", which already has a
layout
digikam.general: Cancel Main Thread
digikam.general: One job is done
digikam.geoiface: ----

May someone help?

Thanks.

BR,


d.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170714/44a8c33f/attachment.html>