Defect #935

when bulk editing, setting "Assigned to" to "nobody" causes an sql error

Added by Marc Horowitz over 9 years ago. Updated over 9 years ago.

Status:ClosedStart date:2008-03-26
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:0.7
Resolution:Fixed Affected version:

Description

at least under postgres:

ActiveRecord::StatementInvalid (PGError: ERROR:  invalid input syntax for integer: "none" 
: SELECT * FROM users WHERE (users."id" = 'none')  LIMIT 1):

I've included a patch which fixes this problem, and as a bonus, allows setting the version to "none" as well, using a similar pattern to assigned_to.

none.diff Magnifier (2.7 KB) Marc Horowitz, 2008-03-26 21:04

Associated revisions

Revision 1294
Added by Jean-Philippe Lang over 9 years ago

Fixed: when bulk editing, setting "Assigned to" to "nobody" causes an sql error with Postgresql (#935).

History

#1 Updated by Jean-Philippe Lang over 9 years ago

  • Category set to Issues
  • Status changed from New to Closed
  • Target version set to 0.7
  • Resolution set to Fixed

Thanks, patch applied in r1294 with the ability to set the category to 'none' as well.

Also available in: Atom PDF