Defect #19161
500 Internal error: sorting for column mail at Administration/User
| Status: | Closed | Start date: | ||
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Jean-Philippe Lang | % 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