digiKam › digikam-users

Digikam not displaying photos after computer reinstall

classic Classic list List threaded Threaded
♦
♦
 1 message Options
Kees Vonk
Reply | Threaded
Open this post in threaded view
♦
♦
|

Digikam not displaying photos after computer reinstall

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) [hidden email]
Donate: http://qtav.org/donate.html
Source: https://github.com/wang-bin/QtAV
Home page: http://qtav.org
Free forum by Nabble Edit this page