我有查询
{
"users" : "SELECT uid, name, pic_big FROM user WHERE uid in (SELECT source_id FROM #stream)",
"stream" : "SELECT post_id, description, type, message, created_time, updated_time, source_id, attachment from stream where filter_key in ('others') and type in (46, 56, 66, 80, 128, 247, 308) and (message or description) ORDER BY created_time desc LIMIT 15",
"photos" :"select images, pid from photo where pid in (SELECT attachment.media.photo.pid FROM #stream)"
}
当我尝试从Graph Explorer中使用Access_Token时,一切都很好。但是,如果我将应用程序的访问令牌用于用户a get en错误
{
"error": {
"message": "An unknown error has occurred.",
"type": "OAuthException",
"code": 1
}
}
我发现,如果更改最后查询并用真实的PID替换此代码都可以。 SELECT attachment.media.photo.pid FROM #stream
任何人可以帮忙吗?
随机管理,这是我想要的。
在这里工作代码:
{
"users" : "SELECT uid, name, pic_big FROM user WHERE uid in (SELECT source_id FROM #stream)",
"stream" : "SELECT post_id, description, type, message, created_time, updated_time, source_id, attachment from stream where filter_key in ('others') and type in (46, 56, 66, 80, 128, 247, 308) and (message or description) ORDER BY created_time desc LIMIT 15",
"photos" :"select images, pid from photo where pid in (SELECT attachment FROM #stream)"
}
您可以看到我将 SELECT attachment.media.photo.pid FROM #stream
更改为 SELECT attachment FROM #stream
我现在根本看不到fql中的逻辑:(