Hi Jason, What version of MySQL are you running?
Christian -- Christian Hammond - [email protected] Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com On Mon, Feb 15, 2016 at 1:06 PM, Jason Woodrich <[email protected]> wrote: > 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. > -- 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.
