[Digikam-users] Mysql/MariaDb database expert needs...
Piter Dias
piter.dias at piterdias.com
Wed Nov 11 23:39:37 GMT 2015
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.
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.
What else could I do to help?
piterdias at microserver:~$ digikam -vQt: 4.8.6KDE Development Platform: 4.13.3digiKam: 4.14.0
piterdias at microserver:~$ mysql --versionmysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
------------------------------------------- MIGRATION TO INTERNAL SERVER -------------------------------------------------
digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikam(29920)/digikam (core) Digikam::DatabaseParameters::defaultParameters: ConnectOptions "UNIX_SOCKET=/home/piterdias/.kde/share/apps/digikam/db_misc/mysql.socket"digikam(29920)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater updatedigikam(29920)/digikam (core) Digikam::SchemaUpdater::startUpdates: No database file availabledigikam(29920)/digikam (core) Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing query: ""Error messages: "QMYSQL: Unable to execute query" "Table 'mysql.proc' doesn't exist" 1146 2Bound values: ()digikam(29920)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error while executing DBAction [ "CreateIndices" ] Statement [ " DROP PROCEDURE IF EXISTS create_index_if_not_exists; " ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikam(29920)/kdeui (KNotification) KNotificationManager::notificationClosed: 3digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]
----------------------------------------------------- MIGRATION TO REGULAR MYSQL DATABASE --------------------
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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )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 )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 ] 0digikam(29920)/khtml (caret) DOM::Selection::validate: [character:baseIsStart] true Position( 0x0 "null" : 0 ) Position( 0x0 "null" : 0 )digikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::checkDigikamInstancesRunning: At least service [ "org.kde.digikam-29920" ] is using the database serverdigikamdatabaseserver(29985)/digikam (database server) Digikam::PollThread::run: Waiting 10 seconds...stop: [ false ]digikam(29920)/kdeui (KNotification) KNotificationManager::close: 4QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in use, all queries will cease to work.digikam(29920)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater updatedigikam(29920)/digikam (core) Digikam::SchemaUpdater::startUpdates: No database file availabledigikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Trying to copy contents from DB with ActionName: [ "Migrate_Read_AlbumRoots" ] to DB with ActionName [ "Migrate_Write_AlbumRoots" ]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.digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Result size: [ 0 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "label" ] value [ QVariant(QString, "") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 0) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "type" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "identifier" ] value [ QVariant(QString, "volumeid:?uuid=59f1850e-dbca-4a1a-b49f-09c3a2ff1db2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "specificPath" ] value [ QVariant(QString, "/home/piterdias/Pictures/digikam/raw") ]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" ]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.digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Result size: [ 0 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "albumRoot" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "relativePath" ] value [ QVariant(QString, "/") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "date" ] value [ QVariant(QString, "2015-11-11") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "caption" ] value [ QVariant(QString, "") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "collection" ] value [ QVariant(QString, "") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "icon" ] value [ QVariant(QString, "") ]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" ]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.digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Result size: [ 35 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0735.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:57:54") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25092588) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "bcf5cc8201189856e4dfe4abd0354ae0") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 2) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0736.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:58:44") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 27673144) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "c1fefa040f1d0bd7dbe47aa4eb0ed39e") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 3) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0737.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:59:04") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 27453799) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "e28612b16aa73000866d4895e2daf77d") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 4) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0738.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:59:26") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26860509) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "ad3f835715d658551d96e6b125045971") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 5) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0739.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T12:59:32") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26522634) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "58bee19dddd6444ebd6ff99272676c34") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 6) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0740.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:01:54") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 28749494) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "58473d29938d3d9f1d570435faecf8df") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 7) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0741.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:03:04") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25279919) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "f8f27d422293dacbbcfdf99b8e36e941") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 8) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0742.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:03:50") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25919351) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "8ea96880cfbca8c5e275ff934f5a256b") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 9) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0743.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:10") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26243290) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "658badd8d58737dd437b7b4dd7876a73") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 10) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0744.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:12") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26201259) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "1cb1226c0a2f8170185ddd4496c91dfd") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 11) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0745.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:16") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 25322644) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "26ffdf644e47ad74445ae3ec7c6b7707") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 12) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0746.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:36") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23609467) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "781eb94490d0808f4a051315b1aa5b56") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 13) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0747.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:40") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23374296) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "7459120c7b8a4d2e932600d11f619014") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 14) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0748.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:05:56") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23997206) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "86cc798b7a83adf95dbbaa8d25d47085") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 15) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0749.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:14") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 26638831) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "91e422e62623101f349fb4d5a0406cca") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 16) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0750.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:28") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 22772218) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "39ec20f23860d3eb1d8356a4e2d5f788") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 17) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0751.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:30") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23083450) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "84a2e92135b171b4b4fbd8c5845de5de") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 18) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "album" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "name" ] value [ QVariant(QString, "_MG_0752.CR2") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "status" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "category" ] value [ QVariant(qlonglong, 1) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "modificationDate" ] value [ QVariant(QString, "2015-11-07T13:06:42") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "fileSize" ] value [ QVariant(qlonglong, 23611240) ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "uniqueHash" ] value [ QVariant(QString, "2fc3c92d71a7ddb4eff59f3bff2623e7") ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Query isOnValidRow [ true ] isActive [ true ] result size: [ -1 ]digikam(29920)/digikam (core) Digikam::DatabaseCopyManager::copyTable: Column: [ "id" ] value [ QVariant(qlonglong, 19) ]
_____________________Piter Diaspiter.dias at piterdias.comwww.piterdias.com
From: caulier.gilles at gmail.com
Date: Wed, 11 Nov 2015 16:59:00 +0100
To: digikam-users at kde.org
Subject: Re: [Digikam-users] Mysql/MariaDb database expert needs...
2015-11-11 12:58 GMT+01:00 Piter Dias <piter.dias at piterdias.com>:
I use digikam under Windows and mysql as database (in a Linux box).
What do you need? Someone to test?More than testing.
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).
Currently the migration stop in the middle due to strange error reported by mysql (Mariadb here) :
[gilles at localhost database]$ mysql --versionmysql Ver 15.1 Distrib 10.0.21-MariaDB, for Linux (x86_64) using readline 5.1
I suppose some ImmoDb incompatibilities with digiKam sql statements to create indexes (tables are created).
[gilles at localhost data]$ digikamdigikam.general: AlbumWatch use QFileSystemWatcherdigikam.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", ""] digikam.databaseserver: Waiting 10 seconds...stop: [ false ]digikam.database: Loading SQL code from config file "/usr/share/digikam/database/dbconfig.xml"digikam.database: Checking XML version ID: false "3" 3 3digikam.database: ConnectOptions "UNIX_SOCKET=/home/gilles/.local/share/digikam/db_misc/mysql.socket"digikam.databaseserver: Failed to use database "digikam"digikam.databaseserver: Query error: "Unknown database 'digikam' QMYSQL: Unable to execute query"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"digikam.databaseserver: Trying to create database now...digikam.databaseserver: Database was successfully createddigikam.database: Loading SQL code from config file "/usr/share/digikam/database/dbconfig.xml"digikam.database: Checking XML version ID: false "3" 3 3digikam.database: SchemaUpdater updatedigikam.database: No database file availabledigikam.database: Failure executing query: "" Error messages: "QMYSQL: Unable to execute query" "Table 'mysql.proc' doesn't exist" 1146 2 Bound values: ()digikam.database: Error while executing DBAction [ "CreateIndices" ] Statement [ "\n DROP PROCEDURE IF EXISTS create_index_if_not_exists;\n " ]digikam.databaseserver: At least service [ "org.kde.digikam.startup-8291" ] is using the database server
digikam.databaseserver: Waiting 10 seconds...stop: [ false ]
Can you reproduce this problem to a fresh account ?
Gilles Caulier
_______________________________________________
Digikam-users mailing list
Digikam-users at kde.org
https://mail.kde.org/mailman/listinfo/digikam-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151111/d5c382f1/attachment.html>
More information about the Digikam-users
mailing list