Greetings,
I upgraded from 1.7 to 2.5.2 today and everything seemed to go smoothly, 
but now when I try to access reviews I'm getting this error:

2016-02-15 21:01:54,090 - ERROR -  - Exception thrown for user X at 
http://X/r/102/

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

I did some digging and found this is the query that's being generated:

SELECT `diffviewer_diffset`.`id`, `diffviewer_diffset`.`name`, 
`diffviewer_diffset`.`revision`, `diffviewer_diffset`.`timestamp`, 
`diffviewer_diffset`.`basedir`, `diffviewer_diffset`.`history_id`, 
`diffviewer_diffset`.`repository_id`, 
`diffviewer_diffset`.`diffcompat`, `diffviewer_diffset`.`base_commit_id`, 
`diffviewer_diffset`.`extra_data`, 
COUNT(`diffviewer_filediff`.`id`) AS `file_count`
FROM `diffviewer_diffset` 
LEFT OUTER JOIN `diffviewer_filediff` ON ( `diffviewer_diffset`.`id` = 
`diffviewer_filediff`.`diffset_id` ) 
WHERE `diffviewer_diffset`.`history_id` = 93  
GROUP BY `diffviewer_diffset`.`id` 
ORDER BY `diffviewer_diffset`.`revision` ASC, 
`diffviewer_diffset`.`timestamp` ASC

Any thoughts?

Thanks,
Jason

-- 
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.

Reply via email to