搜索好友链接时，Facebook FQL未知错误 - Facebook FQL Unknown Error when searching for friends links

我正在运行一个FQL查询，我保持这个错误，但不能弄清楚为什么，因为错误消息告诉我什么。查询和错误如下:

SELECT backdated_time, can_backdate, caption, created_time, owner, owner_comment, picture, summary, title, url FROM link WHERE owner IN (SELECT uid2 FROM friend WHERE uid1 = me()) AND (strpos(lower(summary),"boston") >=0 OR strpos(lower(owner_comment),"boston") >=0 ) LIMIT 20
Fatal error: Uncaught Exception: 1: An unknown error occurred
  thrown in /Facebook/base_facebook.php on line 1254

有人知道为什么会出现这个错误吗?我使用的是Facebook PHP库

卡住了，查询太大了。考虑使用多查询、好友查询的限制和一些偏移来遍历数据。

fql?q={"friendsquery":"SELECT uid2 FROM friend WHERE uid1 = me() LIMIT 20 OFFSET 0","linkquery": "SELECT backdated_time, can_backdate, caption, created_time, owner, owner_comment, picture, summary, title, url FROM link WHERE owner IN (SELECT uid2 FROM #friendsquery) AND (strpos(lower(summary),'boston') >=0 OR strpos(lower(owner_comment),'boston') >=0 ) LIMIT 20"}

对于一个400人的好友列表，当前查询耗时80秒。

这里有一个Python的例子，它不是PHP但API的实现是一样的

from facepy import GraphAPI
import time
import urllib
import json
fb_dump = open('dumpfb.txt', 'w')
graph = GraphAPI('MY_ACCESS_TOKEN')
all_posts = []
offset = 0
friendsquery = 'SELECT uid2 FROM friend WHERE uid1 = me() LIMIT 20 OFFSET '+ str(offset)
linksquery = 'SELECT backdated_time, can_backdate, caption, created_time, owner, owner_comment, picture, summary, title, url FROM link WHERE owner IN (SELECT uid2 FROM #friendsquery) AND (strpos(lower(summary),"trinidad") >=0 OR strpos(lower(owner_comment),"trinidad") >=2 ) LIMIT 20'

t0 = time.time()
try:
     my_posts = graph.fql({'friendsquery': friendsquery, 'linksquery': linksquery})
     while my_posts["data"][0]["fql_result_set"]:
         all_posts = all_posts + my_posts["data"]
         offset = offset + 20
   friendsquery = 'SELECT uid2 FROM friend WHERE uid1 = me() LIMIT 20 OFFSET '+ str(offset)
     my_posts = graph.fql({'friendsquery': friendsquery, 'linksquery': linksquery})
     t1 = time.time()
     print t1-t0
     fb_dump.write(json.dumps(all_posts, indent=4))
except GraphAPI.OAuthError, e:
     print e.message

批量查询可以将查询时间缩短到25秒。不是很快，但比前两个查询快一个数量级。我没有在PHP中做过，但你应该了解要点

这是20多个查询在一个批次和一个/me/friend调用

fb_dump = open('lumpfb.txt', 'w')
graph = GraphAPI('MY_ACCESS_TOKEN')

all_posts = []
offset = 0
friendsquery = 'SELECT uid2 FROM friend WHERE uid1 = me() LIMIT 20 OFFSET '
linksquery = 'SELECT backdated_time, can_backdate, caption, created_time, owner, owner_comment, picture, summary, title, url FROM link WHERE owner IN (SELECT uid2 FROM #friendsquery) AND (strpos(lower(summary),''trinidad'') >=0 OR strpos(lower(owner_comment),''trinidad'') >=2 ) LIMIT 20'

t0 = time.time()
batch_request = []
try:
     my_friends = graph.get("me?fields=friends")
     counter = len(my_friends["friends"]["data"])
     while counter > 0 :
     friendsquery0 = 'SELECT uid2 FROM friend WHERE uid1 = me() LIMIT 20 OFFSET '+ str(offset)
     the_query = '{"friendsquery":"'+friendsquery0+'","linksquery":"'+linksquery+'"}'
     batch_item = {"method":"GET","relative_url":"fql?q=" + the_query}
     batch_request.append(batch_item)
     offset = offset + 20
     counter = counter - 20
     my_posts = graph.batch(batch_request)
     for post in my_posts:
     all_posts = all_posts + post['data']
     t1 = time.time()
     print t1-t0
except facepy.exceptions.FacepyError, e:
     print e.message