ubuntu-apps-bugs team mailing list archive

Thread
Date
[Bug 1296634] [NEW] gallery shows blank dates and photos

To: ubuntu-apps-bugs@xxxxxxxxxxxxxxxxxxx
From: Alan Pope ㋛ <alan@xxxxxxxxxx>
Date: Mon, 24 Mar 2014 10:15:56 -0000
Reply-to: Bug 1296634 <1296634@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Opened my gallery app on a device containing no photos and I see a bunch of seemingly random dates in the Event view.
I also see blank photos in the photos view.
I looked at what I believe to be the gallery database and found what you see below
Those are videos that exist on my device for testing.
Possibly the blanks in gallery relate to the videos which are (for some reason) now listed in my gallery database.

Screenshots attached.

To examine your gallery database:-

adb shell
sudo -u phablet -i
sqlite3 ~/.local/share/com.ubuntu.gallery/gallery-app/database/gallery.sqlite
.dump MediaTable

I see:-

sqlite> .dump MediaTable
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE MediaTable (
  id INTEGER PRIMARY KEY,
  filename TEXT NOT NULL
, width INT, height INT, timestamp INT DEFAULT NULL, exposure_time INT DEFAULT NULL, original_orientation INT DEFAULT NULL, filesize INT DEFAULT NULL);
INSERT INTO "MediaTable" VALUES(1,'/home/phablet/Videos/Songify This - CAN''T HUG EVERY CAT (now on iTunes) -- a song about loving cats-sP4NMoJcFd4.mp4',NULL,NULL,1395353693000,1365995476000,1,10020327);
INSERT INTO "MediaTable" VALUES(2,'/home/phablet/Videos/Robs_drive.mp4',NULL,NULL,1395353692000,1357480306000,1,21475782);
INSERT INTO "MediaTable" VALUES(3,'/home/phablet/Videos/No Man''s Sky-RRpDn5qPp3s.mp4',NULL,NULL,1395353689000,1386168456000,1,39446926);
INSERT INTO "MediaTable" VALUES(4,'/home/phablet/Videos/National Aerobic Championship USA 1989 01.flv-IG4475cv6RQ.mp4',NULL,NULL,1395353684000,1277719966000,1,48214885);
INSERT INTO "MediaTable" VALUES(5,'/home/phablet/Videos/Madeon - Pop Culture (live mashup).mp4',NULL,NULL,1395353678000,1365661642000,1,36529804);
INSERT INTO "MediaTable" VALUES(6,'/home/phablet/Videos/Moog Cookbook - Buddy Holy-SHPkgIPDfcE.mp4',NULL,NULL,1395353678000,1240496399000,1,4906466);
INSERT INTO "MediaTable" VALUES(7,'/home/phablet/Videos/Madeon - Pop Culture (Dance Video).mp4',NULL,NULL,1395353673000,1372852931000,1,82808679);
INSERT INTO "MediaTable" VALUES(8,'/home/phablet/Videos/eHarmony Video Bio-mTTwcCVajAc.mp4',NULL,NULL,1395353663000,1307076871000,1,10994757);
INSERT INTO "MediaTable" VALUES(9,'/home/phablet/Videos/Blaenavon - Into The Night .mp4',NULL,NULL,1395353662000,1362661906000,1,108637811);
INSERT INTO "MediaTable" VALUES(10,'/home/phablet/Videos/Battle at Kruger-LU8DDYz68kM.mp4',NULL,NULL,1395353651000,1370579088000,1,23162323);
INSERT INTO "MediaTable" VALUES(11,'/home/phablet/Videos/Arctic Monkeys - Do I Wanna Know (Official Video)-bpOSxM0rNPM.mp4',NULL,NULL,1395353648000,1386038525000,1,42123927);
INSERT INTO "MediaTable" VALUES(12,'/home/phablet/Videos/1988 Crystal Light National Aerobic Championship Opening-ozoTzkCeO-A.mp4',NULL,NULL,1395353641000,1377152396000,1,38684049);
CREATE INDEX MediaTableFilenameIndex ON MediaTable(filename);
COMMIT;


Which matches:-

phablet@ubuntu-phablet:~$ ls -l ~/Videos
total 456084
-rw-rw-r-- 1 phablet phablet  38684049 Mar 20 22:14 1988 Crystal Light National Aerobic Championship Opening-ozoTzkCeO-A.mp4
-rw-rw-r-- 1 phablet phablet  42123927 Mar 20 22:14 Arctic Monkeys - Do I Wanna Know (Official Video)-bpOSxM0rNPM.mp4
-rw-rw-r-- 1 phablet phablet  23162323 Mar 20 22:14 Battle at Kruger-LU8DDYz68kM.mp4
-rw-rw-r-- 1 phablet phablet 108637811 Mar 20 22:14 Blaenavon - Into The Night .mp4
-rw-rw-r-- 1 phablet phablet  82808679 Mar 20 22:14 Madeon - Pop Culture (Dance Video).mp4
-rw-rw-r-- 1 phablet phablet  36529804 Mar 20 22:14 Madeon - Pop Culture (live mashup).mp4
-rw-rw-r-- 1 phablet phablet   4906466 Mar 20 22:14 Moog Cookbook - Buddy Holy-SHPkgIPDfcE.mp4
-rw-rw-r-- 1 phablet phablet  48214885 Mar 20 22:14 National Aerobic Championship USA 1989 01.flv-IG4475cv6RQ.mp4
-rw-rw-r-- 1 phablet phablet  39446926 Mar 20 22:14 No Man's Sky-RRpDn5qPp3s.mp4
-rw-rw-r-- 1 phablet phablet  21475782 Mar 20 22:14 Robs_drive.mp4
-rw-rw-r-- 1 phablet phablet  10020327 Mar 20 22:14 Songify This - CAN'T HUG EVERY CAT (now on iTunes) -- a song about loving cats-sP4NMoJcFd4.mp4
-rw-rw-r-- 1 phablet phablet  10994757 Mar 20 22:14 eHarmony Video Bio-mTTwcCVajAc.mp4


ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: gallery-app (not installed)
Uname: Linux 3.4.0-5-mako armv7l
ApportVersion: 2.13.3-0ubuntu1
Architecture: armhf
Date: Mon Mar 24 10:09:23 2014
InstallationDate: Installed on 2014-03-24 (0 days ago)
InstallationMedia: Ubuntu Trusty Tahr (development branch) - armhf (20140324)
ProcEnviron:
 TERM=linux
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 SHELL=/bin/bash
SourcePackage: gallery-app
UpgradeStatus: No upgrade log present (probably fresh install)

** Affects: gallery-app (Ubuntu)
     Importance: Undecided
         Status: Confirmed


** Tags: apport-bug armhf trusty

** Attachment added: "device-2014-03-24-101226.png"
   https://bugs.launchpad.net/bugs/1296634/+attachment/4040571/+files/device-2014-03-24-101226.png

-- 
You received this bug notification because you are a member of Ubuntu
Apps bug tracking, which is subscribed to gallery-app in Ubuntu.
https://bugs.launchpad.net/bugs/1296634

Title:
  gallery shows blank dates and photos

Status in “gallery-app” package in Ubuntu:
  Confirmed

Bug description:
  Opened my gallery app on a device containing no photos and I see a bunch of seemingly random dates in the Event view.
  I also see blank photos in the photos view.
  I looked at what I believe to be the gallery database and found what you see below
  Those are videos that exist on my device for testing.
  Possibly the blanks in gallery relate to the videos which are (for some reason) now listed in my gallery database.

  Screenshots attached.

  To examine your gallery database:-

  adb shell
  sudo -u phablet -i
  sqlite3 ~/.local/share/com.ubuntu.gallery/gallery-app/database/gallery.sqlite
  .dump MediaTable

  I see:-

  sqlite> .dump MediaTable
  PRAGMA foreign_keys=OFF;
  BEGIN TRANSACTION;
  CREATE TABLE MediaTable (
    id INTEGER PRIMARY KEY,
    filename TEXT NOT NULL
  , width INT, height INT, timestamp INT DEFAULT NULL, exposure_time INT DEFAULT NULL, original_orientation INT DEFAULT NULL, filesize INT DEFAULT NULL);
  INSERT INTO "MediaTable" VALUES(1,'/home/phablet/Videos/Songify This - CAN''T HUG EVERY CAT (now on iTunes) -- a song about loving cats-sP4NMoJcFd4.mp4',NULL,NULL,1395353693000,1365995476000,1,10020327);
  INSERT INTO "MediaTable" VALUES(2,'/home/phablet/Videos/Robs_drive.mp4',NULL,NULL,1395353692000,1357480306000,1,21475782);
  INSERT INTO "MediaTable" VALUES(3,'/home/phablet/Videos/No Man''s Sky-RRpDn5qPp3s.mp4',NULL,NULL,1395353689000,1386168456000,1,39446926);
  INSERT INTO "MediaTable" VALUES(4,'/home/phablet/Videos/National Aerobic Championship USA 1989 01.flv-IG4475cv6RQ.mp4',NULL,NULL,1395353684000,1277719966000,1,48214885);
  INSERT INTO "MediaTable" VALUES(5,'/home/phablet/Videos/Madeon - Pop Culture (live mashup).mp4',NULL,NULL,1395353678000,1365661642000,1,36529804);
  INSERT INTO "MediaTable" VALUES(6,'/home/phablet/Videos/Moog Cookbook - Buddy Holy-SHPkgIPDfcE.mp4',NULL,NULL,1395353678000,1240496399000,1,4906466);
  INSERT INTO "MediaTable" VALUES(7,'/home/phablet/Videos/Madeon - Pop Culture (Dance Video).mp4',NULL,NULL,1395353673000,1372852931000,1,82808679);
  INSERT INTO "MediaTable" VALUES(8,'/home/phablet/Videos/eHarmony Video Bio-mTTwcCVajAc.mp4',NULL,NULL,1395353663000,1307076871000,1,10994757);
  INSERT INTO "MediaTable" VALUES(9,'/home/phablet/Videos/Blaenavon - Into The Night .mp4',NULL,NULL,1395353662000,1362661906000,1,108637811);
  INSERT INTO "MediaTable" VALUES(10,'/home/phablet/Videos/Battle at Kruger-LU8DDYz68kM.mp4',NULL,NULL,1395353651000,1370579088000,1,23162323);
  INSERT INTO "MediaTable" VALUES(11,'/home/phablet/Videos/Arctic Monkeys - Do I Wanna Know (Official Video)-bpOSxM0rNPM.mp4',NULL,NULL,1395353648000,1386038525000,1,42123927);
  INSERT INTO "MediaTable" VALUES(12,'/home/phablet/Videos/1988 Crystal Light National Aerobic Championship Opening-ozoTzkCeO-A.mp4',NULL,NULL,1395353641000,1377152396000,1,38684049);
  CREATE INDEX MediaTableFilenameIndex ON MediaTable(filename);
  COMMIT;

  
  Which matches:-

  phablet@ubuntu-phablet:~$ ls -l ~/Videos
  total 456084
  -rw-rw-r-- 1 phablet phablet  38684049 Mar 20 22:14 1988 Crystal Light National Aerobic Championship Opening-ozoTzkCeO-A.mp4
  -rw-rw-r-- 1 phablet phablet  42123927 Mar 20 22:14 Arctic Monkeys - Do I Wanna Know (Official Video)-bpOSxM0rNPM.mp4
  -rw-rw-r-- 1 phablet phablet  23162323 Mar 20 22:14 Battle at Kruger-LU8DDYz68kM.mp4
  -rw-rw-r-- 1 phablet phablet 108637811 Mar 20 22:14 Blaenavon - Into The Night .mp4
  -rw-rw-r-- 1 phablet phablet  82808679 Mar 20 22:14 Madeon - Pop Culture (Dance Video).mp4
  -rw-rw-r-- 1 phablet phablet  36529804 Mar 20 22:14 Madeon - Pop Culture (live mashup).mp4
  -rw-rw-r-- 1 phablet phablet   4906466 Mar 20 22:14 Moog Cookbook - Buddy Holy-SHPkgIPDfcE.mp4
  -rw-rw-r-- 1 phablet phablet  48214885 Mar 20 22:14 National Aerobic Championship USA 1989 01.flv-IG4475cv6RQ.mp4
  -rw-rw-r-- 1 phablet phablet  39446926 Mar 20 22:14 No Man's Sky-RRpDn5qPp3s.mp4
  -rw-rw-r-- 1 phablet phablet  21475782 Mar 20 22:14 Robs_drive.mp4
  -rw-rw-r-- 1 phablet phablet  10020327 Mar 20 22:14 Songify This - CAN'T HUG EVERY CAT (now on iTunes) -- a song about loving cats-sP4NMoJcFd4.mp4
  -rw-rw-r-- 1 phablet phablet  10994757 Mar 20 22:14 eHarmony Video Bio-mTTwcCVajAc.mp4



  ProblemType: Bug
  DistroRelease: Ubuntu 14.04
  Package: gallery-app (not installed)
  Uname: Linux 3.4.0-5-mako armv7l
  ApportVersion: 2.13.3-0ubuntu1
  Architecture: armhf
  Date: Mon Mar 24 10:09:23 2014
  InstallationDate: Installed on 2014-03-24 (0 days ago)
  InstallationMedia: Ubuntu Trusty Tahr (development branch) - armhf (20140324)
  ProcEnviron:
   TERM=linux
   PATH=(custom, no user)
   XDG_RUNTIME_DIR=<set>
   SHELL=/bin/bash
  SourcePackage: gallery-app
  UpgradeStatus: No upgrade log present (probably fresh install)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/gallery-app/+bug/1296634/+subscriptions
Follow ups

[Bug 1296634] Re: gallery displaying blanks for videos
From: Launchpad Bug Tracker, 2014-03-28
[Bug 1296634] Re: gallery displaying blanks for videos
From: Bill Filler, 2014-03-27
[Bug 1296634] Re: gallery displaying blanks for videos
From: Launchpad Bug Tracker, 2014-03-26
[Bug 1296634] [NEW] gallery shows blank dates and photos
From: Alan Pope ㋛, 2014-03-24
References

[Bug 1296634] [NEW] gallery shows blank dates and photos
From: Alan Pope ㋛, 2014-03-24