<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><div>I created a new album in the linux box in order to reproduce the error. The internal server gave the same error messages that you got.</div><div><br></div><div>Then I created the databases in my MySQL server and tried to migrate. It worked like a charm. I don't know what the "Internal Server" is, but for sure it doesn't behave the same way a "regular" MySQL instance behaves.</div><div><br></div><div>What else could I do to help?</div><div><br></div><div><div>piterdias@microserver:~$ digikam -v</div><div>Qt: 4.8.6</div><div>KDE Development Platform: 4.13.3</div><div>digiKam: 4.14.0</div></div><div><br></div><div><div>piterdias@microserver:~$ mysql --version</div><div>mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3</div></div><div><br></div><div><br></div><div><br></div><div>------------------------------------------- MIGRATION TO INTERNAL SERVER -------------------------------------------------</div><div><br></div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseParameters::defaultParameters: ConnectOptions "UNIX_SOCKET=/home/piterdias/.kde/share/apps/digikam/db_misc/mysql.socket"</div><div>digikam(29920)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater update</div><div>digikam(29920)/digikam (core) Digikam::SchemaUpdater::startUpdates: No database file available</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing query:</div><div> ""</div><div>Error messages: "QMYSQL: Unable to execute query" "Table 'mysql.proc' doesn't exist" 1146 2</div><div>Bound values: ()</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error while executing DBAction [ "CreateIndices" ] Statement [ "</div><div> DROP PROCEDURE IF EXISTS create_index_if_not_exists;</div><div> " ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikam(29920)/kdeui (KNotification) KNotificationManager::notificationClosed: 3</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div><br></div>----------------------------------------------------- MIGRATION TO REGULAR MYSQL DATABASE --------------------<div><br></div><div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::moveTo: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: Selection[ Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 ) 1 ] 0</div><div>digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database server</div><div>digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]</div><div>digikam(29920)/kdeui (KNotification) KNotificationManager::close: 4</div><div>QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in use, all queries will cease to work.</div><div>digikam(29920)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater update</div><div>digikam(29920)/digikam (core) Digikam::SchemaUpdater::startUpdates: No database file available</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Trying to copy contents from DB with ActionName: [ "Migrate_Read_AlbumRoots" ] to DB with ActionName [ "Migrate_Write_AlbumRoots" ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Driver doesn't support query size. We try to go to the last row and back to the current.</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Result size: [ 0 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "label" ] value [ QVariant(QString, "") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 0) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "type" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "identifier" ] value [ QVariant(QString, "volumeid:?uuid=59f1850e-dbca-4a1a-b49f-09c3a2ff1db2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "specificPath" ] value [ QVariant(QString, "/home/piterdias/Pictures/digikam/raw") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Trying to copy contents from DB with ActionName: [ "Migrate_Read_Albums" ] to DB with ActionName [ "Migrate_Write_Albums" ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Driver doesn't support query size. We try to go to the last row and back to the current.</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Result size: [ 0 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "albumRoot" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "relativePath" ] value [ QVariant(QString, "/") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "date" ] value [ QVariant(QString, "2015-11-11") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "caption" ] value [ QVariant(QString, "") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "collection" ] value [ QVariant(QString, "") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "icon" ] value [ QVariant(QString, "") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Trying to copy contents from DB with ActionName: [ "Migrate_Read_Images" ] to DB with ActionName [ "Migrate_Write_Images" ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Driver doesn't support query size. We try to go to the last row and back to the current.</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Result size: [ 35 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0735.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:57:54") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25092588) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "bcf5cc8201189856e4dfe4abd0354ae0") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 2) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0736.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:58:44") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 27673144) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "c1fefa040f1d0bd7dbe47aa4eb0ed39e") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 3) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0737.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:59:04") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 27453799) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "e28612b16aa73000866d4895e2daf77d") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 4) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0738.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:59:26") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26860509) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "ad3f835715d658551d96e6b125045971") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 5) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0739.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:59:32") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26522634) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "58bee19dddd6444ebd6ff99272676c34") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 6) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0740.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:01:54") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 28749494) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "58473d29938d3d9f1d570435faecf8df") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 7) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0741.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:03:04") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25279919) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "f8f27d422293dacbbcfdf99b8e36e941") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 8) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0742.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:03:50") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25919351) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "8ea96880cfbca8c5e275ff934f5a256b") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 9) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0743.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:10") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26243290) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "658badd8d58737dd437b7b4dd7876a73") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 10) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0744.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:12") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26201259) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "1cb1226c0a2f8170185ddd4496c91dfd") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 11) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0745.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:16") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25322644) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "26ffdf644e47ad74445ae3ec7c6b7707") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 12) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0746.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:36") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23609467) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "781eb94490d0808f4a051315b1aa5b56") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 13) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0747.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:40") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23374296) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "7459120c7b8a4d2e932600d11f619014") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 14) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0748.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:56") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23997206) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "86cc798b7a83adf95dbbaa8d25d47085") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 15) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0749.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:14") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26638831) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "91e422e62623101f349fb4d5a0406cca") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 16) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0750.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:28") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 22772218) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "39ec20f23860d3eb1d8356a4e2d5f788") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 17) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0751.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:30") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23083450) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "84a2e92135b171b4b4fbd8c5845de5de") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 18) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0752.CR2") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:42") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23611240) ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "2fc3c92d71a7ddb4eff59f3bff2623e7") ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]</div><div>digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 19) ]</div><div><br></div><div><br></div><div>_____________________</div><div>Piter Dias</div><div>piter.dias@piterdias.com</div><div><a href="http://www.piterdias.com" target="_blank">www.piterdias.com</a></div><div><br></div><br><br><div><hr id="stopSpelling">From: caulier.gilles@gmail.com<br>Date: Wed, 11 Nov 2015 16:59:00 +0100<br>To: digikam-users@kde.org<br>Subject: Re: [Digikam-users] Mysql/MariaDb database expert needs...<br><br><div dir="ltr"><br><div class="ecxgmail_extra"><br><div class="ecxgmail_quote">2015-11-11 12:58 GMT+01:00 Piter Dias <span dir="ltr"><<a href="mailto:piter.dias@piterdias.com" target="_blank">piter.dias@piterdias.com</a>></span>:<br><blockquote class="ecxgmail_quote" style="border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex;"><div><p dir="ltr">I use digikam under Windows and mysql as database (in a Linux box).</p>
<p dir="ltr">What do you need? Someone to test?</p></div></blockquote><div>More than testing.</div><div><br></div><div>The main problem is the first step of migration from sqlite (the initial DB set at first run) to a local mysql (using internal server).</div><div><br></div><div>Currently the migration stop in the middle due to strange error reported by mysql (Mariadb here) :</div><div><br></div><div><div>[gilles@localhost database]$ mysql --version</div><div>mysql Ver 15.1 Distrib 10.0.21-MariaDB, for Linux (x86_64) using readline 5.1</div></div><div><br></div><div>I suppose some ImmoDb incompatibilities with digiKam sql statements to create indexes (tables are created).</div><div><br></div><div><div>[gilles@localhost data]$ digikam</div><div>digikam.general: AlbumWatch use QFileSystemWatcher</div><div>digikam.general: DatabaseParameters: [ Type "QMYSQL", Name "digikam" (Thumbnails Name "digikam"); (Face Name "digikam"); ConnectOptions: "UNIX_SOCKET=/home/gilles/.local/share/digikam/db_misc/mysql.socket", Using an Internal Server; Username and Password: "root", ""] </div><div>digikam.databaseserver: Waiting 10 seconds...stop: [ false ]</div><div>digikam.database: Loading SQL code from config file "/usr/share/digikam/database/dbconfig.xml"</div><div>digikam.database: Checking XML version ID: false "3" 3 3</div><div>digikam.database: ConnectOptions "UNIX_SOCKET=/home/gilles/.local/share/digikam/db_misc/mysql.socket"</div><div>digikam.databaseserver: Failed to use database "digikam"</div><div>digikam.databaseserver: Query error: "Unknown database 'digikam' QMYSQL: Unable to execute query"</div><div>digikam.databaseserver: Database error: "Can't connect to local MySQL server through socket '/home/gilles/.local/share/digikam/db_misc/mysql.socket' (2 \"No such file or directory\") QMYSQL: Unable to connect"</div><div>digikam.databaseserver: Trying to create database now...</div><div>digikam.databaseserver: Database was successfully created</div><div>digikam.database: Loading SQL code from config file "/usr/share/digikam/database/dbconfig.xml"</div><div>digikam.database: Checking XML version ID: false "3" 3 3</div><div>digikam.database: SchemaUpdater update</div><div>digikam.database: No database file available</div><div>digikam.database: Failure executing query:</div><div> "" </div><div>Error messages: "QMYSQL: Unable to execute query" "Table 'mysql.proc' doesn't exist" 1146 2 </div><div>Bound values: ()</div><div>digikam.database: Error while executing DBAction [ "CreateIndices" ] Statement [ "\n DROP PROCEDURE IF EXISTS create_index_if_not_exists;\n " ]</div><div>digikam.databaseserver: At least service [ "org.kde.digikam.startup-8291" ] is using the database server<br></div><div>digikam.databaseserver: Waiting 10 seconds...stop: [ false ]</div></div><div><br></div><div>Can you reproduce this problem to a fresh account ?</div><div><br></div><div>Gilles Caulier</div></div></div></div>
<br>_______________________________________________
Digikam-users mailing list
Digikam-users@kde.org
https://mail.kde.org/mailman/listinfo/digikam-users</div></div> </div></body>
</html>