[Digikam-devel] [Bug 280678] MYSQL : cannot migrate from sqlite database

[Rodney Baker]

https://bugs.kde.org/show_bug.cgi?id=280678





--- Comment #6 from Rodney Baker <rodney baker iinet net au>  2012-01-21 13:52:58 ---
Running digikam from command line with debugging turned on (via kdebugdialog)
shows the following:

digikam(13542)/kdeui (KNotification) KNotificationManager::close: 204
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(13542)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(13542)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword=?;" 
Error messages: "QMYSQL3: Unable to prepare statement" "Table
'digikam.Settings' doesn't exist" 1146 2 
Bound values:  ()
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword='DBVersion';" 
Error messages: "QMYSQL: Unable to execute query" "Table 'digikam.Settings'
doesn't exist" 1146 2 
Bound values:  (QVariant(QString, "DBVersion") )
digikam(13542)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword=?;" 
Error messages: "QMYSQL3: Unable to prepare statement" "Table
'digikam.Settings' doesn't exist" 1146 2 
Bound values:  ()
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword='DBVersionRequired';" 
Error messages: "QMYSQL: Unable to execute query" "Table 'digikam.Settings'
doesn't exist" 1146 2 
Bound values:  (QVariant(QString, "DBVersionRequired") )
digikam(13542)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  0
digikam(13542)/digikam (core): DBVersion not available! Giving up schema
upgrading. 
digikam(13542)/kdeui (KNotification) KNotificationManager::notificationClosed:
209
digikam(13542)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(13542)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword=?;" 
Error messages: "QMYSQL3: Unable to prepare statement" "Table
'digikam.Settings' doesn't exist" 1146 2 
Bound values:  ()
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword='DBVersion';" 
Error messages: "QMYSQL: Unable to execute query" "Table 'digikam.Settings'
doesn't exist" 1146 2 
Bound values:  (QVariant(QString, "DBVersion") )
digikam(13542)/digikam (core) Digikam::DatabaseCoreBackend::prepareQuery:
Prepare failed!
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword=?;" 
Error messages: "QMYSQL3: Unable to prepare statement" "Table
'digikam.Settings' doesn't exist" 1146 2 
Bound values:  ()
digikam(13542)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "SELECT value FROM Settings WHERE keyword='DBVersionRequired';" 
Error messages: "QMYSQL: Unable to execute query" "Table 'digikam.Settings'
doesn't exist" 1146 2 
Bound values:  (QVariant(QString, "DBVersionRequired") )
digikam(13542)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  0
digikam(13542)/digikam (core): DBVersion not available! Giving up schema
upgrading. 
digikam(13542)/kdeui (KNotification) KNotificationManager::notificationClosed:
218
digikam(13542)/kio (Slave) KIO::Slave::kill: killing slave pid 13562 (
"digikamdates://" )

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.