Facebook FQL photo_tag 表未返回所有合适的照片
我正在尝试运行一个查询，返回我朋友照片上发生的所有最新标签。
这是我的查询：
String query = "SELECT subject, created FROM photo_tag WHERE subject IN (SELECT uid2 FROM friend WHERE uid1 = me()) ORDER BY created DESC LIMIT 200";
这应该返回最新执行的 200 个标签。
不幸的是，在查看我的新闻源后，这是我得到的前几个结果 （按 CREATED_TIME 的 SUBJECT 格式化）
522274044 at Sun Sep 25 20:01:03 AEST 2011
522274044 at Sun Sep 25 20:00:26 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
521123280 at Sun Sep 25 16:39:19 AEST 2011
521123280 at Sun Sep 25 16:39:19 AEST 2011
522274044 at Sun Sep 25 15:00:04 AEST 2011
521342837 at Sun Sep 25 12:10:06 AEST 2011
521123280 at Sun Sep 25 11:20:45 AEST 2011
521123280 at Sun Sep 25 11:20:14 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
如您所见，晚上 8 点和下午 4:39 之间存在巨大差距，通过检查我的新闻源，这些时间之间有大量照片应该在此处列出。我的 FQL 查询正确吗？还是 Facebook 服务器不处理这些类型的查询.. 另外，稍后列出：
512328700 at Sun Jul 24 00:30:02 AEST 2011
523619736 at Sat Jul 23 17:36:37 AEST 2011
521342837 at Tue Jul 19 12:23:32 AEST 2011
519156948 at Fri Jul 15 15:08:11 AEST 2011
更大规模的不一致.. 对此有什么解释吗？感谢您的帮助！
更新：在所有 200 个结果中，我只检索到大约 10 个唯一的主题名称 UPDATE2：我尝试查询不在上面 10 个唯一名称列表中的一堆名称，结果是它们被标记的照片，得出的结论是，由于任何 ' ，它们的名称没有从上面的较大查询中显示出来隐私设置什么的。那么也许这是服务器端的事情？
I'm trying to run a query that returns all the latest tags that happened on my friends photos.
Here is my query:
String query = "SELECT subject, created FROM photo_tag WHERE subject IN (SELECT uid2 FROM friend WHERE uid1 = me()) ORDER BY created DESC LIMIT 200";
This is supposed to return the latest 200 tags performed.
Unfortunately, after looking at my news feed, here are the first few results I get
(formatted by SUBJECT at CREATED_TIME)
522274044 at Sun Sep 25 20:01:03 AEST 2011
522274044 at Sun Sep 25 20:00:26 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
522274044 at Sun Sep 25 20:00:00 AEST 2011
521123280 at Sun Sep 25 16:39:19 AEST 2011
521123280 at Sun Sep 25 16:39:19 AEST 2011
522274044 at Sun Sep 25 15:00:04 AEST 2011
521342837 at Sun Sep 25 12:10:06 AEST 2011
521123280 at Sun Sep 25 11:20:45 AEST 2011
521123280 at Sun Sep 25 11:20:14 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
521123280 at Sun Sep 25 11:16:51 AEST 2011
As you can see, there is a massive gap between 8PM and 4:39PM, and by checking my news feed, there are a WHOLE LOT of photos between these times that should be listed here. Is my FQL query correct? or does the facebook servers just not handle these kinds of queries.. Also, later down the list:
512328700 at Sun Jul 24 00:30:02 AEST 2011
523619736 at Sat Jul 23 17:36:37 AEST 2011
521342837 at Tue Jul 19 12:23:32 AEST 2011
519156948 at Fri Jul 15 15:08:11 AEST 2011
More massive inconsistencies.. Is there any explanation for this?? Thanks for your help!
UPDATE: Of all 200 results, I'm only retrieving about 10 unique subject names
UPDATE2: I tried querying a bunch of names that weren't in that list of 10 unique names above, and they resulted in the photos they were tagged in, concluding that their names aren't showing from the larger query above because of any 'privacy' settings or anything. So maybe it's a server side thing?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您还需要确保您拥有 user_photos 和 Friends_photos 权限。此外，朋友可以选择退出 Facebook 平台，这样他们的照片等就无法通过 Facebook API 提供给应用程序：
You will also want to make sure you have both user_photos and friends_photos permissions. Also, friends can opt out of the Facebook platform so that their photos, etc are not available to applications via the Facebook API:
请求被拒绝：源地址正在发送过多的请求。希望你没有收到这个标签（照片）....我同意 facebook API：
0down vote
您还需要确保您拥有 user_photos 和friends_photos 权限。此外，朋友可以选择退出 Facebook 平台，这样他们的照片等就无法通过 Facebook API 提供给应用程序：
Request denied: source address is sending an excessive volume of requests. hope your not recieving this while tag(photos)....i agree with facebook API:
0down vote
You will also want to make sure you have both user_photos and friends_photos permissions. Also, friends can opt out of the Facebook platform so that their photos, etc are not available to applications via the Facebook API: