Facebook FQL photo_tag表不返回所有适当的照片 [英] Facebook FQL photo_tag table not returning all appropriate photos

问题描述

这是我的查询：

  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在太阳9月25日11:20:14 AEST 2011 
 521123280在太阳9月25日11:16:51 AEST 2011 
 521123280在太阳9月25日11:16:51 AEST 2011 
 521123280在苏9月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 
  

如您所见，8PM和下午4点39分，通过查看我的新闻资讯，这些时间之间的照片总共应该列在这里。我的FQL查询是否正确？或者Facebook服务器只是不处理这些类型的查询。另外，在下面的列表中：

  512328700在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个唯一名称的列表中，他们导致了他们被标记的照片，结论是他们的名字没有显示从上面的较大的查询，因为任何隐私设置或任何东西。所以也许这是一个服务器端的事情？

解决方案

你还要确保你同时拥有user_photos和friends_photos权限。此外，朋友可以选择退出Facebook平台，以便他们的照片等通过Facebook API无法提供给应用程序：

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?

解决方案

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 FQL photo_tag表不返回所有适当的照片的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！