On Thu, 19 Jan 2012 20:38:41 Will Stephenson wrote:
On Thursday 19 January 2012 13:36:33 Rodney Baker wrote:
This was originally asked on opensuse@opensuse.org but got no responses, so I'm trying the KDE list.
Hi all. I'm hoping someone else may have come across this and found a solution. I wanted to convert my digikam setup from sqlite to mysql. Digikam includes a database migration tool so I;
<snip>
Has anyone gotten this to work recently?
I would try turning on debugging (using kdebugdialog) then run digikam from the command line and try again, see if a more specific error is output.
OK, found this (sorry about the line wrap): digikam(13542)/kdeui (KNotification) KNotificationManager::close: 204 QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in use, all queries will cease to work. Note: The above message appears immediately after pressing the "Check DB Connection" button. Subsequently, queries fail. 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 Well, of course it doesn't! You haven't created it yet! We started with an empty database! 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. It isn't supposed to be upgrading the Schema - it's supposed to be creating it! digikam(13542)/kdeui (KNotification) KNotificationManager::notificationClosed: 209 Hmmm - not sure what I'm doing wrong here (if anything)... -- =================================================== Rodney Baker VK5ZTV rodney.baker@iinet.net.au =================================================== -- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org