Re: Something broke! (Error 500) (1055, "'reviewboard.diffviewer_diffset.name' isn't in GROUP BY")

2016-10-24 Thread Cui Fisher 
mysqld  Ver 5.6.31 for Linux on x86_64 (MySQL Community Server (GPL))
It's need to disable sqlmod 'ONLY_FULL_GROUP_BY '.  

在 2016年10月24日星期一 UTC+8下午6:42:19，Cui Fisher写道：
>
> Review Board 2.5.6.1
>
> Something broke! (Error 500)
>
> It appears something broke when you tried to go to here. This is either a 
> bug in Review Board or a server configuration error. Please report this to 
> your administrator.
>
>
>
> - Exception thrown for user liuzhenhua at http://192.168.5.35/r/1117/
>
> (1055, "'reviewboard.diffviewer_diffset.name' isn't in GROUP BY")
> Traceback (most recent call last):
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/core/handlers/base.py",
>  line 112, in get_response
> response = wrapped_callback(request, *callback_args, **callback_kwargs)
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/accounts/decorators.py",
>  line 25, in _check
> return view_func(*args, **kwargs)
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/site/decorators.py",
>  line 35, in _check
> return view_func(request, local_site=local_site, *args, **kwargs)
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/reviews/views.py",
>  line 459, in review_detail
> diffsets = review_request.get_diffsets()
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/reviews/models/review_request.py",
>  line 595, in get_diffsets
> .prefetch_related('files'))
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
>  line 96, in __iter__
> self._fetch_all()
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
>  line 857, in _fetch_all
> self._result_cache = list(self.iterator())
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
>  line 220, in iterator
> for row in compiler.results_iter():
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/sql/compiler.py",
>  line 713, in results_iter
> for rows in self.execute_sql(MULTI):
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/sql/compiler.py",
>  line 786, in execute_sql
> cursor.execute(sql, params)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/util.py",
>  line 53, in execute
> return self.cursor.execute(sql, params)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/utils.py",
>  line 99, in __exit__
> six.reraise(dj_exc_type, dj_exc_value, traceback)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/util.py",
>  line 53, in execute
> return self.cursor.execute(sql, params)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/mysql/base.py",
>  line 124, in execute
> return self.cursor.execute(query, args)
>   File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in 
> execute
> self.errorhandler(self, exc, value)
>   File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, 
> in defaulterrorhandler
> raise errorclass, errorvalue
> OperationalError: (1055, "'reviewboard.diffviewer_diffset.name' isn't in 
> GROUP BY")
>
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Something broke! (Error 500) (1055, "'reviewboard.diffviewer_diffset.name' isn't in GROUP BY")

2016-10-24 Thread Christian Hammond 
Hi,

Can you give me more context around this error?

1) What triggered it? What page, and what action?
2) When did you upgrade to this release?
3) What version of MySQL are you using, and what type of database format
(MyISAM or InnoDB)?

Christian

-- 
Christian Hammond
President/CEO of Beanbag 
Makers of Review Board 

On Mon, Oct 24, 2016 at 3:42 AM, Cui Fisher  wrote:

> Review Board 2.5.6.1
>
> Something broke! (Error 500)
>
> It appears something broke when you tried to go to here. This is either a
> bug in Review Board or a server configuration error. Please report this to
> your administrator.
>
>
>
> - Exception thrown for user liuzhenhua at http://192.168.5.35/r/1117/
>
> (1055, "'reviewboard.diffviewer_diffset.name' isn't in GROUP BY")
> Traceback (most recent call last):
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/core/handlers/base.py",
>  line 112, in get_response
> response = wrapped_callback(request, *callback_args, **callback_kwargs)
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/accounts/decorators.py",
>  line 25, in _check
> return view_func(*args, **kwargs)
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/site/decorators.py",
>  line 35, in _check
> return view_func(request, local_site=local_site, *args, **kwargs)
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/reviews/views.py",
>  line 459, in review_detail
> diffsets = review_request.get_diffsets()
>   File 
> "/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/reviews/models/review_request.py",
>  line 595, in get_diffsets
> .prefetch_related('files'))
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
>  line 96, in __iter__
> self._fetch_all()
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
>  line 857, in _fetch_all
> self._result_cache = list(self.iterator())
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
>  line 220, in iterator
> for row in compiler.results_iter():
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/sql/compiler.py",
>  line 713, in results_iter
> for rows in self.execute_sql(MULTI):
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/sql/compiler.py",
>  line 786, in execute_sql
> cursor.execute(sql, params)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/util.py",
>  line 53, in execute
> return self.cursor.execute(sql, params)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/utils.py",
>  line 99, in __exit__
> six.reraise(dj_exc_type, dj_exc_value, traceback)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/util.py",
>  line 53, in execute
> return self.cursor.execute(sql, params)
>   File 
> "/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/mysql/base.py",
>  line 124, in execute
> return self.cursor.execute(query, args)
>   File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in 
> execute
> self.errorhandler(self, exc, value)
>   File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, 
> in defaulterrorhandler
> raise errorclass, errorvalue
> OperationalError: (1055, "'reviewboard.diffviewer_diffset.name' isn't in 
> GROUP BY")
>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> Happy user? Let us know! https://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "reviewboard" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Something broke! (Error 500) (1055, "'reviewboard.diffviewer_diffset.name' isn't in GROUP BY")

2016-10-24 Thread Cui Fisher 
Review Board 2.5.6.1

Something broke! (Error 500)

It appears something broke when you tried to go to here. This is either a 
bug in Review Board or a server configuration error. Please report this to 
your administrator.



- Exception thrown for user liuzhenhua at http://192.168.5.35/r/1117/

(1055, "'reviewboard.diffviewer_diffset.name' isn't in GROUP BY")
Traceback (most recent call last):
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/core/handlers/base.py",
 line 112, in get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File 
"/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/accounts/decorators.py",
 line 25, in _check
return view_func(*args, **kwargs)
  File 
"/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/site/decorators.py",
 line 35, in _check
return view_func(request, local_site=local_site, *args, **kwargs)
  File 
"/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/reviews/views.py",
 line 459, in review_detail
diffsets = review_request.get_diffsets()
  File 
"/usr/lib/python2.7/site-packages/ReviewBoard-2.5.6.1-py2.7.egg/reviewboard/reviews/models/review_request.py",
 line 595, in get_diffsets
.prefetch_related('files'))
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
 line 96, in __iter__
self._fetch_all()
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
 line 857, in _fetch_all
self._result_cache = list(self.iterator())
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/query.py",
 line 220, in iterator
for row in compiler.results_iter():
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/sql/compiler.py",
 line 713, in results_iter
for rows in self.execute_sql(MULTI):
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/models/sql/compiler.py",
 line 786, in execute_sql
cursor.execute(sql, params)
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/util.py",
 line 53, in execute
return self.cursor.execute(sql, params)
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/utils.py", 
line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/util.py",
 line 53, in execute
return self.cursor.execute(sql, params)
  File 
"/usr/lib/python2.7/site-packages/Django-1.6.11-py2.7.egg/django/db/backends/mysql/base.py",
 line 124, in execute
return self.cursor.execute(query, args)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in 
execute
self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in 
defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1055, "'reviewboard.diffviewer_diffset.name' isn't in GROUP 
BY")

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.