[digiKam-users] Digikam's digital fingerprints freezes at 99%

[MarPar]

Hi all.

On KDE Neon 5.13.4 User edition (16.04 LTS) I've launched digikam 5.9
(official release) via CLI.

Digikam seems works well but when digital fingerprints search reaches
the 99% of job it freezes (no way to reaching the 100% of job).

Here is the code:

digikam.general: One job is done
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
  "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate, uniqueHash,
matrix)  SELECT id, modificationDate, uniqueHash, :a FROM Images WHERE
id=:bb; "
Error messages: "Impossibile eseguire il comando" "no such table:
ImageHaarMatrix" 1 2
Bound values:  ()
digikam.dbengine: Failure executing query:
  "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate, uniqueHash,
matrix)  SELECT id, modificationDate, uniqueHash, :a FROM Images WHERE
id=:bb; "
Error messages: "Numero di parametri non corrispondente" "" -1 2

What do you think about?

Many thanks

MarPar

[MarPar]

Hi.

Now in Xubuntu 18.04.01 LTS with digikam 5.6 (version from repository)
I'm trying to do the digital fingerprints search.

A question: can various versions of digikam (5.6 and 5.9, from
repositories, and appimage) are able to use the same database?

Thanks in advance for replies.

MarPar

Il 28/08/2018 15:57, Marco Paravano ha scritto:

> Hi all.
>
> On KDE Neon 5.13.4 User edition (16.04 LTS) I've launched digikam 5.9
> (official release) via CLI.
>
> Digikam seems works well but when digital fingerprints search reaches
> the 99% of job it freezes (no way to reaching the 100% of job).
>
> Here is the code:
>
> digikam.general: One job is done
> digikam.dbengine: Prepare failed!
> digikam.dbengine: Failure executing query:
>  "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate,
> uniqueHash, matrix)  SELECT id, modificationDate, uniqueHash, :a FROM
> Images WHERE id=:bb; "
> Error messages: "Impossibile eseguire il comando" "no such table:
> ImageHaarMatrix" 1 2
> Bound values:  ()
> digikam.dbengine: Failure executing query:
>  "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate,
> uniqueHash, matrix)  SELECT id, modificationDate, uniqueHash, :a FROM
> Images WHERE id=:bb; "
> Error messages: "Numero di parametri non corrispondente" "" -1 2
>
> What do you think about?
>
> Many thanks
>
> MarPar
>

[Gilles Caulier-4]

yes all 5.x version use the same DB schema.

Only 6.0.0, currently in beta introduce changes.

Gilles Caulier

2018-08-28 18:17 GMT+02:00 Marco <[hidden email]>:

Hi.

Now in Xubuntu 18.04.01 LTS with digikam 5.6 (version from repository) I'm trying to do the digital fingerprints search.

A question: can various versions of digikam (5.6 and 5.9, from repositories, and appimage) are able to use the same database?

Thanks in advance for replies.

MarPar

Il 28/08/2018 15:57, Marco Paravano ha scritto:

Hi all.

On KDE Neon 5.13.4 User edition (16.04 LTS) I've launched digikam 5.9 (official release) via CLI.

Digikam seems works well but when digital fingerprints search reaches the 99% of job it freezes (no way to reaching the 100% of job).

Here is the code:

digikam.general: One job is done
digikam.dbengine: Prepare failed!
digikam.dbengine: Failure executing query:
 "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate, uniqueHash, matrix)  SELECT id, modificationDate, uniqueHash, :a FROM Images WHERE id=:bb; "
Error messages: "Impossibile eseguire il comando" "no such table: ImageHaarMatrix" 1 2
Bound values:  ()
digikam.dbengine: Failure executing query:
 "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate, uniqueHash, matrix)  SELECT id, modificationDate, uniqueHash, :a FROM Images WHERE id=:bb; "
Error messages: "Numero di parametri non corrispondente" "" -1 2

What do you think about?

Many thanks

MarPar

[MarPar]

Hello!

After 1 hour and 8 minutes the digital fingerprints search has done its
job with NO ERRORS or freezing! I remember that it has done by digikam
5.6 (from repository) in Xubuntu 18.04.01 LTS.

MarPar


Il 28/08/2018 18:17, Marco ha scritto:

> Hi.
>
> Now in Xubuntu 18.04.01 LTS with digikam 5.6 (version from repository)
> I'm trying to do the digital fingerprints search.
>
> A question: can various versions of digikam (5.6 and 5.9, from
> repositories, and appimage) are able to use the same database?
>
> Thanks in advance for replies.
>
> MarPar
>
> Il 28/08/2018 15:57, Marco Paravano ha scritto:
>> Hi all.
>>
>> On KDE Neon 5.13.4 User edition (16.04 LTS) I've launched digikam 5.9
>> (official release) via CLI.
>>
>> Digikam seems works well but when digital fingerprints search reaches
>> the 99% of job it freezes (no way to reaching the 100% of job).
>>
>> Here is the code:
>>
>> digikam.general: One job is done
>> digikam.dbengine: Prepare failed!
>> digikam.dbengine: Failure executing query:
>>  "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate,
>> uniqueHash, matrix)  SELECT id, modificationDate, uniqueHash, :a FROM
>> Images WHERE id=:bb; "
>> Error messages: "Impossibile eseguire il comando" "no such table:
>> ImageHaarMatrix" 1 2
>> Bound values:  ()
>> digikam.dbengine: Failure executing query:
>>  "REPLACE INTO ImageHaarMatrix  (imageid, modificationDate,
>> uniqueHash, matrix)  SELECT id, modificationDate, uniqueHash, :a FROM
>> Images WHERE id=:bb; "
>> Error messages: "Numero di parametri non corrispondente" "" -1 2
>>
>> What do you think about?
>>
>> Many thanks
>>
>> MarPar
>>
>