Digikam not displaying photos after computer reinstall
Maik Qualmann
metzpinguin at gmail.com
Fri Aug 4 20:48:24 BST 2017
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) wbsecg1 at gmail.com
> >> Donate: http://qtav.org/donate.html
> >> Source: https://github.com/wang-bin/QtAV
> >> Home page: http://qtav.org
More information about the Digikam-users
mailing list