Project

General

Profile

Actions
Copy link

Defect #21411

closed

MySQL 5.7: Mysql2::Error: Expression #1 of ORDER BY clause is not in SELECT list...

Added by Haihan Ji almost 9 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

# ruby script/about 

sh: darcs: command not found
sh: hg: command not found
sh: bzr: command not found
Environment:
  Redmine version                2.5.2.stable
  Ruby version                   1.9.3-p545 (2014-02-24) [x86_64-linux]
  Rails version                  3.2.19
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.7.4
  Git                            1.7.12.4
  Filesystem                     
Redmine plugins:
  parent_issue_filter            1.0.1
  redmine_code_review            0.7.0
  redmine_importer               1.2
  redmine_issue_templates        0.0.9
  redmine_xls_export             0.2.1

Upgrade database to MySQL 5.7, login is OK, project overview display '500 Internal Server Error'.

stack trace

Started GET "/naca00/projects/********" for xxx.xxx.xxx.xxx at 2015-11-28 11:47:17 +0800
Processing by ProjectsController#show as HTML
  Parameters: {"id"=>"********"}
  Current user: ******** (id=280)
Completed 500 Internal Server Error in 10.7ms

ActiveRecord::StatementInvalid (Mysql2::Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'redmine
.projects.name' which is not in SELECT list; this is incompatible with DISTINCT: SELECT  DISTINCT `members`.id FROM `members` LEF
T OUTER JOIN `projects` ON `projects`.`id` = `members`.`project_id` LEFT OUTER JOIN `member_roles` ON `member_roles`.`member_id`
= `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`user_id` = 280 AND `members`
.`project_id` = 169 AND (projects.status<>9) ORDER BY projects.name LIMIT 1):
  app/models/user.rb:464:in `block in membership'
  app/models/user.rb:466:in `yield'
  app/models/user.rb:466:in `default'
  app/models/user.rb:466:in `membership'
  app/models/user.rb:479:in `roles_for_project'
  app/models/user.rb:538:in `allowed_to?'
  app/controllers/application_controller.rb:257:in `authorize'

Actions
Copy link
 #1

Updated by Toshi MARUYAMA almost 9 years ago

  • Status changed from New to Closed

Redmine 2.5 is unmaintained and Rails 3.2.19 is old.
we cannot do anything.

Actions
Copy link

Also available in: Atom PDF