Digikam not displaying photos after computer reinstall

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Digikam not displaying photos after computer reinstall

Anders Lund
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
>

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Digikam not displaying photos after computer reinstall

Maik Qualmann
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Digikam not displaying photos after computer reinstall

Richard Mortimer-2
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Digikam not displaying photos after computer reinstall

Maik Qualmann
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

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Digikam not displaying photos after computer reinstall

Richard Mortimer-2
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
>
Loading...