[Digikam-devel] [digikam] [Bug 323062] digikam (core): Schema update to V 7 failed!

[Rainer Dorsch]

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

--- Comment #7 from Rainer Dorsch <ml at bokomoko.de> ---
Many thanks for your reply.

I am using digikam 3.1 since April, so it cannot be that the schema update is
called for the first time.

After enabling 50003 in kdedebugdialog, I got

digikam(11831)/digikam (core) Digikam::KInotify::Private::open: Successfully
opened connection to inotify: 12
digikam(11831)/digikam (core) Digikam::AlbumManager::setDatabase:
DatabaseParameters: [ Type "QSQLITE", Name
"/home/rd/Rohdaten/digiKam/digikam4.db" (Thumbnails Name
"/home/rd/Rohdaten/digiKam/thumbnails-digikam.db"); ]
QSqlDatabasePrivate::removeDatabase: connection 'ConnectionTest' is still in
use, all queries will cease to work.
digikam(11831)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
Loading SQL code from config file
"/usr/share/kde4/apps/digikam/database/dbconfig.xml"
digikam(11831)/digikam (core) Digikam::DatabaseConfigElementLoader::readConfig:
false "1" 1 1
digikam(11831)/digikam (core) Digikam::SchemaUpdater::update: SchemaUpdater
update
digikam(11831)/digikam (core) Digikam::SchemaUpdater::startUpdates: Have a
database structure version  6                                                   
digikam(11831)/digikam (core) Digikam::SchemaUpdater::makeUpdates: makeUpdates 
6  to  7                                                                    
digikam(11831)/digikam (core)
Digikam::DatabaseCoreBackendPrivate::debugOutputFailedQuery: Failure executing
query:                                         
 ""                                                                             
Error messages: "Unable to execute statement" "table VideoMetadata already
exists" 1 2                                                                     
Bound values:  ()                                                               
digikam(11831)/digikam (core) Digikam::DatabaseCoreBackend::execDBAction: Error
while executing DBAction [ "UpdateSchemaFromV6ToV7" ] Statement [ " CREATE
TABLE VideoMetadata                                                             
                            (imageid INTEGER PRIMARY KEY,                       
                            aspectRatio TEXT,                                   
                            audioBitRate TEXT,                                  
                            audioChannelType TEXT,                              
                            audioCompressor TEXT,                               
                            duration TEXT,                                      
                            frameRate TEXT,                                     
                            exposureProgram INTEGER,                            
                            videoCodec TEXT)" ]                                 
digikam(11831)/digikam (core): Schema update to V 7 failed!                     
digikam(11831)/kdeui (KNotification) KNotificationManager::notificationClosed:
2919   

Seems digikam tries to create VideoMetadata, but it already exists (?).

In that context I might have tried to add GPS coordinates to a video (using
Image->Geo-location, which failed. But not sure if this is related...

Can you tell why digikam tries to create VideoMetadata?

Many thanks again,
Rainer

-- 
You are receiving this mail because:
You are the assignee for the bug.