openphoto/frontend — Issue #292: Certain (scanned) photos are not properly uploaded
Author: jmathai
Created: 2011-10-31 05:37:48+00:00
State: open
Labels: Release 1.4

From email:

> As requested via Facebook, here are the problem photos that I was
> unable to upload to http://ajft.openphoto.me/

> The 25 photos were originally taken on an APS film camera in 1998,
> then scanned to CD by commercial vendor in 2006. I then manually
> geotagged them and set the date with Geosetter (Windows) sometime in
> 2007 after getting them back from the scanning agency (hence the EXIF
> dates indicating that some of them are the scanned or editted time in
> 2007).

> Table here is the original photo file name, Y/N as to whether it
> uploaded correctly, the index on openphoto, last column is either the
> URL of the successful photo upload or the filename in the S3 store of
> the uploaded file. Attempting to access any of the "missing" index
> items, eg http://ajft.openphoto.me/photo/7/view, gets me the openphoto
> error "Sorry, but the page you're looking for doesn't exist."

> 299-421_03 Y 1 http://ajft.openphoto.me/photo/1/view
> 299-421_07 Y 2 http://ajft.openphoto.me/photo/2/view
> 299-421_08 Y 3 http://ajft.openphoto.me/photo/3/view
> 299-421_04 Y 4 http://ajft.openphoto.me/photo/4/view
> 299-421_09 Y 5 http://ajft.openphoto.me/photo/5/view
> 299-421_01 Y 6 http://ajft.openphoto.me/photo/6/view
> 299-421_10 N 7 1319450905-299-421_10.JPG
> 299-421_11 Y 8 http://ajft.openphoto.me/photo/8/view
> 299-421_12 Y 9 http://ajft.openphoto.me/photo/9/view
> 299-421_13 Y a http://ajft.openphoto.me/photo/a/view
> 299-421_15 Y b http://ajft.openphoto.me/photo/b/view/
> 299-421_14 Y c http://ajft.openphoto.me/photo/c/view
> 299-421_19 N d 1319451106-299-421_19.JPG
> 299-421_17 Y e http://ajft.openphoto.me/photo/e/view
> 299-421_20 N f 1319451118-299-421_20.JPG
> 299-421_19 N g 1319451649-299-421_19.JPG
> 299-421_20 N h 1319451668-299-421_20.JPG
> 299-421_21 N i 1319451668-299-421_20.JPG
> 299-421_23 Y j http://ajft.openphoto.me/photo/j/view
> 299-421_25 N k 1319451736-299-421_25.JPG
> 299-421_24 Y l http://ajft.openphoto.me/photo/l/view/
> 299-421_19 N m 1319452342-299-421_19.JPG

> Prior to upload, 299-421_10.JPG was:

> ajft@fafnir:~/media/photos/APS/299-421$ sha1sum 299-421_10.JPG
> e08779ef07fb8999563fecf160b4b229094c5372 299-421_10.JPG

> The "failed to upload" versions when downloaded back from S3 are:

> ajft@fafnir:~/Downloads$ sha1sum *_10.JPG
> 92bc4296cd7b9a17d3e1b9a96726e931cf7987f5 1319450905-299-421_10.JPG
> 92bc4296cd7b9a17d3e1b9a96726e931cf7987f5 1319622497-299-421_10.JPG

> One copy is attached.

> I can send you copies of 299-421_19.JPG and 299-421_20.JPG if you require them.

> Cleanup
> ======

> Would it be possible to develop a script that could read the contents
> of your S3 store and your openphoto database and present you with a
> list of files that can be deleted?

> Dates
> ====

> I'm also a bit confused about the date that openphoto decides a given
> photo was taken on. My 299-421_24,
> http://ajft.openphoto.me/photo/l/view/, was taken 1998-09-27 and has
> EXIF data saying so, yet openphoto has picked the "ModifyDate" or
> possibly "FileModifyDate" as (immutable) date to display

> ajft@fafnir:~/media/photos/APS/299-421$ /usr/bin/exiftool -s
> 299-421_24.JPG | grep -i date
> FileModifyDate : 2007:05:10 15:15:25+10:00
> ModifyDate : 2007:05:10 15:15:25
> DateTimeOriginal : 1998:09:27 15:47:10
> CreateDate : 2006:01:20 11:38:10

> ajft@fafnir:~/Downloads$ /usr/bin/exiftool -s
> 1319451741-299-421_24.JPG | grep -i date
> FileModifyDate : 2011:10:26 20:54:06+11:00
> ModifyDate : 2007:05:10 15:15:25
> DateTimeOriginal : 1998:09:27 15:47:10
> CreateDate : 2006:01:20 11:38:10

> thanks for your help,

> Adrian

Photos are not attached to this issue but you can request a copy of them to debug this by emailing jaisen@openphoto.me.