一个看似奇怪的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
最满意答案
您可以对此任务使用条件聚合 :
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 ofrating
field.
相关问答
更多-
Google API中的评论(Reviews in Google API)[2022-04-13]
我想我已经发现问题所在。 您无法看到有关该地点的现有评价的原因是,似乎有2个Google +帐户是相同的; 唯一的区别(至少我注意到的第一个)在邮政编码MA 02116与MA 02111之间。 看一眼: https://plus.google.com/101511264527346460079/about 和 https://plus.google.com/105917345931375838754/about 正如你所看到的,第二个是你在搜索页面看到相同的评论 通过将地址“The Kensington,6 ... -
MySQL网站评论系统(MySQL Review System for Website)[2022-03-27]
你可以修改reviews_thumbs看起来更像这样: reviews_thumbs -------------- review_id user_id upvote downvote 1 22 1 0 1 45 0 1 2 40 0 1 3 22 1 0 这将有效地存储重复的信息,但是当你有一个好的目的时,这没关系。 你真的有两件事你想知道,这 ... -
显示评价高于评论(Display rating above Reviews)[2022-11-22]
这应该有所帮助,你可能需要做一些微小的css改变。 getReviewsCollection()->getItems();?>_ ...
你必须在layout.xml中做一些工作。 Classy Llama的家伙们很容易: http://www.magentocommerce.com/boards/viewthread/41882/#t142654 You have to do a little bit of work in your layout.xml. The guys at Classy Llama make it easy: http://www.magentocommerce.com/boards/viewthread/41882 ...在* magento / app / design / frontend / base / [your_theme] /template/review/product/view/list.phtml* 你会看到下面的foreach循环:escapeHtml($_vote->getRatingCode()) ?> 您可以对此任务使用条件聚合 : 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, ...从表中获取评论数量(Getting number of reviews from table)[2023-09-16]
使用JOIN获取评论计数: public function get_count_reviews($c) { $this->db->select('COUNT(review.id) AS reviewCount'); $this->db->join('review', 'review.bizid = biz.id'); $this->db->where('bizid', $c); $query = $this->db->get('biz'); ...按评论数量对产品进行排序(Sort products by number of reviews)[2022-05-12]
由于您可能在查询中选择了COUNT('review_id') ,因此您最后只需添加ORDER BY COUNT('review_id') DESC 。 Since you're presumably selecting COUNT('review_id') in your query, you can simply add ORDER BY COUNT('review_id') DESC at the end.事实证明,没有办法通过API实现这一点,因为激励所征求的用户评论风险很大。 谷歌是最不挑剔的评论收集组织之一,但他们仍试图阻止有偏见的评论。 换句话说,不要这样做.... As it turns out, there isn't a way to do this through an API, since there is so much risk of user reviews solicited by incentives. Google is one of the least picky review ...使用COUNT和GROUP BY计算每个公司的评论,并使用JOIN从另一个表中获取公司名称。 询问 select t2.name as companyName,coalesce(t1.`count`,0) as `count` from ( select companyid,count(companyid) as `count` from reviews group by companyid )t1 right join companies t2 on t1.companyid= t ...相关文章
更多- 很奇怪的一个问题
- [转]So You Want To Be A Producer
- openSessionInView引出的奇怪问题
- apache虚拟主机的一个奇怪的问题
- 最近遇到一个Ext.Ajax.request的奇怪问题
- hibernate 插入sql 2000 ,很奇怪
- javascript函数返回的一个奇怪的现象
- Becoming a data scientist
- trouble is a friend
- Fading Like a Flower - Roxette
最新问答
更多- 散列包括方法和/或嵌套属性(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)