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 10 years ago. Updated over 10 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 10 years ago

Status changed from New to Confirmed
Target version set to 3.0.2

Actions

Copy link

Updated by Toshi MARUYAMA over 10 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