Defect #19161
500 Internal error: sorting for column mail at Administration/User
Status: | Closed | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | % Done: | 0% | ||
Category: | UI | |||
Target version: | 3.0.2 | |||
Resolution: | Fixed | Affected version: | 3.0.0 |
History
#1
Updated by Toshi MARUYAMA about 7 years ago
- Status changed from New to Confirmed
- Target version set to 3.0.2
#2
Updated by Toshi MARUYAMA about 7 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'
#3
Updated by Jean-Philippe Lang about 7 years ago
- Status changed from Confirmed to Resolved
- Assignee set to Jean-Philippe Lang
- Resolution set to Fixed
Ability to sort users by email removed in r14140.
#4
Updated by Jean-Philippe Lang about 7 years ago
- Status changed from Resolved to Closed