<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Follow-up/update:</p>
<p>I launched digiKam with all logging enabled, then activated
database migration again.</p>
<p>I see in the log where the TagProperties are migrated. In the
source data (SQLite) there are 384 rows; in the MySQL Server
(actually running mariadb 10), there are 382 rows. It doesn't
quite follow, as there are three rows of data for the person who
is missing: a 'person', faceEngineID, and faceEngineUuid. In any
case, the log file lists those rows of data, but those rows do not
show up in the actual MySQL Server database (mariadb). That is,
tagid=41 does not exist in the SQL Server dB. See log below.<br>
</p>
<p><font face="monospace">Digikam::CoreDbCopyManager::copyTable:
Core database: query isOnValidRow [ true ] isActive [ true ]
result size: [ -1 ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "tagid" ] value [ QVariant(qlonglong, 41) ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "property" ] value [ QVariant(QString, "person") ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "value" ] value [ QVariant(QString, "Lissa") ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: query
isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "tagid" ] value [ QVariant(qlonglong, 41) ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "property" ] value [ QVariant(QString, "faceEngineId") ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "value" ] value [ QVariant(QString, "Lissa") ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: query
isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "tagid" ] value [ QVariant(qlonglong, 41) ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "property" ] value [ QVariant(QString, "faceEngineUuid") ]<br>
Digikam::CoreDbCopyManager::copyTable: Core database: column:
[ "value" ] value [ QVariant(QString,
"{ef03ec83-b6ec-4449-b87f-b35fd8ade955}") ]<br>
</font></p>
<p>So, either the actual SQL command to write that data wasn't sent
to the server, or the server failed to write the data. I'm not <i>that</i>
much of a SQL/mariadb expert to be able to dig into this. If
anyone has suggestions, I'd certainly welcome them.</p>
<p>MarcusW<br>
</p>
<div class="moz-cite-prefix">On 4/29/24 06:08, Marcus Winston wrote:<br>
</div>
<blockquote type="cite"
cite="mid:c6c0c827-a927-80f1-5ca6-81b203680a1d@thechocolatehouse.net">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>If, by "first original", you mean this is the first person I
named, or identified, then yes, it's possible. I don't quite
remember. It's definitely not the last. It's also not the first
person in the recognition.db file.</p>
<p>-Marcus<br>
</p>
<div class="moz-cite-prefix">On 4/29/24 00:21, Paul A. Norman
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:C23BF45D-14C1-4025-A30F-29DF10203B36@paulanorman.info">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
Dear Marcus,<br>
<br>
Just checking - can you recall whether that 'person' was entered
as your first original, or even last entry? <br>
Or just somewhere along the way sometime?<br>
<br>
-Paul
<hr><a href="https://PaulANorman.info" moz-do-not-send="true">https://PaulANorman.info</a><br>
<br>
<br>
<div class="gmail_quote">On 29 April 2024 4:00:25 pm NZST,
Marcus Winston <a class="moz-txt-link-rfc2396E"
href="mailto:marcus@thechocolatehouse.net"
moz-do-not-send="true"><marcus@thechocolatehouse.net></a>
wrote:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<pre class="k9mail">I did see that online doc, and followed it. What is confusing to me is
whether the faces data is, or is not, "migrate-able". That is, when
moving to MySQL Server, is all my previous face information essentially
thrown away? When I read "all other databases have to be rebuilt as
post-processing...", I'm not sure exactly what that means.
The Core database seems to have included all the face information,
except for one person (one face). Rebuilding the faces database did not
change that. Hence, I'm a little confused.
-MarcusW
On 4/28/24 20:54, Gilles Caulier wrote:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> Hi,
See explanation from the online doc:
<a href="https://docs.digikam.org/en/setup_application/database_settings.html#database-migration" moz-do-not-send="true" class="moz-txt-link-freetext">https://docs.digikam.org/en/setup_application/database_settings.html#database-migration</a>
Best
Gilles Caulier
Le lun. 29 avr. 2024 à 02:59, Marcus Winston
<a class="moz-txt-link-rfc2396E" href="mailto:marcus@thechocolatehouse.net" moz-do-not-send="true"><marcus@thechocolatehouse.net></a> a écrit :
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;"> Hello all,
I'm using digiKam 8.3.0 on Linux (AppImage), and migrating the database
to MySQL Server on a NAS. In the process, I have found a "missing
person". That is, one of the people in my "database" (I use that term
loosely, as I'm not sure the right word) is missing. There are 2700
pictures with this person's face identified in the SQLite version of
"database". In the MySQL, after migrating it to the NAS, this person is
entirely missing. All face tags with this person are gone.
Is there any way to debug this? I don't really want to go through and
manually re-train digiKam, and manually re-label a bunch of photos. It
took me several hours to train it so far.
Thanks.
MarcusW
</blockquote></blockquote></pre>
</blockquote>
</div>
</blockquote>
</blockquote>
</body>
</html>