FQL query with subquery suddenly started failing...

Dec 5, 2010 at 7:45 PM

Hello,


all of the sudden the following query within a multiquery is failing (has been working for over a year): 

            return string.Format("SELECT uid FROM user WHERE is_app_user = 1 AND uid IN (SELECT uid2 FROM friend WHERE uid1 = {0})", fbId);

strange is that if I leave the subquery part out it works:

            return string.Format("SELECT uid FROM user WHERE is_app_user = 1 AND uid = {0}", fbId);

the queries you see above are simplified (my query returns more than just the uid), but the results with this simplified queries are the same.

Anybody else have this issue?Any ideas?

Thank you!

The failure message is:
{System.Net.WebException: The remote server returned an error: NotFound. ---> System.Net.WebException: The remote server returned an error: NotFound.   at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)   at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClass5.<EndGetResponse>b__4(Object sendState)   at System.Net.Browser.AsyncHelper.<>c__DisplayClass2.<BeginOnUI>b__0(Object sendState)   --- End of inner exception stack trace ---   at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)   at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)   at Facebook.Utility.WebClientHelper.BeginResponse(IAsyncResult ar)}