Description of problem:
Updating to sqlite-3.8.1-1.fc20 from sqlite-188.8.131.52-4.fc20 causes the collection/album functionality in gnome-documents and gnome-photos to break. See: https://bugzilla.gnome.org/show_bug.cgi?id=711510
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Install gnome-photos.
2. Create an album from your local photos, or if you have sets in your Flickr account you can add your Flickr account via Online Accounts in Settings.
3. Once you have an album, double-click it to see what is inside.
The album will show up and its thumbnail will be a collage of the photos inside it, but when you click the album nothing will show up inside it.
Both gnome-documents and gnome-photos speak SPARQL with tracker, which in turn translates them and speaks SQL with sqlite.
After some back and forth on the sqlite Git mirror  I found that it has been fixed in master. Particularly this commit appears to fix it:
Author: D. Richard Hipp <firstname.lastname@example.org>
Date: Mon Oct 28 20:15:56 2013 +0000
Do not use transitive WHERE-clause constraints on LEFT JOINs.
Fix for ticket [c620261b5b5dc].
I am going to build a Fedora package with this commit cherry-picked and if it does not break anything we can hopefully push it to stable.
sqlite-3.8.1-2.fc20 has been submitted as an update for Fedora 20.
Proposing as a final FE as this breaks behaviour in apps people may want to run from the live images.
Proposed as a Blocker for 20-final by Fedora user rishi using the blocker tracking app because:
Proposing as a blocker because it adversely affects the functionality (ie. collections) of a default application (ie. gnome-documents).
* should fix your issue,
* was pushed to the Fedora 20 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing sqlite-3.8.1-2.fc20'
as soon as you are able to.
Please go to the following url:
then log in and leave karma (feedback).
+1 FE - this would be good to get into TC3.
Setting AcceptedFreezeException with four votes, thanks.
Discussed at 2013-11-27 blocker review meeting: http://meetbot.fedoraproject.org/fedora-blocker-review/2013-11-27/f20-blocker-review-3.2013-11-27-17.01.log.txt . Accepted as a blocker per criterion "All applications that can be launched using the standard graphical mechanism of a release-blocking desktop after a default installation of that desktop must start successfully and withstand a basic functionality test." - https://fedoraproject.org/wiki/Fedora_20_Final_Release_Criteria#Default_application_functionality ; the functions of Documents and Photos in question are pretty basic.
Tested, with the updated sqlite and a restart of goa-daemon (it doesn't seem to autorespawn; after killing it, I had to manually launch it again...), Photos works great.
sqlite-3.8.1-2.fc20 has been pushed to the Fedora 20 stable repository. If problems still persist, please make note of it in this bug report.