[digikam] [Bug 374326] Tag view does not always show children

[bugzilla_noreply at kde.org]

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

--- Comment #2 from kde at kiekerjan.isdronken.nl ---
I tried digikam-5.4.0-01-x86-64.appimage

When executing it, it complains about not being able to convert to version 8 of
the database. (see below).

On further investigation, I also seem to be missing many tags that I made in
the past. That leads me to believing I'm dealing with a corrupt database, not a
bug. I guess the best way ahead would be to close this bug and start with a new
digikam database :(
Any pointers regarding salvaging my tag database would be appreciated. I put a
lot of work into organizing this collection, and I would hate to have to start
over.

digikam.coredb: Core database: running schema update
digikam.geoiface: ----
digikam.coredb: Core database: have a structure version  7
digikam.coredb: Core database: makeUpdates  7  to  8
digikam.dbengine: Failure executing query:
 "" 
Error messages: "QMYSQL: Unable to execute query" "You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near 'IF EXISTS identifier' at line 2" 1064 2 
Bound values:  ()
digikam.dbengine: Error while executing DBAction [ "UpdateSchemaFromV7ToV8" ]
Statement [ "ALTER TABLE AlbumRoots\n                                       
DROP INDEX IF EXISTS identifier;" ]
digikam.coredb: Core database: schema update to V 8 failed!
digikam.coredb: Core database: cannot process schema initialization

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