Bug 180351 - Tooltip exposure shown as "unavailable" even if info present in EXIF
Summary: Tooltip exposure shown as "unavailable" even if info present in EXIF
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Scan (show other bugs)
Version: 0.10.0
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-11 18:11 UTC by Sebastian
Modified: 2017-07-26 05:22 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 0.10.0


Attachments
file imported to digikam (1) (408.55 KB, image/png)
2009-01-11 20:47 UTC, caulier.gilles
Details
file imported to digikam (2) (338.50 KB, image/png)
2009-01-11 20:48 UTC, caulier.gilles
Details
file imported to digikam (3) (502.25 KB, image/png)
2009-01-12 11:39 UTC, caulier.gilles
Details
old digikam4.db database file archived (422.24 KB, application/octet-stream)
2009-01-17 10:21 UTC, caulier.gilles
Details
new digikam4.db database file (142.39 KB, application/octet-stream)
2009-01-17 10:23 UTC, caulier.gilles
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sebastian 2009-01-11 18:11:21 UTC
Version:           0.10.0-beta6 (using 4.1.3 (KDE 4.1.3) "release 4.9", openSUSE 11.1)
Compiler:          gcc
OS:                Linux (x86_64) release 2.6.27.7-9-default

When I hoover over a thumbnail in album view, the tooltip shows the exposure (and aperture) as "unavailable" even though the EXIF sidebar has both information. You can find an example file here: http://www.jbib.de/tmp/pict2826.jpg. This is a JPG file created with a Konica Minolta 7D straight from camera. Other meta-data are shown correctly (eg dimensions, ISO, focal length).
Comment 1 caulier.gilles 2009-01-11 20:46:36 UTC
I confirm this bug.

I just copied this file in my collection when digiKam running.

The file appear in icon view, but all photograph information are not imported to the database automatically.
Comment 2 caulier.gilles 2009-01-11 20:47:56 UTC
Created attachment 30138 [details]
file imported to digikam (1)
Comment 3 caulier.gilles 2009-01-11 20:48:37 UTC
Created attachment 30139 [details]
file imported to digikam (2)
Comment 4 caulier.gilles 2009-01-11 20:58:16 UTC
Marcel,

re-starting digiKam do not help.

Going to Caption & Tags and using More/Read Metadata from File to Database do not help

Gilles Caulier

Comment 5 caulier.gilles 2009-01-12 11:38:27 UTC
Marcel,

I found a way to see photograph information with this image.

1/ stop digiKam
2/ copy file to collection
3/ start digiKam
4/ if scan for new image at startup is not set on, start it manually from Tools menu
5/ The image is now on icon view with all photograph info.

Gilles Caulier
Comment 6 caulier.gilles 2009-01-12 11:39:40 UTC
Created attachment 30180 [details]
file imported to digikam (3)

Screenshot of file imported in digiKAm with all photo info available.
Comment 7 caulier.gilles 2009-01-12 11:40:41 UTC
Sebastian, 

Can you confirm my investigations from #5 ?

Gilles Caulier
Comment 8 Marcel Wiesweg 2009-01-13 15:51:05 UTC
No problem for me here, everything from the metadata is shown. No difference if imported with digikam running or not (of course, I removed the database entries before). Can you reliably reproduce this?
Comment 9 caulier.gilles 2009-01-13 15:55:31 UTC
Marcel,

Are you changed something in code ?

Why it doesn't work here ? It's relevant of digikam4.db file ? I need to remove it before to test again ?

Gilles
Comment 10 Marcel Wiesweg 2009-01-13 16:36:04 UTC
No I'm not aware of any relevant changes - it just works here...
(I updated exiv2 yesterday because of the other bug, that's the only change I see here)

To re-import from scratch, remove the whole digikam4.db, or just remove all entries for this file:
DELETE FROM Images WHERE name ='pict2826.jpg';
(Hope you have no other image with the same name;-) )
and restart digikam, or remove the file and add it while digikam is running.

If you can reproduce, it would be interesting to get a database dump:
SELECT * FROM Images LEFT JOIN ImageMetadata ON imageid=id WHERE name ='pict2826.jpg';
Comment 11 caulier.gilles 2009-01-17 09:44:52 UTC
Marcel, trying to import again this image in my collection when digiKam already running doesn't work. No photo info avaialble.

Are you see that Color Mode of this image is YCbCr not RGB. Perhaps it's the problem? 

See below the database dump:


[gilles@localhost photo]$ sqlite3 digikam4.db
SQLite version 3.6.1
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT * FROM Images LEFT JOIN ImageMetadata ON imageid=id WHERE name ='pict2826.jpg';
1269|120|pict2826.jpg|1|1|2009-01-11T20:36:52|3621253|79196ae66df7c4fec30ebca48983a026|||||||||||||||||
1271|147|pict2826.jpg|1|1|2009-01-17T09:36:57|3621253|79196ae66df7c4fec30ebca48983a026|||||||||||||||||
sqlite>

Gilles
Comment 12 caulier.gilles 2009-01-17 10:20:02 UTC
Marcel,

Renaming digikam4.db to digikam4.db.old solve the problem.

Runing digiKam and importing the file again in collection work fine now.

I will attach bziped DB file for investiguations...

Gilles
Comment 13 caulier.gilles 2009-01-17 10:21:40 UTC
Created attachment 30339 [details]
old digikam4.db database file archived
Comment 14 caulier.gilles 2009-01-17 10:23:03 UTC
Created attachment 30340 [details]
new digikam4.db database file
Comment 15 caulier.gilles 2009-01-17 10:25:02 UTC
Sebastian, 

Please rename your digiKam database file as explained before in this thread and try again.

Gilles Caulier 
Comment 16 Marcel Wiesweg 2009-01-17 13:09:53 UTC
I cannot find out why this image was imported without metadata information into the database at first, if new attempts with a fresh database do not reproduce this.
I see some related TODOs. The collection scanner perhaps relies a bit too strongly on information it has already in its database. We also need to clear up the actions "Refresh", "Synchronize Images with database", "Update Metadata database", "More->Read metadat from file to database", "More->Write metadata to each file", sometimes do not do what they say (or they are unprecise in saying what they do), or it is not really clear which images are affected. But I would prefer to do that when the batch manager is implemented.
Comment 17 caulier.gilles 2009-01-17 14:02:27 UTC
Marcel,

Do you think that we can close this file now ?

Gilles
Comment 18 Marcel Wiesweg 2009-01-18 22:26:16 UTC
Let's close this file now. No more actions to be expected.