Hi Christian, I'm using mysqld Ver 5.5.29-rel29.4 for Linux on x86_64 (Percona Server with XtraDB (GPL), Release rel29.4, Revision 401)
Thanks, Jason On Monday, February 15, 2016 at 6:18:31 PM UTC-7, Christian Hammond wrote: > > Hi Jason, > > What version of MySQL are you running? > > Christian > > -- > Christian Hammond - [email protected] <javascript:> > 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] > <javascript:>> 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] <javascript:>. >> 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.
