2014-03-24 10:18:43 |
Alan Pope 🍺🐧🐱 🦄 |
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 this http://paste.ubuntu.com/7145536/
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.
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) |
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) |
|