Project

General

Profile

Actions

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
Category:
UI
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

Actions #1

Updated by Toshi MARUYAMA over 9 years ago

  • Status changed from New to Confirmed
  • Target version set to 3.0.2
Actions #2

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 #3

Updated by Jean-Philippe Lang over 9 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.

Actions #4

Updated by Jean-Philippe Lang over 9 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF