首页 \ 问答 \ 一个看似奇怪的OAuthException(A seemingly strange OAuthException)

一个看似奇怪的OAuthException(A seemingly strange OAuthException)

我正在学习构建fb应用程序,并且在第一次尝试时,我得到了这个奇怪的OAuthException。 该教程清楚地提到我需要传递redirect_uri,client_secret,client_id和代码(来自app auth阶段)。 但是当流程完成时,我得到的是JSON错误对象,而不是获取访问令牌:

{"error":{"message":"client_secret should not be passed to \/oauth\/access_token\/","type":"OAuthException"}}

编辑:这是我用来建立网址的片段(请原谅第二行过多,请)

url = "https://graph.facebook.com/oauth/access_token/"
url += "?" 
url += urllib.urlencode([('client_id',client_id),
                           ('redirect_uri', redirect_uri),
                           ('client_secret', client_secret),
                           ('code', code)])

变量保存正确的值。(选中> 5次)


I am learning to build fb apps, and on the very first attempt, I get this strange OAuthException. The tutorial clearly mentions that I need to pass redirect_uri, client_secret, client_id and code(from the app auth phase). But when the flow completes, instead of getting an access token here is the JSON error object I get:

{"error":{"message":"client_secret should not be passed to \/oauth\/access_token\/","type":"OAuthException"}}

EDIT: this is the snippet I'm using to build the url(pardon the excessive 2nd line, please)

url = "https://graph.facebook.com/oauth/access_token/"
url += "?" 
url += urllib.urlencode([('client_id',client_id),
                           ('redirect_uri', redirect_uri),
                           ('client_secret', client_secret),
                           ('code', code)])

where the variables hold correct values.(checked > 5 times)


原文:https://stackoverflow.com/questions/7542721
更新时间:2023-10-30 17:10

最满意答案

您可以对此任务使用条件聚合

SELECT company_id as cid, 
       ROUND(AVG(rating)) AS rate, 
       COUNT(*) AS review_count,
       COUNT(CASE WHEN `rating` = 5 THEN 1 END) AS rating_5,
       COUNT(CASE WHEN `rating` = 5 THEN 1 END) / (COUNT(*) * 100) AS rating_5_avg,
        ... etc 
FROM `reviews` 
GROUP BY company_id

使用包含CASE表达式的聚合:

COUNT(CASE WHEN `rating` = 5 THEN 1 END)

您可以根据rating字段的值获取有关company_id记录子集的计数。


You can use conditional aggregation for this task:

SELECT company_id as cid, 
       ROUND(AVG(rating)) AS rate, 
       COUNT(*) AS review_count,
       COUNT(CASE WHEN `rating` = 5 THEN 1 END) AS rating_5,
       COUNT(CASE WHEN `rating` = 5 THEN 1 END) / (COUNT(*) * 100) AS rating_5_avg,
        ... etc 
FROM `reviews` 
GROUP BY company_id

Using an aggregate that contains a CASE expression:

COUNT(CASE WHEN `rating` = 5 THEN 1 END)

you can obtain a count on a subset of company_id records based on the value of rating field.

相关问答

更多

相关文章

更多

最新问答

更多
  • 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
  • TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
  • 企业安全培训的各项内容
  • 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
  • NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
  • 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
  • 将多个行和可变行移动到列(moving multiple and variable rows to columns)
  • 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
  • Angular $资源不会改变方法(Angular $resource doesn't change method)
  • 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
  • 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
  • Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
  • 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)
  • 是否可以嵌套hazelcast IMaps?(Is it possible to nest hazelcast IMaps? And whick side effects can I expect? Is it a good Idea anyway?)
  • UIViewAnimationOptionRepeat在两个动画之间暂停(UIViewAnimationOptionRepeat pausing in between two animations)
  • 在x-kendo-template中使用Razor查询(Using Razor query within x-kendo-template)
  • 在BeautifulSoup中替换文本而不转义(Replace text without escaping in BeautifulSoup)
  • 如何在存根或模拟不存在的方法时配置Rspec以引发错误?(How can I configure Rspec to raise error when stubbing or mocking non-existing methods?)
  • asp用javascript(asp with javascript)
  • “%()s”在sql查询中的含义是什么?(What does “%()s” means in sql query?)
  • 如何为其编辑的内容提供自定义UITableViewCell上下文?(How to give a custom UITableViewCell context of what it is editing?)
  • c ++十进制到二进制,然后使用操作,然后回到十进制(c++ Decimal to binary, then use operation, then back to decimal)
  • 以编程方式创建视频?(Create videos programmatically?)
  • 无法在BeautifulSoup中正确解析数据(Unable to parse data correctly in BeautifulSoup)
  • webform和mvc的区别 知乎
  • 如何使用wadl2java生成REST服务模板,其中POST / PUT方法具有参数?(How do you generate REST service template with wadl2java where POST/PUT methods have parameters?)
  • 我无法理解我的travis构建有什么问题(I am having trouble understanding what is wrong with my travis build)
  • iOS9 Scope Bar出现在Search Bar后面或旁边(iOS9 Scope Bar appears either behind or beside Search Bar)
  • 为什么开机慢上面还显示;Inetrnet,Explorer
  • 有关调用远程WCF服务的超时问题(Timeout Question about Invoking a Remote WCF Service)