Databases
StackOverflow2013
Postsdbo
POFQL returning different results when queried from APP
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFQL returning different results when queried from APP
    primarykey
    data
    text
    <p>I have a process which scrapes the stream table periodically for given users, importing any new comments or posts which have come in. When I test my query using the facebooks fql.query link, the correct results are listed. For example:</p> <p>SELECT post_id, app_id, actor_id, created_time, updated_time, message, comments, app_data, likes, attachment, permalink FROM stream WHERE source_id = "652904096" ORDER BY updated_time DESC LIMIT 0, 20</p> <p><a href="https://api.facebook.com/method/fql.query?query=SELECT%20post_id,%20app_id,%20actor_id,%20created_time,%20updated_time,%20message,%20comments,%20app_data,%20likes,%20attachment,%20permalink%20FROM%20stream%20WHERE%20source_id=652904096%20ORDER%20BY%20updated_time%20DESC%20LIMIT%200,%2020&amp;access_token=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" rel="nofollow">https://api.facebook.com/method/fql.query?query=SELECT%20post_id,%20app_id,%20actor_id,%20created_time,%20updated_time,%20message,%20comments,%20app_data,%20likes,%20attachment,%20permalink%20FROM%20stream%20WHERE%20source_id=652904096%20ORDER%20BY%20updated_time%20DESC%20LIMIT%200,%2020&amp;access_token=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX</a></p> <p>The first result is from earlier today.</p> <p>But when I use my app and the php sdk, with the same query and access token, the first result is from December 23rd</p> <p>Here is how I am calling the query from my App</p> <pre><code>$result = $fb-&gt;api(array( "method"=&gt;"fql.query", "query"=&gt;$query, "access_token"=&gt;$oauth_token )); </code></pre> <p>Does anyone have any idea why this could be occurring? I have added debug statements to the PHP SDK to confirm that the query and access tokens are the same.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USthefreeman
    1. USthefreeman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POFQL returning different results when queried from APP
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI have exactly the same problem! working on it at the moment. Did you find what was the issue? It's not a cache problem for sure.
      singulars
      1. POFQL returning different results when queried from APP
      1. USmaxwell2022
    2. COI switched to using the Graph API to query FQL and that seems to have solved my issue. graph.facebook.com/fql?q=YOUR_QUERY
      singulars
      1. POFQL returning different results when queried from APP
      1. USthefreeman
    3. COI'm already using the graph api, but still don't get the same results with the different 2 different tokens
      singulars
      1. POFQL returning different results when queried from APP
      1. USmaxwell2022
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload