Digikam not displaying photos after computer reinstall
Locked
 
|
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 |
Re: Digikam not displaying photos after computer reinstall
|
|
Hi,
Does digikam have the correct path to the database and collection root? It may change during reinstall, so maybe it is just a question of telling digikam the path. Kindly, Anders På Wed, 2 Aug 2017 21:41:20 +0100 Kees Vonk <[hidden email]> skrev: > 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 > |
Re: Digikam not displaying photos after computer reinstall
|
|
In reply to this post by Kees Vonk
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) [hidden email] > Donate: http://qtav.org/donate.html > Source: https://github.com/wang-bin/QtAV > Home page: http://qtav.org |
Re: Digikam not displaying photos after computer reinstall
|
|
Hi,
I was wondering if MariaDB might work! I had a brief look at the v7 to v8 upgrade scripts and noticed that it uses "IF EXISTS". That isn't supported in MySQL (only supported in MariaDB 10.0 upwards). I guess that means that upgrades are not supported for MySQL at all. I think that practically any user with a pre v8 database (I think that means a database created in digikam 4.x or earlier) is best advised to migrate the old database into a new database. The digikam 5.x MySQL/MariaDB changes corrected a lot of previous problems and will give you a database that should work correctly. There can be some issues migrating an existing database due to previous bugs/features. I provided some mysql commands to help cleanup the data in bug 355831 https://bugs.kde.org/show_bug.cgi?id=355831 specifically https://bugs.kde.org/attachment.cgi?id=99906 Recently I've suggested some changes to the migration that ignore the bad data during migration. That is not included in digikam yet. https://bugs.kde.org/show_bug.cgi?id=382732 I would really sugggest that you try a migration to a clean database. I have done that with my databases to ensure minimal problems at a later date. Regards Richard On 04/08/2017 19:29, Maik Qualmann wrote: > 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) [hidden email] >> Donate: http://qtav.org/donate.html >> Source: https://github.com/wang-bin/QtAV >> Home page: http://qtav.org |
Re: Digikam not displaying photos after computer reinstall
|
|
Richard,
I have the patch from https://bugs.kde.org/show_bug.cgi?id=382732 to git/ master commited. Do you see a solution for the MySQL and "IF EXISTS" problem? Maik Am Freitag, 4. August 2017, 21:25:24 CEST schrieb Richard Mortimer: > Hi, > > I was wondering if MariaDB might work! I had a brief look at the v7 to > v8 upgrade scripts and noticed that it uses "IF EXISTS". That isn't > supported in MySQL (only supported in MariaDB 10.0 upwards). I guess > that means that upgrades are not supported for MySQL at all. > > I think that practically any user with a pre v8 database (I think that > means a database created in digikam 4.x or earlier) is best advised to > migrate the old database into a new database. The digikam 5.x > MySQL/MariaDB changes corrected a lot of previous problems and will give > you a database that should work correctly. > > There can be some issues migrating an existing database due to previous > bugs/features. > > I provided some mysql commands to help cleanup the data in bug 355831 > https://bugs.kde.org/show_bug.cgi?id=355831 > specifically > https://bugs.kde.org/attachment.cgi?id=99906 > > Recently I've suggested some changes to the migration that ignore the > bad data during migration. That is not included in digikam yet. > https://bugs.kde.org/show_bug.cgi?id=382732 > > I would really sugggest that you try a migration to a clean database. I > have done that with my databases to ensure minimal problems at a later date. > > Regards > > Richard > > On 04/08/2017 19:29, Maik Qualmann wrote: > > 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) [hidden email] > >> Donate: http://qtav.org/donate.html > >> Source: https://github.com/wang-bin/QtAV > >> Home page: http://qtav.org |
Re: Digikam not displaying photos after computer reinstall
|
|
Maik et al,
I'm going to move this discussion to digikam-devel. The technical implementation details are not really appropriate to -users. Richard On 04/08/2017 20:48, Maik Qualmann wrote: > Richard, > > I have the patch from https://bugs.kde.org/show_bug.cgi?id=382732 to git/ > master commited. Do you see a solution for the MySQL and "IF EXISTS" problem? > > Maik > > Am Freitag, 4. August 2017, 21:25:24 CEST schrieb Richard Mortimer: >> Hi, >> >> I was wondering if MariaDB might work! I had a brief look at the v7 to >> v8 upgrade scripts and noticed that it uses "IF EXISTS". That isn't >> supported in MySQL (only supported in MariaDB 10.0 upwards). I guess >> that means that upgrades are not supported for MySQL at all. >> >> I think that practically any user with a pre v8 database (I think that >> means a database created in digikam 4.x or earlier) is best advised to >> migrate the old database into a new database. The digikam 5.x >> MySQL/MariaDB changes corrected a lot of previous problems and will give >> you a database that should work correctly. >> >> There can be some issues migrating an existing database due to previous >> bugs/features. >> >> I provided some mysql commands to help cleanup the data in bug 355831 >> https://bugs.kde.org/show_bug.cgi?id=355831 >> specifically >> https://bugs.kde.org/attachment.cgi?id=99906 >> >> Recently I've suggested some changes to the migration that ignore the >> bad data during migration. That is not included in digikam yet. >> https://bugs.kde.org/show_bug.cgi?id=382732 >> >> I would really sugggest that you try a migration to a clean database. I >> have done that with my databases to ensure minimal problems at a later date. >> >> Regards >> >> Richard >> >> On 04/08/2017 19:29, Maik Qualmann wrote: >>> 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) [hidden email] >>>> Donate: http://qtav.org/donate.html >>>> Source: https://github.com/wang-bin/QtAV >>>> Home page: http://qtav.org > |
«
Return to digikam-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |