Digikam not displaying photos after computer reinstall

Kees Vonk keesvonk at gmail.com
Wed Aug 2 21:41:30 BST 2017 

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