photos downloaded from browser lack timestamp in db

[Kyle Nitzsche]

Use browser to download a picture to Gallery.

Look in mediascanner db and the picture is present but has no timestamp.

Expectation: picture has timestamp in mediascanner db.

phablet@ubuntu-phablet:~$ system-image-cli -i
current build number: 90
device name: krillin
channel: ubuntu-touch/ubuntu-rtm/14.09-proposed
last update: 2014-10-08 14:06:05
version version: 90
version ubuntu: 20141008.1
version device: 20141002-d5938d7
version custom: 1412639048

[Kyle Nitzsche (knitzsche)]

Example, I dowloaded a png named BrookfieldVtCow.png from browser.

Here are the db results after that, with one picture from camera and my new png with no timestamp (or mime type and more)

phablet@ubuntu-phablet:~$ sqlite3 .cache/mediascanner-2.0/mediastore.db 'select * from media'
/home/phablet/Pictures/com.ubuntu.camera/image20141008_141021813.jpg|image/jpeg|1412777423:229343|image20141008 141021813|2014-10-08T16:10:23|||||0|0|0|2448|4352|0.0|0.0|0|3
/home/phablet/Pictures/BrookfieldVtCow.png|||BrookfieldVtCow||||||0|0|0|0|0|0.0|0.0|0|3

This timestamp is needed by, for example, My Photos scope, which sorts photos into time categories.

[James Henstridge (jamesh)]

Following on from the comments in the merge proposal, what exactly are you expecting from this piece of metadata?

In every other case, we fill it in with information from embedded metadata that indicates when a photo was taken, or when a song was recorded, etc. If that information isn't present in the metadata, we leave it blank. If you download an image off the web that doesn't contain any embedded metadata, we don't know when it was taken. The file modification time (as used in the attached MP) is basically meaningless, so wouldn't it make more sense to sort cases like this as "unknown"?

[Kyle Nitzsche (knitzsche)]

I am asking Joe Odukoya for prroduct/design guidance on this question.

[Kyle Nitzsche (knitzsche)]

I would guess in such cases it makes sense to sue the current date.

[Kyle Nitzsche (knitzsche)]

Also, I think this bug needs to be marked High or Critical since until it is dealt with downloaded photos don't display in My Photos.

[Joe Odukoya (jodukoya)]

I believe that the best option for photos that don't have the required metadata is for them to appear in the users timeline sensibly.

Specifically if the user downloads a photo today that does not have the required metadata then it should be timestamped today (and thus appear in the users photo roll etc. today).

[Kyle Nitzsche (knitzsche)]

A photo without a timestamp causes My Photos scope to crash, since it sorts photos into date ranges. (I will fix this so it won't crash as a short term solution). Long term: MS should add a timestamp when there is none.

[Launchpad Janitor (janitor)]

This bug was fixed in the package mediascanner2 - 0.105+15.04.20150121-0ubuntu1

---------------
mediascanner2 (0.105+15.04.20150121-0ubuntu1) vivid; urgency=low

  [ Jussi Pakkanen ]
  * Extract metadata from images that don't have exif entries. (LP:
    #1378880)
  * Make Valgrind uninitialised jump warning go away.
 -- Ubuntu daily release <email address hidden> Wed, 21 Jan 2015 15:21:18 +0000

[Yuan-Chen Cheng (ycheng-twn)]

@ethan, can you please verify this is fix when convenient ?