Shutter Speed display workaround

[kolohe]

In another thread somewhere out here, there was a comment made about the "new" decimal format being used by EE2 to display shutter speeds (for example 0.004 instead of 1/250). I don't really like this either.

If you have access to your database via a tool such as MySQL Query Browser or phpMyAdmin, you can run this UPDATE to change all of the new format shutter speeds back to the old format (or something reasonably close to it):

update ee_photo
set ee_photo_shutter_unit="1/100",
ee_photo_exif_shutter=round(1/(abs(ee_photo_exif_shutter))*10)
where ee_photo_shutter_unit="s" AND ee_photo_exif_shutter>-1;

You could also use this query inside of a PHP file to run the update via a browser. I didn't have the time to find the place in the upload code to make this change when the photos are uploaded.

The UPDATE excludes any photos where the shutter speed is greater or equal to 1 second. I didn't have any of those in my database, and didn't want to mess them up, so the UPDATE just excludes them.

Paul

[wkitty42]

well, that's one way of doing it... i'd probably go the other way and handle it in the display code instead... if the shutter speed is less than 1 second, then take 1 divided by the amount in the shutter speed field and write it as 1/result... that is, if your 0.004 example is 1/250 ;)

if that is all it is, then it is only one or two lines and no database manipulation on possibly several thousand rows...

[Pekka]

EE 2 does not have any "new shutter speed format". What you might see is the effect of small change in order of reading XMP/EXIF/IPTC data.

I convert in C1 and save in CS2 and shutter speeds are read normally. What kind of files are you working with? Do you use internal or PHP exif in EE?

[kolohe]

I'm using internal EXIF.

The files are straight from the camera jpegs from both a Nikon Coolpix 990 and a Nikon D80.

Thanks.

[Pekka]

I'm using internal EXIF.

The files are straight from the camera jpegs from both a Nikon Coolpix 990 and a Nikon D80.

Thanks.

Can you PM me a location of one such a photo for testing purposes?

[DavidW]

Pekka - if you're going to take a look at the internal EXIF code, it goes wrong over various things including shutter speed with some images that MikeCaine has created - see here (http://photography-on-the.net/forum/showthread.php?t=234207) for details. The IMG 11444.jpg in the folder he mentions in the other thread shows the problem.

I'm fairly busy at the moment and I'm still working towards getting a debuggable PHP setup (I need to sit down when I have some time and sort the DBG FreeBSD port out properly). When I've got that done, I'll be in a better position to chase some of these issues, but if you're going to save me the trouble of fixing this bug, I've certainly got no objection!



David

[MikeCaine]

David, I uploaded some more photos yesterday and all seems fine now with your fix and the change to external EXIF.

One photo did show a shutter speed on 1/61 but I can live with that as it's easy to sort manually, rather than as before when I had to inspect the EXIF locally and play "spot the difference"

[Pekka]

Yes the internal EXIF code is very simple, old and most likely buggy (It was donated to EE use by a user, but there was no futher developement). It is there for those who do not have EXIF installed in PHP. I would be happy if someone did completely new reader or some existing code could be integrated.

BTW: above shutter speed problem can be worked around by making EE prefer XMP data over EXIF, which means change

$shutter = $xmp_shutterspeedvalue;
if ($exif_shutterspeedvalue != "") $shutter = $exif_shutterspeedvalue;

to

$shutter = $exif_shutterspeedvalue;
if ($xmp_shutterspeedvalue != "") $shutter = $xmp_shutterspeedvalue;

in PHOTODATA_photohandler.php, but that does not get around the fact that internal exif reads shutter value wrong.

[Philscbx]

Yes the internal EXIF code is very simple,

BTW: above shutter speed problem can be worked around by making EE prefer XMP data over EXIF, which means change

$shutter = $xmp_shutterspeedvalue;
if ($exif_shutterspeedvalue != "") $shutter = $exif_shutterspeedvalue;
to
$shutter = $exif_shutterspeedvalue;
if ($xmp_shutterspeedvalue != "") $shutter = $xmp_shutterspeedvalue;

in PHOTODATA_photohandler.php, but that does not get around the fact that internal exif reads shutter value wrong.

Wow, I was going through some of my Canon 30D CR2 files, and very disappointed from last tour to Europe. Focus seems to be a huge issue shooting from shore a very cool event of sail boarding, and Kite surfing in Northern Holland in a busy environment of other ships.

I wish I had loaded the images soon after shooting them to see them at 100%.
I would of made sure to spend the next day re-shooting before flying home.
Maybe I can clean them up in DPP which came with the camera.
My old G5 did better I think.

Investigating the info file of images, I see shutter speed 0.004 out to 7 places with 2 on the last place. Ok, lets see if a simple Google search can alter this number to 250 the easy way.

This is pretty cool actually. When I first got this camera, I searched one day and some how found Your image library. From then on seeing Your behind the scenes view of the Orchestra Halls, and members at work has inspired me to no end.
You might see some of my postings in Your guest area about a year ago.
I was out snowmobiling with friends while I was out shooting, and mentioned to them that I wish I could alter this fresh 2 feet of snow in evening light as You do.

So to make the transition a little easier on choosing lenses, I noted the ones You have and use. So far, I recently acquired the 135-f2.0L, and a new 24-70 f2.8L. Now to find the next one around a fast 14mm f1 or similar. I may have to get a 5D as well. A new Mark III is out, we'll see if I upgrade this extreme.

In the mean time I'll try to figure out this shutter speed thing.
I'll be one day very happy to get images anywhere near what i've seen from Your files.
My Sweden tour is over due, maybe in a month or so.

Have a Great Day,
Phil Mpls Mn