Comment 10 for bug 1468585

I (still) think the issue is that the mediastore.db contains the wrong time (off by one hour), because the image's exiv2 data is correct.

Here's "proof".

System info [1]

1) I took a photo at 11:27 on Nov2 2015.

2) Here's the datetime a couple minutes later:
phablet@ubuntu-phablet:~/Pictures/com.ubuntu.camera$ date
Mon Nov 2 11:31:32 EST 2015

3) exiv2 Image timestamp is correct for the device timezene:
$ exiv2 image20151102_112746056.jpg | grep -i timestamp
Image timestamp : 2015:11:02 11:27:47

4) mediastore.db contains image but has time off by on hour:
sqlite> select date from media where filename='/home/phablet/Pictures/com.ubuntu.camera/image20151102_112746056.jpg';
2015-11-02T17:27:47

5) My Photos shows that ^ time, which is off by an hour

5A) scopregistry.log:
"======== media_date: 2015-11-02T17:27:47"
==== MS url: "image://thumbnailer/file:///home/phablet/Pictures/com.ubuntu.camera/image20151102_112746056.jpg"
==== media_date: "2015-11-02T17:27:47"
==== mDataTime_utc: "Mon Nov 2 17:27:47 2015 GMT"
==== mDataTime_local: "Mon Nov 2 12:27:47 2015"
5B) Screenshot of photo preview with off-by-one time.

Note: the code My Photos uses to get date is quite simple here: ihttps://bazaar.launchpad.net/~hanloon-team/hanloon/photos-local/view/head:/src/query.cpp#L139

I think this shows the problem is that the mediastore.db has the wrong timestamp for the photo.

[1] phablet@ubuntu-phablet:~$ system-image-cli -i
current build number: 547
device name: krillin
channel: ubuntu-touch/rc-proposed/bq-aquaris.en-proposed