[Digikam-devel] [Bug 288599] Schema update to V6 failed

[serge at pdmi.ras.ru]

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





--- Comment #8 from  <serge pdmi ras ru>  2011-12-11 10:09:25 ---
This is the digikam output after applying sql code from comment #3:

digikam(20752)/digikam (core) Digikam::AlbumManager::setDatabase:
DatabaseParameters: [ Type "QMYSQL", Name "digikam" (Thumbnails Name
"digikam"); ConnectOptions:
"UNIX_SOCKET=/home/serge/.kde4/share/apps/digikam/db_misc/mysql.socket",
Username and Password: "root", ""]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(20752)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
Loading SQL code from config file
"/usr/share/apps/digikam/database/dbconfig.xml"
digikam(20752)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
false "1" 1 1
digikam(20752)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(20752)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  5
digikam(20752)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates 
5  to  6
digikam(20752)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:
 "" 
Error messages: "QMYSQL: Unable to execute query" "Incorrect number of
arguments for PROCEDURE digikam.create_index_if_not_exists; expected 4, got 3"
1318 2 
Bound values:  ()
digikam(20752)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error
while executing DBAction [ "UpdateSchemaFromV5ToV6" ] Statement [ "CALL
create_index_if_not_exists('ImageTags','tag_id_index','imageid');" ]
digikam(20752)/digikam (core): Schema update to V6 failed! 

Please, help!

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