Digikam not displaying photos after computer reinstall

Maik Qualmann metzpinguin at gmail.com
Fri Aug 4 19:29:05 BST 2017 

Can you use MariaDB? The update to the database version V8 should work with 
MariaDB.

Maik

Am Mittwoch, 2. August 2017, 22:41:20 CEST schrieb Kees Vonk:
> Hello,
> 
> I have recently needed to reinstall my computer. I have backed up the
> mysql database that I was using and restore it on my rebuild computer. I
> am not sure what version of digikam was installed before, but I now have
> digikam 5.6 on Ubuntu 17.04 (initially digikam 5.4 was installed, but
> because of the problems I was facing I upgraded to 5.6). The mysql
> version is 5.7.
> 
> When I start up digikam it comes up with an error about upgrading the
> database and then when digikam comes up it there don't seem to be any
> photos, even though they are in the same location as on the previous
> build of the computer.
> 
> I have started it up from the terminal to capture the output and errors,
> which gives me the output below. I added the digikam-facedb when it was
> complaining about DB errors, but it has not actually created the
> database. I have even added the mysql root user to see if that would
> make a difference.
> 
> Any help would be greatly appreciated.
> 
> Kees
> 
> ----- output of digikam captured from terminal -----
> 
> digikam.general: AlbumWatch use QFileSystemWatcher
> digikam.general: Database Parameters:
>     Type:                     "QMYSQL"
>     DB Core Name:             "digikam"
>     DB Thumbs Name:           "digikam-thumbnails"
>     DB Face Name:             "digikam-facedb"
>     Connect Options:          ""
>     Host Name:                "localhost"
>     Host port:                3306
>     Internal Server:          false
>     Internal Server Path:     ""
>     Internal Server Serv Cmd: ""
>     Internal Server Init Cmd: ""
>     Username:                 "root"
>     Password:                 "XXXXXXXXXXXXX"
> 
> digikam.dbengine: Loading SQL code from config file
> "/usr/share/digikam/database/dbconfig.xml"
> digikam.dbengine: Checking XML version ID => expected:  3 found:  3
> digikam.coredb: Core database: running schema update
> 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
> KMemoryInfo: Platform identified :  "LINUX"
> KMemoryInfo: TotalRam:  8295964672
> digikam.general: Allowing a cache size of 200 MB
> digikam.general: Switch to widget style:  ""
> digikam.dimg: ("/usr/share/color/icc")
> digikam.dimg: No X.org XICC profile installed for screen  0
> digikam.general: Camera XML data:
> "/home/cesera/.local/share/digikam/cameras.xml"
> digikam.facedb: FaceDB SelectFaceSetting val ret =  0
> digikam.facedb: FaceDB SelectFaceSetting val ret =  0
> digikam.facedb: Face database: have a structure version  "2"
> digikam.facesengine: Face database ready for use
> digikam.general: Face PipeLine: add database writer
> digikam.general: Face PipeLine: add faces trainer
> digikam.facesengine: Face database ready for use
> digikam.general: Face PipeLine: add database writer
> digikam.general: Face PipeLine: add faces trainer
> digikam.geoiface: "setting backend marble"
> digikam.general: AudioOutput backends: ("Pulse", "OpenAL", "null")
> digikam.general: Stacked View Mode :  0
> digikam.geoiface: "setting backend marble"
> digikam.geoiface: "setting backend marble"
> digikam.general: "browse_album"
> digikam.general: "browse_tag"
> digikam.general: "browse_labels"
> digikam.general: "browse_date"
> digikam.general: "browse_timeline"
> digikam.general: "browse_search"
> digikam.general: "browse_fuzzysearch"
> digikam.general: "browse_gpssearch"
> digikam.general: "browse_people"
> digikam.widgets: Paths to color scheme : ("/usr/share/digikam/colorschemes")
> digikam.widgets: "Breeze"  ::  ""
> digikam.widgets: "Breeze"  ::  ""
> QFSFileEngine::open: No file name specified
> digikam.dimg: Root lens database dir:  "/usr/share/lensfun"
> digikam.dimg: Load lens database file:  "6x6.xml"
> digikam.dimg: Load lens database file:  "actioncams.xml"
> digikam.dimg: Load lens database file:  "compact-canon.xml"
> digikam.dimg: Load lens database file:  "compact-casio.xml"
> digikam.dimg: Load lens database file:  "compact-fujifilm.xml"
> digikam.dimg: Load lens database file:  "compact-kodak.xml"
> digikam.dimg: Load lens database file: "compact-konica-minolta.xml"
> digikam.dimg: Load lens database file:  "compact-leica.xml"
> digikam.dimg: Load lens database file:  "compact-nikon.xml"
> digikam.dimg: Load lens database file:  "compact-olympus.xml"
> digikam.dimg: Load lens database file:  "compact-panasonic.xml"
> digikam.dimg: Load lens database file:  "compact-pentax.xml"
> digikam.dimg: Load lens database file:  "compact-ricoh.xml"
> digikam.dimg: Load lens database file:  "compact-samsung.xml"
> digikam.dimg: Load lens database file:  "compact-sigma.xml"
> digikam.dimg: Load lens database file:  "compact-sony.xml"
> digikam.dimg: Load lens database file:  "contax.xml"
> digikam.dimg: Load lens database file:  "generic.xml"
> digikam.dimg: Load lens database file:  "mil-canon.xml"
> digikam.dimg: Load lens database file:  "mil-fujifilm.xml"
> digikam.dimg: Load lens database file:  "mil-nikon.xml"
> digikam.dimg: Load lens database file:  "mil-olympus.xml"
> digikam.dimg: Load lens database file:  "mil-panasonic.xml"
> digikam.dimg: Load lens database file:  "mil-pentax.xml"
> digikam.dimg: Load lens database file:  "mil-samsung.xml"
> digikam.dimg: Load lens database file:  "mil-samyang.xml"
> digikam.dimg: Load lens database file:  "mil-sigma.xml"
> digikam.dimg: Load lens database file:  "mil-sony.xml"
> digikam.dimg: Load lens database file:  "mil-tamron.xml"
> digikam.dimg: Load lens database file:  "mil-zeiss.xml"
> digikam.dimg: Load lens database file:  "misc.xml"
> digikam.dimg: Load lens database file:  "rf-leica.xml"
> digikam.dimg: Load lens database file:  "slr-canon.xml"
> digikam.dimg: Load lens database file:  "slr-hasselblad.xml"
> digikam.dimg: Load lens database file:  "slr-konica-minolta.xml"
> digikam.dimg: Load lens database file:  "slr-leica.xml"
> digikam.dimg: Load lens database file:  "slr-nikon.xml"
> digikam.dimg: Load lens database file:  "slr-olympus.xml"
> digikam.dimg: Load lens database file:  "slr-panasonic.xml"
> digikam.dimg: Load lens database file:  "slr-pentax.xml"
> digikam.dimg: Load lens database file:  "slr-ricoh.xml"
> digikam.dimg: Load lens database file:  "slr-samsung.xml"
> digikam.dimg: Load lens database file:  "slr-samyang.xml"
> digikam.dimg: Load lens database file:  "slr-schneider.xml"
> digikam.dimg: Load lens database file:  "slr-sigma.xml"
> digikam.dimg: Load lens database file:  "slr-soligor.xml"
> digikam.dimg: Load lens database file:  "slr-sony.xml"
> digikam.dimg: Load lens database file:  "slr-tamron.xml"
> digikam.dimg: Load lens database file:  "slr-tokina.xml"
> digikam.dimg: Load lens database file:  "slr-ussr.xml"
> digikam.dimg: Load lens database file:  "slr-vivitar.xml"
> digikam.dimg: Load lens database file:  "slr-zeiss.xml"
> digikam.dimg: variant:  QVariant(Digikam::LensFunIface::DevicePtr, )
> digikam.dimg: dev:  AEE  ::  AEE DV  ::  6
> digikam.dimg: Search for camera  "" - ""  ==> false
> digikam.dimg: Search for lens  ""  ==> false
> digikam.dimg: updating data
> digikam.dimg: updating data
> digikam.general: Using  4  CPU core to run threads
> digikam.general: new search text settings:  "" : hasResult = false ,
> validRows =  0
> QFSFileEngine::open: No file name specified
> digikam.geoiface: ----
> digikam.general: Did not find album root album in hash
> digikam.general: Did not find album root album in hash
> digikam.general: Did not find album root album in hash
> digikam.general: Could not find parent with url:  ""  for: "/00000000"
> digikam.general: Could not find parent with url:  ""  for: "/00000000"
> digikam.general: Could not find parent with url:  ""  for: "/00000000"
> digikam.general: Could not find parent with url:  ""  for: "/200107-July"
> digikam.general: Could not find parent with url:  ""  for: "/200107-July"
> digikam.general: Could not find parent with url:  ""  for: "/200107-July"
> digikam.general: Could not find parent with url:  ""  for:
> "/200202-February"
> digikam.general: Could not find parent with url:  ""  for:
> "/200202-February"
> digikam.general: Could not find parent with url:  ""  for:
> "/200202-February"
> digikam.general: Could not find parent with url:  ""  for: "/200203-March"
> digikam.general: Could not find parent with url:  ""  for: "/200203-March"
> digikam.general: Could not find parent with url:  ""  for: "/200203-March"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020312"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020312"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020312"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020326"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020326"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020326"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020329"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020329"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020329"
> digikam.general: Could not find parent with url:  "/200203-March" for:
> "/200203-March/20020331"
> 
> ... this kind of message repeats for about 2600 lines ...
> 
> digikam.general: Could not find parent with url:  "/201206-June" for:
> "/201206-June/20120609"
> digikam.general: Could not find parent with url:  "/201206-June" for:
> "/201206-June/20120609"
> digikam.general: Could not find parent with url:  ""  for: "/Unkown"
> digikam.general: Could not find parent with url:  ""  for: "/Unkown"
> digikam.general: Could not find parent with url:  "/Unkown"  for:
> "/Unkown/pixie"
> digikam.general: Could not find parent with url:  "/Unkown"  for:
> "/Unkown/pixie"
> digikam.general: Using  4  CPU core to run threads
> digikam.general: Action Thread run  1  new jobs
> digikam.geoiface: ----
> digikam.geoiface: ----
> digikam.general: Using  4  CPU core to run threads
> digikam.general: Action Thread run  1  new jobs
> digikam.geoiface: ----
> digikam.database: " ( (Images.id IN (?,?,?,?,?)  ) ) "
> digikam.database: Search query:
>   "SELECT DISTINCT Images.id, Images.name, Images.album,
> Albums.albumRoot,        ImageInformation.rating,
> Images.category,        ImageInformation.format,
> ImageInformation.creationDate,        Images.modificationDate,
> Images.fileSize,        ImageInformation.width,
> ImageInformation.height,        ImagePositions.latitudeNumber,
> ImagePositions.longitudeNumber  FROM Images        LEFT JOIN
> ImageInformation ON Images.id=ImageInformation.imageid LEFT  JOIN
> ImageMetadata    ON Images.id=ImageMetadata.imageid        LEFT  JOIN
> VideoMetadata ON Images.id=VideoMetadata.imageid        LEFT  JOIN
> ImagePositions   ON Images.id=ImagePositions.imageid        INNER JOIN
> Albums           ON Albums.id=Images.album WHERE Images.status=1 AND (
> ( (Images.id IN (?,?,?,?,?)  ) )  );"
>   (QVariant(qlonglong, 5436), QVariant(qlonglong, 5432),
> QVariant(qlonglong, 5429), QVariant(qlonglong, 5435),
> QVariant(qlonglong, 5433))
> digikam.general: Cancel Main Thread
> digikam.geoiface: ----
> digikam.database: Search result: 70
> digikam.general: Using  4  CPU core to run threads
> digikam.general: Stacked View Mode :  2
> digikam.general: Action Thread run  1  new jobs
> digikam.geoiface: "ROADMAP"
> digikam.geoiface: "ROADMAP"
> digikam.geoiface: "ROADMAP"
> digikam.geoiface: ----
> digikam.general: Stacked View Mode :  2
> digikam.geoiface: "ROADMAP"
> digikam.geoiface: ----
> digikam.general: Stacked View Mode :  2
> digikam.general: Not active, returning without action
> digikam.general: One job is done
> digikam.general: One job is done
> digikam.general: Data From DBJobsThread is null:  true
> digikam.general: Cancel Main Thread
> digikam.general: One job is done
> kipi.library: Plugin  "KXMLHelloWorld"  (generic name: "KXMLHelloWorld"
> ) is in the ignore list from host application
> digikam.geoiface: ----
> digikam.general: Stacked View Mode :  2
> digikam.geoiface: "setting backend marble"
> QFSFileEngine::open: No file name specified
> digikam.geoiface: "ROADMAP"
> digikam.geoiface: "setting backend marble"
> digikam.facesengine: Face database ready for use
> digikam.general: Face PipeLine: add database writer
> digikam.general: Face PipeLine: add faces trainer
> digikam.facesengine: Face database ready for use
> digikam.general: Face PipeLine: add database writer
> digikam.general: Face PipeLine: add faces trainer
> digikam.geoiface: "setting backend marble"
> QFSFileEngine::open: No file name specified
> digikam.geoiface: "ROADMAP"
> digikam.geoiface: "ROADMAP"
> digikam.geoiface: ----
> digikam.general: scan mode: ScanDeferredFiles
> digikam.general: total scan value :  0
> digikam.database: items to tag ()
> digikam.database: Complete scan took: 111 msecs.
> digikam.general: Event is dispatched through a passive pop-up
> QLayout: Attempting to add QLayout "" to QWidget "", which already has a
> layout
> digikam.geoiface: ----
> digikam.dbengine: WARNING !!! Transaction count is 1 when destroying
> database!!!
> digikam.general: Cancel Main Thread
> digikam.general: Cancel Main Thread
> digikam.general: Cancel Main Thread
> digikam.general: Cancel Main Thread
> digikam.general: Cancel Main Thread
> QtAV 1.11.0(Mar 14 2017, 12:08:50)
> Multimedia framework base on Qt and FFmpeg.
> Distributed under the terms of LGPLv2.1 or later.
> Shanghai University->S3 Graphics->Deepin, Shanghai, ChinaCopyright (C)
> 2012-2016 Wang Bin (aka. Lucas Wang) wbsecg1 at gmail.com
> Donate: http://qtav.org/donate.html
> Source: https://github.com/wang-bin/QtAV
> Home page: http://qtav.org

More information about the Digikam-users mailing list