BugsFQL query sorting does not work for users with a lot of photos
- Status: Triaged
- Priority: Medium
- Updated: October 22, 2012 at 10:26am
Latest response from Facebook
Sean Quinlan
Thanks for the report. We will follow up.
Status changed to Triaged · Priority changed to Medium · October 22, 2012 at 10:26am
My app needs to retrieve user photos sorted by the number of likes. I ran this query:
"SELECT object_id, src_big, src_big_width, src_big_height, link, like_info, caption, created FROM photo WHERE owner = USER_ID_HERE ORDER BY like_info DESC LIMIT 3"
This query returns an error when I run it for any user who is my friend and my app user has over 3,000 photos (the list of those users could be provided by additional request).
I ran variants of this query in graph API explorer and it starts working only when i remove "ORDER BY like_info DESC" :
"SELECT object_id, src_big, src_big_width, src_big_height, link, like_info, caption, created FROM photo WHERE owner = USER_ID_HERE LIMIT 3" - this works"
Please help resolve this issue because there is no other way to get all pictures via FB API and this is a core functionality of my app.
"SELECT object_id, src_big, src_big_width, src_big_height, link, like_info, caption, created FROM photo WHERE owner = USER_ID_HERE ORDER BY like_info DESC LIMIT 3"
This query returns an error when I run it for any user who is my friend and my app user has over 3,000 photos (the list of those users could be provided by additional request).
I ran variants of this query in graph API explorer and it starts working only when i remove "ORDER BY like_info DESC" :
"SELECT object_id, src_big, src_big_width, src_big_height, link, like_info, caption, created FROM photo WHERE owner = USER_ID_HERE LIMIT 3" - this works"
Please help resolve this issue because there is no other way to get all pictures via FB API and this is a core functionality of my app.
| Steps to Reproduce: | To Reproduce In Graph Explorer: 1. Find your friend, which has more than 3000 pics, get their id. 2. Run "SELECT object_id, src_big, src_big_width, src_big_height, link, like_info, caption, created FROM photo WHERE owner = USER_ID_HERE ORDER BY like_info DESC LIMIT 3" replacing USER_ID_HERE with that user id. To Reproduce in my app, Vash: 1. Find your friend, which has more than 3000 pics, get their username. 2. Open browser with FireBug or Chrome Dev Tools Console enabled. 3. Login to Vash 4. Go to vash.co/username, where username is that friend. 5. Approx in 30 sec. you will see broken HTML, with an error on server |
|---|---|
| Expected Behavior: | Get 3 photos with the highest number of likes from that user. |
| Actual Behavior: | Graph Explorer freezes. If done in Vash (my app) - returns Error. Logs from Vash server: Uncaught Exception: 1: An unknown error occurred\n thrown in /app/www/sdk/src/base_facebook.php on line 1238 OR 500 (Internal Server Error) all.js:71 when running the query above from JavaScript SDK. |
| API/SDK: | FQL |
| App IDs: |
|
2 people can reproduce this issue by following these steps
Repro