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 [email protected]. For more options, visit https://groups.google.com/d/optout.
