Defect #19161: 500 Internal error: sorting for column mail at Administration/User - Redmine

Actions

Copy link

Defect #19161

closed

500 Internal error: sorting for column mail at Administration/User

Added by Grischa Zengel over 9 years ago. Updated over 9 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Jean-Philippe Lang

Category:

Target version:

3.0.2

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Fixed

Affected version:

3.0.0

Description

https://redmine/redmine/users?sort=mail will show an error.

Actions

Copy link

Updated by Toshi MARUYAMA over 9 years ago

Status changed from New to Confirmed
Target version set to 3.0.2

Actions

Copy link

Updated by Toshi MARUYAMA over 9 years ago

Started GET "/users?sort=mail%2Clogin" for 192.168.11.10 at 2015-03-20 12:35:41 +0900
Processing by UsersController#index as HTML
  Parameters: {"sort"=>"mail,login"}
  Current user: admin (id=1)
SQLite3::SQLException: no such column: mail: SELECT  "users".* FROM "users" 
 WHERE "users"."type" IN ('User', 'AnonymousUser') AND (users.status <> 0)
 AND "users"."status" = ?  ORDER BY mail, login LIMIT 25 OFFSET 0
Completed 500 Internal Server Error in 4ms

ActiveRecord::StatementInvalid (SQLite3::SQLException: no such column: mail:
 SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser')
 AND (users.status <> 0) AND "users"."status" = ?  ORDER BY mail, login LIMIT 25 OFFSET 0):
  app/controllers/users_controller.rb:51:in `index'

Actions

Copy link