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

Rainer Dorsch ml at bokomoko.de
Sun Aug 11 20:25:31 BST 2013


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

--- Comment #9 from Rainer Dorsch <ml at bokomoko.de> ---
Seems the database contains inconsistent data:
-> DBVersion|6

but 

sqlite> .tables VideoMetadata
VideoMetadata
sqlite> 

Can you imagine any scenario, which results in such an inconsistent database?

Does it make sense to change DBVersion manually to 7?

Here are the full settings:

sqlite> select * from Settings;
Locale|UTF-8
UpgradedFromSqlite2|yes
databaseImageFormats|jpg;jpeg;jpe;jp2;j2k;jpx;jpc;pgx;tif;tiff;png;xpm;ppm;pnm;pgf;gif;bmp;xcf;pcx;bay;bmq;cr2;crw;cs1;dc2;dcr;dng;erf;fff;hdr;k25;kdc;mdc;mos;mrw;nef;orf;pef;pxn;raf;raw;rdc;sr2;srf;x3f;arw;3fr;cine;ia;kc2;mef;nrw;qtk;rw2;sti;rwl;srw;
databaseVideoFormats|mpeg;mpg;mpo;mpe;avi;divx;wmv;wmf;asf;mp4;3gp;mov;3g2;m4v;m2v;mkv;webm
databaseAudioFormats|ogg;mp3;wma;wav
FilterSettingsVersion|4
DcrawFilterSettingsVersion|4
databaseUserImageFormats|dps
databaseUserVideoFormats|
databaseUserAudioFormats|
RemovedItemsTime|2013-07-31T20:55:51
DeleteRemovedCompleteScanCount|1
Scanned|2013-07-31T20:56:06
preAlpha010Update1|true
preAlpha010Update2|true
preAlpha010Update3|true
beta010Update1|true
beta010Update2|true
databaseUUID|{5f83ecaf-ffb7-4858-9a74-ed0507c6940b}
DBVersion|6
DBVersionRequired|5
sqlite> 

Thanks,
Rainer

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



More information about the Digikam-devel mailing list