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

[Marcel Wiesweg]

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

--- Comment #22 from Marcel Wiesweg <marcel.wiesweg at gmx.de> ---
Short guidance for anyone wishing to repair his database:

Open the digikam4.db file with the sqlite3 command line tool:
sqlite3 <path>/digikam4.db

Make sure this bug is for you:
SELECT * FROM Settings WHERE keyword='DBVersion';
DBVersion|6
SELECT COUNT(*) FROM VideoMetadata;
0

The latter statement should give any number, and not the error "no such table:
VideoMetadata"

If that applies, fix your DBVersion: 

REPLACE INTO Settings (keyword, value) VALUES ('DBVersion', 7);
.exit

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