Description of problem: Updating to sqlite-3.8.1-1.fc20 from sqlite-3.8.0.2-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): sqlite-3.8.1-1.fc20 How reproducible: Every time. 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. Actual results: 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. Additional info: 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 [1] I found that it has been fixed in master. Particularly this commit appears to fix it: commit c098d918e1e19088be9659c409f1a6fa32b0efe6 Author: D. Richard Hipp <drh> 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. [1] http://repo.or.cz/w/sqlite.git
sqlite-3.8.1-2.fc20 has been submitted as an update for Fedora 20. https://admin.fedoraproject.org/updates/sqlite-3.8.1-2.fc20
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).
Package sqlite-3.8.1-2.fc20: * 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: https://admin.fedoraproject.org/updates/FEDORA-2013-22183/sqlite-3.8.1-2.fc20 then log in and leave karma (feedback).
+1 FE - this would be good to get into TC3.
+1 FE
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.