Oauth 604 Graph API error for non-indexable column, even though column is indexable

Question

Using the Graph API Explorer app, I attempt the following query: https://developers.facebook.com/tools/explorer?method=GET&path=fql%3Fq%3DSELECT%20uid%20FROM%20page_fan%20WHERE%20page_id%3D'123412341234'

(fake id above, though I used a real id in my query)

An error is noting: Your statement is not indexable. The WHERE clause must contain an indexable column. Such columns are marked with * in the tables linked from http://developers.facebook.com/docs/reference/fql

However, the uid field in the page_fan table does have an asterisk next to it, indicating it's an indexable column.

What am I doing wrong here?

Phat H. VU Phat H. VU · Accepted Answer · 2013-12-12T06:34:48

@Lucas Dickey : I faceed the same problem with you before. Even the columns in WHERE is index-able (marked *), but failed with error like this :

{
"error": {
   "message": "Your statement is not indexable. The WHERE clause must contain an indexable   column. Such columns are marked with * in the tables linked from http://developers.facebook.com/docs/reference/fql ", 
   "type": "NoIndexFunctionException", 
   "code": 604
 }
}

I think this is an "bug" of Graph API Explorer. But, everything's OK when I copied and run in browser ( add query access_token as well), like this :

https://graph.facebook.com/fql?q=SELECT+uid+FROM+page_fan+WHERE+page_id=153453&access_token=CAACEdEose0cBANNkxdpIUuuhPXgbS0M6Tpt0GYgL4Q1p2OgwicLHEzCp7EPPVCB4zMqZA1LvWFyEr9aBhysXS13MYy3ZAZAihO0KvM07KWt8dcDqWry2mdTwhHe1yChDcWMQ54UtKCSEQOrTQuIkWcOjBpswiLhQkDWIHd7PnMvsc0mhI8fLsEz7pylxcXGT

Hope it works.

Oauth 604 Graph API error for non-indexable column, even though column is indexable

4 Answers