"mutual_friend_count" FQL query returns "NULL" but Graph API returns mutual friends- Facebook Developers

Created By

Wolfram Arnold

03/13/2012 10:38pm

Subscribers (8)

Bugs"mutual_friend_count" FQL query returns "NULL" but Graph API returns mutual friends

Status: Fixed
Priority: Medium
Updated: August 29, 2012 at 2:39pm

Toggle 2 older responses

Latest response from Facebook

Jeff Bowen

This issue was resolved in May. Thanks for the report.

Status changed to Fixed

Eric Osgood

Sorry for the erroneous status update, it was intended for bugs in a stale state. Please disregard the previous message.

Simon Cross

Thanks for the report. We are looking into this.

Status changed to Assigned · Priority changed to Medium

I see an inconsistency in results between an FQL query of the "mutual_friend_count" column of the "user" table and Graph API results for "mutualfriends". The former reports null, but the latter reports a non-zero number of records. Because the two API's behave inconsistently, I don't believe this is a permissions issue. I only observe this with a single user ID (an early member of FB).

Steps to Reproduce:

1. Given an access token with these permissions: user_about_me, user_activities, user_birthday, user_checkins, user_education_history, user_events, user_groups, user_hometown, user_interests, user_likes, user_location, user_notes, user_photos, user_questions, user_relationships, user_relationship_details, user_religion_politics, user_status, user_videos, user_website, user_work_history, email, read_stream

2. I run an FQL query like so: SELECT mutual_friend_count FROM user WHERE uid=NNNN
(see "Related ID's for the actual user ID NNNN that shows this behavior). The result is: [{"mutual_friend_count": null}]

3. Then I run a Graph API query for mutual friends: https://graph.facebook.com/me/mutualfriends/NNNN which does return a bunch of records like (redacted): {
"data": [
{
"name": "Joe Smith",
"id": "MMMMM"
},
{
"name": "Joe Smith2",
"id": "PPPPPP"
},
]

Is this a platform bug, and issue with this particular user or something else?

Expected Behavior:

I would expect the FQL query to return a non-null value for "mutual_friend_count", e.g. 2 in this example. This does happen for all of the friends, except this particular user record (see Related ID's), for which there is the inconsistency.

Actual Behavior:

I get a "mutual_friend_count" of null.

API/SDK:

FQL

5 people can reproduce this issue by following these steps

Repro